Sunday, September 20, 2009

Startup fails with oracle error ORA-00119, ORA-00132

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER'

If the tnsnames.ora entry was used for the value of the LOCAL_LISTENER and the LOCAL_LISTENER entry inside tnsnames.ora is changed or tnsnames.ora file is moved and hence the tns alias to which the LOCAL_LISTENER parameter points is no longer valid. So, the entry inside spfile or pfile to be unresolvable, and the database will not start.

I)Correct the tnsnames.ora



Just go to pfile (\d01\oracle11G\admin\db11g\pfile).
then comment the LOCAL_LISTENER parameter like


Then start the Database with pfile.

SQL> startup pfile=C:\oracle11G\app\era-1\admin\db11g\pfile\init.ora.11312009193622 ;

and then

SQL> create spfile from pfile='C:\oracle11G\app\era-1\admin\db11g\pfile\init.ora.11312009193622' ;

1 comment:

Lantrix said...

That helped. I had to correct the entry in the PFILE. Thanks.