Oracle Net 12c: How to enable Clients using SID to connect to PDB?
Last updated on SEPTEMBER 06, 2017
Applies to:Oracle Net Services - Version 18.104.22.168 and later
Information in this document applies to any platform.
Client connection string uses SID to connect to TEST database .For example :
(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 22.214.171.124.0 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