Oracle Database&EBS General
-
Oracle Dataguard Standby Log Apply is slow
You may hit performance issue on your dataguard setup. You may not hit the transfer gap but You may have an apply gap on your standby site. It can because some critical issue if your primary side goes down. There are some trick which You can increase your performance on the Standby database on your Continue reading
-
ORA-27126 and Linux-x86_64 Error: 12 During Database Creation or during Database Startup
I faced with that error message on 12.1.0.2.0 EE version on RHEL6 Here are the error messages SQL> startup nomount; ORA-27126: unable to lock shared memory segment in core Linux-x86_64 Error: 12: Cannot allocate memory Additional information: 3894 Additional information: 2129923 Additional information: 6090752 Continue reading
-
INS-30131: Initial setup required for execution of installer validation failed Cause: “Failed to access the temporary location”.
I faced with that issue trying to install Oracle 11g database on Linux 6. Here is the screenshot: Continue reading
-
ORA-29548:java system class reported:java.lang.ExceptionInInitializerError Ora-06512: at line 6 During 12c installation
I face with that error message while I was making 12c installation on Solaris machine. The Screen shoot is: Continue reading
-
How To Give Grant Select On X$ Objects In Oracle
The X$ tables are owned by the SYS database user and are read-only, which is why they are referred to as fixed tables and the V$ views are referred to as fixed views. This statement might be a juicy invitation for you to try to verify this read-only property. Any attempt to alter these tables Continue reading
-
Create or rebuilding an oracle spatial index in another schema ORA-06512: at “”MDSYS.SDO_INDEX_METHOD_10I””, line 10 “
I hit with that error message during the export&import process on 12c database on Linux While I am checking import log, I noticed below error message: ORA-13249: Error in R-tree: [mdrcrtscrt] ORA-13231: failed to create index table [MY_OBJECT$] during R-tree creation ORA-13249: Stmt-Execute Failure: CREATE TABLE “MY_SCHEMA”.”MY_OBJECT$”(NODE_ID NUMBER,NODE_LEVEL NUMBER,INFO BLOB) LOB (INFO) STORE ORA-39083: Object Continue reading
-
Sqlplus “/as sysdba” gives ORA-01031: insufficient privileges On Windows
One of our Prod systems is running on Windows server. While I am trying to connect database as sysdba user it throws A-01031: insufficient privileges C:\Windows\>sqlplus “/ as sysdba” SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 27 13:15:06 2018 ERROR: ORA-01031: insufficient privileges Continue reading
-
Restore control file show wrong path
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 Continue reading
-
ASMCMD-08016 error during copy process
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 [+] Continue reading
HELIOS BLOG 