Wednesday, October 21, 2020

tnsames.ora for pluggable database

something that I keep forgetting


 PDBSLM =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = pdbslm.companyname.com)

    )

  )


 select value from v$parameter where name='service_names';

select name, pdb from v$services;


where pdbslm.companyname.com is the global name of the pluggable database