Oracle Net 12c: How to enable Clients using SID to connect to PDB? (Doc ID 1644355.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Net Services - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

 Client connection string uses SID to connect to TEST database .For example :

net12c =
  (DESCRIPTION =
    (ADDRESS=(protocol = tcp)(HOST=test.oracle.com)(port = 1521))
    (CONNECT_DATA=(SERVER=DEDICATED)(SID = TEST))
)

The TEST database is changed to a pluggable database and client connection fais with ORA-12505.

 C:\Users\test>sqlplus sys/test_12c@net12c as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Apr 16 18:15:25 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor

Changes

 The TEST database is now a PDB. Connections to a pluggable database use service name .

 

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