trpost_at_avaya.com said...
> I just did a brand new install of Oracle 8.1.7 on Win2k. The install
> went just fine, no errors. When I try to create a database using the
> database configuration assistant, I get an error: ORA-12560 TNS
> Protocol adaptor error. If I access svrmgrl from the command line, I
> get a ORA-12154 TNS:could not resolve service name. I have read the
> deja fourms about creating the databas manually, but I cannot connect
> internal through svrmgrl, I get the same ORA-12154 error. If I do a
> look at the listener, it is started.
>
> C:\Documents and Settings\Administrator>lsnrctl status
>
> LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on
> 07-FEB-2003 15:17:
> 46
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jorden)(PORT=1521)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for 32-bit Windows: Version
> 8.1.7.0.0 - Produc
> tion
> Start Date 07-FEB-2003 14:57:57
> Uptime 0 days 0 hr. 19 min. 49 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File D:\oracle\ora81\network\admin\listener.ora
> Listener Log File D:\oracle\ora81\network\log\listener.log
> Services Summary...
> PLSExtProc has 1 service handler(s)
> The command completed successfully
>
> Below is a copy of my tnsnames.ora, listener.ora
>
> TNSNAMES.ORA:
> # TNSNAMES.ORA Network Configuration File:
> D:\oracle\ora81\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> EXTPROC_CONNECTION_DATA.SD.AVAYA.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> LISTENER.ORA:
> # LISTENER.ORA Network Configuration File:
> D:\oracle\ora81\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = jorden)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\oracle\ora81)
> (PROGRAM = extproc)
> )
> )
>
> Please Help!!!
> Thanks!
>
You've told the Listener (listener.ora) where to listen, but you haven't
told the client (tnsnames.ora) how to talk to the listener. You need an
entry in your tnsnames.ora something like:
jordan =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jordan)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jordan)
)
)
--
/Karsten
Received on Fri Feb 07 2003 - 19:14:27 CST
