Infrastructure at your Service

All posts by Mouhamadou Diaw

Mouhamadou Diaw
Consultant

Mouhamadou Diaw has more than ten years of experience in IT domains. He is specialized in Oracle technologies (engineered system, architecture, backup and recovery, high availability, security, audit etc.). Mouhamadou Diaw is Oracle professional Certified (8i, 10g, 11g, 12c), Oracle RAC 11gR2 Certified Expert , Oracle Database 11g Security Certified and CISA (Isaca). He received a Doctorate in Heat and Humidity Transfer of INSA Toulouse, France. His branch-related experience covers Insurance, Retail, International Organizations, Transport & Logistics, etc.
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)) [oracle@racsrv2 ~]$ /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 | 10 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