RDBPROD: ORA-12504: TNS:listener was not given the SID in CONNECT_DATA (Doc ID 143729.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.1.2 and later
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

Attempting to attach to an Oracle Rdb database via OCI Services (SQL*NET) for Rdb gives:

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms