How to check oracle database status – Interview question

let us find out the database health status by using following sql command. Check whether the Oracle Process run or not#> ps -ef | grep pmon If no pmon detected, your database... Read more »

How to change sys & System user password in Oracle 12C database

We cannot change the sys and system password in usual way as like till 11g. we have different method to do same. following blog describe the way to change user password in... Read more »

How to create user in oracle 12c ?- Interview question

In this bog, I will explain you how the user management work in oracle 12c. Starting from Oracle 12C there are two types of user. Common User Local User Common User Common... Read more »

How to change SYS/SYSTEM password in 12C-Oracle 12C Administration

Read more »

How to take backup of container & Pluggable database-Oracle 12C Administration

Read more »

How to Rename/Change PDB database name-Oracle 12C Administration

Read more »

Migration from Non-Container to PDB database-PART I- Oracle 12C Administration

Read more »

Migration of Non-Container Database to Pluggable-PART II- Oracle 12C Administration

Read more »

How to create Non-Container Database using DBCA-Oracle 12C Administration

Read more »

Create pluggable database using DBCA-Oracle 12C Administration

Read more »