Making Connection with Database
SQLPLUS / as SYSDBA
To clear Screen
To format the output of command line.
COLUMN name FORMAT a20;
To get the container id of ORCLPDB, which will be further used in finding the name of plugable orclpdb service.
SELECT name, con_id FROM v$pdbs;
To get the service name
SELECT name As "Service Name" FROM v$active_services WHERE con_id = 3;
Create [TNS Service] Using Oracle Net Configuration Assistant (netCA)
Launch the Oracle Net Configuration Assistant
Run command prompt with Admin rights.
netca and press enter.
find the HOST name and Port number in listner.ora which is located in
ALTER PLUGGABLE DATABASE ORCLPDB OPEN;