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 AUGUST 07, 2024
Applies to:
Oracle E-Business Suite Technology Stack - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]Information in this document applies to any platform.
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
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
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)))
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)))
Changes
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 |