troubleshooting Question

Configure multiple Oracle listeners

Avatar of dbadm
dbadmFlag for Italy asked on
NetworkingOracle Database
5 Comments1 Solution30 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
ASKER CERTIFIED SOLUTION
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 5 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 5 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004