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 for high availability, disaster recovery, and high-level security to protect your databases and business.You’ll also see the advantages of managing a MySQL database side by side with an Oracle database in the Oracle Public Cloud with the push-button ease of the MySQL Cloud Service.

Cheers !

Raheel

Advertisements
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 permissions for Arcsight AD user to read the SQL Trace files, and then enable the Auditing in MSSQL server and see the files are generating in the SQLTRACE folder. All went well, he could see the files but Arcsight AD user couldn’t see the files.

One thing was very sure, this is related to permissions issue but how come ? If we see the permission on the SQLTRACE it exists (right click -> properties -> security ) and even the Advanced includes “Applies To” – “This folder, subfolder and files”  for that user, but the same doesn’t exits for the SQL trace files generated from MSSQL Server.

Then this magic command ICACLS actually did the trick.

Here is the actual command

icacls * /T /Q /C /RESET

That’s it ! It worked.

Cheers !

Raheel

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 the “order by” clause column in the SELECT statement.

Note: MOS ID: 1600974.1

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 to Manual startup type.
2. Restart the server.
3. Rename the above .dll and try running opatch apply again.

Cheers !!!

Raheel Syed

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