Assignment II: Database Creation, Deletion & OEM

Name: Arsene Iradukunda
Student ID: 27206
Date: October 8, 2025
Course: PL/SQL

---

Introduction

This report demonstrates the creation and management of Oracle Pluggable Databases (PDBs). I successfully created two PDBs, deleted one as per requirements, and configured Oracle Enterprise Manager (OEM) to manage and monitor the database system.

---

Task 1: Create Main Pluggable Database

PDB Name: Ar_pdb_Iradukunda_27206
Admin User: Arsene_pdb_Iradukunda_27206
Status: Successfully created and opened

Commands Used:

CREATE PLUGGABLE DATABASE Ar_pdb_27206
ADMIN USER Arsene_plsqlauca_27206 IDENTIFIED BY 1111
FILE_NAME_CONVERT = ('pdbseed', 'Ar_pdb_27206');

ALTER PLUGGABLE DATABASE Ar_pdb_Iradukunda_27206 OPEN;

Screenshot:

---

Task 2: Create and Delete Second PDB

Created PDB: Ar_to_delete_pdb_27206
Admin User: Arsene_to_delete_pdb_27206
Status: Successfully created, verified, and then deleted

Commands Used:

-- Create second PDB
CREATE PLUGGABLE DATABASE Ar_to_delete_pdb_27206
ADMIN USER Arsene_to_delete_pdb_27206 IDENTIFIED BY SimplePass123
FILE_NAME_CONVERT = ('pdbseed', 'Ar_to_delete_pdb_27206');

ALTER PLUGGABLE DATABASE Ar_to_delete_pdb_27206 OPEN;

-- Delete second PDB
ALTER PLUGGABLE DATABASE Ar_to_delete_pdb_27206 CLOSE;
DROP PLUGGABLE DATABASE Ar_to_delete_pdb_27206 INCLUDING DATAFILES;

Screenshots:

Both PDBs Existing:

After Deletion:

---

Task 3: Oracle Enterprise Manager (OEM)

Successfully accessed and configured Oracle Enterprise Manager dashboard. The OEM interface provides a graphical view of database status, performance metrics, and administrative functions.

Access URL: https://localhost:5500/em
Login: Connected as SYSDBA
Status: Dashboard accessible and showing database information

Screenshot:

---

Notes and Observations

• All three tasks were completed successfully without major issues
• The pluggable database architecture allows for efficient database management and isolation
• Oracle Enterprise Manager provides a user-friendly interface for database administration
• Screenshots clearly show username visibility as required

---

Conclusion

This assignment provided hands-on experience with Oracle Pluggable Database creation, deletion, and management through both SQL*Plus command-line interface and Oracle Enterprise Manager. All tasks were completed according to specifications, demonstrating proficiency in basic Oracle database administration tasks.