[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference eps::oracle

Title:Oracle
Notice:For product status see topics: UNIX 1008, OpenVMS 1009, NT 1010
Moderator:EPS::VANDENHEUVEL
Created:Fri Aug 10 1990
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1574
Total number of notes:4428

1562.0. "TNSNAMES.ORA and LISTENER.ORA" by VAXRIO::NOVELLO (Cristina Novello - Sales Suport/RJ) Tue May 13 1997 18:50

Hi,

I'm using Oracle 7.3.2 with OVMS 7.0.
We are trying to work with 2 different instances from
2 different clients (PC with Windows 95 and SQL*plus).

Below are the LISTENER.ORA and TNSNAMES.ORA files.
When we try to connect to alu1 or orcl from SQL*plus
(PC) we are connected to alu2!!!
If we change the order of the tnsnames, for instance,
orcl, alu2 and alu1, everybody will connect to alu1 
(the last defined) even if we specify another instance
to connect.

The TNSNAMES.ORA from the PC is also properly defined.

We are using the same port for all instances that is defined
at the LISTENER.ORA. 

Is that correct? What are we doing wrong?

Thanks in advance,
Cristina Novello
Sales Support/Brazil.

===========================================================================
The LISTENER.ORA file:

LISTENER=
     (ADDRESS_LIST=
     (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=1.0.0.1)
      (PORT=1521))
      )

    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 10
    TRACE_LEVEL_LISTENER = 16
    TRACE_DIRECTORY_LISTENER = DKA100:[ORACLE7.NETWORK.LOG]
    LOG_DIRECTORY_LISTENER = DKA100:[ORACLE7.NETWORK.LOG]

    SID_LIST_LISTENER=
     (SID_LIST=
      (SID_DESC=
       (SID_NAME=orcl)
       (PROGRAM='dka100:[oracle7.network.admin]orasrv_netv2.com')
      )
      (SID_DESC=
       (SID_NAME=alu1)
       (PROGRAM='dka100:[oracle7.network.admin]orasrv_netv2.com')
      )
      (SID_DESC=
       (SID_NAME=alu2)
       (PROGRAM='dka100:[oracle7.network.admin]orasrv_netv2.com')
      )

     )

===========================================================================
The TNSNAMES.ORA file:

    orcl=
            (DESCRIPTION=
                    (ADDRESS_LIST =
                            (ADDRESS =
                                    (PROTOCOL = TCP)
                                    (HOST = 1.0.0.1)
                                    (PORT = 1521)
                            )
                    )
                    (CONNECT_DATA =
                            (SID = orcl)
                    )
            )
    alu1=
            (DESCRIPTION=
                    (ADDRESS_LIST =
                            (ADDRESS =
                                    (PROTOCOL = TCP)
                                    (HOST = 1.0.0.1)
                                    (PORT = 1521)
                            )
                    )
                    (CONNECT_DATA =
                            (SID = alu1)
                    )
            )
    alu2=
            (DESCRIPTION=
                    (ADDRESS_LIST =
                            (ADDRESS =
                                    (PROTOCOL = TCP)
                                    (HOST = 1.0.0.1)
                                    (PORT = 1521)
                            )
                    )
                    (CONNECT_DATA =
                            (SID = alu2)
                    )
            )
===========================================================================

T.RTitleUserPersonal
Name
DateLines