IMPDB with REMAP_SCHEMA may create(import) Trigger on table in Wrong Schema

Funny situation was discovered recently by one of our customers. Actually, it was an incident with Core Banking System, so, in reality, it wasn’t Funny….

I have checked and found that this issue reproduces not only with customer’s database using software version 11.2.0.4, but with version 12.1.0.2 with latest Oracle Database Proactive Bundle Patch(160719) installed.

To reproduce issue you need: Continue reading

Advertisements

Global Context + Session Client Identifier = Strange Behaviour or Documentation BUG ?

Here I’ll describe some strange/interesting/ behaviour of Global Application Context connected with usage of Session Client Identifier, that is quite usually met in Application Express, J2EE Agent, Oracle Data Integrator starting from release 11.1.1.7 and many other applications that uses JDBC Connection Pooling in conjunction with setting Session Client Identifier.

So what is the problem ?

The problem is that Global Application Context doesn’t work as expected and described in documentation – attributes’ VALUES ARE NOT VISIBLEContinue reading

Funny Package Non-Compilation Issue

Today I was contacted by one of our customers with very non-typical issue on their 10.2.0.4 database. They have added new column to one table at the middle of the day and now they are not able to compile some of invalidated packages.

Now I’m clarifying what does it mean ‘NOT ABLE TO COMPILE‘:

ALTER PACKAGE PKG_ERP_MAIN COMPILE;
Package altered.

SHOW ERR
No errors.

ALTER PACKAGE PKG_ERP_MAIN COMPILE BODY;
Package body altered.

SHOW ERR
No errors.

select object_type,status from dba_objects where object_name='PKG_ERP_MAIN';
OBJECT_TYPE         STATUS
------------------- -------
PACKAGE             VALID
PACKAGE BODY        INVALID

Funny! Isn’t ? Continue reading

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… Continue reading

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! Continue reading

ORA-600 [qsmkzsi_setup_ivqbc:1] with Materialized View COMPILE/REFRESH

Hi.

Just a quick post about issue that wasn’t ever discussed… and hasn’t fix from Oracle yet…

Compiling or refreshing materialized view You may face ORA-600 [qsmkzsi_setup_ivqbc:1] error.

It’s because of:

BUG 10145667 – ANSI query does not rewrite

Fixed In:

12.1. (future release)
11.2.0.4 (future release)

What is most interesting is that sometimes You may get mentioned error, but sometimes everything works as expected, so issue is not consistent…

Workaround: Continue reading

RMAN DUPLICATE FROM Active Database From Standby ends with ORA-01671

Hi.

Quite interesting question was asked by one of our customers:

“Is it possible/supported to do RMAN DUPLICATE FOR STANDBY FROM ACTIVE DATABASE when TARGET is STANDBY ?”

It’s really seasonable question, especially when You already have standby database and wanna refresh a development environment using standby as a source/target to not stress primary database .

There are no such restriction in 11.2 “Prerequisites Specific to Active Database Duplication”, so why not ? 😉

But even Oracle wanted to provide mentioned functionality it’s not often used(tested), so let’s see what we get as a result Continue reading