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

Some of our developers run their code on Our  11.2.0.4 database. While they are running the code, they are hitting ORA-29538&ORA-06512 errors.

Here is the complete error messages:

ORA-29538:Java not installed
ORA-06512:at_konum “XXX.UNZIPPER_PKG”, line 2
ORA-06512:at “XXX.UNZIPPER_PKG”, line 12
ORA-06512:at “XXX.UNZIP”, line 4

Read the rest of this entry »

As a DBA, We are using export/import utility many times during our daily process.
I have face this error trying to import only one table from full export.

Error message is

ORA-39002: invalid operation
ORA-39166: Object USER1.TABLE was not found.

Read the rest of this entry »

While you are trying to open alert_SID.log file or some other large files with vi editor you may hit ex: 0602-101 Out of memory saving lines for undo  error message,

# cd /u01/app/oracle/admin/DB_NAME/bdump
# vi alert_SID.log
ex: 0602-101 Out of memory saving lines for undo.

So you can use below syntax to can set EXINIT value,then you can retry to open your alert.log  file.

export EXINIT=”set ll=80000000″

Reference:
Hints and tips when using vi on AIX

I faced with ORA-19606 error on 11.2.0.4 database. I am using below rman script to take full backup for my database.

Here is my script:

rman target  /

run
{
ALLOCATE CHANNEL C1 device type ‘sbt_tape’ ;
ALLOCATE CHANNEL C2 device type ‘sbt_tape’ ;
backup database plus archivelog delete input format= ‘DB_SID_DB_%d_%t_%s_%p’;
backup archivelog all delete input FORMAT= ‘DB_ARC_%d_%t_%s_%p’;
delete force noprompt obsolete;
RELEASE CHANNEL C1;
RELEASE CHANNEL C2;
}

Read the rest of this entry »

I faced with that error on r12.1.3 EBS system. My db version is 11.2&2 node RAC system.

My first node is goes down by below errors:

opiodr aborting process unknown ospid (11075852) as a result of ORA-28
LMON (ospid: 63767522) detects hung instances during IMR reconfiguration
LMON (ospid: 63767522) tries to kill the instance 2. 
Please check instance 2’s alert log and LMON trace file for more details.
Tue Mar 19 10:58:36 2020
USER (ospid: 32900426): terminating the instance due to error 481
Tue Mar 19 10:58:36 2020
Errors in file /oracle11g/PROD00/db/diag/rdbms/PROD00/PROD001/trace/PROD001_lmon_63767522.trc:
ORA-29702: error occurred in Cluster Group Service operation
System state dump is made for local instance
System State dumped to trace file /oracle11g/PROD00/db/diag/rdbms/PROD00/PROD001/trace/PROD001_diag_9373174.trc
Instance terminated by USER, pid = 32900426

Read the rest of this entry »

On my 11.2&2 node RAC system, one of the node has been rebooted. While I was investigating issue I noticed LMDO process terminating the instance.

We have below in alert.log on victim node:

LMS2 (ospid: 28770960) received an instance eviction notification from instance 2 [2]
LMON received an instance eviction notification from instance 2
The instance eviction reason is 0x2
The instance eviction map is 1
PMON (ospid: 13435162): terminating the instance due to error 481
/oracle11g/db/diag/rdbms/VIS/rac_node1/trace/rac_node1_diag_19530038.trc

Read the rest of this entry »

You can hit this error on your alert.log. Error could be similar as:
ORA-01578: ORACLE data block corrupted (file # 12, block # 4207)
ORA-01110: data file 11: ‘/xx/sytem.dbf’

There are many possible causes of a block corruption including:

– Bad IO hardware / firmware
– OS problems
– Oracle problems
– Recovering through “UNRECOVERABLE” or “NOLOGGING” database actions (in which case ORA-1578 is expected behavior)

Read the rest of this entry »

You can face with this error message while you are deleting some xxx.trc -c-dump files or some other files which fill up your disk you may hit ksh: /usr/bin/rm: arg list too long error message,

Read the rest of this entry »

In Our RAC databases I noticed  EMON process consuming CPU. OEM graph like below:

111111

Read the rest of this entry »

I faced with this error message on 18c RAC database.

Error message is:

ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SA_SPC_SY_10909″
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at “SYS.DBMS_ADVISOR”, line 201
ORA-06512: at “SYS.DBMS_SPACE”, line 2563
ORA-06512: at “SYS.DBMS_SPACE”, line 2643

Read the rest of this entry »