Database Administration (MOSC)

MOSC Banner

Why can not they connect in the second instance?

edited Sep 4, 2017 5:01AM in Database Administration (MOSC) 3 commentsAnswered

Hello,

                 I have 2 non-cdb instances in Oracle 12c.

         TNSNAMES.ORA:

# tnanames.ora Network Configuration File: /ora00/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora

#Generated by Oracle configuration tools.

db2 =

   (DESCRIPTION =

      (ADDRESS_LIST =

         (ADDRESS =

            (PROTOCOL=TCP)

            (HOST=xxx)

            (PORT=1521)))

   (CONNECT_DATA = (SID = db2))

)

db1 =

  (DESCRIPTION =

     (ADDRESS_LIST =

        (ADDRESS =

           (PROTOCOL=TCP)

           (HOST=xxx)

           (PORT=1521)))

  (CONNECT_DATA = (SID = db1))

)

LISTENER.ORA

# listener.ora Network Configuration File: /ora00/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER=

   (DESCRIPTION_LIST=

       (DESCRIPTION=

           (ADDRESS_LIST=

               (ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1521))

           )

       )

   )

PROC=

   (DESCRIPTION_LIST=

      (ADDRESS_LIST=

         (ADDRESS=(PROTCOL=IPC)(KEY=EXTPROC0))

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