Funny FBDA BUG: ORA-00600 [ktfa_error_handler_map], [942]

I have faced quite interesting situation with Flashback Data Archive(FBDA)  that wasn’t covered yet in blogosphere.

So I have just created new Flashback Archive and altered some tables specifying it(Flashback Archive).

Just after some time of any DMLs on altered tables next error appears in alert.log

Starting background process FBDA
Thu Feb 21 11:07:07 2013
FBDA started with pid=203, OS id=3626
Errors in file /u01/app/oracle/diag/rdbms/siam_opt/siamopt/trace/orcl_fbda_3626.trc  (incident=57628):
ORA-00600: internal error code, arguments: [ktfa_error_handler_map], [942], []
ORA-00942: table or view does not exist

Please, notice presence of additional funny error  – ORA-00942. Why it may be here ? we’ll see later…

Oracle 12cR1 Upgrade Companion – Coming Soon [ID 1462240.1]

Just short post about Something Coming Soon from mentioned note

“

Modified:Jan 23, 2013

COMING SOON!!! Stay Tuned

“

 

Still have to wait

No Oracle Database 12c(12.1) was released on 12.12.(20)12…

Despite the fact that there were some speculations that Oracle Database 12c will be released on 12.12.(20)12 to use the Magic of 3×12, this opportunity was missed by Oracle and Release 12c is still in Beta Testing period,

so we have to wait for the another ‘good’ moment like 3×13(12.13.[20]13) 

Later we’ll see if it add more power to new Release…

Troubleshooting ‘Log File Sync’ Waits

I have been contacted by one of our customers to provide reference information on troubleshooting Oracle Log File Sync waits.

I think that this information worth short blog post.

Reasons:

• Log File Sync waits occur when sessions wait for redo data to be written to disk
• typically this is caused by slow writes
• or committing too frequently in the application
• CPU overburning(very high demand => LGWR on run queue)
• improper Operating System configuration(check 169706.1)
• BUGs in Oracle(especially with RAC option) and 3rd Party software(like ODM/DISM)

Recommendations:

Production System with Performance Problems

Hi.

Recently I was involved in performance troubleshooting of one quite expensive system

that had performance problems during business hours.

I’ll not provide all details, but just post some pictures that will show resource usage:

Oracle memory allocation:

Linux memory allocation

or from other side:

cat /proc/meminfo
 MemTotal:     98848220 kB
 MemFree:      75109972 kB
 Buffers:        597460 kB

RMAN RESTORE ends with ORA-01180: can not create datafile

I was doing RMAN RESTORE database for refreshing developers’ stand and stuck on next situation:

run{

SET UNTIL SCN 18508482749;

SET NEWNAME FOR DATABASE TO ‘/oradata1/oradata/XXX/%b’;

RESTORE DATABASE;

RECOVER DATABASE;

}

creating datafile file number=1 name=/oradata1/oradata/XXX/system01.dbf

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

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

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

RMAN-03002: failure of restore command at 08/08/2012 13:27:26

ORA-01180: can not create datafile 1

ORA-01110: data file 1: ‘/oradata1/oradata/XXX/system01.dbf’

RMAN DUPLICATE FROM… Active Standby

Recently I have published post about issue with RMAN duplication of Oracle database when standby database was used as a target. Later in updates of mentioned post I have confirmed that with fix for BUG:11715084 everything works as expected.

Today I have decided to make post with step-by-step procedure with which I have tested mentioned feature – making standby database from standby database.
I will Simplify setup As Much As Possible(SAMAP):

1. single machine will be used as a host for all 3 databases
2. OMF(Oracle Managed Files) will be used for managing files location and file names
3. FRA(Fast/Flash Recovery Area) will be used for archive logs

Fixing ORA-07445 [opixrb()+6944] + ORA-600 [opixrb] Over Gateway

Today I was contacted by one of our customers (one of the biggest Ukraine banks) – that faced next issue after upgrading server-size PL/SQL code to new version on one of their critical systems:

• they wasn’t able to compile one of packages – package compilation session just ended with the next message
  • ORA-01331 end of file communication channel
• from the server-side(trace-file) error message was next:
  • ORA-07445: exception encountered: core dump [opixrb()+6944] [SIGSEGV] [ADDR:0x0] [PC:0x103C1D980] [Address not mapped to object] []
• current SQL Statement from the trace-file:
  • SELECT :”SYS_B_0″ DUMMY FROM “dbo”.”sysusers”@APS WHERE “name” = :”SYS_B_1″
• customer confirmed that they are using Oracle Gateway (Heterogeneous Services) link to Microsoft SQL Server inside mentioned package
• there weren’t any changes to mentioned package during application code update
• there weren’t any patches applied to ORACLE_HOME since everything worked OK
• it just stopped compiling
• they must have working system tomorrow morning!