Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to change default listener port?

Dario B.Feb 8 2011 — edited Feb 8 2011

I know that this topic appeared several times, but I did not found a clue...
So, DB 11g R2 on linux (suse), and I installed database on port 1521.

I would like to change this port, so I shut down database & listener, change port number (in listener.ora and tnsnames.ora) and restarted listener and db instance.
After that I receive ORA-12514 error... I tried to to do 'alter system register', but nothing works.

listener status is:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.1)(PORT=1571)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_BONGO
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                08-FEB-2011 18:48:28
Uptime                    0 days 0 hr. 11 min. 29 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/11.2.0/bongoserver/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/bongoserver/listener_bongo/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.1)(PORT=1571)))
The listener supports no services
The command completed successfully

how to register db instance with listener?

This post has been answered by Viacheslav Ostapenko on Feb 8 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2011

Added on Feb 8 2011

#general-database-discussions, #listener

8 comments

357 views