Error ORA-01034 When Running Adcfgclone on Database Tier
(Doc ID 387739.1)
Last updated on MAY 05, 2024
Applies to:
Oracle Applications Manager - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]Information in this document applies to any platform.
Symptoms
Getting ORA-01034 Error when running adcfgclone on dbtier:
---------------------------------------------------------------
ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : host
sDbDomain : domain.com
sDbPort : 1610
sDbSid : sid
sDbUser : apps
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@host.domain.com:1610:sid
Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTO =tcp)(HOST=host.
domain.com)(PORT=1610))(CONNECT_DATA=(SERVICE_NAME=SID)))
Exception occurred: java.sql.SQLException: Io exception: Connection refused(
DESCRIPTION=(TMP=)(VSNNUM=153093888)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(
EMFI=4))))
Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTO =tcp)(HOST=host.
domain.com)(PORT=1610))(CONNECT_DATA=(SERVICE_NAME=sid.host.com)))
Exception occurred: java.sql.SQLException: Io exception: Connection refused(
DESCRIPTION=(TMP=)(VSNNUM=153093888)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(
EMFI=4))))
Connection could not be obtained; returning null
ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : host
sDbDomain : domain.com
sDbPort : 1610
sDbSid : sid
sDbUser : apps
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@host.domain.com:1610:sid
Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTO =tcp)(HOST=host.
domain.com)(PORT=1610))(CONNECT_DATA=(SERVICE_NAME=SID)))
Exception occurred: java.sql.SQLException: Io exception: Connection refused(
DESCRIPTION=(TMP=)(VSNNUM=153093888)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(
EMFI=4))))
Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTO =tcp)(HOST=host.
domain.com)(PORT=1610))(CONNECT_DATA=(SERVICE_NAME=sid.host.com)))
Exception occurred: java.sql.SQLException: Io exception: Connection refused(
DESCRIPTION=(TMP=)(VSNNUM=153093888)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(
EMFI=4))))
Connection could not be obtained; returning null
The issue can be reproduced at will with the following steps:
1. Running adcfgclone on dbtier
Verified the issue as noted below:
Trying to connect using SID as ServiceName.DomainName:
getConnectionUsingServiceName() -->
JDBC URL:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTO =tcp)(HOST=host.
domain.com)(PORT=1610))(CONNECT_DATA=(SERVICE_NAME=sid.domain.com)))
Exception occurred: java.sql.SQLException: Io exception: Connection refused(
DESCRIPTION=(TMP=)(VSNNUM=153093888)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(
EMFI=4))))
Connection could not be obtained; returning null
JDBC URL:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTO =tcp)(HOST=host.
domain.com)(PORT=1610))(CONNECT_DATA=(SERVICE_NAME=sid.domain.com)))
Exception occurred: java.sql.SQLException: Io exception: Connection refused(
DESCRIPTION=(TMP=)(VSNNUM=153093888)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(
EMFI=4))))
Connection could not be obtained; returning null
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 |
| Cause |
| Solution |