Autoconfig Error On Dbtier After Upgrade - afdbprf.sh and adcrobj.sh fail with ORA-27101: shared memory realm does not exist (Doc ID 422709.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle Applications Technology Stack - 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 27-JAN-2013

Symptoms

When running Autoconfig on the database tier, afdbprf.sh fails with:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory


ERRORCODE = 1 ERRORCODE_END

 


adcrobj.sh fails with:

ORA-01012: not logged on
SP2-0359: memory exhausted
Disconnected
adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END

 

This is followed with:

getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@<hostname>.<domain>.com:23002:xxxxxx
Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>.<domain>.com)(PORT=23002))(CONNECT_DATA=(SERVICE_NAME=xxxxxx)))
Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>.<domain>.com)(PORT=23002))(CONNECT_DATA=(SERVICE_NAME=xxxxxx.<domain>.com)))
Exception occurred: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>.<domain>.com)(PORT=23002))(CONNECT_DATA=(SERVICE_NAME=xxxxxx.<domain>.com)))

 

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