Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

DBUA - ORA-0019 invalid specification for system parameter LOCAL_LISTENER ORA-0032: syntax error or

edited Mar 3, 2017 10:19AM in Database Install/Upgrade/Opatch (MOSC) 7 commentsAnswered

I was trying to follow this doc https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD105 

in order to upgrade from 11.2.0.4 to 12.1.0.2.  The process fails immediately with the subject error:

ORA-0019 invalid specification for system parameter LOCAL_LISTENER ORA-0032: syntax error or unresolved network name 'LISTENER_T1104'

Mixed signals all over the place on this.  This guy says you have to move the spfile or init.ora to the target ORACLE_HOME.  He also says you have to copy the TNSNAMES and LIstener.ora to the target.

https://pavandba.com/tag/dbua-failing-with-local_listener-parameter-error/

This is confusing.  Why does the guide not say any of this, or perhaps it is false.  Something is off, for sure.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center