ORA-00600 [150]

SQL> alter system set log_file_name_convert= 2 'c:\ora9ihome\oradata\ora9i\','c:\ora9istdy' scope=spfile;

alter system set log_file_name_convert=

*

ERROR at line 1:ORA-00600: internal error code, arguments: [150], [], [], [], [], [], [], []

During configuration of standby database i am getting above error.

It is known bug

check metalink note: Note:138414.1

ksdpec: called for event 13740 prior to event group initialization

After upgrade db from 10gr1 to 10gr2 I got the following message in alertlog file during db startup time only.

ksdpec: called for event 13740 prior to event group initialization

starting up ORACLE RDBMS Version: 10.2.0.1.0

After searching on metalink and google I found below metalink note.

Metalink Note: 342505.1

http://oracleappstechnology.blogspot.com/2008/03/ksdpec-called-for-event-13740-prior-to.html

'Lb_library_path Is Not Set' On Startup

After successfully upgrade db from 10gr1(10.1.0.3.0) to 10gr2 (10.2.0.1.0) I got below warning message during database startup

Sat Aug 9 17:52:09 2008

Starting ORACLE instance(normal)

Cannot determine all dependent dynamic libraries for /proc/self/exe

Unable to find dynamic library libocr10.so in search paths

after searching on metalink I found below metalink note.

Metalink Note: 371408.1

According to metalink note it is a BUG:4918834.

Soluction: Set LD_LIBRARY_PATH enviourment variable.

$export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

Memory Notification: Library Cache Object Loaded Into SGA

After upgrade db from 10gr1 to 10gr2(10.2.0.1.0) on linux server I got below warning message in alert_sid.log file.

Tue Aug 12 11:34:37 2008Memory Notification: Library Cache Object loaded into SGAHeap size 2205K exceeds notification threshold (2048K)

After searching on metalink and google I found below metalink note and link.

Metalink Note: 330239.1

http://sabdarsyed.blogspot.com/2007/03/warning-memory-notification-library.html

ORA-00959 tablespace "_$deleted$0$0' Does Not Exist

Yesterday I upgrade the Production DB from 10gr1 (10.1.0.3.0) to 10gr2 (10.2.0.1.0) on Linux 4.

Upgrading process going fine and well. but after upgrading when I trying to export DB schema then I was getting below error

ORA-00959 tablespace '_$deleted$0$0' Does Not Exist

Then after I visit to metalink and found below metalink note: 604648.1

It is unpublish BUG.

Short Hint: Above Error occur after when we done below procedure after upgrade.

1. create new temp tablespace

2. make default temp tablespace to new one

3. drop old temp tablespace

4. rename new tablespace name to old tablespace name

After that we will get above error. for solution kindly visit mentioned metalink note.

RMAN TSPITR + ORA-25153

Today I come across one problem during testing RMAN TSPITR option.

Database Version: 10.1.0.2.0 (10gr1)

The problem during TSPITR operation RMAN session disconnected with the following errors

About to export Tablespace Point-in-time Recovery objects...

EXP-00008: ORACLE error 25153 encountered

ORA-25153: Temporary Tablespace is Empty

ORA-06512: at "SYS.DBMS_PITR", line 887

ORA-06512: at line 1

EXP-00000: Export terminated unsuccessfully

host command complete

Above error message we face till 10.1.0.4.0.

This problem fix in 10.1.0.5.0 or later version.

Above error occur becuase RMAN automatically not create tempfile. After searching on metalink I found below metalink note: Note:263483.1

Strange but Interesting problem

Our database backup through RMAN was terminated with below error message

In RMAN log file

RMAN-03009: failure of backup command on C1 channel at 06/20/2008 10:04:34

RMAN-10038: database session for channel C1 terminated unexpectedly

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 06/20/2008 10:06:03

RMAN-00600: internal error, arguments [8039] [sqlrcn failed] [-1075] [] []

In alertsid.log file

Sat Jun 21 17:11:56 2008
Errors in file e:\oracle\product\10.1.0\admin\udump\ora_3856.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x114B926] [] [] [] []

After that I start my searhing in metalink for ORA-07445 but didn't get any useful.

then search for RMAN-00600 error and get hint through increase SWAP space will solve the issue but it is not solve the problem

then after I search for RMAN-10038 error and get metalink note: 337894.1 which refer to check RMAN configuration, and this is the actual problem when I reset all RMAN configuration then RMAN backup is work smootly.

In RMAN configuration below parameter is set wrongly.

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'G:\ORA_BACKUP\%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024 M;

Actually I set above parameter for the backup location and format and also mention FORMAT cluase in BACKUP SCRIPT with "BACKUP DATABASE ... FORMAT ...". but when I clear this configuration parameter RMAN backup is work.

CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;

After that RMAN backup work properly and problem solved.

RMAN-00600: [8039] [sqlrcn failed] [-1075]

Yesterday I was getting below error message during RMAN backup session on our developement database

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 06/20/2008 10:06:03

RMAN-00600: internal error, arguments [8039] [sqlrcn failed] [-1075] [] []

Backup session was terminated with RMAN-00600 error message.

When I search on metalink then I found below metalink note: 602757.1

Metalink note refer Oracle 9i database but our database version is 10gr1 on WIN2003 platform.

it is related to OS SWAP space problem, SWAP space increase will solve the issue.

ORA-00600: [17183], [0xA2C0044]

Today I getting following error in 10gr1 database running on windows 2003 server

ORA-00600: internal error code, arguments: [17183], [0xA2C0044], [], [], [], [], [], []

It is reported as BUG.

It can be found in Oracle 9i,10gr2.

The BUG is fixed in 10.1.0.4 Server Patch Set

Kindly Refer Metalink Note: 3350337.8

RMAN Backup Fails With ORA-19571

RMAN Backup Fails With ORA-19571

RMAN-00571: ===========================================================

RMAN-00569: ===============

ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on

ORA_DISK_1 channel at 06/06/2008 20:47:31

ORA-19571: archived-log recid 13100 stamp 656015599 not found in controlfile

If you are getting above error message then apply below solution

1. increase value of CONTROL_FILE_RECORD_KEEP_TIME parameter

NOTE: It is static parameter so we need to bounce our database to take effect.

2. Use RECOVERY CATALOG instead of CONTROLFILE to keep RMAN backup information.

NOTE: For more details check metalink note: Note:563219.1

Trace Event

How to Determine What Events/Parameters are Set in the Current Session?

Check Metalink Note: 28446.1

How To List All The Named Events Set For A Database?

Check Metalink Note: 436036.1