How to create the CDB and PDB in oracle database?

Rameshdba.com

 The contents are of my own testing and deployments. Not guaranteed that these might work in your environment. Please test before usage.


 Summary: In this session, I will teach you How to create the CDB(Container database) and PDB(pluggable database) in oracle database.


Step1:Login to the server

Note :We are go will create the CDB using DBCA method in oracle database

Step2:Goto the home location or set the environment


Step3:You can choose the create database option and press next



Step 4:You can choose the container name and pdb name,password as well



Step5:Press next and wait until its complete




Step6:Read the summary carefully and press finish




Step7:Its completed CDB and PDB created.



Now You can login and check like below




How to create the PDB in CDB in the same container?


Login to the server 

Make the directory to collect the output from that old pdb seed location see below



Step2:

Make the directory as below mentioned.

mkdir -p /u01/app/oracle/oradata/cdbdev/pdb2

Step3:

Connect the sqlplus / as sysdba

Provide the below command 

SQL> CREATE PLUGGABLE DATABASE pdb2 ADMIN USER pdb_adm IDENTIFIED BY Password1 FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdbdev/pdbseed/','u01/app/oracle/oradata/cdbdev/pdb2');

Pluggable database created.



Step4:Open the PDB2 which we are created now


SQL> alter pluggable database PDB2 open;

Pluggable database altered.


Step5:PDB has been open;




                                                        Thank You for your time!!









                                                                                                                                                                 
               







0 Comments

DELETE Statement in ORACLE DB— Step by Step Internal Flow with classroom example.

by
Imagine your Oracle database like a school, and you’re Teacher decides to remove a student (row) from the classroom(table). Let’s see how the journey works step by step: 1)Classroom = Oracle Table 2)Students = Rows (Records) 3)Class Teacher = Oracle Server Process 4)Attendance Register = Data Dictionary User fires DELETE statement: DELETE FROM students WHERE grade = 'D'; Internal Processing Steps: Client Process Sends DELETE Statement to Server Process The teacher receives a request to remove a student from the classroom. Syntax Check (Parsing) The teacher checks if the request is grammatically correct — proper command, keywords, and a semicolon. Semantic Check Teacher verifies if the classroom exists and whether the condition (like grade = 'D') makes sense. Object Resolution Teacher confirms that the ‘students’ classroom (table) exists in the school records (data dictionary). Optimization Decides the fastest way to find those students — by roll number, grade, or al...
Image