This error occurs when you have a public synonym defined and the object referencing or owning the synonym has been…
Tag 11g
CAUTION !!!! DO NOT DO THIS ON YOUR PRIMARY. IF YOU DO THEN YOU WOULD REQUIRE MEDIA RECOVERY ON THE…
SELECT /*+ RULE */ GRANTEE FROM SYS.DBA_ROLE_PRIVS A WHERE GRANTED_ROLE=’DBA’ AND EXISTS (SELECT NULL FROM ALL_USERS WHERE USERNAME =A.GRANTEE);
Even when sessions are inactive they can be executing SQL’s in the background. You have to identify the SQL’s which…
Just found an amazing monitoring tool for Oracle Databases. All it needs is an Oracle client installed on your workstation.…
ADDING TAF SERVICE FOR SCAN _____________________________ ####### As “Oracle” (owner of database) user test – name of database test1- instance…
Below is the Solaris user profiles for “grid” and “oracle” user. If you have followed Oracles official documentation for installation…
SCAN (Single Client Access Name) is a new concept introduced in since 11gR2. It eliminated to have VIP )Virutal ip)…
RMAN Point-In-Time Recovery Example There are many ways to restore a database using an RMAN backup – this example assumes…
ORA-01578: ORACLE data block corrupted (file # 19, block # 461509) ORA-01110: data file 19: ‘E:\ORACLE\ORADATA\PLACID\CARA_NS.ORA’ You are getting the…
In this activity we will create Oracle 11gR2 Datagaurd using active duplication. In active duplication, we don’t need to take…
Apple use’s Oracle Active Dataguard 11g for its AppStore. In Oracle 11g data guard you can have upto 30 active…