Thursday 11 July 2013

FIX- ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'db11g'

EASY fix.

Instead of spfile, start your database from pfile, and if the database starts then create a new spfile from it. 

Otherwise remove the local_listener parameter from the pfile and spfile and try starting it. 

$ cd $ORACLE_HOME/dbs
$  ls -rt
$ vi initdb11g.ora

and remove 
*.local_listener='db11g'

$ vi spfiledb11g.ora

and remove 
*.local_listener='db11g'

$ sqlplus / as sysdba

SQL> startup;
ORACLE instance started.

Total System Global Area  830930944 bytes
Fixed Size    2217912 bytes
Variable Size  641730632 bytes
Database Buffers  180355072 bytes
Redo Buffers    6627328 bytes
Database mounted.
Database opened.

SQL> select name from v$database;

NAME
---------
DB11G

Wonders!!!!!