Re: Oracle 8.1.7 NET8 problem

From: Enkidu Utnapishtim <utnapishtim43NOSPAM_at_hotmail.com>
Date: Mon, 22 Jul 2002 20:05:04 GMT
Message-ID: <3D3C656F.50204@hotmail.com>

Sinisa,

In your listener.ora on the server, something like:

LISTENER =
   (DESCRIPTION_LIST =

     (DESCRIPTION =


       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

     )
     (DESCRIPTION =


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

     )
     (DESCRIPTION =


       (PROTOCOL_STACK =

         (PRESENTATION = GIOP)
         (SESSION = RAW)
       )


       (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 2481))

     )

   )

SID_LIST_LISTENER =
   (SID_LIST =

     (SID_DESC =


       (SID_NAME = PLSExtProc)

       (ORACLE_HOME = /export/home/oracle/u01/app/oracle/product/8.1.7)

       (PROGRAM = extproc)

     )
     (SID_DESC =


       (GLOBAL_DBNAME = DB1)

       (ORACLE_HOME = /export/home/oracle/u01/app/oracle/product/8.1.7)

       (SID_NAME = DB1)

     )
     (SID_DESC =


       (GLOBAL_DBNAME = DB2)

       (ORACLE_HOME = /export/home/oracle/u01/app/oracle/product/8.1.7)

       (SID_NAME = DB2)

     )

   )

In your tnsnames.ora on the client, something like:

FOO1=
   (description=

     (address_list=


       (address=(protocol=tcp)(host=hostname)(port=1521))

     )
     (connect_data=(server=shared)(service_name=db1))

   )

FOO2=
   (description=

     (address_list=


       (address=(protocol=tcp)(host=hostname)(port=1521))

     )
     (connect_data=(server=shared)(service_name=db2))

   )

You might change "server=shared" to "server=dedicated" (or leave out) if you're not using multi-threaded servers.

 From client, connect to DB1:

sqlplus user/pass_at_foo1

 From client, connect to DB2:

sqlplus user/pass_at_foo2

HTH,
Roger Crowley - DBA - LearningFramework

Sinisa wrote:

> I have configured 2 Oracle's instances on the same server. From client
> I can't connect to second instance.
> Any help is welcome.
> Thanks's in advance.

Received on Mon Jul 22 2002 - 15:05:04 CDT