From: support (support@xiatecs.net)
Date: Sat Oct 26 2002 - 19:06:06 EDT
Justin,
This error mean that the listener can not resolve the host name in the
tnsname.ora . Try to ping that host name. If it can not be resolved, resolve
this issue by either correcting your DNS entry for this host or by adding it
to the /etc/hosts. You can also try replacing the hostname by IP address in
the tnsname.ora
XiaTecs Support Team
support@xiatecs.net
www.xiatecs.net
-----Original Message-----
From: IBM AIX Discussion List [mailto:aix-l@Princeton.EDU]On Behalf Of
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