Infrastructure at your Service

All Posts By

Mouhamadou Diaw

Mouhamadou Diaw

About OCR backup

By | Database Administration & Monitoring | No Comments

Last day Franck and me were discussing about OCR backup Let’s take a 2 nodes RAC. We can see that OCR backup is automatically done by oracle in only one node on local (with a certain frequency every day, every week and every 4 hours)) [[email protected] ~]$ /u01/app/12.1.0.2/grid/bin/ocrconfig -showbackup racsrv2 2016/02/03 19:58:05 /u01/app/12.1.0.2/grid/cdata/racsrv-cluster/backup00.ocr 2528224568 racsrv2 2016/02/03 15:58:03 /u01/app/12.1.0.2/grid/cdata/racsrv-cluster/backup01.ocr 2528224568 racsrv2 2016/02/03 11:58:02 /u01/app/12.1.0.2/grid/cdata/racsrv-cluster/backup02.ocr 2528224568 racsrv2 2016/02/02 23:57:57 /u01/app/12.1.0.2/grid/cdata/racsrv-cluster/day.ocr 2528224568 racsrv2 2016/02/02 23:57:57 /u01/app/12.1.0.2/grid/cdata/racsrv-cluster/week.ocr 2528224568 But…

Read More
Mouhamadou Diaw

Protect your oracle password function

By | Database Administration & Monitoring | 13 Comments

Every DBA knows the famous oracle password verification script $ORALE_HOME/rdbms/admin/utlpwdmg.sql This function can be used to control password complexity. This script should be protected from unauthorized users. The reason is that by adding an insert in this function, someone can get passwords of users in the database. Let’s go through an example Here is my script (I have modified initial oracle script by just adding the 2 lines after the BEGIN)   CREATE OR REPLACE…

Read More