Thursday, March 4, 2010

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

When trying to startup the Oracle Database 11g , Its return following message.

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

Solution:
=========
In Oracle 11g

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

Then start the Database with pfile.
Like:=

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' ;

8 comments:

Anonymous said...

nice and simple
thanks
Stefaan

Anonymous said...

Hi,
I have same problem like above but my OS is windows7 I don't know how to enter those values
and also My oracle database itself not installed on laptop so I am unable to do any thing means I cannot connect sql to Db, please help me I am struggling since two days with this problem
Ananth

Muhammad Abdul Halim said...

have you follow the above steps ?

Khorshed said...

SQL> startup pfile=G:\app\Administrator\admin\orcl\pfile\init.ora.132012215240;
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

still appear these error. what should I do?

chilled.dba said...

thanks alot it works

chilled.dba said...

thanks alot dude
it works

Anonymous said...

boss your solution is highly appreciable. i could resolve the error by following the steps given
thanks a ton

Anonymous said...

Thanks, its working fine :)