Oracle Database certification path update 2019

If you are planning for oracle database certification then this post is going to be very helpful for all of you. Initially we used to go with OCA (Oracle certified associate) and... Read more »

Oracle dba jobs will die in future due to autonomous database ?

Many dba’s have the question related to oracle dba career and opportunity of oracle dba in future and worried about whether oracle dba jobs will die in future. oracle dba is serious... Read more »
listener.ora and tnsnames.ora location in oracle 12c database

listener.ora and tnsnames.ora location in oracle 12c database

In our previous blog We have seen about the error message related to the address of tnsnames.ora file. In this blog we will see the location of listener.ora and tnsnames.ora file .... 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 »

Basic Unix Command for Oracle DBA

In this video you will understand the use of unix command for daily dba life. you will find this command useful while while working on dba environment. 1. To Cleanup trace files... 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 »

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

Read more »