Error ORA-01034 When Running Adcfgclone on Database Tier (Doc ID 387739.1)

Last updated on AUGUST 29, 2017

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.
Checked for relevance on 30-SEP-2016

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

 
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

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms