Making Connection with Database

SQLPLUS / as SYSDBA

SHOW user;

To clear Screen

cl scr

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)

Step 1

Launch the Oracle Net Configuration Assistant

Run command prompt with Admin rights.

type netca and press enter.

find the HOST name and Port number in listner.ora which is located in C:\oracle_db_home\network

ALTER PLUGGABLE DATABASE ORCLPDB OPEN;