Tuesday, May 10, 2022
adbld.xml fails during upgrade step : Generate a new database context file as follows:
oraupg@TESTDB:/data/tech_st/19c/appsutil/bin$ perl adbldxml.pl
Starting context file generation for db tier..
Using JVM from /data/tech_st/19c/appsutil/jre/bin/java to execute java programs..
APPS Password:
The log file for this adbldxml session is located at:
/data/tech_st/19c/appsutil/log/adbldxml_05101159.log
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Additional information: 2852
Additional information: 1180227351
Connecting to the CRPPP database instance...
Connection parameters values:
Database server hostname ==> TESTDB.DOMAIN.COM
Database listener port ==> 1571
Database SID ==> CRPPP
Database schema name ==> apps
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Additional information: 2852
Additional information: 1180227351
AC-40000: Error: Exception - java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Additional information: 2852
Additional information: 1180227351
occurred while connecting to the database - CRPPP
Could not Connect to the Database with the above parameters, Please answer the Questions below
Enter Hostname of Database server[TESTDB.DOMAIN.COM]:
Enter Port of Database server[1571]:
Enter SID of Database server[CRPPP]:
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Additional information: 2852
Additional information: 1180227351
Could not Connect to the Database with the above parameters, Please answer the Questions below
Enter Hostname of Database server[TESTDB.DOMAIN.COM]:^C^C
Solution : Add parameter USE_SID_AS_SERVICE_LISTENER=ON in the listner.ora and repalce LISTENER with your listner name, relaod the listner and retry adbldxml.pl
Subscribe to:
Posts (Atom)