Database Networking (MOSC)

MOSC Banner

My listener configuration produces multiple instances of the same db

Database 19.3 Standard Edition 2 on Oracle Linux 8.8 (vm on ESXi 8)

Initially, my listener.ora had only a simple statement:

LISTENER =

 (ADDRESS_LIST =

    (ADDRESS= (PROTOCOL= TCP)(Host=<hostname>)(Port= 1521))

 )

I wanted to register multiple databases to the single LISTENER, but merely naming them in tnsnames.ora didn't give me access via sqlplus. I edited listener.ora to list the databases.

SID_LIST_LISTENER =

 (SID_LIST =

   (SID_DESC =

     (GLOBAL_DBNAME = mriTEST)

     (ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)

     (SID_NAME = mriTEST)

   )

   (SID_DESC =

     (GLOBAL_DBNAME = mri10)

     (ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)

     (SID_NAME = mri10)

   )

 )


LISTENER =

 (DESCRIPTION_LIST =

   (DESCRIPTION =

     (ADDRESS_LIST =

       (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname>)(PORT = 1521))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center