Re: 8.1.6 Listener Weirdness

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Tue, 15 Aug 2000 14:07:10 -0400
Message-Id: <10590.114635@fatcity.com>

--------------99D6F839E01EC177D771D2CC
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

8.1.6 listener dont play nice with 8.1.5 and vice versa.

isnt this the problem?
(SID_DESC =

      (GLOBAL_DBNAME = qodd)
      (ORACLE_HOME = /oracle/dbserver/8.1.5)
      (SID_NAME = qodd)

)

joe

"Koivu, Lisa" wrote:

>
>
> I am at my wits' end here. I have a TAR logged with support.
> I have installed 8.1.6 on our HP/UX 11.0 host. Upgrade of database
> was smooth, no errors, database is behaving normally (so far). We
> have DBMS_UTILITY back.
>
> However I CAN NOT START an 8.1.6 listener!! The 8.1.5 listener can't
> listen for the 8.1.6 database (I tried that too) so I tried to start a
> second listener on a different port. No dice. lsnrctl thinks I am
> trying to start a listener with the same attributes as the 8.1.5
> listener.
>
> My environment variables are all set to 8.1.6, there is no 8.1.5
> anywhere.
> I have un-set SHLIB_PATH and LD_LIBRARY_PATH as suggested in
> description of bug 1355618.
> I have also tried having the 8.1.6 listener listen for both the 8.1.6
> db and 8.1.5 db. Doesn't work either.
>
> Out of ideas and waiting on an iTar response (and taking bets on how
> long it will be.) In the meantime our development team will grind to
> a standstill eventually - I know it's not a production outage, but
> it's darn near that. It's my neck if 30 people can't do any work.
>
> Here's my listener.ora. It does not recognize the name I have given
> it (won't accept start LSNR816).
>
> ANY suggestions are appreciated. Thanks in advance.
>
> LSNR816 =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.13)(PORT = 1526))
>
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.13)(PORT = 2486))
>
> )
> )
>
> SID_LIST_LSNR816 =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /oracle/dbserver/8.1.6)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = qodd)
> (ORACLE_HOME = /oracle/dbserver/8.1.5)
> (SID_NAME = qodd)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = qodt)
> (ORACLE_HOME = /oracle/dbserver/8.1.6)
> (SID_NAME = qodt)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = viking)
> (ORACLE_HOME = /oracle/dbserver/8.1.6)
> (SID_NAME = viking)
> )
> )
>
>
> Lisa Rutland Koivu
> Oracle Database Administrator
> Qode.com
> 4850 North State Road 7
> Suite G104
> Fort Lauderdale, FL 33319
>
> V: 954.484.3191, x174
> F: 954.484.2933
> C: 954.658.5849
> http://www.qode.com
>
> "The information contained herein does not express the opinion or
> position of Qode.com and cannot be attributed to or made binding upon
> Qode.com."

--------------99D6F839E01EC177D771D2CC
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html>
8.1.6 listener dont play nice with 8.1.5 and vice versa.

<p>isnt this the problem?
<br>(SID_DESC =
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (GLOBAL_DBNAME = qodd)
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ORACLE_HOME = /oracle/dbserver/8.1.5)
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID_NAME = qodd)
<br>&nbsp;&nbsp;&nbsp; )
<br>&nbsp;
<br>&nbsp;
<p>joe
<br>&nbsp;
<p>"Koivu, Lisa" wrote:
<blockquote TYPE=CITE>&nbsp;
<p><font face="Arial"><font size=-1>I am at my wits' end here.&nbsp; I

have a TAR logged with support. I have installed 8.1.6 on our HP/UX 11.0 host.  Upgrade of database was smooth, no errors, database is behaving normally (so far).  We have DBMS_UTILITY back. However I CAN NOT START an 8.1.6 listener!!  The 8.1.5 listener can't listen for the 8.1.6 database (I tried that too) so I tried to start a second listener on a different port.  No dice. lsnrctl thinks I am trying to start a listener with the same attributes as the 8.1.5 listener.
My environment variables are all set to 8.1.6, there is no 8.1.5 anywhere. I have un-set SHLIB_PATH and LD_LIBRARY_PATH as suggested in description of bug 1355618. I have also tried having the 8.1.6 listener listen for both the 8.1.6 db and 8.1.5 db.  Doesn't work either.
Out of ideas and waiting on an iTar response (and taking bets on how long it will be.)  In the meantime our development team will grind to a standstill eventually - I know it's not a production outage, but it's darn near that. It's my neck if 30 people can't do any work.
Here's my listener.ora.  It does not recognize the name I have given it (won't accept start LSNR816). ANY suggestions are appreciated.  Thanks in advance.
LSNR816 =   (DESCRIPTION_LIST =
     (DESCRIPTION =

<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
(ADDRESS_LIST =</font></font>
<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))       )

<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
(ADDRESS_LIST =</font></font>
<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.13)(PORT = 1526))       )
     )     (DESCRIPTION =
       (PROTOCOL_STACK =

<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
(PRESENTATION = GIOP)</font></font>
<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

(SESSION = RAW)
       )
         (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.13)(PORT = 2486))

<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp; )</font></font>
<br><font face="Courier New TUR"><font size=-1>&nbsp; )</font></font>
<p><font face="Courier New TUR"><font size=-1>SID_LIST_LSNR816 =</font></font>
<br><font face="Courier New TUR"><font size=-1>&nbsp; (SID_LIST =</font></font>
<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp; (SID_DESC

=
       (SID_NAME = PLSExtProc)
       (ORACLE_HOME = /oracle/dbserver/8.1.6)

<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
(PROGRAM = extproc)</font></font>
<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp; )</font></font>
<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp; (SID_DESC

=
       (GLOBAL_DBNAME = qodd)
       (ORACLE_HOME = /oracle/dbserver/8.1.5)       (SID_NAME = qodd)
     )     (SID_DESC =
       (GLOBAL_DBNAME = qodt)
       (ORACLE_HOME = /oracle/dbserver/8.1.6)       (SID_NAME = qodt)
     )     (SID_DESC =
       (GLOBAL_DBNAME = viking)
       (ORACLE_HOME = /oracle/dbserver/8.1.6)

<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
(SID_NAME = viking)</font></font>
<br><font face="Courier New TUR"><font size=-1>&nbsp;&nbsp;&nbsp; )</font></font>
<br><font face="Courier New TUR"><font size=-1>&nbsp; )</font></font>
<br>&nbsp;
<p><b><font face="Arial"><font size=-2>Lisa Rutland Koivu</font></font></b>
<br><font face="Arial"><font size=-2>Oracle Database Administrator</font></font>
<br><font face="Arial"><font size=-2>Qode.com</font></font>
<br><font face="Arial"><font size=-2>4850 North State Road 7</font></font>
<br><font face="Arial"><font size=-2>Suite G104</font></font>
<br><font face="Arial"><font size=-2>Fort Lauderdale, FL&nbsp; 33319</font></font>
<p><font face="Arial"><font size=-2>V: 954.484.3191, x174</font></font>
<br><font face="Arial"><font size=-2>F: 954.484.2933</font></font>
<br><font face="Arial"><font size=-2>C: 954.658.5849</font></font>

http://www.qode.com "The information Received on Tue Aug 15 2000 - 13:07:10 CDT