Sync Midtier Database Script Fails With Error: Exception in thread "main" java.lang.RuntimeException: No ADDRESS element in tns string
(Doc ID 3061816.1)
Last updated on DECEMBER 06, 2024
Applies to:
Oracle Analytics Server - Version 2024 and laterInformation in this document applies to any platform.
Symptoms
When trying to run the synchronization DB RCU script (sync_midtier_db.sh) experiencing the following error:
ERROR
-----------------------
weblogic@pxl1obi00001:jdbc [0] $ $DOMAIN_HOME/bitools/bin/sync_midtier_db.sh
Nov 25, 2024 11:35:52 AM com.oracle.cie.domain.info.variable.DomainVariableServiceImpl
INFO: initializing domaininformation object.
Nov 25, 2024 11:35:53 AM com.oracle.cie.domain.info.variable.DomainVariableServiceImpl
INFO: initializing domaininformation object.
Exception in thread "main" java.lang.RuntimeException: No ADDRESS element in tns string: (DESCRIPTION_N = (CONNECT_TIMEOUT =10)(TRANSPORT_CONNECT_TIMEOUT = 3)(RETRY_COUNT = 3)(ADDRESS_LIST = (LOAD_BALANCEserver)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = sp3e05oas001)))(DESCRIPTION =(CONNECOUNT = 3)(ADDRESS_LIST =(LOAD_BALANCE = on)(ADDRESS = (PROTOCOL =TCP)(HOST = exa02-scan.servicos.bb.co3e05oas001))))
at oracle.bi.syncmidtierdb.db.oracle.DBDetailFactoryOracleHelper.createDetailsFromInlineTNS(DB
at oracle.bi.syncmidtierdb.db.oracle.DBDetailsFactoryOracle.createDetails(DBDetailsFactoryOrac
at oracle.bi.syncmidtierdb.db.JDBCURLParser.getDBDetailsFromURL(JDBCURLParser.java:31)
at oracle.bi.syncmidtierdb.DatasourceHelper.createDatasource(DatasourceHelper.java:89)
at oracle.bi.syncmidtierdb.DatasourceHelper.createDatasource(DatasourceHelper.java:69)
at oracle.bi.syncmidtierdb.DatasourceHelper.getWlsDatasources(DatasourceHelper.java:53)
at oracle.bi.syncmidtierdb.SyncMidtierDb.sync(SyncMidtierDb.java:263)
at oracle.bi.syncmidtierdb.SyncMidtierDb.mainEx(SyncMidtierDb.java:137)
at oracle.bi.syncmidtierdb.SyncMidtierDb.main(SyncMidtierDb.java:72)
-----------------------
weblogic@pxl1obi00001:jdbc [0] $ $DOMAIN_HOME/bitools/bin/sync_midtier_db.sh
Nov 25, 2024 11:35:52 AM com.oracle.cie.domain.info.variable.DomainVariableServiceImpl
INFO: initializing domaininformation object.
Nov 25, 2024 11:35:53 AM com.oracle.cie.domain.info.variable.DomainVariableServiceImpl
INFO: initializing domaininformation object.
Exception in thread "main" java.lang.RuntimeException: No ADDRESS element in tns string: (DESCRIPTION_N = (CONNECT_TIMEOUT =10)(TRANSPORT_CONNECT_TIMEOUT = 3)(RETRY_COUNT = 3)(ADDRESS_LIST = (LOAD_BALANCEserver)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = sp3e05oas001)))(DESCRIPTION =(CONNECOUNT = 3)(ADDRESS_LIST =(LOAD_BALANCE = on)(ADDRESS = (PROTOCOL =TCP)(HOST = exa02-scan.servicos.bb.co3e05oas001))))
at oracle.bi.syncmidtierdb.db.oracle.DBDetailFactoryOracleHelper.createDetailsFromInlineTNS(DB
at oracle.bi.syncmidtierdb.db.oracle.DBDetailsFactoryOracle.createDetails(DBDetailsFactoryOrac
at oracle.bi.syncmidtierdb.db.JDBCURLParser.getDBDetailsFromURL(JDBCURLParser.java:31)
at oracle.bi.syncmidtierdb.DatasourceHelper.createDatasource(DatasourceHelper.java:89)
at oracle.bi.syncmidtierdb.DatasourceHelper.createDatasource(DatasourceHelper.java:69)
at oracle.bi.syncmidtierdb.DatasourceHelper.getWlsDatasources(DatasourceHelper.java:53)
at oracle.bi.syncmidtierdb.SyncMidtierDb.sync(SyncMidtierDb.java:263)
at oracle.bi.syncmidtierdb.SyncMidtierDb.mainEx(SyncMidtierDb.java:137)
at oracle.bi.syncmidtierdb.SyncMidtierDb.main(SyncMidtierDb.java:72)
Changes
Running utility after making system changes. Issue also applies when upgrading cluster instance.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |