Oracle Net 12c: How to enable Clients using SID to connect to PDB?

(Doc ID 1644355.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

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


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

net12c =
    (ADDRESS=(protocol = tcp)( = 1521))

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 Production on Wed Apr 16 18:15:25 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
ORA-12505: TNS:listener does not currently know of SID given in connect


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



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