To connect as sys or other elevated local users, use the same methods as below, but use ‘as sysdba‘ where necessary

Method 1:

Method 2:For other methods, you need to know the service-name for the PDB:
Get the service name for the PDB:

or by doing “lsnrctl services LISTENER” and locating service for the PDB.

Method 2a: Using host and port without SCAN

or

Method 2b: Using host and port with SCAN

Method 3: Using tns entry

Make Tns entry

  • with hostname and scan
  • with hostname and non-scan listener:

Without Scan:

With Scan:

Then connect as follows:

or

where PDB1 is the TNS alias

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply