Re: 8.1.6 Listener Problem

What we ended up doiing is temporarily creating a second listener listeneing on port 1526 for 8.1.6. We were told that this problem is specific to Digital UNIX. When we finish upgrading all instances, we will change the primary listener back to port 1521 and eliminate the second one. This allows access between clients and instances that are at either level.

On Wed, 03 May 2000 20:18:59 GMT, cohene_at_sdc-moses.com (Erik Cohen) wrote:

>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

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