Category Archive

You are currently browsing the category archive for the ‘Oracle Database&EBS General’ category.

Data Pump Export workers are waiting on ‘wait for unread message on broadcast channel’

November 18, 2018 in Oracle Database&EBS General | Tags: | Leave a comment

I faced with that issue on 11.2.0.4 version on Linux 6. There were no messages or warnings in the alert log file.

Export status showed as executing and there weren’t any errors.

I used below sql to identify wait:

select v.status, v.sid,v.serial#,io.block_changes,event
from v$sess_io io, v$session v
where io.sid = v.sid
and v.saddr in (
    select saddr
    from dba_datapump_sessions
) order by sid;

Read the rest of this entry »

Advertisements

ORA-27126 and Linux-x86_64 Error: 12 During Database Creation or during Database Startup

November 7, 2018 in Oracle Database&EBS General | Tags: , | Leave a comment

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

Read the rest of this entry »

EXPORT and IMPORT process by using multiple directories

November 5, 2018 in Oracle Database&EBS General | Tags: , , , | Leave a comment

If your export size volume is huge than you may need to split export files instead of single FS. In this case, We need to use the multiple directories feature of EXPDP utility.

By using this feature, We can create multiple dump files in multiple directories and distribute our logical export to different directories on the operating system.

In my case my db version in 11.2.0.4 and my os is linux 6

Read the rest of this entry »

INS-30131: Initial setup required for execution of installer validation failed Cause: “Failed to access the temporary location”.

September 27, 2018 in Oracle Database&EBS General | Tags: , , | Leave a comment

I faced with that issue trying to install Oracle 11g database on Linux 6.  Here is the screenshot:

Screenshot_1

Read the rest of this entry »

ORA-29548:java system class reported:java.lang.ExceptionInInitializerError Ora-06512: at line 6 During 12c installation

September 21, 2018 in Oracle Database&EBS General | Tags: , , | Leave a comment

I face with that error message while I was making 12c installation on Solaris machine. The Screen shoot is:

Screenshot_2

Read the rest of this entry »

How To Give Grant Select On X$ Objects In Oracle

August 25, 2018 in Oracle Database&EBS General | Tags: , | Leave a comment

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 with a DDL or DML statement is met with an ORA-02030 error.

Only SYS can query the X$ tables, they cannot be granted.  However, you can create view on them and grant the view.
Read the rest of this entry »

Create or rebuilding an oracle spatial index in another schema ORA-06512: at “”MDSYS.SDO_INDEX_METHOD_10I””, line 10 “

May 13, 2018 in Oracle Database&EBS General | Tags: , , , , | Leave a comment

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 type INDEX:"MY_SCHEMA"."GI_LOCATION_1" failed to create with error:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed

Read the rest of this entry »

Sqlplus “/as sysdba” gives ORA-01031: insufficient privileges On Windows

April 27, 2018 in Oracle Database&EBS General | Tags: , | Leave a comment

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

Read the rest of this entry »

Restore control file show wrong path

April 25, 2018 in Oracle Database&EBS General | Tags: | Leave a comment

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.

Read the rest of this entry »

 ASMCMD-08016 error during copy process

April 25, 2018 in Oracle Database&EBS General | Tags: | Leave a comment

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]

Advertisements
Advertisements