From: Miller, Dave (Dave.Miller@BHS.ORG)
Date: Fri Oct 25 2002 - 16:32:19 EDT
this would usualy be because it can not resolve one of the host names in the
listener definitions, for example tamtest in your example....wherever you
are starting this listener, you need to make sure you can ping any ip
addresses specified explicitly, and resolve and ping any implicit addresses
(hostnames). the tnsnames.ora should not come into play for starting the
listener.
-----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