Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> 8.1.6 Listener Problem

8.1.6 Listener Problem

From: Erik Cohen <cohene_at_sdc-moses.com>
Date: 2000/05/03
Message-ID: <3910884d.25788622@news.bellatlantic.net>#1/1

Platform: Tru64 Unix version 4.0f Oracle 8.1.6

Problem: I loaded 8.1.6 in a separate ORACLE_HOME from the existing 8.0.4 ORACLE_HOME and updated 2 databases from 8.0.4.3 to 8.1.6 using the Oracle Data Migration Assistant. ODMA created a listener.ora and tnsnames.ora file in the 8.1.6 $ORACLE_HOME/network/admin directory. I added the 8.0.4 databases to the new listener.ora and tnsnames.ora files and did a lsnrctl start from the 8.1.6 ORACLE_HOME. I could connect to the 8.1.6 databases, but when I connect to the 8.0.4 databases I get an "ORA-12500: TNS listener failed to start a dedicated server process". I stopped the listener and restarted it from the 8.0.4 ORACLE_HOME and I was able to connect to the 8.0.4 databases, but got the ORA-12500 error on the 8.1.6 databases.

If anyone has got an 8.1.6 listener up and access both 8.1.6 and 8.0,4 instances, please respond with text from listener.ora and tnsnames.ora.

Thanks in advance

Erik L. Cohen
Database Administrator
Systems Development Center (SAIC)
6565 Arlington Blvd.
Falls Church, VA 22042 (USA)

E-mail: erik.l.cohen_at_saic.com

         erik.l.cohen_at_pipeline.com
         ebu_at_epaibm.rtpnc.epa.gov
Received on Wed May 03 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US