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:
18.104.22.168 on Linux x66(new platform ? ;)) released – this joke no more present in mentioned document 😉
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], ,  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 →
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):
The following dynamic performance views were deprecated in Oracle Database 11g Release 2 (11.2).
V$FLASH_RECOVERY_AREA_USAGE (replaced by V$RECOVERY_AREA_USAGE)
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.
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“
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 →