You are currently browsing the category archive for the ‘Oracle Database&EBS General’ category.
I faced this issue while working with preparing standby database with E-Business Suite R12.1 with 11gR2-RAC on ASM
I have E-Business Suite R12.1.2 with 11.2.0.4 RAC database which is working on ASM
I needed to create standby server. I followed below command on the primary database to can create RMAN backup for can create standalone standby database.
Advertisements
I face wiht this error while i try to move one of my file system to my ASM
I have 11.2.0.2 database which is working on 12c ASM
I needed to copy one file from file system to asm. Here is the my steps:
[oracle@prod]</tmp> asmcmd -p ASMCMD [+] > ls ORADATA/ ORAFRA/ ASMCMD [+] > cd oradata ASMCMD [+oradata] > ls ASM/ ORCL/ ASMCMD [+oradata] > cp /tmp/thread_1_seq_148.268.755819361 +ORADATA/thread_1_seq_148.268.755819361 copying /tmp/thread_1_seq_148.268.755819361 -> +ORADATA/thread_1_seq_148.268.755819361 ASMCMD-08016: copy source->’/tmp/thread_1_seq_148.268.755819361′ and target->’+ORADATA/thread_1_seq_148.268.755819361′ failed ORA-19505: failed to identify file “+ORADATA/thread_1_seq_148.268.755819361” ORA-17502: ksfdcre:4 Failed to create file +ORADATA/thread_1_seq_148.268.755819361 ORA-15046: ASM file name ‘+ORADATA/thread_1_seq_148.268.755819361’ is not in single-file creation form ORA-06512: at “SYS.X$DBMS_DISKGROUP”, line 397 ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute) The cp command failed because the ASM file name was not in a form that can be used to create an single file.File name should not contain the file number/incarnation
Here is the solution:
ASMCMD [+oradata] > cp /tmp/thread_1_seq_148.268.755819361 +ORADATA/thread_1_seq_148
Reference:
ASMCMD cp command fails with ORA-15046 [ID 452158.1]
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)
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
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
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 file SVR4 Error: 2: No such file or directory Additional information: 3
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
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
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 JVM Requesting Java Dump using ‘/tmp/javacore.xx.txt’
JVMDUMP012E Error in Java Dump: /tmp/javacore.xx.txt
JVMDUMP013I Processed Dump Event “gpf”, detail “”.
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:
