Problem —— Error on starting ASM from SQLPLUS or ASMCMD SQL> startup; ORA-01078: failure in processing system parameters ORA-29701: unable…
Tag 11gR2
To Configure RAC 11gR2 on AIX 6.1 using ASM. You need to prepare the raw devices like below. The general…
bash-3.2$ impdp system/***** directory=import_dir nologfile=y dumpfile=exp_swx_20092012.dmp full=y ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open…
The various security mandates these days required a lot of auditing on the database. Though there are a host of…
Occasionally you need to create a quick one node RAC setup for testing and one of the requirements is a…
SQL> conn / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. SQL> drop database; drop…
While trying to troubleshoot an application connectivity issue today along with a developer I faced an interesting situation. We had…
Working on creating a muti-master replication for a production system. Each database needs to be active and replicate changes back…
Oracle GoldenGate will now be more closely coupled with Oracle database. And it is by far the best heterogenous replication…
GoldenGate is touted by Oracle as its future for data replication. It will slowly phase out Oracle Streams and will…
// *Cause: The archiver process received an error while trying to archive // a redo log. If the problem is…
When a large number of records neds to be deleted from a table. If you do a normal delete it…
Recovery interrupted! Recovered data files to a consistent state at change 13507372 Fri May 11 20:11:09 2012 Errors in file…
Guaranteed Restore Points are a life-saver when it comes to Application changes.It can ensure that you can rewind the database…
I had a block corruption of my primary database, though we had a standby build we wanted to recover the…
Flashback Technology provided by Oracle is one of the most useful in a production environment. It is a life saver.…
This error occurs when you have a public synonym defined and the object referencing or owning the synonym has been…
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…
Source –> http://oraexplorer.com/2007/11/oracle-apex-in-11g-installation/ Today I installed Oracle 11g (11.1.0.6) on my machine. I did not realize that Oracle APEX is…
Just found an amazing monitoring tool for Oracle Databases. All it needs is an Oracle client installed on your workstation.…
IF crsctl stat res -t gives output like below, means that the VIP failed over to node 1 from node…
ADDING TAF SERVICE FOR SCAN _____________________________ ####### As “Oracle” (owner of database) user test – name of database test1- instance…