oracledba
In this blog post we will discuss about the oracle 19c installation on windows server. Here is the latest version of oracle 19c installation steps on the top of windows operating system. In the end of blog you will find the youtube video based on oracle 19c installation step by step. Oracle Database for Windows […]
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. […]