RE: Oracle 81 on redhat 6.2

From: Jack Silvey <JSilvey_at_XOL.com>
Date: Thu, 6 Jul 2000 17:52:50 -0500
Message-Id: <10550.111381@fatcity.com>

Adam,

Check your installation docs for the system variables that need to be set. The problem is probably your $ORACLE_HOME. Make sure it is set correctly in your current session before you try to start the listener. (Also check your $LD_LIBRARY_PATH). Also, the listener has does not depend on the database at all. You can start the listener whether the database is up, down, or sideways.

Jack
OCP x 2
Senior @ xol.com

-----Original Message-----
From: Adam Turner [mailto:ATurner_at_concretemedia.com] Sent: Thursday, July 06, 2000 5:54 PM
To: Multiple recipients of list ORACLE-L Subject: Oracle 81 on redhat 6.2

Hi listers ... I am trying to get my listener up and running and having all kinds of trouble getting anywhere. here's the output of a few commands in lsnrctl:

LSNRCTL> status
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=latdev1.concretemedia.co m)(PORT=1521)))
TNS-01103: Protocol specific component of the address is incorrectly specified
 TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
   TNS-00511: No listener
    Linux Error: 111: Connection refused

and ....

LSNRCTL> start
Starting /u01/app/oracle/product/8.1.6/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 8.1.6.0.0 - Production System parameter file is
/u01/app/oracle/product/8.1.6/network/admin/listener.or a
Log messages written to
/u01/app/oracle/product/8.1.6/network/log/listener.log Attempted to listen on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=latdev1.concre temedia.com)(PORT=1521)))
TNS-12542: TNS:address already in use
 TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   Linux Error: 98: Address already in use

My instance is lat.
listener.ora :

LISTENER.ORA Configuration
File:/u01/app/oracle/product/8.1.6/network/admin/li stener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = latdev1.MYDOMAIN.com)(PORT = 152 1))

      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/8.1.6)
(PROGRAM = extproc)

    )
  )

anybody out there have a magic answer?

At one point I was getting these issues when I started listener after oracle - I tried in both directions and get the same problem.

help

adam

-- 
Author: Adam Turner
  INET: ATurner_at_concretemedia.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Thu Jul 06 2000 - 17:52:50 CDT