INSTALLING ORACLE REST DATA SERVICES/ORDS ON WEBLOGIC

Oracle REST data services is a Java based application that makes Oracle DB REST enabled. ORDS can be run as a standalone application or can be deployed on application servers: weblogic, Tomcat and GlassFish. We installed ORDS 20.3 without APEX on Weblogic. Thanks to my colleagues Shubham and Rohit in helping me setup it. Here are the steps:

  1. Download ORDS from Oracle Site
  2. Copy and unzip installable on installation machine.
  3. Create ORDS user in database, say ords_admin.
  4. Execute ords_installer_privileges.sql by passing ords admin user as input. This file is located under “installer” directory of the downloaded ords. This script provides all necessary permission for the admin user.
  5. Go to dir where unzipped installable is present:
    For example, cd /u01/software/ords-20.3
  6. Run below command. Responses to installer prompt are highlighted in bold
    java -jar ords.war install advanced
[oracle@mymachine ords-20.3]$ java  -jar ords.war install advanced
Specify the database connection type to use.
Enter number for [1] Basic  [2] TNS  [3] Custom URL [1]:3
Enter the Custom JDBC URL:jdbc:oracle:thin:@//mydatabase:1521/pmyebs
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:1
Enter the database password for ORDS_PUBLIC_USER: (enter password of your choice)
Confirm password:
Requires to login with administrator privileges to verify Oracle REST Data Services schema.
Enter the administrator username:ords_admin (Enter admin user created in step 3)
Enter the database password for ords_admin: (enter admin user password created in step 3)
Confirm password:
Connecting to database user: ords_admin url: jdbc:oracle:thin:@//mydatabase:1521/pmyebs

Retrieving information.
Enter the default tablespace for ORDS_METADATA [SYSAUX]:USERS
Enter the temporary tablespace for ORDS_METADATA [TEMP]:TEMP2
Enter the default tablespace for ORDS_PUBLIC_USER [SYSAUX]:USERS
Enter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:TEMP2
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:2
Enter a number to select a feature to enable:
   [1] SQL Developer Web  (Enables all features)
   [2] REST Enabled SQL
   [3] Database API
   [4] REST Enabled SQL and Database API
   [5] None
Choose [1]:5

2020-11-17T05:00:08.335Z INFO        reloaded pools: []
Installing Oracle REST Data Services version 20.3.0.r3011819
... Log file written to 050008_00679.log
... Verified database prerequisites
... Created Oracle REST Data Services proxy user
... Created Oracle REST Data Services schema
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to 00799.log
... Log file written to 00156.log
Completed installation for Oracle REST Data Services version 20.3.0.r3011819. Elapsed time: 00:01:13.736

Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2

ORDS configuration can be validated using:

[oracle@mymachine ords-20.3]$ java -jar ords.war validate
Specify the database connection type to use.
Enter number for [1] Basic [2] TNS [3] Custom URL [1]:3
Enter the Custom JDBC URL:jdbc:oracle:thin:@//mydatabase:1521/pmyebs
Requires to login with administrator privileges to verify Oracle REST Data Services schema.
Enter the administrator username:ords_admin
Enter the database password for ords_admin:
Confirm password:
Connecting to database user: ords_admin url: jdbc:oracle:thin:@//mydatabase:1521/pmyebs
Retrieving information.
Oracle REST Data Services will be validated.
Validating Oracle REST Data Services schema version 20.3.0.r3011819
… Log file written to2020-11-17_050418_00613.log
Completed validating Oracle REST Data Services version 20.3.0.r3011819. Elapsed time: 00:00:16.732

Next step is to install ords.war on weblogic.

  1. Log into weblogic admin console.
  2. Lock the edit session by clicking on Lock & Edit button located in Change Center.
  3. Go to Deployments page.
  4. Click on Install.
  5. In Path text box enter path of ords.war that was downloaded and choose ords.war in bottom list. Click on Next.
  6. Choose Install this deployment as an application and click on Next.
  7. Select servers/clusters where you want to install ords and click on Next.
  8. Choose Custom Roles: Use roles that are defined in the Administration Console; use policies that are defined in the deployment descriptor in security section. Click on Next.
  9. Choose “Yes, take me to the deployment’s configuration screen” and click on Finish.
  10. Click on Activate Changes in Change Center to complete installation.
  11. After deployment, application may go into Prepared state. You can start application by clicking on Lock & Edit -> Deployments -> Control Tab -> Select ords and click on Start button.

Comments

Post a Comment

Popular posts from this blog

HOW WE REDUCED SOA OSB PROVISIONING FROM 4 DAYS TO 4 HOURS

 In our organization, we’ve undertaken the task of upgrading both SOA and OSB from version 12.2.1.3 to 12.2.1.4. This involves an out-of-place migration approach, wherein we create a new environment and switch traffic during the cutover. As you know, this process typically requires several days we opt for manual provisioing. A very significant amount of automation work was previously accomplished for 12.2.1.3 by our predecessors. Despite these efforts, the process still used to take lot of time due to following factors: Bugs in existing automation. For example, SOA composite deployments is not stable which warrants lot of manual work Import of 10s of TLS Certificates into KSS Manual retiring and shutting down of services Monitoring setup Miscellaneous: Increasing Log file count, enabling GC logging, changing heap parameters, bash profile changes While our current automation initiatives have yielded substantial savings, we aimed to capitalize on this upgrade activity to enable end-t...
Read more

NOT ABLE TO START RABBITMQ CLUSTER: CANNOT DECLARE A QUEUE ‘~S’ ON NODE ‘~S’: ~255P

We have 7 node rabbitmq cluster and we are using sharding queues. We have shutdown all non prod rabbitmq nodes as part of VM patching. As it was non prod, we thought of shutting down all together instead of rolling patching. We couldn’t start the any of the rabbitmq post patching. All of nodes were failing to start with the below error: 2022-06-23 05:13:10.104845-07:00 [error] <0.647.0> “Cannot declare a queue ‘~s’ on node ‘~s’: ~255p”, 2022-06-23 05:13:10.104845-07:00 [error] <0.647.0> [“queue ‘sharding: shard.my.queue – rabbit@rabbit1’ in vhost ‘my_vhost'” This is a known issue in some old versions of rabbitmq. rabbitmq node fails to come up with above error. Work around for this is to disable sharding policy for the problematic sharding queue. It can be done either from command line or from rabbitmq admin page. It requires to connect a running node. But as all the nodes were down, we could not disable sharding policy. Luckily, rabbitmq allows disabling sharding pulgi...
Read more

SOA SUITE 12.2.1.4 INSTALLATION: GOT EXCEPTION WHEN AUTO CONFIGURING THE SCHEMA COMPONENT(S) WITH DATA OBTAINED FROM SHADOW TABLE

  We planned to do out of place upgrade from soa suite 12.2.1.3 to 12.2.1.4. As part of this, we planned to automate end to end provisioning. While executing domain configuration using ansible and python scripts, we got following error in domain creation step. Got exception when auto configuring the schema component(s) with data obtained from shadow table. Failed to build JDBC Connection object: com.oracle.cie.domain.script.jython.CommandExceptionHandler. exception. Quick internet search gave few solutions like deleting domain-registry.xml file, verifying dehydration store password supplied to script etc. But none of them helped. After trying several options, I thought I might have done some stupid error prior to domain creation step. To track down the issue, though of checking what getDatabaseDefaults actually doing. I tried to grep for the getDatabaseDefaults function call inside oracle home. But couldn’t find the source code for the python function. As a final resort, thought of...
Read more