ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect

From: Jane Wang via OracleMonster.com <forum_at_OracleMonster.com>
Date: Fri, 07 Jan 2005 20:30:27 GMT
Message-ID: <c70ef4b330164ffb8773c42afa9bffeb@OracleMonster.com>

I installed Oracle 8i on Windows 2000, and tried to create a tablespace for a database I created, using a script as follows:

sqlplus SYSTEM/password_at_DEVTEST @doCreateSpace.DEVTEST.IMDIS.sql

and got the error:

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Here is the tnsnames.ora file on server.

DEVTEST.UNHQ.UN.ORG =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DPCNY)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = DEVTEST)

    )
  )   

Here is the listener.ora file on server.

# LISTENER.ORA Network Configuration File: D:\oracle\ora817\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = DPCNY)(PORT = 1521))
      )

    )
    (DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = DPCNY)(PORT = 2481))

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora817)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = DEVTEST)
(ORACLE_HOME = D:\oracle\ora817)
(SID_NAME = DEVTEST)

    )
  )

Here is the sqlnet.ora file on server.

# SQLNET.ORA Network Configuration File: D:\oracle\ora817\network\admin\sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = unhq.un.org

SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) The OracleServiceDEVTEST and OracleOraHome817TNSListener were all started. I tried tnsping DEVTEST, and it looks OK.

TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 07-JAN-2005 15:30:39

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=DPCNY)(PORT=1521)) OK (120 msec)

I also tried:

sqlplus SYSTEM/password_at_DEVTEST.UNHQ.UN.ORG @doCreateSpace.DEVTEST.IMDIS.sql

and got the same error.

Any help is greatly appreciated.

Jane

-- 
Message posted via http://www.oraclemonster.com

Received on Fri Jan 07 2005 - 14:30:27 CST