ORACLE.EXE Virtual Memory Keeps Increasing on x64 Windows

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.5.0   [Release: 10.2 to 10.2]
Microsoft Windows x64 (64-bit)
NOTICE that this is a PLATFORM SPECIFIC problem for 10gR2 on x64 Windows systems

Symptoms

ORACLE.EXE continuous increases the amount of virtual memory used, and you see zombie thread accumulation on 64-bit MS Windows environment.

No ORA-4030 seen, but instance needs be restarted frequently to bring down the amount of virtual memory consumed by the oracle.exe process. Eventually, if all virtual memory has been consumed, ORA-4030 will occur.

Using Perfmon or TaskManager you see that the virtual size of oracle.exe is constantly growing (up to several 100's MB per day).

Using the VMMap tool to analyze the oracle.exe process, you see that the process stack accumulates zombie threads that holds around 3072 KB per zombie thread, accounting for the excess virtual memory consumption.

VMMap is a process virtual and physical memory analysis utility (available for free) (technet.microsoft.com/sysinternals).

Cause

10.2 was the first release on x64 Windows and it shipped with the 1.5 JDK / 1.4 in the database. There are some memory management issues with this release which are only fixed in 11.1+, so customers should use the workaround or upgrade to 11.1+.

The problem can occur when running JVM related applications.

When a session ends, the thread is not cleaned up at OS level, but remains as a zombie thread, still occupying 3072 KB of thread stack memory.

Solution

Workaround the problem by setting the following parameter, and restart the instance :

  _kill_java_threads_on_eoc=TRUE

OR

Migrate to 11gR1 or 11gR2, where this problem does not occur.

ORA-00600 + [kqlidchg0]

Today i saw below error message on my alert log files

Mon Jan 16 08:34:12 2012

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\fakpropr\fakpropr\trace\fakpropr_ora_3244.trc  (incident=72644):

ORA-00603: ORACLE server session terminated by fatal error

ORA-00600: internal error code, arguments: [kqlidchg0], [], [], [], [], [], [], [], [], [], [], []

ORA-00604: error occurred at recursive SQL level 1

ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

Clause:

There are dependent objects in an invalid state.

Solution:

Please run the following query and review the results.

SQL> SET LINESIZE 100

SQL> SELECT object_id, object_name, object_type, owner, status 

     FROM   dba_objects 

     WHERE  object_name IN (SELECT symrep 

                            FROM   plscope_identifier$ 

                            WHERE  obj# IN (SELECT obj# 

                                            FROM   plscope_identifier$ 

                                            MINUS  

                                            SELECT object_id 

                                            FROM   dba_objects));

2.  Drop the invalid objects.
3.  Purge the recyclebin to clear the dropped objects.
4.  Drop the table that was failing to drop.

TNS-12570: TNS:packet reader failure

Intermittent TNS-12570 on Application server [ID 556964.1]

OS: Windows
11gr2.

Fatal NI connect error 12570, connecting to:

 (LOCAL=NO)

  VERSION INFORMATION:

TNS for 32-bit Windows: Version 11.2.0.2.0 - Production

Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.2.0 - Production

Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.2.0 - Production

opiodr aborting process unknown ospid (6528) as a result of ORA-609

  Time: 05-OCT-2011 16:31:55

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12570

    

TNS-12570: TNS:packet reader failure

Receiving above error in the alert.log file after that searched on metalink and found following solution:
The Database server sqlnet log shows :

ns main err code: 12637
        TNS-12637: Packet receive failed
        ns secondary err code: 12547
        nt main err code: 0
        nt secondary err code: 0
        nt OS err code: 0  

Changes

Recently Installed security update MS05-019 or Windows Server 2003 Service Pack 1 on the Appliction server..

Cause

This is due to the bug in the Microsoft Windows Server 2003 SP1.
Installing security update MS05-019 or Windows Server 2003 Service Pack 1 may cause network connectivity between clients and servers to fail
For more informaiton and for the fix refer the below URL:
http://support.microsoft.com/?kbid=898060

Solution

To resolve this problem, install security update 913446 (security bulletin MS06-007). For more information about how to obtain and install security update 913446, visit the following Microsoft Web site: http://www.microsoft.com/technet/security/bulletin/MS06-007.mspx

Unable to file export data from form

Dear All,

sometime you can face the similar problem where you can't able to export data file from oracle application form.

when selecting FILE/EXPORT the data appears to export but the dialog box (to open or save) never appears.

Cause: BUG

Solution:

1. Run $FND_TOP/patch/115/sql/afupdlob.sql to drop the index.
2. Then run $FND_TOP/sql/aflobbld.sql to build the FND_LOBS table.
3. Retest for File > Export

In R12 Get APP-FND-01564 ORA-01116 ORA-01110 ORA-27041 Errors When Running Concurrent Requests

In our live server we are getting below error message:

In R12 Get APP-FND-01564 ORA-01116 ORA-01110 ORA-27041 Errors When Running Concurrent Requests

I raised SR and found the following solution:

Cause
The error would appear if the output of the lsof command is greater than the value of the ulimit.


Use the following command to check the number of open files used by applmgr:


$ lsof -u applmgr | wc -l
Compare the result to the value in ulimit:

$ ulimit -n


Solution
Modifying the Number of Open File Descriptors

Open the /etc/security/limits.conf file and change the existing values for "hard" and "soft" parameters as follows. Restart the system after making changes.


Note:
If the current value for any parameter is higher than the value listed in this document, then do not change the value of that parameter.


* hard nofile 65535
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047

Note:
* means all users listed in /etc/passwd would inherit the above values.

but no luck, after doing all above still the problem occurs...

then it is found this error occurring because of corrupted nls files (eg: lx40030.nlb)

kindly do the following step to resolve the above matter:

1.stop all applications services & DB services ,and recreate the nls 9idata directory :-

-backup and remove the corrupted $ORACLE_HOME/nls/data/9idata directory

-Re-Create $ORACLE_HOME/nls/data/9idata directory

On the database server node, as the owner of the Oracle RDBMS file system and database instance, run the $ORACLE_HOME/nls/data/old/cr9idata.pl script to create the $ORACLE_HOME/nls/data/9idata directory.

eg: How to run cr9idata.pl script

$perl cr9idata.pl {hit enter}

After creating the directory, make sure that the ORA_NLS10 environment variable is set to the full path of the 9idata directory whenever you enable the 10g Oracle home.

-The above steps must be performed after patch installation and before lauching the application server environment.

3.retest the issue.

If above changes didn't help then apply the following patch and repeat the same steps as mentioned above.

Patch 5257698

SYSADMIN Login via Discoverer Admin Fails with Invalid Username/Password (ORA-1017)

When connecting to an Oracle Applications mode EUL as the SYSADMIN user via Discoverer Administration Edition, an error is encountered:

"Error:

Unable to connect to: sysadmin:@myinstance

Failed to connect to database - Unable to connect to Oracle Applications database: invalid
username/password"

All required Applications setup steps have been completed and the DBC files have been copied from FND_TOP\Secure directory on the 11i instance to the $ORACLE_HOME\SECURE directory on the client PC.

SYSADMIN user IS able to connect via Discoverer Admin on this same PC to other instances and does
not get errors.

The EUL owner is able to connect to the production instance.
This only fails on the Production server instance and only fails for SYSADMIN (or other privileged applications user).

Cause

Incorrect instance name referenced in the local dbc file name.

The dbc file in the PC "secure" directory was named "myhost_myinstance.dbc" but the actual instance
name on the 11i machine was "myinstance_1."  Due to the instance name mismatch, the ORA-1017 invalid username/password error occurred.

Solution

To implement the solution, please execute the following steps:

1.  Logon to SQL*Plus and run following query to confirm instance and host name:

    SQL> select lower(host_name) || '_' || lower(instance_name) from v$instance;

2. Rename the existing DBC file in the $ORACLE_HOME/SECURE directory to accurately reflect the hostname_instance on this server.  This must be done on the client PC where Discoverer Administration Edition is installed.

Reference: Metalink, Oracle OTN forums

Discoverer 10g (10.1.2) Connections To Oracle E-Business Suite 12 Fails With 'Invalid Username/Password'

While connecting from Discoverer (Installed on windows machine). and Oracle application installed on linux machine getting following error message:

Discoverer 10g (10.1.2) Connections To Oracle E-Business Suite 12 Fails With 'Invalid Username/Password'

Even other application user & TOAD we are able to connect.

Reason: This is a BUG

Solution: Apply needful patch

Reference: Oracle OTN Forums

How to recover corrupted UNDO tablespace

Dear All,

Yesterday our development system went down because of CORRUPTED UNDO TABLESPACE.

the following error reported in the alert.log file

Sun Jul 31 09:27:35 2011

Flush retried for xcb 0x333b8e78, pmd 0x32898888

Doing block recovery for file 2 block 330

Block recovery from logseq 1462, block 70 to scn 42078052

Sun Jul 31 09:27:36 2011

Recovery of Online Redo Log: Thread 1 Group 3 Seq 1462 Reading mem 0

  Mem# 0 errs 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG

Block recovery completed at rba 1462.408.16, scn 0.42078054

Sun Jul 31 09:27:38 2011

Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j006_4020.trc:

ORA-00600: internal error code, arguments: [4194], [18], [24], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [18], [24], [], [], [], [], []

Sun Jul 31 09:27:41 2011

Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j006_4020.trc:

ORA-00600: internal error code, arguments: [4194], [18], [24], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [18], [24], [], [], [], [], []

Sun Jul 31 09:27:45 2011

DEBUG: Replaying xcb 0x333ad298, pmd 0x33bc9e54 for failed op 8

Doing block recovery for file 2 block 227

Sun Jul 31 09:27:45 2011

Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j006_4020.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-00600: internal error code, arguments: [4194], [18], [24], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [18], [24], [], [], [], [], []

No block recovery was needed

Sun Jul 31 09:27:49 2011

Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_948.trc:

ORA-00600: internal error code, arguments: [4194], [13], [7], [], [], [], [], []

Sun Jul 31 09:27:53 2011

Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_948.trc:

ORA-00600: internal error code, arguments: [4194], [13], [7], [], [], [], [], []

PMON: terminating instance due to error 472

Sun Jul 31 09:27:53 2011

Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j009_1608.trc:

ORA-00472: PMON  process terminated with error

Kindly use the following solution if you encountered with the exact above situation.

Step 1

--------

SQL> Startup nomount ; --> using spfile

SQL> Create pfile='/tmp/corrupt.ora' from spfile ;

SQL> Shutdown immediate;

Step 2

-------

Modify the corrupt.ora and set Undo_managment=Manual

SQL> Startup mount pfile='/tmp/corrupt.ora'

SQL> Show parameter undo

it should show manual

SQL> Alter database open ;

If it comes up

SQL> Create rollback segment r01 ;

SQL> Alter rollback segment r01 online ;

Create a new undo tablespace

SQL> Create undo tablespace undotbs_new datafile '<>' size <> M ;

Drop the Old undo tablespace

SQL> Drop tablespace including contents and datafiles

Step 3

-------

SQL> Shutdown immediate;

SQL> Startup nomount ; ---> Using spfile

SQL>Alter system set undo_tablespace= scope=spfile;

SQL> Shutdown immediate ;

SQL> Startup

Check if error is reported

Live Example:

C:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 31 10:52:25 2011

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

Connected to an idle instance.

SQL> startup nomount

ORACLE instance started.

Total System Global Area  612368384 bytes

Fixed Size                  1250428 bytes

Variable Size             100666244 bytes

Database Buffers          503316480 bytes

Redo Buffers                7135232 bytes

SQL> create pfile = 'c:\corrupt.ora' from spfile;

File created.

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup mount pfile='c:\corrupt.ora';

ORACLE instance started.

Total System Global Area  612368384 bytes

Fixed Size                  1250428 bytes

Variable Size             100666244 bytes

Database Buffers          503316480 bytes

Redo Buffers                7135232 bytes

Database mounted.

SQL> alter database open;

Database altered.

SQL> create rollback segment r01;

Rollback segment created.

SQL> alter rollback segment r01 online;

Rollback segment altered.

SQL> create undo tablespace undotbs01 datafile 'C:\oracle\product\10.2.0\oradata

\ORCL\undotbs001.dbf' size 100m;

Tablespace created.

SQL> drop tablespace undotbs1 including contents and datafiles;

Tablespace dropped.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup nomount

ORACLE instance started.

Total System Global Area  612368384 bytes

Fixed Size                  1250428 bytes

Variable Size             100666244 bytes

Database Buffers          503316480 bytes

Redo Buffers                7135232 bytes

SQL> alter system set undo_tablespace=undotbs01 scope=spfile;

System altered.

SQL> shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  612368384 bytes

Fixed Size                  1250428 bytes

Variable Size             100666244 bytes

Database Buffers          503316480 bytes

Redo Buffers                7135232 bytes

Database mounted.

Database opened.

SQL>

ANY QUERIES ASKTAJ AT ASKDBATAJ

ORA-600 [4194] "Undo Record Number Mismatch While Adding Undo Record"

My Signature Article

Today i come across with the following ORA-00600 error on our DEVELOPMENT instance.

As we all knows ORA-00600 = Oracle BUG

but lets find out more about this particular error

ERROR:              
  ORA-600 [4194] [a] [b]
 
VERSIONS:           
10.2.0.1.0

DESCRIPTION:

  A mismatch has been detected between Redo records and rollback (Undo) 
  records.

  We are validating the Undo record number relating to the change being 
  applied against the maximum undo record number recorded in the undo block.

  This error is reported when the validation fails.

ARGUMENTS:
  Arg [a] Maximum Undo record number in Undo block
  Arg [b] Undo record number from Redo block

FUNCTIONALITY:      
  Kernel Transaction Undo called from Cache layer
 
IMPACT:             
  PROCESS FAILURE
  POSSIBLE ROLLBACK SEGMENT CORRUPTION

SUGGESTIONS:

  This error may indicate a rollback segment corruption.

  This may require a recovery from a database backup depending on 
  the situation.

  If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle
  Support Services for further analysis.

I raised TAR with Oracle Support and they are working on it.

Oracle Metalink Support

ORA-27001 on Database Startup, Machines Resources are Fine

Tips:
Oracle Certification - Tips

DBA Preparation - Tips

Practical DBA - Tips

Database: 10.1.0.5.0 / Win2003Sp1 standard edition

We have total 7 gb ram on server , but PAE (physical address extention) is not enabled so i can't increase our SGA memory size more than ONE gb. when ever i try to increase i am getting "O/S Error: (OS 8) Not enough storage is available to process this command "

So I followed the below suggested solution and our db got up :)

Metalink Note:
Doc ID:
208285.1

fact: Oracle Server - Enterprise Edition
fact: MS Windows Platform
symptom: Database startup fails
symptom: ORA-27100: shared memory realm already exists
symptom: DB_BLOCK_BUFFERS parameter is not set too high for the machine resources


cause:

Operating system has a duplicate Oracle memory segment still in memory.

fix:

Stop and start the database service. If this does not help, then a re-boot of the server will flush the memory

Check this metalink note also:
Doc ID:
370469.1

How to enable PAE on windows platform

Windows 2003 service pack1 standard edition

step:

1. open boot.ini file ( location: c:\ drive (it is hidden system file)

2. add the "/PAE /3GB" lines as following format

[boot loader]timeout=30default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS[operating systems]multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /noexecute=optout /fastdetect /PAE /3GB

3. restart the windows server

4. after restarting you can see the following line in the my computer properties.

Export Failed after upgrade 11.2.0.1 to 11.2.0.2 with 'DMSYS.DBMS_DM_MODEL_EXP'

Tips:
Oracle Certification - Tips

DBA Preparation - Tips

Practical DBA - Tips

After upgraded 11.2.0.1 to 11.2.0.2 export failed with the following errors

About to export specified users ...
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 4063 encountered
ORA-04063: package body "DMSYS.DBMS_DM_MODEL_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DMSYS.DBMS_DM_MODEL_EXP"
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling DMSYS.DBMS_DM_MODEL_EXP.schema_info_exp

Cause:
unpublished Bug 9694190 "11.2.0.1 UPGRADE TO 11.2.0.2 ODM BECOMES INVALID WITH A FEW INVALID PACKAGE BODIES"

Solution:
SQL> CONNECT / AS SYSDBA;
SQL> DROP USER DMSYS CASCASE;
SQL> DELETE FROM SYS.EXPPKGACT$ WHERE SCHEMA = 'DMSYS';
SQL> SELECT COUNT(*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';

If the above SQL returns non-zero rows, create and run a SQL script as shown in the following example:

SQL> SET HEAD OFF
SQL> SPOOL /DROP_DMSYS_SYNONYMS.SQL
SQL> SELECT 'Drop public synonym ' || SYNONYM_NAME || ' ;'
FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
SQL> SPOOL OFF
SQL> @/DROP_DMSYS_SYNONYMS.SQL
SQL> EXIT;

Responding Notifications from Hotmail, Yahoo, and OWA Web Mails

Oracle Application has a wonderful features "Email Notification Approval".

As per business logic there are few process require approval from end user and if end user is travelling most of the time then that user require something email notification kind approval, so approval process will not stop and wait for their approval and that user can approve and reject through email from outside.

Responding notification works perfectly with MS-OUTLOOK but there are few other services like YAHOO/HOTMAIL which not support fully and response not generated properly.

To avoid this kind of issue Oracle provides PATCH for R12.1
Patch 8515763

for more info: check metalink note: 1179772.1

Workflow Mailer Response Time Is Slow For Email Notifications

Workflow Mailer Response Time Is Slow For Email Notifications, The Workflow Mailer is sending email notifications very slowly.

Cause:
java.io.InterruptedIOException: timeout in stream read)

it is internal bug as per oracle support.

Solution:
1. Increase the value of FRAMEWORK_URL_TIMEOUT mailer parameter using $FND_TOP/sql/afsvcpup.sql to 120 or 180 secs. By default, it should be 30 secs.

2. Bounce the Workflow Mailer component and the Apache server.

METALINK NOTE ID: 1143166.1

Bug : DATABASE CRASH AND FAILS TO OPEN WITH ORA-600 [KCRATR_NAB_LESS_THAN_ODR]

During database opening i got ORA-00600 error message on 11gr2 on windows vista.
check on metalink and found this is a BUG and solution didn't publish.




If you receive error like this then kindly submit logfiles to support for further action.

Error message:
ORA-600: internal error code, arguments: [kcratr_nab_less_than_odr],[1],[1838],[180473],[180496],[]

Upgrade db 11gr1 to 11gr2 on windows

Dear All,

I am upgrading database from 11gr1 to 11gr2 on windows 2003r2.

my database configured with DATA GUARD and i am upgrade PRIMARY DATABASE.

during the upgrade through DBUA getting error message 'ORA-16024 : LOG_ARCHIVE_DEST_1='LOCATION= XXXXX' CAN'T PARSED. AND upgrade process abort.

Actually this was happen due to bug.

Kindly find the below details.

Upgrading a 11.1.0.6 database which is part of Data Guard environment to
11.1.0.7 using dbua.

The log_archive_dest parameters are written on more than one line in the
11.1.0.6 database parameter file, for example.,

log_archive_dest_1       = "LOCATION=USE_DB_RECOVERY_FILE_DEST
                      VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)
                      DB_UNIQUE_NAME=testp"
log_archive_dest_2       = "SERVICE=p9secs ASYNC COMPRESSION=ENABLE
                      VALID_FOR=(ONLINE_LOGFILE,PRIMARY_ROLE)
                      DB_UNIQUE_NAME=tests"

While upgrading to 11.1.0.7 using DBUA, these parameters are truncated to a
single line as below

log_archive_dest_1       = "LOCATION=USE_DB_RECOVERY_FILE_DEST"
log_archive_dest_2       = "SERVICE=p9secs ASYNC COMPRESSION=ENABLE"

Since the init parameters are truncated by dbua, this has caused problems
with the rolling upgrade in the data guard environment for the customer

Bug: Bug 8225933: DBUA TRUNCATES INITIALIZATION PARAMETER(S)

ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []

One of our Production database we are getting following ORA-00600 error

OS: Windows 2003

DB: 10.2.0.4.0 (Jan-09 CPU Applied)

ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []

Solution:

There is no solution yet on metalink...

Kindly submit "Trace Files" & "Alert Log" to Oracle Support

Above Error Fixed In the 11.2 Version

Metalink Note: 756784.1

Temporary Workaround:

If

An ORA-600 can occur while recompiling stored PLSQL if a procedure / function argument name matches to a columnname referred to in that function / procedure .

Then

Change the Function/procedure's argument name so that it does not match to any column name being referred in the function/procedure body.

ORA-7445 [kwqidafc0()] Followed by ORA-25326 and ORA-01089 Errors

One of our production box I am getting the following error during shutdown.

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kwqidafc0+124] [PC:0x11BD280] [ADDR:0x4] [UNABLE_TO_READ] []ORA-25326: Array dequeue operation failed for message at index 1ORA-01089: immediate shutdown in progress - no operations are permitted

Our database is running at 10.2.0.4 with Oct'08 cpu applied. on windows 2003 platforms.

when I searched on metalink then found the following notes

#NOTE: 741999.1

It is becuase of BUG and fixed in the 10.2.0.5 patchset or 11g.

But for temporary workaround:

set the following parameter

SQL>alter system set "_first_spare_parameter"=0 scope=spfile

Restart the instance.

ORA-00600[librarycachenotemptyonclose]

Today I come across the following error message during shutdown the our production db.

ORA-00600[librarycachenotemptyonclose]

when i search on metalink i found it is due to BUG.

our database version is 10.2.0.4 on linux AS3 update 4.

Metalink Note: 466425.1

Bug ID: 4483084.8

The bug will FIXED in 11g.

Temporary workaround:

1. shutdown abort + startup + shutdown normal

2. before shutdown kill all NON-SYS session through alter system kill session ''''';

EXP-00056 + ORA-00932

The following error message i am getting during export operation in 10gr1 on windows platform after apply the cpu october 2008 patch.

EXP-00056: ORACLE error 932 encountered

ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR

When i Search on metalink i found below metalink note: 339938.1

The above problem can be fixed to run the following SQL script as SYSDBA user.

SQL> connect / as sysdba

SQL> @?/rdbms/admin/catmetx.sql

SQL> @?/rdbms/admin/utlrp.sql

ORA-16401: archivelog rejected by RFS

Yesterday I configured Data Guard on our production box after that i got below error message in primary database alertsid.log file.

Errors in file f:\ora10g_home\admin\orcl\bdump\orcl_arc0_5132.trc:
ORA-16401: archivelog rejected by RFS
FAL[server, ARC0]: Complete FAL archive (thread 1 sequence 34687 destination orcldg)

After searching on metalink and oracle forums I come up with below suggestion.

1. It is just an informational message, no more action is required.

2. If Above message appear in "physical standby" database then it is reported as a Bug 4376276 - ORA-16401 can occur on standby Doc ID: Note:4376276.8

3. If "log_archive_dest_1" & "standby_archive_dest" parameter at standby site set for same location then above error can occur in alertsid.log file so make it differ to each other.