Author Archives: Raheel Syed

About Raheel Syed

Oracle DBA

ICACLS – A magic command

One of our colleague was configuring Auditing on MSSQL Server using Arcsight (more info about the tool can be found here ) and one of the steps is to create SQLTRACE folder and SHARE the folder and provided the necessary … Continue reading

Posted in Auditing, Database Security | Tagged , , , | Leave a comment

ORA-01791: not a SELECTed expresssion

SQL query runs perfectly fine in 11.2.0.3 and not in 11.2.0.4 and reported with ORA-01791 error. If the error “ORA-01791: not a SELECTed expresssion” is reported in 11.2.0.4 release then it’s a expected behavior and NOT a bug. Solution: Include … Continue reading

Posted in Troubleshooting | Tagged , , , , | Leave a comment

Patching through OEM 12c in Offline mode

The below document is the step-by-step procedure to patch Oracle databases using OEM 12c in Offline mode. SPU/CPU Patch Apply through OEM Cloud Control 12c (Offline Mode).pdf Hope this helps Cheers !! Raheel Syed

Posted in OEM12c | Tagged , , , , , , , , | 1 Comment

Opatch Apply on Windows failed with CheckActiveFilesAndExecutables

While applying CPU Jan 2014 Patch on windows, opatch apply failed with error ‘CheckActiveFilesAndExecutables’ Following files are active : D:\oracle\product\11.2.0\db_1\bin\oracommon11.dll D:\oracle\product\11.2.0\db_1\bin\oraclient11.dll D:\oracle\product\11.2.0\db_1\bin\orageneric11.dll D:\oracle\product\11.2.0\db_1\bin\orapls11.dll D:\oracle\product\11.2.0\db_1\bin\oran11.dll D:\oracle\product\11.2.0\db_1\bin\oraxml11.dll D:\oracle\product\11.2.0\db_1\bin\oci.dll D:\oracle\product\11.2.0\db_1\bin\orahasgen11.dll D:\oracle\product\11.2.0\db_1\bin\orahasgen11.dll D:\oracle\product\11.2.0\db_1\bin\oraocr11.dll D:\oracle\product\11.2.0\db_1\bin\oraocrb11.dll D:\oracle\product\11.2.0\db_1\bin\oraocrutl11.dll D:\oracle\product\11.2.0\db_1\bin\orannzsbb11.dll D:\oracle\product\11.2.0\db_1\bin\orazt11.dll D:\oracle\product\11.2.0\db_1\bin\oraasmclnt11.dll Workaround: 1. Modify the Oracle services … Continue reading

Posted in Patch | Tagged , , , , , , , , , , , , , , , , | 2 Comments

scp – lost connection

Lost connection error when using scp [oracle@server1 bkup]$ scp full_orcl.dmp myuser@server2:/app/oradump myuser@server2’s password: full_orcl  31% ******************************** lost connection Resolution: [oracle@server2 oradump]$ rsync –append –progress myuser@server1:/app/bkup/full_orcl.dmp . full_orcl.dmp   5825256969   100%    1.78MB/s    1:22:47 Cheers !!! Raheel

Posted in Linux | Tagged , | Leave a comment

ora-201 and Checker run found %n% new persistent data failures

Message from Alert.log: Checker run found 3 new persistent data failures ora-201 signalled during: alter database mount exclusive. On Windows, when we stop and start the OracleService (services.msc) the above error reported. Issue was with the permission on the controlfiles. … Continue reading

Aside | Posted on | Tagged , , , | Leave a comment