From: justin.bleistein@SUNGARD.COM
Date: Fri Oct 25 2002 - 16:20:50 EDT
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