Author Archives: Raheel Syed

About Raheel Syed

Oracle DBA

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

Posted on September 9, 2017 by Raheel Syed

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 | Comments Off on MySQL in Oracle Environments Part 1: Quick Start for the Oracle DBA

ICACLS – A magic command

Posted on July 10, 2015 by Raheel Syed

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

Posted on January 8, 2015 by Raheel Syed

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

Posted on February 5, 2014 by Raheel Syed

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

XDB.DBMS_XDBUTIL_INT.SYSTEM_INFO_EXP – Export Error

Posted on February 4, 2014 by Raheel Syed

ORA-39127: unexpected error from call to “XDB”.”DBMS_XDBUTIL_INT”.”SYSTEM_INFO_EXP” ORA-44002: invalid object name ORA-06512: at “SYS.DBMS_ASSERT”, line 316 ORA-06512: at “SYS.DBMS_METADATA”, line 9311 Solution: SQL> create table SYS.EXPPKGACT$_BACKUP as select * from SYS.EXPPKGACT$; SQL> delete from sys.exppkgact$ where package = ‘DBMS_XDBUTIL_INT’ and … Continue reading →

Posted in Export and Import | Tagged , , , , , , , | Leave a comment

Opatch Apply on Windows failed with CheckActiveFilesAndExecutables

Posted on February 4, 2014 by Raheel Syed

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

Posted on February 3, 2014 by Raheel Syed

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

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 →

Posted on January 7, 2014 by Raheel Syed | Leave a comment

ORA-00001: unique constraint violated

Posted on January 3, 2014 by Raheel Syed

IGNORE_ROW_ON_DUPKEY_INDEX hint is on rescue. This is the NEW feature in 11gR2 applied on INSERT statements, wherein duplicate values will be ignored rather causing ORA-00001 error. Scenario: Development team wanted one of the STAGING table to be refreshed from PROD table … Continue reading →

Posted in 11gR2, New Features | Tagged , , , | Leave a comment

Recovering from rm -rf on a datafile

Posted on December 10, 2013 by Raheel Syed

Originally posted on jarneil:
This blog posting is entirely the credit of Frits Hoogland, who pointed out to me that this was possible. I managed to delete a datafile, that while it had been created in a completely stupid location,…

Posted in Troubleshooting | Tagged , , | Leave a comment