INSTALLATION DOCUMENTS BY RAVI

Friday, April 14, 2017

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

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

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...