How to change my LOCAL_LISTENER
This is probably the wrong forum, but I ran into this problem while doing an Upgrade and thought someone might have an quick answer for me.
I installed Oracle 11g, and created a database, while I still had a LISTENER still running on port 1521.
Therefore my LOCAL_LISTENER, and database, was created on port 1522.
Now I want to Upgrade my Application Server to 11g, from 10g, and it needs remain on port 1521.
If I do an upgrade from 11g using dbua the Application Server database gets modified to listen on port 1522.
This breaks the Application Server.
All I want to do is change the Listener from 1522 to 1521 so that I can use the dbua to upgrade my Application Server to 11g.
I think this is supposed to be easy, and it probably is for someone who know how to do it. But I need some help here.
A. I know to modify the Listener.ora file and the TnsNames.ora files.
B. When I try doing an: ALTER SYSTEM SET LOCAL_LISTENER='MYLISTENER' SCOPE=BOTH, I get this error:
invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'MYLISTENER'
What am I doing wrong?