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, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Thursday, March 4, 2010
ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER
Labels:
ora-error
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 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