Today , I was unable to generate new context file on database side after upgrading to 11.2.0.3.
When i ran adbldxml.pl file and provided apps password. scripts has failed with following error.
---------------------------------------------------------
ERROR:
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Connecting to the DEV database instance...
Connection paramaters values:
Database server hostname ==> local.localdomain.com
Database listener port ==> 1526
Database SID ==> DEV
Database schema name ==> apps
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
--------------------------------------------------------
After some analysis, i came to know that listener was not registered with new upgraded 11.2.0.3.
===============SOLUTIONS:===============
i have registered listener manually and performed following steps.
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
SQL> alter system set local_listener='(ADDRESS =(PROTOCOL=TCP)(HOST=EVO.EVOSYS.CO.IN)(PORT=1526)(SID=DEV))';
System altered.
SQL> alter system register;
System altered.
Now, create context file using adbldxml.perl file.
[orar12@nitin bin]$ perl adbldxml.pl
Starting context file generation for db tier..
Using JVM from /u01/app/orar12/db/tech_st/11.2.0/jdk/jre/bin/java to execute java programs..
APPS Password: apps
The log file for this adbldxml session is located at:
/u01/app/orar12/db/tech_st/11.2.0/appsutil/log/adbldxml_01200605.log
Enter the value for Display Variable: nitin:1.0
The context file has been created at:
/u01/app/orar12/db/tech_st/11.2.0/appsutil/DEV_nitin.xml
===============================
Context file has been created successfully after registered listener.
************Enjoy new upgraded Database.
When i ran adbldxml.pl file and provided apps password. scripts has failed with following error.
---------------------------------------------------------
ERROR:
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Connecting to the DEV database instance...
Connection paramaters values:
Database server hostname ==> local.localdomain.com
Database listener port ==> 1526
Database SID ==> DEV
Database schema name ==> apps
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
--------------------------------------------------------
After some analysis, i came to know that listener was not registered with new upgraded 11.2.0.3.
===============SOLUTIONS:===============
i have registered listener manually and performed following steps.
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
SQL> alter system set local_listener='(ADDRESS =(PROTOCOL=TCP)(HOST=EVO.EVOSYS.CO.IN)(PORT=1526)(SID=DEV))';
System altered.
SQL> alter system register;
System altered.
Now, create context file using adbldxml.perl file.
[orar12@nitin bin]$ perl adbldxml.pl
Starting context file generation for db tier..
Using JVM from /u01/app/orar12/db/tech_st/11.2.0/jdk/jre/bin/java to execute java programs..
APPS Password: apps
The log file for this adbldxml session is located at:
/u01/app/orar12/db/tech_st/11.2.0/appsutil/log/adbldxml_01200605.log
Enter the value for Display Variable: nitin:1.0
The context file has been created at:
/u01/app/orar12/db/tech_st/11.2.0/appsutil/DEV_nitin.xml
===============================
Context file has been created successfully after registered listener.
************Enjoy new upgraded Database.
