Oracle Database&EBS General
-
Background Media Recovery terminated with error 1111
I have dataguard configuration such as,2 node RAC(11.2.0.4) on Aix 7.1 as primary, standalone standby database. I noticed that Primary can transport archive log to standby but standby cannot apply archive log and giving errors at standby alert.log such as: MRP0: Background Media Recovery terminated with error 1111 and MRP0: Background Media Recovery process shutdown (PROD00DG) Continue reading
-
ORA-02097&ORA-00068 during chancing CPU count dynamically
As you know sometimes we need to change CPU count dynamically on our prod systems. Our Unix team change our 2 node RAC system (11.2.0.4 version) server’s CPU from 20 to 30 on AIX 7.1 Continue reading
-
How to Sync RMAN catalog and Tivoli Storage Manager (TSM)
I face this issue when my Tivoli admin friends warn me about old backup which could be listed on Tivoli Storage even I delete my all old RMAN backups with RMAN commands on our 11.2.0.4 database have 11.2.0.4 database on AIX 6.1 which we use RMAN backup utility with RMAN catalog by using Tivoli tool Continue reading
-
ORA-01116-ORA-01110-ORA-27041 errors during drop tablespace
I faced with those errors on 12c database. While I try to drop some tablespace it throws errors such as: SQL> DROP TABLESPACE MY_TABLESPACE INCLUDING CONTENTS AND DATAFILES; DROP TABLESPACE MY_TABLESPACEINCLUDING CONTENTS AND DATAFILES * ERROR at line 1: ORA-01116: error in opening database file 35 ORA-01110: data file 35: ‘/u01/app/oracle/product/12.1.0/dbhome_2/dbs/MY_TABLESPACE02_A.DBF’ ORA-27041: unable to open Continue reading
-
ORA-01078&ORA-29701 on startup
I hit this error during try to start my ASM instance I am working standalone Oracle 11.2.0.1 database with ASM option on AIX 6.1. I this error after I reboot my server. $export ORACLE_SID=+ASM $sqlplus “/as sysasm” SQL> startup ORA-01078: failure in processing system parameters ORA-29701: unable to connect to Cluster Synchronization Service Continue reading
-
ORA-31626 ORA-31637 ORA-39080 errors during expdp
I face this issue while trying to take export by using data pump My system is: AIX:6.1 Db verison:11.2.0.3 Process: expdp Continue reading
-
11g ./runInstaller gives JVMDUMP error on AIX
I hit this error while I was trying to make 11gR2 installation on the AIX6 operating system. /runInstaller ended by: JVMDUMP006I Processing Dump Event “gpf”, detail “” – Please Wait. JVMDUMP007I JVM Requesting System Dump using ‘/tmp/core.xx.dmp’ JVMDUMP010I System Dump written to /tmp/core.xx.dmp JVMDUMP007I JVM Requesting Snap Dump using ‘/tmp/x.trc’ JVMDUMP010I Snap Dump written to /tmp/xx.trc JVMDUMP007I Continue reading
-
java.lang.ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class Error
For test purpose, We need to create EBS on Oracle VM box. After installation some of our user cant login to our new test system. To can see what happen, We just enabled java to debug console on client machines. While We checked the end of the console We noticed those errors: Continue reading
-
How to Compare Schemas between databases
For some reason, We need to compare between Test Schema objects with Prod Schema objects to can see a difference. Its possible to do that by using am going to share one document which is using TOAD program for this purpose. I hope you enjoy it. How to Generate A Schema Script to Compare with Continue reading
-
ORA-00054: resource busy and acquire with NOWAIT specified error
You can hit ORA-00054: resource busy and acquire with NOWAIT specified error during some of your operations on your database such as alter some objects. The main reason for this error is Table Level Locks(TM lock). The transaction holds two locks (Row Locks(TX) and Table Locks(TM) when the session opens. So What are those locks? Continue reading
HELIOS BLOG 