TNS Listener

[mlawrenson]

Hello,

I have a Windows 2000 server (service pack 2). Running ORacle 8174 and Oracle 9204.

I have 2 Oracle Homes
ORacle8
ORacle9

I have 2 listeners, Oracle 9 version, running from Oraclehome9 and ORacle 8 running from Oraclehome8. They are configured on different ports and have different names.

I have 2 databases ver8 and ver9. Oracle 8 listener listens to connections requesting ver8 database, and Oracle 9 listener listens to connections requesting ver9 database....obviously!

If I stop the Oracle9 listener, I can no longer connect to the ver8 database. Even though, as far as I can work out, the Oracle 9 listener knows nothing about the ver 8 database.

Any ideas why this might be? Thanks in advance!

 

[LKBrwnDBA]

1) You could use only one listener (9i) for both DB's.
2) It may be due to tnsnames.ora? do you have two tnsnames.ora files?
Copy the tnsnames.ora file to a 'generic directory' (non-oracle home) like c:\oracle\local.
Set the TNS_ADMIN=c:\oracle\local environment variable.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[dbtoo2001]

Doc ID: Note:69546.1
Subject: Oracle8i - Instance Registration to Listeners
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 15-APR-1999
Last Revision Date: 31-JAN-2002


Introduction
~~~~~~~~~~~~

From Oracle 8i onwards, database instances can register themselves with the
Listener when started. Prior to this release, information about the
instance was required to be manually configured in the "listener.ora" file.