For Discoverer 10g: 1. On the Discoverer 10g Server machine, please set the environment variables by running the following script, . ./$OH/discoverer/discwb.sh (Note : It is dot space dot slash…
Read MoreOne small article on ASMCMD commands which can help you in day to day ASM Command-Line tasks. 1. Let’s check ASMCMD’s version. [oracle@dbnode1 ~]$ asmcmd -V asmcmd version 11.2.0.0.0 Let’s…
Read MorePlease follow the below steps col COMP_ID for a15 col COMP_NAME for a45 col STATUS for a20 set lines 100 pages 100 select COMP_ID,COMP_NAME,STATUS from dba_registry; COMP_ID COMP_NAME STATUS —————…
Read MoreSteps to Resize the Online Redo Logfiles >sqlplus /nolog SQL> connect / as sysdba SQL> select name,open_mode from v$database; NAME OPEN_MODE ——— ——————– PROD READ WRITE Please check the below…
Read MorePlease use the below script. #!/bin/ksh file1=$1 file2=$2 for parameter in `cat $file1 | grep = | awk ‘{print $1}’ | grep -v ‘#’` do value1=`grep ^$parameter $file1 |…
Read MoreIt is a feature that is enhanced in oracle 19c and it is mainly used to automate the upgrade process.it not only automates the database upgrade but also performs the pre-upgrade steps…
Read MoreIt is possible to recover datafile when accidentally removed or deleted and when there is no backup at all , We can recover the datafile without any issues ,now i…
Read MoreORA-01555 / ORA-600 in standby database after switchover After doing a SwitchOver from Production to standby(open read only), We were facing frequent ORA-01555 error. This is a Oracle bug in…
Read MoreUnpublished Base Bug 3603160 has been fixed in the patchset 10.2.0.3.0 For version 10.1.0.4 and version 10.1.0.5 oneoff patches exists for some platforms. Below is a list of available onoff…
Read MoreCMD for Installation. yum -y -q install oracle-instantclient18.3-basic.x86_64.
Read More