Oracle Database Patchset is ready for downloading

Oracle RDBMS PatchSet version is available for downloading since 27-AUG-2013 ! again some time earlier than OOW2013

But(as of 29-AUG-2013) it’s still available only for Linux x86-64 + Linux x86 and all Oracle Solarises(x86, x86-64, SPARC 32-bit, SPARC 64-bit)

Checked on 29-OCT-2013 – patchset aditionally available for next platforms: Microsoft Windows(32-bit), Microsoft Windows x64(64-bit), HP-UX Itanium(32-bit), HP-UX Itanium(64-bit), IBM AIX on POWER Systems (32-bit), IBM AIX on POWER Systems (64-bit)

Based on  NOTE:742060.1 Release Schedule of Current Database Releases:

  • on Linux x66(new platform ? ;)) released – this joke no more present in mentioned document 😉
  • this is the terminal patch set for 11.2 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

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


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) (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


Quite interesting question was asked by one of our customers:


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

Oracle Database Behavior Changes

Just a quick post of some(not all, but most important for me) interesting facts about Oracle Database Behavior Changes in releases 11.2, 11.1, 10.2 & 10.1 for those who are quite long time with Oracle, but not always has time to read Documentation:

Compatibility and Interoperability Issues in Oracle Database 11g Release 2 (11.2):

Dynamic Performance Views Deprecated in Oracle Database 11g Release 2 (11.2)

The following dynamic performance views were deprecated in Oracle Database 11g Release 2 (11.2).


Changes to LOG_ARCHIVE_DEST_n Parameters

Starting with Oracle Database 11g Release 2 (11.2), the number of supported destinations in the LOG_ARCHIVE_DEST_n and the LOG_ARCHIVE_DEST_STATE_n parameters have been increased from 10 to 31. Destinations LOG_ARCHIVE_DEST_11 through LOG_ARCHIVE_DEST_31 do not support the SYNC, ARCH, LOCATION, MANDATORY, ALTERNATE, or DEPENDENCY attributes, and cannot be specified as the target of the ALTERNATE or DEPENDENCY attributes.

LOG_ARCHIVE_DEST_11 through LOG_ARCHIVE_DEST_31 can only be used when the COMPATIBLE initialization parameter is set to 11.2.0 or higher.

Non-Uniform Memory Access Optimizations and Support Disabled in 11.2

With Oracle Database 11g Release 2 (11.2), non-uniform memory access support is disabled by default. This restriction applies to all platforms and operating systems (reference Bug 8450932).

Non-uniform memory access optimizations and support in the Oracle Database are only available for specific combinations of Oracle version, operating systems, and platforms. Work with Oracle Support Services and your hardware vendor to enable non-uniform memory access support.

Continue reading

Investigation of the 11g Oracle*Net connection delay when DNS server is unreachable

Oleksandr Denysenko:

“I’d like to introduce new Contributor to this Blog – Robert Oliynichenko.

Hi will make post on topics that are related to main direction of this Blog.

So, here we have The First Post about Slow 11.2 SQL*Net connections on AIX

Problem description:

Oracle 11g utilities like tnsping, lsnrctl or sqlplus on AIX 6.1 hanged for about 2,5 minutes (150 seconds) before connection with alias to any destination when DNS server was unreachable. In the same conditions (host and configuration) 10g utilities connected without delay. Oracle*Net was configured for local naming method only – NAMES.DIRECTORY_PATH=(tnsnames) in the both 10g and 11g Oracle Home. The tnsnames.ora files where identical in the 10g and 11g Oracle Home. The aliases in the tnsnames.ora used host names instead of IP addresses in the connection descriptions; if a host name was substituted by IP address the delay disappeared for this alias. Nevertheless all the host names from tnsnames where described in the /etc/hosts and resolution order was hosts = local, bind in the netsvc.conf (analog of  the nsswitch.conf in other UNIXs). This configuration should guarantee local name resolution when DNS server was unreachable. What is the root reason of this delay in 11g Oracle*Net ? Continue reading