troubleshooting Question

Configure multiple Oracle listeners

Avatar of dbadm
dbadmFlag for Italy asked on
Oracle DatabaseNetworking
5 Comments1 Solution28 ViewsLast Modified:
Hi,
My Oracle version is: Oracle Database 19c EE on Oracle Linux Server 7.9

I've installed 3 Oracle databases single instance on hostname = oracledbsq01, PORT = 1521

[oracle@oracledbsq01]$ cat /etc/oratab

ORCLSDB:/u01/oracle/install:N
ORCLBDB:/u01/oracle/install:N
ORCLMDB:/u01/oracle/install:N


[oracle@oracledbsq01]$ ps -ef | grep -i pmon
oracle    1671     1  0 22:53 ?        00:00:00 ora_pmon_ORCLSDB
oracle    2492     1  0 22:55 ?        00:00:00 ora_pmon_ORCLBDB
oracle    3151     1  0 22:57 ?        00:00:00 ora_pmon_ORCLMDB


[oracle@oracledbsq01 admin]$ ls -ltr
-rw-r--r--. 1 oracle oinstall 1536 Feb 14  2018 shrept.lst
-rw-r-----. 1 oracle oinstall  175 Apr 13 23:48 sqlnet.ora
drwxr-xr-x. 2 oracle oinstall   64 Apr 26 23:24 samples

I need to understand how to Configure multiple Oracle listeners one for each database.

For example I'd like to configure the listener.ora file to have 3 listeners (LISTENER_ORCLSDB, LISTENER_ORCLBDB, LISTENER_ORCLMDB).

Thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros