RE: 8.1.6 Listener Weirdness

From: Singla, Sanjeev K. <SSingla_at_oxhp.com>
Date: Wed, 16 Aug 2000 09:10:12 -0400
Message-Id: <10591.114714@fatcity.com>

 Hi  

  (SID_DESC =
(GLOBAL_DBNAME = qodt)
(ORACLE_HOME = /oracle/dbserver/8.1.6)
(SID_NAME = qodt) (SERVICE_NAME=name of service from init.ora)
------> Try adding this entry into listener.ora

    )

Sanjeev     

-----Original Message-----
From: Nguyen, Long [mailto:Long.Nguyen_at_its.csiro.au] Sent: Wednesday, August 16, 2000 3:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: 8.1.6 Listener Weirdness

Hi,
Just a few things to check ...  

1. Did you get any error mesages when you tried to start up 816 listener?
2. Did you start up 816 listener using "lsnrctl start lsnr816' command?
3. What do you mean by "lsnrctl thinks I am trying to start a listener with the same attributes as the 8.1.5 listener" ?
4. You might want to set TNS_ADMIN variable to /oracle/dbserver/8.1.6/network/admin and then try to start the 816 listener
5. Any thing in the listener.log file?

Long  

-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com] Sent: Wednesday, 16 August 2000 4:45 AM
To: Multiple recipients of list ORACLE-L Subject: 8.1.6 Listener Weirdness

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 <http://www.qode.com>

"The information contained herein does not express the opinion or position Received on Wed Aug 16 2000 - 08:10:12 CDT