I have a W2K Server with Oracle 8.1.7 installed and I have also installed
Oracle 9.0.1 on to this machine.
I have two listeners now, one for Oracle 8i on port 1521 and one for Oracle
9i on port 1522.
Is it possible to have the Oracle 9i listener listen for connections to
Oracle 8i databases?
Below is the listener.ora file I have for the Oracle 9i listener.
(ADDRESS = (PROTOCOL = TCP)(HOST = dboracle)(PORT = 1522))
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora90)
(PROGRAM = extproc)
(GLOBAL_DBNAME = SALES)
(ORACLE_HOME = c:\oracle\ora81)
(SID_NAME = SALES)
When I try to connect to the SALES database I get a Ora-12541 TNS: No
listener error message.