Re: 8.1.6 Listener problem

In article <3911002A.CDB9B219_at_stones.com>,   Karanbir <ksd_at_stones.com> wrote:
> 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
> >

Eric, I believe that with ver 8.1 you must make a special entry in the listener.ora file that tells the listener that it is listening for a ver 8 or below instance. I was told this by a friend who set up a ver 8.1 listener to listen for a ver 8.1 and 8.0 database. This should be in the Net 8.1 Admin manual and the Net 8 Assistant might have a sceen paramater for this.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.