Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

AppsDBA CV Download CV Contact Me

Errors/Workarounds10g

October 1, 2017 ORA-01157: cannot identify/lock data file 206 – see DBWR trace file
Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

ERROR ORA-01157: cannot identify/lock data file 206 – see DBWR trace file ORA-01110: data file 206: ‘+DATA’ SOLUTION If you…

October 1, 2017 How to Find and repair Corrupt block in database
Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

How to Find and repair Corrupt block in database Step 1: Below query will show if there is any corrupted…

October 1, 2017 ORA-01442: column to be modified to NOT NULL is already NOT NULL 
Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

ERROR Solution : ORA-01442: column to be modified to NOT NULL is already NOT NULL sql> alter table HR.employees modify…

September 1, 2017 RAC Files and Directories
Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

RAC Files and Directories   $ORA_CRS_HOME/cdata/<cluster_name> OCR backups (default location) $ORA_HOME/log/<hostname>/client/ocrconfig_<pid>.log OCR command log file $ORA_CRS_HOME/crs/log contains trace files for…