How to put database in Archive/No-Archive log mode?- Oracle Interview question

In this blog I will show you the importance of archive and no-archive log mode. Mode of Logging There are two types of logging modes in Oracle database :- 1. ARCHIVELOG :-... Read more »

How to Set ORACLE_HOME & ORACLE_SID on Windows Server

We will be finding out the way to set oracle environment path for windows server. What is ORACLE_HOME used for? The ORACLE_HOME is an environment variable which is used to set and... Read more »

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 »

Alert log file in Oracle

As you know alert log file location determined by the background dump destination it’s specified by backupground_dump_dest parameter You can find location of alert log with following command. SQL> show parameter background... 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 »

Swichover in oracle Datagurd

HP 14 Core i3 7th gen 14-inch Thin and Light Laptop (8GB/256GB SSD/Windows 10 Home/MS Office/Jet Black/1.43 kg), 14q-cs0023TU  (787) (as of April 3, 2020 - More infoProduct prices and availability are... Read more »

How to check oracle database status- Interview question

Dell Vostro 3568 15.6-inch Laptop (Core i3 6th Gen/4GB/1TB HDD/Windows 10 Home+ MS Office/ Black/ 2.18 kg)  (465) (as of April 3, 2020 - More infoProduct prices and availability are accurate as... Read more »

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

Lenovo IdeaPad S340 81VV008SIN 14-inch FHD IPS Thin and Light Laptop (10th Gen CORE I3-1005G1/4GB/1TB/Windows 10/Microsoft Office/Integrated Graphics), Platinum Grey  (4) (as of April 3, 2020 - More infoProduct prices and availability... Read more »

How to convert Physical Standby database to Snapshot Standby Database-DataGuard

ASUS TUF Gaming FX505DY-BQ002T 15.6-inch FHD Laptop (AMD Ryzen 5-3550H/8GB/1TB HDD/Windows 10/Radeon RX 560X 4GB Graphics/2.20 Kg), Black  (1070) (as of April 3, 2020 - More infoProduct prices and availability are accurate... Read more »