When
trying to start the Oracle Database 11g , Its return following message below:
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 (C:\oracle11G\app\oracle\admin\db11g\pfile).
then
comment the LOCAL_LISTENER parameter like #LOCAL_LISTENER
Then
start the Database with pfile.
SQL>
startup pfile=C:\oracle11G\app\oracle\admin\db11g\pfile\init.ora.11312009193622
;
and
then
SQL>
create spfile from pfile='C:\oracle11G\app\oracle\admin\db11g\pfile\init.ora.11312009193622'
;
No comments:
Post a Comment