O2C PIP - Product Sync Is Not Working As Expected (Doc ID 2002586.1)

Last updated on MAY 02, 2023

Applies to:

Goal

After the O2C and AABC PIP Installation [11.1.1.7] and BRM reinstallation, product sync is not working.

Impact at AIA side based on BRM changes:-

1) Modified the AIAInstallProperties.xml under $AIA_INSTANCE/config folder
2) Uploaded the AIAInstallProperties.xml changes to MDS by ant script run [cd $AIA_HOME/Infrastructure/Install/config & ant –f UpdateMetaData.xml]
3) OracleBRMJCA15Adapter was modified and deployed with new BRM Port value.
4) Updated the DataSource [PortalEventSyncAQ1DS] from Admin Console with new User and Password details, also with new BRM DB SID value
5) Restarted the Managed and Admin Server [Standalone server]
 

In RAC configuration, following connection string was created ,it works but only pointing to one of the instances of the RAC, which is not correct. 

• ADAPTER: oracle.jdbc.OracleDriver

 CONNECTION STRING: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=HOSTNAME)(INSTANCE_NAME=HOSTNAME1)))

Currently used the following connection string as declared in the TNSNAMES.ORA but not working for multiple RAC instance connections configurations

BRMDEVX =
(DESCRIPTION =
(LOAD_BALANCE=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = host3)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = host4)(PORT = 1522))
(CONNECT_DATA =(SERVER = DEDICATED)
(SERVICE_NAME = BRMDEV)
)
)

We need advice on setting a proper connection string for multiple RAC instance connections configurations?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.