The Hadoop FAQ for Oracle DBAs January 8, 2014
The Hadoop FAQ for Oracle DBAs by Gwen here.
Oracle 12c June 26, 2013
Oracle 12c Database (220.127.116.11.0) is available for download under http://edelivery.oracle.com/
How to block developing tools on Database March 23, 2012
CONNECT / AS SYSDBA;
CREATE OR REPLACE TRIGGER block_tools_from_prod
AFTER LOGON ON DATABASE
SELECT program INTO v_prog
WHERE audsid = USERENV(‘SESSIONID’)
AND audsid != 0 — Don’t Check SYS Connections
AND ROWNUM = 1; — Parallel processes will have the same AUDSID’s
IF UPPER(v_prog) LIKE ‘%TOAD%’ OR UPPER(v_prog) LIKE ‘%T.O.A.D%’ OR — Toad
UPPER(v_prog) LIKE ‘%SQLNAV%’ OR — SQL Navigator
UPPER(v_prog) LIKE ‘%PLSQLDEV%’ OR — PLSQL Developer
UPPER(v_prog) LIKE ‘%BUSOBJ%’ OR — Business Objects
UPPER(v_prog) LIKE ‘%EXCEL%’ — MS-Excel plug-in
RAISE_APPLICATION_ERROR(-20000, ‘Development tools are not allowed here.’);
Security in the Database Oracle 11g March 19, 2012
We have seen the most awful of technology either stolen or lost your data on Databases especially Oracle has improved security through the newer version of Oracle 11g
Oracle 11g provides transparent data encryption at a tablespace level, and this video presents practical ways to look at security and implementing standards and procedures around the database environment to account for the security outside of the users, including secured environments for regulations and compliance.
Deadlock ORA-00060 error August 22, 2011
Video Tutorial – Installing Oracle 10gR2 Grid Control and deploying agent on Linux and Windows OS June 27, 2011
Oracle Grid Control managing lots of databases and application servers It can manage multiple instances of Oracle deployment platform.Click here for the video tutorial of how to install Oracle 10gR2 Grid Control.