oracle dba

If you are looking for real time database training then please contact me. Email – ankush.thavali@gmail.com Mob No – +91 9960262955

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 then only can cover the OCP (Oracle certified professional) certification. Oracle have introduced new certification path from oracle 18c to go directly on […]

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 job and have lot responsibility as its directly affecting to production environment.In this blog we will see the future responsibilities of oracle dba […]

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 . listener.ora is the database server level file and tnsnames.ora is the client side file. oracle listener service should be up and running to […]

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 define the path of Oracle Home (server) Directory. How to set ORACLE_HOME in Environment variable To set the ORACLE_HOME environment variable go to […]

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 might be down Check the instance status SQL>select instance_name, status from v$instance; Check whether the database can be read or write SQL>select name, […]

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 more than n days old $ find $DBA/$ORACLE_SID/bdump/*.trc -mtime +n -exec rm {} \; 2. To get the value of all environment variables. […]

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 oracle 12c database. How to change SYS/SYSTEM password in 12C-Oracle 12C Administration =================================================== PDB1@ORCL= alter session set container=CDB$ROOT; Session altered. PDB1@ORCL=show con_id CON_ID […]

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 NAME TYPE VALUE ——————————— ———– —————————— background_core_dump string partial background_dump_dest string D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCLDATA\BDUMP Also you can use following command SQL> select name, value from […]

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 user have the access to all PDB except seed pdb Common user start with C## prefix SYS and SYSTEM are the common user […]