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