Re: 8.1.6 Listener problem

From: Karanbir <ksd_at_stones.com>
Date: 2000/05/04
Message-ID: <3911002A.CDB9B219@stones.com>#1/1

Hi Erik,

Well I think you can have more then One Listeners, ie seperate for each one.

There you can start in different Port Number and have different Oracle Home.

Hope it works for you.

I tried it worked for me.

Sample below after having the 2 listeners :-

Since in Listener.ora :-
LISTENER =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = pmserver)(PORT = 1521))
      )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PMDB)
      (ORACLE_HOME = /oracle/8.0.4)

    )
  )
LIST =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = pmserver)(PORT = XYZ))
      )

SID_LIST_LIST =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = YYY)
      (ORACLE_HOME = /oracle/8.1.5)

    )
  )

Bye

Karanbir.

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
> 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 Thu May 04 2000 - 00:00:00 CDT