Troubleshooting
Problem
After installing TADDM pointing to an Oracle RAC database server, the URL must be updated to use service name rather then SID otherwise database communication problems will occur.
Symptom
There are several different errors that may manifest within the storage server when the incorrect database URL is used. Typically there are many NullPointerException errors followed by "IO Error" or "Connection Reset". Examples below.
ERROR changemgr.ChangeManagerPersisterImpl - Exception while getting display name for id=33FBB2A71AA73A4388B6FF28AEE67777
java.sql.SQLException: IO Error: Connection reset
java.sql.SQLException: IO Error: Broken pipe
com.collation.proxy.api.client.ApiException: java.rmi.RemoteException: CTJOX0193E The application cannot get objects from the Topology Manager: java.rmi.RemoteException: Listener refused the
connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Cause
In an Oracle RAC Setup, the service name should be used rather then SID. This change must be done post installation as noted at:
http://www-01.ibm.com/support/knowledgecenter/SSPLFC_7.2.2/com.ibm.taddm.doc_7.2.2/InstallGuide/t_cmdb_install_oracle_rac.html?lang=en
Resolving The Problem
Update collation.properties to use service name in the URL rather then SID. Change both the primary and archive URL. If there is a firewall between the database and storage servers also include ENABLE=BROKEN on the URL. For example:
com.collation.db.url=jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=taddm.db.ibm.com))(CONNECT_DATA=(service_name=TADDM)))
com.collation.db.archive.url=jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=BROKEN)(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=taddm.db.ibm.com))(CONNECT_DATA=(service_name=TADDM)))
Note that each URL should be one line within the file.
Product Synonym
TADDM
Was this topic helpful?
Document Information
Modified date:
23 June 2018
UID
swg21690189