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

3 comments:


  1. Many innovative methods are emerging in the world of custom apparel, allowing designers to bring their visions to life with greater ease. One popular technique involves using dtf transfers for vibrant and durable prints on various fabrics. This technology not only enhances color accuracy but also ensures the longevity of the design, making it a preferred choice for both small businesses and large manufacturers. As the industry evolves, embracing such advancements can significantly improve product quality and customer satisfaction.

    ReplyDelete

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...