From: Gene Sais (Gsais@CO.PALM-BEACH.FL.US)
Date: Fri Oct 25 2002 - 17:09:58 EDT
It looks like your Oracle env variables are not set when you reboot. Test it by su - oracle -c "lsnrctl start" from root. If the same problem then set Oracle env variables in .profile. I actually use a env script for Oracle and call that from .profile.
hth,
gene
>>> SMurphy@UAMAIL.ALBANY.EDU 10/25/02 04:43PM >>>
Do you have an extra trailing / on your entries for ORACLE_HOME in your
listener.ora? The file name doesn't seem right.
--
*---------------------------------------------------------------------------
*
Stephen T. Murphy
Manager, Database and Technical Support
ITS - University Applications Development
MSC-100
The University at Albany, S.U.N.Y
Albany, New York 12222
Phone: (518) 437-4523 Fax: (518) 437-4540
MailTo: SMurphy@UAMail.Albany.EDU AIM: SMurphy199
-----Original Message-----
From: justin.bleistein@SUNGARD.COM [mailto:justin.bleistein@SUNGARD.COM]
Sent: Friday, October 25, 2002 4:21 PM
To: aix-l@Princeton.EDU
Subject: oracle error
Oracle question again. I had my test database working great then I rebooted
my AIX system now I get this when I try to start the listener back up for
Oracle:
$ bin/lsnrctl
LSNRCTL for IBM/AIX RISC System/6000: Version 8.1.6.0.0 - Production on
25-OCT-2
002 16:11:16
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Starting tnslsnr: please wait...
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
IBM/AIX RISC System/6000 Error: 2: No such file or directory
LSNRCTL> quit
Here are the contents of my listener.ora file:
$ more listener.ora
# LISTENER.ORA Configuration
File:/home/oracle/OraHome1//network/admin/listener.
ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION = dragonlf database
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tsmtest)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.162.31.49)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/OraHome1/)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dragonlf)
(ORACLE_HOME = /home/oracle/OraHome1/)
(SID_NAME = dragonlf)
)
)
$
Here are the contents of my tnsnames.ora file:
$ more tnsnames.ora
# TNSNAMES.ORA Configuration
File:/home/oracle/OraHome1//network/admin/tnsnames.
ora
# Generated by Oracle configuration tools.
DRAGONLF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tsmtest)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dragonlf)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = dragonlf)
(PRESENTATION = RO)
)
)
$
Any suggestions would be appreciated thanks!.
--Justin
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:17 EDT