12 Temmuz 2014 Cumartesi

[EN] ORA-00600: internal error code, arguments: [kcbtema_10], [1], [], [], [], [], [], []

ERROR:

During startup we got the following error. The version of the database is; 10.2.0.5.

SQL> startup
ORACLE instance started.

Total System Global Area 3372220416 bytes
Fixed Size                  2071640 bytes
Variable Size            1291846568 bytes
Database Buffers         2046820352 bytes
Redo Buffers               31481856 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcbtema_10], [1], [], [], [], [],[], []


SQL>

Also we noticed the following entires in alertlog;


28 Mayıs 2014 Çarşamba

[EN] RMAN connection error: ORA-28041: Authentication protocol internal error

$ rman target rman/xxx@db1;

Recovery Manager: Release 10.2.0.5.0 - Production on Tue May 27 18:44:36 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: 
ORA-28041: Authentication protocol internal error

We got this error after applying PSU12 to one of our 10.2.0.5 production database. It was on a HP-UX Itanium 64 bit server. We applied the PSU successfully, but later we noticed that it gave some WARNINGs.
Here are the warnings;

7 Mayıs 2014 Çarşamba

[EN] ORA-19706: invalid SCN

ERROR:

During a select through a database link we got the following error;

===> select sysdate from dual@TARGET_DBX
select sysdate from dual@TARGET_DBX
                         *
Error at line 1
ORA-19706: invalid SCN
ORA-02063: önceki line, kaynağı TARGET_DBX Script Terminated on line 1.

Also we noticed the following message in the alert.log;

*********************************************************************************
Rejected the attempt to advance SCN over limit by 8 hours worth to 0x0ca5.1y0772c8, by distributed transaction remote logon, remote DB: TARGET_DBX.WORLD.
 Client info : DB logon user USERX, machine hostx program JDBC Thin Client, and OS user app_usr1 *********************************************************************************

17 Şubat 2014 Pazartesi

[EN] ORA-28030: Server encountered problems accessing LDAP directory service

After IDM entegration, we got

"ORA-28030: Server encountered problems accessing LDAP directory service"

error during logon to database via TOAD.









9 Şubat 2014 Pazar

[EN] ORA-00245 control file backup failed; target is likely on a local file system


------------------
-- ERROR --
------------------

At the end of a full backup of our database we got the following error during control file and spfile file autobackup;

piece handle=TRYY_ARCH.9up06jbt_1_1 tag=TAG20140209T130029 comment=API Version 2.0,MMS Version 1.1.0.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:10
channel ORA_SBT_TAPE_2: finished piece 1 at 09-FEB-14
piece handle=TRYY_ARCH.9vp06jc0_1_1 tag=TAG20140209T130029 comment=API Version 2.0,MMS Version 1.1.0.0
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:07
Finished backup at 09-FEB-14

Starting Control File and SPFILE Autobackup at 09-FEB-14
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script GLOBAL_TRYY_FULL_BACKUP
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_SBT_TAPE_1 channel at 02/09/2014 13:00:58
ORA-00245: control file backup failed; target is likely on a local file system

Recovery Manager complete.