To verify that Oracle Database was installed Successfully,

1. Go to your windows start program and type Services.

This will take you to the Windows Services.

Open Services in Windows and verify that the following services are running:

• OracleServiceORCL

• OracleOraDB19HomeTNSListener

(Replace ORCL with your SID if it is different.)

Connect to installed databases

2. Start command prompt on your laptop. Go to windows start program and type cmd.

In the command prompt window, type the following command to logon as user system  with password oca. I created this administrative password during installation. If you used a different password, then use your password.

sqlplus / as sysdba

This will connect you to Sqlplus.

3. Use the following command, if you want to know the details about the Oracle version installed.

SELECT * FROM V$VERSION;

4. Verify Instance Status

   SELECT INSTANCE_NAME, STATUS FROM V$INSTANCE;

Expected output

INSTANCE_NAME STATUS

------------- -------

orcl                            OPEN

5. Verify Current Container

SHOW CON_NAME;

Expected output:

CDB$ROOT

6. Show Pluggable Databases

SHOW PDBS;

Expected output:

ORCLPDB READ WRITE

7. Switch to PDB

ALTER SESSION SET CONTAINER = ORCLPDB;

8. Verify Again

SHOW CON_NAME;

Expected output:

ORCLPDB

9. Now connect to one of the users you have unlocked during installation.

CONNECT HR/hr@orclpdb

Show Tables

SELECT * FROM TAB;

Following the above mentioned steps, you can verify that the installation was done successfully and you can connect to your sample databases.

Chandraish Sinha

Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.

Explore more of his work on his Amazon Author Profile.