My Oracle Support Banner

RDBPROD: ORA-12504: TNS:listener was not given the SID in CONNECT_DATA when connecting to Oracle RDB (Doc ID 143729.1)

Last updated on FEBRUARY 04, 2020

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

To view full details, 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 a vibrant support community of peers and Oracle experts.