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

On Fri, 07 Jan 2005 20:30:27 GMT, "Jane Wang via OracleMonster.com" <forum_at_OracleMonster.com> wrote:

>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.

The service_name parameter in your init.ora isn't set to devtest

Please look up errors in the error manual at http://tahiti.oracle.com prior to posting. Do NOT misuse Usenet as a first aid.

--
Sybrand Bakker, Senior Oracle DBA