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!

Database on non-default port

722837Mar 16 2011 — edited Mar 18 2011

Dear Gurus,

A small query, whenever we have a database that has its listener configured on a non default port (i.e. other than 1521), we have to specify local_listener parameter in the instance file. Now I have 2 databases (Win-2K and Oracle 10.2.0.4), both databases are registered on 1528 port (on listener). and only one of my database has local_listener parameter set.

Now the query is, if my other database has local_listener as NULL then how is it possible for the users to connect to the database (I tried removing the local_listener entry, and then the database was not being shown in the lsnrctl status, and when I include the parameter, the lsnrctl status shows the database)

Thanks,
Ajinkya

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2011

Added on Mar 16 2011

#general-database-discussions

9 comments

830 views