ORA-12504: TNS:listener was not given the SID in CONNECT_DATA

    The tnsnames entry you are using to connect to the database is lacking the SID or SERVICE_NAME entry.

    eg:


    ERROR.EU.DBMOTIVE.COM =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = mydbserver)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
        )
      )

    Altough a tnsping will succeed (as it does not connect to an SID), a connection request will fail:


    C:\>sqlplus myuser@error

    SQL*Plus: Release 9.2.0.7.0 - Production

    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

    Enter password:
    ERROR:
    ORA-12504: TNS:listener was not given the SID in CONNECT_DATA


    Either add a correct SID or SERVICE_NAME to the tnsnames entry:


    ERROR.EU.DBMOTIVE.COM =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = mydbserver)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SID=MYDB)
        )
      )


Adverteren bij Daisycon
Forum Messages
No messages
Add your message for ORA-12504
Name:email:
Validation Code:jea06b8twjuebudyo
Enter Code above:
Title:
State your problem: