Friday, April 3, 2009

Error while running adbldxml.pl after upgrading database to 11.1.0.7 from 9.2.0.8

Error while running adbldxml.pl after upgrading database to 11.1.0.7 from 9.2.0.8
The following error was encountered while running adbldxml.pl on the database tier to create the context file.


====================================================================
Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Connecting to the wish database instance...

Connection paramaters values:
Database server hostname ==> SPINNER.LINKPC.NET
Database listener port ==> 1523
Database SID ==> wish
Database schema name ==> apps

Could not Connect to the Database : ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory


AC-40000: Error: Exception - java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
====================================================================


The problem was that the database was not registered with the listener.




SQL> show parameter local_listener;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string




The value for LOCAL_LISTENER is missing, so automatic instance registration is not taking place
We can correct this by setting the LOCAL_LISTENER parameter:


SQL> alter system set local_listener='(ADDRESS =(PROTOCOL=TCP)(HOST=host.domain.com)(PORT=port_number)(SID=sid_name))';

System altered.

SQL> alter system register;

System altered.


SQL> exit

Check TNS_ADMIN value. This should point to new O-H Path i.e., 11.1.0.6

Now adbldxml runs successfully.