usingSqlplus

This provides a detailed explanation of the commands executed using SQL*Plus connected to an Oracle Database 21c instance. The process involves creating, managing, and deleting pluggable databases (PDBs), configuring HTTP/HTTPS ports, and starting/stopping the Oracle instance. ##Command Breakdown #Connect to Oracle Database

C:\Users\Sandra>sqlplus sys as SYSDBA    --Connecting to oracle database as sysdba

Display

SQL> show pdbs;               --Display Existing Pluggable Databases

Creating a New Pluggable Database plsql_class2024db

CREATE PLUGGABLE DATABASE plsql_class2024db
ADMIN USER sa_plsqlauca IDENTIFIED BY password
FILE_NAME_CONVERT =
('D:\app\Sandra\oradata\ORCL\pdbseed','D:\app\Sandra\oradata\ORCL\orclpdb\sa_plsqlauca');

Creating Another Pluggable Database sa_to_delete_pdb

CREATE PLUGGABLE DATABASE sa_to_delete_pdb
ADMIN USER sa_delplsqlauca IDENTIFIED BY password
FILE_NAME_CONVERT =
('D:\app\Sandra\oradata\ORCL\pdbseed','D:\app\Sandra\oradata\ORCL\orclpdb\sa_delplsqlauca');

Open mode of all containers

SQL> select name, open_mode from v$containers;

Drop the sa_to_delete_pdb Pluggable Database

DROP PLUGGABLE DATABASE sa_TO_DELETE_PDB INCLUDING DATAFILES;

Set HTTP and HTTPS Ports for Oracle Database

BEGIN
DBMS_XDB_CONFIG.SETHTTPPORT(8083);
DBMS_XDB_CONFIG.SETHTTPSPORT(8443);
END;

Checking the Configured Ports

SELECT DBMS_XDB_CONFIG.GETHTTPPORT() AS HTTP_PORT,
       DBMS_XDB_CONFIG.GETHTTPSPORT() AS HTTPS_PORT
FROM dual;

Shutdown the Database

SQL> SHUTDOWN IMMEDIATE;

Restarting the DB

SQL> STARTUP;

License

This project is licensed under the MIT License. You can freely use, copy, modify, and distribute this software, but please include a copy of this license in any distributions.