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' ;
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
Index Usage – 21 week ago
-
-
-
-
-
-
-
-
Oracle Cloud & Third party tools3 years ago
-
-
-
Moving Sideways7 years ago
-
Upcoming Events...10 years ago
-
8 comments:
nice and simple
thanks
Stefaan
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
have you follow the above steps ?
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?
thanks alot it works
thanks alot dude
it works
boss your solution is highly appreciable. i could resolve the error by following the steps given
thanks a ton
Thanks, its working fine :)
Post a Comment