From: Kathe Newsome (knewsome@CENTENARY.EDU)
Date: Fri Oct 25 2002 - 16:53:53 EDT
Justin,
In the TNSNAMES.ora file try using the IP address where you have
HOST = tsmtest. My tnsnames.ora is far less complex than this.
HTH
Kathe
justin.bleistein@SUNGARD.COM wrote:
>
> 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
-- Kathe C. Newsome Centenary College of Louisiana Database Administrator Email : knewsome@centenary.edu Telephone : 318.869.5213 Fax : 318.869.5004 Mark 11:24
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:17 EDT