Author Archives: Raheel Syed

About Raheel Syed

Oracle DBA

MySQL in Oracle Environments Part 1: Quick Start for the Oracle DBA

Source: MySQL in Oracle Environments Part 1: Quick Start for the Oracle DBA This webinar covers the different use cases for MySQL and Oracle Database, as well as the tools to manage both databases. Additionally, the presentation spotlights top MySQL solutions … Continue reading

Posted in Uncategorized

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