adbldxml – ORA-27101: shared memory realm does not exist

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

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 VISN11 database instance…
Connection paramaters values:
Database server hostname ==> NGLINUX05.NEWGEN.COM
Database listener port ==> 1542
Database SID ==> VISN11
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
Now adbldxml runs successfully