8.1.6 Listener Weirdness

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Tue, 15 Aug 2000 13:47:39 -0400
Message-Id: <10590.114630@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C006E0.E8D3A7C0
Content-Type: text/plain;

charset="iso-8859-1"

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."

------_=_NextPart_001_01C006E0.E8D3A7C0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>8.1.6 Listener Weirdness</TITLE>
</HEAD>
<BODY>

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 =3D   (DESCRIPTION_LIST = =3D
     = (DESCRIPTION =3D
       (ADDRESS_LIST =3D         (ADDRESS =3D (PROTOCOL = =3D IPC)(KEY =3D EXTPROC0))
       )       (ADDRESS_LIST =3D         (ADDRESS =3D (PROTOCOL = =3D TCP)(HOST =3D 192.168.6.13)(PORT =3D 1526)) <FONT SIZE=3D2 FACE=3D"Courier New =

TUR">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New TUR">&nbsp;&nbsp;&nbsp; )</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New TUR">&nbsp;&nbsp;&nbsp; =

(DESCRIPTION =3D
       (PROTOCOL_STACK =3D         (PRESENTATION =3D = GIOP)
         (SESSION =3D = RAW)
       )         (ADDRESS =3D (PROTOCOL =

=3D TCP)(HOST =3D 192.168.6.13)(PORT =3D 2486))</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New TUR">&nbsp;&nbsp;&nbsp; )</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New TUR">&nbsp; )</FONT>

<P><FONT SIZE=3D2 FACE=3D"Courier New TUR">SID_LIST_LSNR816 =3D</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New TUR">&nbsp; (SID_LIST =3D</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New TUR">&nbsp;&nbsp;&nbsp; =

(SID_DESC =3D
       (SID_NAME =3D PLSExtProc)       (ORACLE_HOME =3D = /oracle/dbserver/8.1.6)
       (PROGRAM =3D extproc)     )     = (SID_DESC =3D
       (GLOBAL_DBNAME =3D qodd)       (ORACLE_HOME =3D = /oracle/dbserver/8.1.5)
       (SID_NAME =3D qodd)     )     = (SID_DESC =3D
       (GLOBAL_DBNAME =3D qodt)       (ORACLE_HOME =3D = /oracle/dbserver/8.1.6)
       (SID_NAME =3D qodt)     )     = (SID_DESC =3D
       (GLOBAL_DBNAME =3D viking)       (ORACLE_HOME =3D = /oracle/dbserver/8.1.6)
       (SID_NAME =3D viking)

<BR><FONT SIZE=3D2 FACE=3D"Courier New TUR">&nbsp;&nbsp;&nbsp; )</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New TUR">&nbsp; )</FONT>
</P>
<BR>
<BR>

<P><B><FONT SIZE=3D1 FACE=3D"Arial">Lisa Rutland Koivu</FONT></B>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">Qode.com</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">4850 North State Road 7</FONT>

Suite G104 Fort Lauderdale, FL  = 33319

<P><FONT SIZE=3D1 FACE=3D"Arial">V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">F: 954.484.2933 </FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial">C: 954.658.5849</FONT>
<BR><FONT SIZE=3D1 FACE=3D"Arial"><A HREF=3D"http://www.qode.com" =

TARGET=3D"_blank">http://www.qode.com</A>

"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."

</BODY>
</HTML>
------_=_NextPart_001_01C006E0.E8D3A7C0--

From: "Jamadagni, Rajendra" <rajendra.jamadagni_at_espn.com> Date: Tue, 15 Aug 2000 13:45:22 -0400
Subject: RE: encrypt passwords and hold on Oracle tables

We implemented a similar thing for intranet stuff. Users and their passwords Received on Tue Aug 15 2000 - 12:47:39 CDT