Skip to Main Content

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!

listener.ora file for default & non default ports

JhilJun 28 2023

Dear Experts,

DB Version 12.2 and running on OL 6.7 (my own work station - Self practice).

I want to use non default port for new database and listener name would be LISTENER_HRMS

Already listener.ora file have entries for 2 databases. (which is for 1521 default port and listner name is LISTENER ).

[oracle@primdb admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = primdb)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = crms)
(ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome_1)
)
)

ADR_BASE_LISTENER = /u01/app/oracle

Question is

If i want to use listener name as LISTENER_HRMS &1522 port number for new database i.e (HRMS), shall i add entry for the HRMS database on the listener.ora file ? Kindly suggest me.

Thanks in Advance

Jhil

This post has been answered by Zoltán on Jun 30 2023
Jump to Answer
Comments
Post Details
Added on Jun 28 2023
6 comments
497 views