ORA-12154 TNS:could nor resolve service name / ORA-12560 TNS Protocol adaptor error

From: Tom Post <trpost_at_avaya.com>
Date: 7 Feb 2003 14:34:08 -0800
Message-ID: <634d59c5.0302071434.7c287377@posting.google.com>

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! Received on Fri Feb 07 2003 - 16:34:08 CST