{"id":14643,"date":"2020-09-07T23:08:34","date_gmt":"2020-09-07T21:08:34","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/"},"modified":"2020-09-07T23:08:34","modified_gmt":"2020-09-07T21:08:34","slug":"oracle-rest-data-services-installation-and-configuration","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/","title":{"rendered":"Oracle REST Data Services &#8211; Installation and Configuration"},"content":{"rendered":"<p>The goal of this blog is to install and configure Oracle REST Data Services 19.2 in Standalone mode into an oracle database 12.2.<\/p>\n<p>The official documentation is stored <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-rest-data-services\/20.2\/aelig\/installing-REST-data-services.html#GUID-A16BCCA2-8081-4062-A635-9F7C36FC394F\">here<\/a> and you will find a lot of resources and examples from the <a href=\"https:\/\/www.thatjeffsmith.com\/oracle-rest-data-services-ords\/\"><em>Thatjeffsmith<\/em> website.<\/a><\/p>\n<p>The first step is to download the last version of ORDS from the <a href=\"https:\/\/www.oracle.com\/database\/technologies\/appdev\/rest-data-services-v192-downloads.html\">Oracle REST Data Services download page.<\/a><\/p>\n<p>Unzip the zip file into a directory (or folder) of your choice :<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">-rw-r--r--. 1 oracle oinstall 63211594 Sep 4 10:15 ords-19.2.0.199.1647.zip\noracle@oel7:\/tmp\/ [DBI] unzip ords-19.2.0.199.1647.zip\noracle@oel7:\/tmp\/ [DBI] ls -ltr\ntotal 122764\ndrwxrwxrwx. 2 oracle oinstall 36 May 20 2019 params\ndrwxrwxrwx. 6 oracle oinstall 64 May 20 2019 examples\n-rw-rw-rw-. 1 oracle oinstall 38023 Jul 5 2019 index.html\ndrwxrwxrwx. 2 oracle oinstall 43 Jul 18 2019 installer\n-rw-r--r--. 1 oracle oinstall 62454471 Jul 18 2019 ords.war\ndrwxr-xr-x. 3 oracle oinstall 21 Jul 18 2019 docs\n-rw-r--r--. 1 oracle oinstall 63211594 Sep 4 10:15 ords-19.2.0.199.1647.zip<\/pre>\n<p>Perform an advanced installation :<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@oel7:\/tmp\/ [DBI] java -Doracle.net.tns_admin=\/home\/oracle\/app\/oracle\/network\/admin\/tnsnames.ora -jar ords.war install advanced\nThis Oracle REST Data Services instance has not yet been configured.\nPlease complete the following prompts\n\nEnter the location to store configuration data: \/home\/oracle\/app\/oracle\/product\/ords\n\nEnter the name of the database server [localhost]:\nEnter the database listen port [1521]:\nEnter 1 to specify the database service name, or 2 to specify the database SID [1]:2\nEnter the database SID [xe]:DBI\nEnter 1 if you want to verify\/install Oracle REST Data Services schema or 2 to skip this step [1]:\nEnter the database password for ORDS_PUBLIC_USER:\nConfirm password:\nRequires to login with administrator privileges to verify Oracle REST Data Services schema.\n\nEnter the administrator username:sys\nEnter the database password for SYS AS SYSDBA:\nConfirm password:\n\nRetrieving information.\nEnter the default tablespace for ORDS_METADATA [SYSAUX]:\nEnter the temporary tablespace for ORDS_METADATA [TEMP]:\nEnter the default tablespace for ORDS_PUBLIC_USER [USERS]:\nEnter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:\nEnter 1 if you want to use PL\/SQL Gateway or 2 to skip this step.\nIf using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:2\nSep 04, 2020 5:41:07 PM\nINFO: reloaded pools: []\nInstalling Oracle REST Data Services version 19.2.0.r1991647\n... Log file written to \/home\/oracle\/ords_install_core_2020-09-04_174127_00883.log\n... Verified database prerequisites\n... Created Oracle REST Data Services proxy user\n... Created Oracle REST Data Services schema\n... Granted privileges to Oracle REST Data Services\n... Created Oracle REST Data Services database objects\n... Log file written to \/home\/oracle\/ords_install_datamodel_2020-09-04_174220_00874.log\n... Log file written to \/home\/oracle\/ords_install_apex_2020-09-04_174225_00292.log\nCompleted installation for Oracle REST Data Services version 19.2.0.r1991647. Elapsed time: 00:01:01.973\n\nEnter 1 if you wish to start in standalone mode or 2 to exit [1]:\nEnter 1 if using HTTP or 2 if using HTTPS [1]:\nEnter the HTTP port [8080]:\n2020-09-04 17:43:11.493:INFO::main: Logging initialized @342587ms to org.eclipse.jetty.util.log.StdErrLog\nSep 04, 2020 5:43:11 PM\nINFO: HTTP and HTTP\/2 cleartext listening on port: 8080\nSep 04, 2020 5:43:12 PM\nINFO: Disabling document root because the specified folder does not exist: \/home\/oracle\/app\/oracle\/product\/ords\/ords\/standalone\/doc_root\n2020-09-04 17:43:15.629:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2019-05-02T09:46:34.874Z; git: 14f32d50076f2b706f41a33066eb364d8492e199; jvm 1.8.0_232-b09\n2020-09-04 17:43:15.789:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0\n2020-09-04 17:43:15.789:INFO:oejs.session:main: No SessionScavenger set, using defaults\n2020-09-04 17:43:15.791:INFO:oejs.session:main: node0 Scavenging every 600000ms\nSep 04, 2020 5:43:35 PM\nINFO: Configuration properties for: |apex|pu|\ncache.caching=false\ncache.directory=\/tmp\/apex\/cache\ncache.duration=days\ncache.expiration=7\ncache.maxEntries=500\ncache.monitorInterval=60\ncache.procedureNameList=\ncache.type=lru\ndb.hostname=localhost\ndb.password=******\ndb.port=1521\ndb.sid=DBI\ndb.username=ORDS_PUBLIC_USER\ndebug.debugger=false\ndebug.printDebugToScreen=false\nerror.keepErrorMessages=true\nerror.maxEntries=50\njdbc.DriverType=thin\njdbc.InactivityTimeout=1800\njdbc.InitialLimit=3\njdbc.MaxConnectionReuseCount=1000\njdbc.MaxLimit=10\njdbc.MaxStatementsLimit=10\njdbc.MinLimit=1\njdbc.statementTimeout=900\nlog.logging=false\nlog.maxEntries=50\nmisc.compress=\nmisc.defaultPage=apex\nresource.templates.enabled=true\nsecurity.disableDefaultExclusionList=false\nsecurity.maxEntries=2000\n\nSep 04, 2020 5:43:35 PM\nWARNING: *** jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment ***\nSep 04, 2020 5:43:35 PM\nWARNING: *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment ***\nSep 04, 2020 5:44:21 PM\nINFO: Oracle REST Data Services initialized\nOracle REST Data Services version : 19.2.0.r1991647\nOracle REST Data Services server info: jetty\/9.4.z-SNAPSHOT\n\n2020-09-04 17:44:23.289:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@15ca7889{\/ords,null,AVAILABLE}\n2020-09-04 17:44:23.338:INFO:oejs.AbstractConnector:main: Started ServerConnector@6f204a1a{HTTP\/1.1,[http\/1.1, h2c]}{0.0.0.0:8080}\n2020-09-04 17:44:23.339:INFO:oejs.Server:main: Started @414433ms\n\nThe ords properties are stored into \/tmp\/ords_params.properties\n\noracle@oel7:\/tmp\/params\/ [DBI] more ords_params.properties\n#Fri Sep 04 17:43:11 CEST 2020\ndb.hostname=localhost\ndb.port=1521\ndb.sid=DBI\ndb.username=APEX_PUBLIC_USER\nmigrate.apex.rest=false\nplsql.gateway.add=false\nrest.services.apex.add=false\nrest.services.ords.add=true\nschema.tablespace.default=SYSAUX\nschema.tablespace.temp=TEMP\nstandalone.http.port=8080\nstandalone.mode=true\nstandalone.use.https=false\nuser.public.password=@05FA82FC82E07209C8D6400E78EBC780A319B1F48D2C46E372\nuser.tablespace.default=USERS\nuser.tablespace.temp=TEMP<\/pre>\n<pre class=\"brush: shell; gutter: true; first-line: 1\"><\/pre>\n<p>The configuration data are stored under \/home\/oracle\/app\/oracle\/product\/ords\/ords\/defaults.xml.<\/p>\n<p>Let&#8217;s check the\u00a0 Oracle REST Data Services installation is valid :<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">oracle@oel7:\/tmp\/ [DBI] java -jar ords.war validate\nEnter the name of the database server [localhost]:\nEnter the database listen port [1521]:\nEnter the database SID [DBI]:\nRequires to login with administrator privileges to verify Oracle REST Data Services schema.\n\nEnter the administrator username:sys\nEnter the database password for SYS AS SYSDBA:\nConfirm password:\n\nRetrieving information.\n\nOracle REST Data Services will be validated.\nValidating Oracle REST Data Services schema version 19.2.0.r1991647\n... Log file written to \/home\/oracle\/ords_validate_core_2020-09-04_183627_00259.log\nCompleted validating Oracle REST Data Services version 19.2.0.r1991647. Elapsed time: 00:00:12.532\n\noracle@oel7:\/tmp\/ [DBI]<\/pre>\n<p>If we check the validation log file, here is how ords validate the process :<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">more \/home\/oracle\/ords_validate_core_2020-09-04_183627_00259.log\n...\n\nINFO: 18:36:35 Validating objects for Oracle REST Data Services.\nVALIDATION: 18:36:35 Starting validation for schema: ORDS_METADATA\nVALIDATION: 18:36:35 Validating objects\nVALIDATION: 18:36:36 Validating ORDS Public Synonyms\nVALIDATION: 18:36:39 Total objects: 252, invalid objects: 0\nVALIDATION: 18:36:39 72 INDEX\nVALIDATION: 18:36:39 3 LOB\nVALIDATION: 18:36:39 12 PACKAGE\nVALIDATION: 18:36:39 12 PACKAGE BODY\nVALIDATION: 18:36:39 1 PROCEDURE\nVALIDATION: 18:36:39 44 PUBLIC SYNONYM\nVALIDATION: 18:36:39 1 SEQUENCE\nVALIDATION: 18:36:39 27 TABLE\nVALIDATION: 18:36:39 27 TRIGGER\nVALIDATION: 18:36:39 20 TYPE\nVALIDATION: 18:36:39 6 TYPE BODY\nVALIDATION: 18:36:39 27 VIEW\nVALIDATION: 18:36:39 Validation completed.\nINFO: 18:36:39 Completed validating objects for Oracle REST Data Services.<\/pre>\n<p>Let&#8217;s now configure ORDS to use Oracle SQL Developer to administer (within a graphical interface) Oracle REST Data Services.<\/p>\n<p>The first step is to configure an administrator user as follows :<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@oel7:\/tmp\/ [DBI] java -jar ords.war user adminlistener \"Listener Administrator\"\nEnter a password for user adminlistener:\nConfirm password for user adminlistener:\nSep 07, 2020 11:30:20 AM oracle.dbtools.standalone.ModifyUser execute\nINFO: Created user: adminlistener in file: \/home\/oracle\/app\/oracle\/product\/ords\/ords\/credentials<\/pre>\n<p>Now let&#8217;s check into SQL Developer, which schema and database objects are related to ORDS :<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-43153\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png\" alt=\"\" width=\"172\" height=\"300\" \/><\/a><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-43153\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png\" alt=\"\" width=\"172\" height=\"300\" \/><\/a><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-43154\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects3.png\" alt=\"\" width=\"94\" height=\"303\" \/><\/a><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-43156\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects4.png\" alt=\"\" width=\"150\" height=\"300\" \/><\/a><\/p>\n<p>Two schemas are created after the installation :<\/p>\n<ul>\n<li>ORDS_METADATA :\n<ul>\n<li>Owner of the PL\/SQL packages used for implementing many Oracle REST Data Services capabilities. ORDS_METADATA is where the metadata about Oracle REST Data Services-enabled schemas is stored.<\/li>\n<\/ul>\n<\/li>\n<li>ORDS_PUBLIC_USER, technical user, accessed :\n<ul>\n<li>User for invoking RESTful Services in the Oracle REST Data Services-enabled schemas.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>As we are using Oracle REST Data Services without HTTPS, we\u00a0 have to add the following properties into defaults.xml configuration file :<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">&lt;entry key=\"security.verifySSL\"&gt;false&lt;\/entry&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>Note that it is only appropriate to use this setting in development or test environments.<br \/>\nIt is never appropriate to use this setting in production environments because it will result in user credentials being passed in clear text.<\/p>\n<p>Now let&#8217;s launch Oracle REST Data Services in standalone mode :<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">oracle@oel7:\/tmp\/ [DBI] nohup java -jar ords.war standalone &amp;\n[1] 7731\noracle@oel7:\/tmp\/ [DBI] nohup: ignoring input and appending output to \u2018nohup.out\u2019\n\noracle@oel7:\/tmp\/ [DBI] tail -f nohup.out\n2020-09-07 11:58:40.775:INFO::main: Logging initialized @2904ms to org.eclipse.jetty.util.log.StdErrLog\nSep 07, 2020 11:58:40 AM\nINFO: HTTP and HTTP\/2 cleartext listening on port: 8080\nSep 07, 2020 11:58:41 AM\n...\ndb.hostname=localhost\ndb.password=******\ndb.port=1521\ndb.sid=DBI\ndb.username=ORDS_PUBLIC_USER\ndebug.debugger=false\n...\nsecurity.verifySSL=false\n\nSep 07, 2020 11:58:44 AM\nWARNING: *** jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment ***\nSep 07, 2020 11:58:44 AM\nWARNING: *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment ***\nSep 07, 2020 11:58:45 AM\nINFO: Oracle REST Data Services initialized\nOracle REST Data Services version : 19.2.0.r1991647\nOracle REST Data Services server info: jetty\/9.4.z-SNAPSHOT\n\n2020-09-07 11:58:46.174:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@28d25987{\/ords,null,AVAILABLE}\n2020-09-07 11:58:46.188:INFO:oejs.AbstractConnector:main: Started ServerConnector@63021689{HTTP\/1.1,[http\/1.1, h2c]}{0.0.0.0:8080}\n2020-09-07 11:58:46.189:INFO:oejs.Server:main: Started @8319ms<\/pre>\n<p>Now, ords is installed and configured, we are ready to create some web services&#8230;<\/p>\n<p>All details in my next blog&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The goal of this blog is to install and configure Oracle REST Data Services 19.2 in Standalone mode into an oracle database 12.2. The official documentation is stored here and you will find a lot of resources and examples from the Thatjeffsmith website. The first step is to download the last version of ORDS from [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":14644,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-14643","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle REST Data Services - Installation and Configuration - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle REST Data Services - Installation and Configuration\" \/>\n<meta property=\"og:description\" content=\"The goal of this blog is to install and configure Oracle REST Data Services 19.2 in Standalone mode into an oracle database 12.2. The official documentation is stored here and you will find a lot of resources and examples from the Thatjeffsmith website. The first step is to download the last version of ORDS from [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-07T21:08:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"283\" \/>\n\t<meta property=\"og:image:height\" content=\"494\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle REST Data Services &#8211; Installation and Configuration\",\"datePublished\":\"2020-09-07T21:08:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/\"},\"wordCount\":319,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png\",\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/\",\"name\":\"Oracle REST Data Services - Installation and Configuration - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png\",\"datePublished\":\"2020-09-07T21:08:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png\",\"width\":283,\"height\":494},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle REST Data Services &#8211; Installation and Configuration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle REST Data Services - Installation and Configuration - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/","og_locale":"en_US","og_type":"article","og_title":"Oracle REST Data Services - Installation and Configuration","og_description":"The goal of this blog is to install and configure Oracle REST Data Services 19.2 in Standalone mode into an oracle database 12.2. The official documentation is stored here and you will find a lot of resources and examples from the Thatjeffsmith website. The first step is to download the last version of ORDS from [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/","og_site_name":"dbi Blog","article_published_time":"2020-09-07T21:08:34+00:00","og_image":[{"width":283,"height":494,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle REST Data Services &#8211; Installation and Configuration","datePublished":"2020-09-07T21:08:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/"},"wordCount":319,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png","articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/","name":"Oracle REST Data Services - Installation and Configuration - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png","datePublished":"2020-09-07T21:08:34+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/REST_DBObjects1.png","width":283,"height":494},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-rest-data-services-installation-and-configuration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle REST Data Services &#8211; Installation and Configuration"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14643","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14643"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14643\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14644"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14643"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}