Oracle SOA Suite 12.2.1.3 SOA Server- ONS Initialization failed for data source

-
This is another post on Oracle Middleware setup and issues encountered during the process. 
Current post is focused on ONS(Oracle Notification Service) Initialization issue that encountered during managed servers startup. Below is the environment details-
  • Oracle SOA Suite- 12.2.1.3
  • Oracle Database- 12.2.1.0
  • Oracle Linux- 7.5
  • AdminServer home variable- ASERVER+HOME
  • ManagaedServer home variable- MSERVER_HOME
  • SOA Suite HOST machines- DC-SOABPM-01.host.com, DC-SOABPM-02.host.com
  • Oracle Database RAC Nodes- DC-DB-01.soa.com, DC-DB-02.soa.com
What Happened?
  1. Successful install and domain configuration of Oracle SOA Suite 12.2.1.3
  2. Staring the AdminServer
  3. Starting SOA_Server1
  4. Server startup log $MSERVER_HOME/servers/SOA_Server1/logs/SOA_Server1.out says below error message-
<BEA-001598> ONS Initialization failed for data source-
LocalSvcTblDataSource
WLSSchemaDataSource
mds_bam
mds_owsm
mds_soa
ops_audit_DBDS
ops_data_source
........... unable to connect host dc-db-01................. unable to connect host dc-db-02......

Issue Cause-
Actually the issue is definitely associated with host 'dc-db-01'. The SOA machine is not able to connect the machine dc-db-01 (Oracle Database RAC node 1)  and machine dc-db-01(Oracle RAC Database node 2).
Finally, this is a networking issue that we need to solve.

The Solution Worked-
1. Actually, dc-db-01 & dc-db-02 are the hostnames of respective Oracle Database RAC Node.
2. Checking the /etc/hosts file of both nodes and making necessary changes so that the hostname should be reachable from the SOA Host machines (DC-SOABPM-01.soa.com, DC-SOABPM-02.soa.com) machines.
3. RAC Node 1 /etc/hosts
10.0.144.204 DC-SOABPM-01.host.com DC-SOABPM-01
10.0.144.204 DC-SOABPM-02.host.com DC-SOABPM-02
4. RAC Node 2 /etc/hosts
10.0.144.204 DC-SOABPM-01.host.com DC-SOABPM-01
10.0.144.204 DC-SOABPM-02.host.com DC-SOABPM-02
5. Check the Oracle RAC Nodes reachability from SOA host machines by ping test.
6. Reconfigure the soa_domain and do the entry of below ONS host(2 entries) or SCAN(one entry) address on respective screen-
  • ONS  Detail Section 
    • if SCAN, only 1 entry required- 
      • scandb.example.com, Port- 6200
    • If not SCAN, 2 entries required-
      • DC-SOABPM-01.host.com, Port-6200
      • DC-SOABPM-02.host.com, Port-6200
7. Start the managed servers and ONS issue will not encounter.








Comments

Post a Comment

Popular posts from this blog

Oracle SOA Suite- Implementing Email Notification

-
Image
In this post, I am going to show how to implement email notifications in Oracle SOA Suite using BPEL process. So let's get started- Implementing email notification in Oracle SOA Suite consists of below steps: Environment- IDE- Oracle jDeveloper 11g Weblogic Server 12c Oracle SOA Suite 12c High Level Steps Keep ready email server settings. Configure & enable usermessagingdriver-email for target SOA servers via console. Setting up Email driver (usermessagingdriver-email )with email server settings via enterprise manager. Enable notifications for SOA workflows(make sure either All or EMail option is selected).. Create SOA composite application Deploy it on SOA server. Testing & done. 1. Keep ready email server settings. Keep ready your below email server settings: Outgoing Mail Server          : smtp.domain.com Outgoing Mail Server Port   : xxx Default From Address         : username@doamin.com Outgoing Username            : actualemailid@doma
Read more

Oracle SOA Suite 12c- PKIX path building failed & unable to find valid certification path to requested target

-
Image
Hi Everyone, in this blog I'll be writing one of the strange issue that has been encountered while working with a Oracle SOA composite running in Oracle IDAM environment and trying to invoke a SSL based remote service where SSL certification based exception has been thrown during the service invocation. Environment Oracle SOA Suite 12c  (HA Mode) Oracle IDAM 12c (HA Mode) Oracle Linux 7 External Web Service (SOAP Service) Problem Below is the exception thrown when trying to invoke an external webservice (SSL Based) via BPEL process- <bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>oracle.fabric.common.FabricInvocationException: Unable to invoke endpoint URI "https://idam.uppclonline.com/soa-infra/services/default/DefaultOperationalApproval!5.12*soa_69e4734b-d8fe-4edf-b44e-e287f61c2ddf/SMSNotification%23ApprovalProcess/SMSNotification" succe
Read more

Migration of Oracle SOA Suite Composite from 11g to 12c

-
Image
Recently I have came across a scenario where I have a business requirement of  migration of Oracle SOA Suite 11g(11.1.1.7.0) to 12c(12.1.3.0). Below are the different mechanisms I have tried to do, few of them failed and one succeeded. Working in Oracle SOA Suite 11g is completely different from 12c. In 11g, we need to install the jDeveloper(11.1.1.7) then SOA extension separately to be installed either via offline file  (download available at  https://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/156082.xml ) or through jDeveloper top menu >>  Help >> Check for Updates >> SOA Extension.  While working with 12c doesn't involves such tedious job. Only single installer is required for jDeveloper/SOA/Weblogic and is available as QuickStart Installer(download available at https://www.oracle.com/technetwork/middleware/soasuite/downloads/index.html). Approach 1- Compress(Zip) SOA composite code of 11g version (11.1.1.7.0) and unzip to a differe
Read more