Tuesday, May 29, 2012

ORA-12514 on +ASM , ASM & ORA-12514 , ASM tnsnames.ora

Links to this post
Environment was 3 Node RAC running on Grid Infrastructure. 11.2.0.1

I tried to connect to +ASM instances using sqlplus from same node using TNSnames but i got ORA-12514.

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 29 19:44:36 2012

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

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name: 

Both Listener is running.
RACG1@:/u00/app/11.2.0/grid/network/admin :+ASM $ps -ef | grep tns
oracle    9661     1  0 18:54 ?        00:00:00 /u00/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
oracle    9696     1  0 18:55 ?        00:00:00 /u00/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit

Below is my configuration.
RACG1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $vi listener.ora
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))             # line added by Agent
LISTENER_SCAN3=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))) # line added by Agent
LISTENER_SCAN2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                                         # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2=ON                                         # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3=ON                                         # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON                                               # line added by Agent

RACG1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $vi endpoints_listener.ora
LISTENER_RACG1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=RACG1-VIP)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.121)(PORT=1521)(IP=FIRST))))  # line added by Agent

Tnsentry.
+ASM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = RACG-SCAN)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = +ASM)
    )
  )

Here are services supported by from both listener.
RACG1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $lsnrctl services listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-MAY-2012 19:45:05

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "RACT.localdomain.com" has 1 instance(s).
  Instance "RACT1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0 state:ready
         LOCAL SERVER
Service "RACTXDB.localdomain.com" has 1 instance(s).
  Instance "RACT1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER 
         (ADDRESS=(PROTOCOL=tcp)(HOST=RACG1.localdomain.com)(PORT=54564))
The command completed successfully


RACG1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $lsnrctl services listener_scan2

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-MAY-2012 19:45:24

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
Services Summary...
Service "RACT.localdomain.com" has 3 instance(s).
  Instance "RACT1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0 state:ready
         REMOTE SERVER
         (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RACG1-VIP)(PORT=1521)))
  Instance "RACT2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0 state:ready
         REMOTE SERVER
         (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RACG2-VIP)(PORT=1521)))
  Instance "RACT3", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RACG3-VIP)(PORT=1521)))
Service "RACTXDB.localdomain.com" has 3 instance(s).
  Instance "RACT1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER 
         (ADDRESS=(PROTOCOL=tcp)(HOST=RACG1.localdomain.com)(PORT=54564))
  Instance "RACT2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER 
         (ADDRESS=(PROTOCOL=tcp)(HOST=RACG2.localdomain.com)(PORT=65286))
  Instance "RACT3", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER 
         (ADDRESS=(PROTOCOL=tcp)(HOST=RACG3.localdomain.com)(PORT=39505))
The command completed successfully

Here What we needed to do ....

RACG1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 29 19:46:21 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> show parameter remote

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_listener                      string
remote_login_passwordfile            string      EXCLUSIVE
remote_os_authent                    boolean     FALSE
remote_os_roles                      boolean     FALSE

Just add REMOTE_LISTENER pointing to SCAN ip address.

SQL> ALTER SYSTEM SET remote_listener='RACG-SCAN:1521' scope=both;

System altered.

SQL> ALTER SYSTEM REGISTER;

System altered.


As you can see how it reflected in scan listener

RACG1@:/u00/app/11.2.0/grid/network/admin :+ASM1 $lsnrctl services listener_scan2

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 29-MAY-2012 19:48:42

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
Services Summary...
Service "+ASM" has 3 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:3 refused:0 state:ready
         REMOTE SERVER
         (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RACG1-VIP)(PORT=1521)))
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RACG2-VIP)(PORT=1521)))
  Instance "+ASM3", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RACG3-VIP)(PORT=1521)))
Service "RACT.localdomain.com" has 3 instance(s).
  Instance "RACT1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0 state:ready
         REMOTE SERVER
         (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RACG1-VIP)(PORT=1521)))
  Instance "RACT2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:1 refused:0 state:ready
         REMOTE SERVER
         (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RACG2-VIP)(PORT=1521)))
  Instance "RACT3", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         REMOTE SERVER
         (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RACG3-VIP)(PORT=1521)))
Service "RACTXDB.localdomain.com" has 3 instance(s).
  Instance "RACT1", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER 
         (ADDRESS=(PROTOCOL=tcp)(HOST=RACG1.localdomain.com)(PORT=54564))
  Instance "RACT2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER 
         (ADDRESS=(PROTOCOL=tcp)(HOST=RACG2.localdomain.com)(PORT=65286))
  Instance "RACT3", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER 
         (ADDRESS=(PROTOCOL=tcp)(HOST=RACG3.localdomain.com)(PORT=39505))
The command completed successfully

Monday, May 7, 2012

Uninstall Oracle 11g on Unix/ Remove Oracle 11g Unix

Links to this post
Here is procedure to Uninstall 11g Oracle Home. earlier it used to done by OUI.

DEVL:/u00/app/oracle/product/11.2.0/db_1/deinstall :TEST$./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /tmp/deinstall2012-05-07_07-55-03-AM/logs/

############ ORACLE DEINSTALL & DECONFIG TOOL START ############


######################## CHECK OPERATION START ########################
Install check configuration START


Checking for existence of the Oracle home location /u00/app/oracle/product/11.2.0/db_1
Oracle Home type selected for de-install is: SIDB
Oracle Base selected for de-install is: /u00/app/oracle
Checking for existence of central inventory location /u00/app/oraInventory

Install check configuration END


Network Configuration check config START

Network de-configuration trace file location: /tmp/deinstall2012-05-07_07-55-03-AM/logs/netdc_check8067592795646126333.log

Specify all Single Instance listeners that are to be de-configured [LISTENER]:

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: /tmp/deinstall2012-05-07_07-55-03-AM/logs/databasedc_check8855114124755634650.log

Use comma as separator when specifying list of values as input

Specify the list of database names that are configured in this Oracle home [TEST]:

###### For Database 'TEST' ######

Single Instance Database
The diagnostic destination location of the database: /u00/app/oracle/diag/rdbms/test
Storage type used by the Database: FS
Database file location: /u01/test/data
Flash recovery area location: Does not exist
database spfile location: /u00/app/oracle/product/11.2.0/db_1/dbs/spfileTEST.ora

The details of database(s) TEST have been discovered automatically. Do you still want to modify the details of TEST database(s)? [n]: n

Database Check Configuration END

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: /tmp/deinstall2012-05-07_07-55-03-AM/logs/emcadc_check.log

Checking configuration for database TEST
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : /tmp/deinstall2012-05-07_07-55-03-AM/logs//ocm_check3012.log
Oracle Configuration Manager check END

######################### CHECK OPERATION END #########################


####################### CHECK OPERATION SUMMARY #######################
Oracle Home selected for de-install is: /u00/app/oracle/product/11.2.0/db_1
Inventory Location where the Oracle home registered is: /u00/app/oraInventory
Following Single Instance listener(s) will be de-configured: LISTENER
The following databases were selected for de-configuration : TEST
Database unique name : TEST
Storage used : FS
No Enterprise Manager configuration to be updated for any database(s)
No Enterprise Manager ASM targets to update
No Enterprise Manager listener targets to migrate
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/tmp/deinstall2012-05-07_07-55-03-AM/logs/deinstall_deconfig2012-05-07_07-56-11-AM.out'
Any error messages from this session will be written to: '/tmp/deinstall2012-05-07_07-55-03-AM/logs/deinstall_deconfig2012-05-07_07-56-11-AM.err'

######################## CLEAN OPERATION START ########################

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: /tmp/deinstall2012-05-07_07-55-03-AM/logs/emcadc_clean.log

Updating Enterprise Manager ASM targets (if any)
Updating Enterprise Manager listener targets (if any)
Enterprise Manager Configuration Assistant END
Database de-configuration trace file location: /tmp/deinstall2012-05-07_07-55-03-AM/logs/databasedc_clean1221138661467301182.log
Database Clean Configuration START TEST
This operation may take few minutes.
Database Clean Configuration END TEST

Network Configuration clean config START

Network de-configuration trace file location: /tmp/deinstall2012-05-07_07-55-03-AM/logs/netdc_clean6816269865994649600.log

De-configuring Single Instance listener(s): LISTENER

De-configuring listener: LISTENER
    Stopping listener: LISTENER
    Warning: Failed to stop listener. Listener may not be running.
    Deleting listener: LISTENER
    Listener deleted successfully.
Listener de-configured successfully.

De-configuring Listener configuration file...
Listener configuration file de-configured successfully.

De-configuring Local Net Service Names configuration file...
Local Net Service Names configuration file de-configured successfully.

De-configuring backup files...
Backup files de-configured successfully.

The network configuration has been cleaned up successfully.

Network Configuration clean config END

Oracle Configuration Manager clean START
OCM clean log file location : /tmp/deinstall2012-05-07_07-55-03-AM/logs//ocm_clean3012.log
Oracle Configuration Manager clean END
Oracle Universal Installer clean START

Detach Oracle home '/u00/app/oracle/product/11.2.0/db_1' from the central inventory on the local node : Done

Delete directory '/u00/app/oracle/product/11.2.0/db_1' on the local node : Done

Delete directory '/u00/app/oraInventory' on the local node : Done

Delete directory '/u00/app/oracle' on the local node : Done

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END


Oracle install clean START

Clean install operation removing temporary directory '/tmp/install' on node 'DEVL'

Oracle install clean END

Moved default properties file /tmp/deinstall2012-05-07_07-55-03-AM/response/deinstall_OraDb11g_home1.rsp as /tmp/deinstall2012-05-07_07-55-03-AM/response/deinstall_OraDb11g_home1.rsp0

######################### CLEAN OPERATION END #########################


####################### CLEAN OPERATION SUMMARY #######################
Successfully de-configured the following database instances : TEST
Following Single Instance listener(s) were de-configured successfully: LISTENER
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
Successfully detached Oracle home '/u00/app/oracle/product/11.2.0/db_1' from the central inventory on the local node.
Successfully deleted directory '/u00/app/oracle/product/11.2.0/db_1' on the local node.
Successfully deleted directory '/u00/app/oraInventory' on the local node.
Successfully deleted directory '/u00/app/oracle' on the local node.
Oracle Universal Installer cleanup was successful.


Run 'rm -rf /etc/oraInst.loc' as root on node(s) 'DEVL' at the end of the session.

Oracle install successfully cleaned up the temporary directories.
#######################################################################


############# ORACLE DEINSTALL & DECONFIG TOOL END #############

DEVL:/u00/app/oracle/product/11.2.0/db_1/deinstall :TEST$

Tuesday, May 1, 2012

export fails with ORA-00600 [qmtGetColumnInfo1]

Links to this post
I was taking export as below .
/testc/qual/orasw10/app/oracle/admin/testdummy6/scripts (Dummy_server) $ cat export.sh
export ORACLE_HOME=/testc/qual/orasw10/app/oracle/product/10.2.0.3
export PATH=/testc/qual/orasw10/app/oracle/product/10.2.0.3/bin:$PATH
export ORACLE_SID=testdummy6
exp userid=system/**** owner=stscorp file=/testc/qual/testdummy6/arch/stscorp.dmp consistent=y STATISTICS=None
and i have hit below error.

Export: Release 10.2.0.4.0 - Production on Tue May 1 14:20:29 2012

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user dummy_schema
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user dummy_schema
About to export dummy_schema's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitionsWarning: Entry/Exit code is optimized.  Cannot restore context (UNWIND 22)

EXP-00056: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [qmtGetColumnInfo1], [], [], [], [], [], [], []
EXP-00000: Export terminated unsuccessfully

I check that is there any cluster tables are in schema or not.
SQL> SELECT OWNER,SEGMENT_NAME,TABLESPACE_NAME FROM DBA_SEGMENTS WHERE SEGMENT_TYPE='CLUSTER';

OWNER                          SEGMENT_NAME         TABLESPACE_NAME
------------------------------ -------------------- ------------------------------
SYS                            C_USER#              SYSTEM
SYS                            C_TS#                SYSTEM
SYS                            C_OBJ#               SYSTEM
SYS                            C_FILE#_BLOCK#       SYSTEM
SYS                            C_COBJ#              SYSTEM
SYS                            C_MLOG#              SYSTEM
SYS                            C_TOID_VERSION#      SYSTEM
SYS                            C_RG#                SYSTEM
SYS                            C_OBJ#_INTCOL#       SYSTEM
SYS                            SMON_SCN_TO_TIME     SYSTEM

so i have open alert log, and found below contents.

Tue May  1 14:20:37 2012
Errors in file /testc/qual/testdummy6/admin/udump/testdummy6_ora_17082.trc:
ORA-00600: internal error code, arguments: [qmtGetColumnInfo1], [], [], [], [], [], [], []

Below is call stack from trace file.

/testc/qual/testdummy6/admin/udump/testdummy6_ora_17082.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application testing options
ORACLE_HOME = /testc/qual/orasw10/app/oracle/product/10.2.0.4_2
System name:    HP-UX
Node name:      Dummy_server
Release:        B.11.11
Version:        U
Machine:        9000/800
Instance name: testdummy6
Redo thread mounted by this instance: 1
Oracle process number: 25
Unix process pid: 17082, image: oracle@Dummy_server (TNS V1-V3)

*** ACTION NAME:() 2012-05-01 14:20:37.159
*** MODULE NAME:(exp@Dummy_server (TNS V1-V3)) 2012-05-01 14:20:37.159
*** SERVICE NAME:(SYS$USERS) 2012-05-01 14:20:37.159
*** SESSION ID:(142.3367) 2012-05-01 14:20:37.159
*** 2012-05-01 14:20:37.159
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qmtGetColumnInfo1], [], [], [], [], [], [], []
No current SQL statement being executed.
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+40          ?        ksedst1()            4000000001ADAB5B ?
                                                   000000000 ?
                                                   800003F9FFFFF1B8 ?
                                                   800003FFC0012ED8 ?
ksedmp()+424         ?        ksedst()             800003F9FFFFF1B8 ?
                                                   800003FFC0012ED8 ?
                                                   800003FFC0014400 ?
                                                   1000000010 ?
ksfdmp()+32          ?        ksedmp()             800003FFC0012980 ?
                                                   4000000001B35633 ?
                                                   000000006 ? 000000000 ?
kgerinv()+152        ?        ksfdmp()             000000006 ? 000000000 ?
                                                   C00000007FFFFFFF ?
                                                   4020000000000000 ?
kgeasnmierr()+88     ?        kgerinv()            000000000 ?
                                                   8000000100147A00 ?
                                                   000000458 ?
                                                   8000000000000001 ?
qmtkGetColumnInfo()  ?        kgeasnmierr()        4000000080 ? 00000000C ?
+140                                               C000000134155608 ?
                                                   C000000134B371B4 ?
koksxmlticm()+3908   ?        qmtkGetColumnInfo()  800003F7C006A9F0 ?
                                                   C000000134156DA0 ?
                                                   000000000 ?
                                                   8000000100013468 ?
koksicm()+1120       ?        koksxmlticm()        C000000134156848 ?
                                                   5101002000 ? 000000000 ?
                                                   000000001 ?
kokaccx()+1304       ?        koksicm()            000000001 ?
                                                   800003FFC000D560 ?
                                                   C00000013FF6F8B0 ?
                                                   1000000000000000 ?
kokacmc()+64         ?        kokaccx()            C000000134B37228 ?
                                                   4000000001BD19B3 ?
                                                   00005E8A8 ?
                                                   800003FFC0010E88 ?

I have put this call stack into Metalink Note

ORA-600/ORA-7445 Error Look-up Tool [ID 153788.1]

Which suggest me to export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH.

but no luck again.So I check dba_registry and found that Oracle XML Database is invalid in XDB schema.

COMP_NAME                                     SCHEMA               STATUS      VERSION
--------------------------------------------- -------------------- ----------- ------------------------------
Oracle Enterprise Manager                     SYSMAN               VALID       10.2.0.4.0
Spatial                                       MDSYS                VALID       10.2.0.4.0
Oracle interMedia                             ORDSYS               VALID       10.2.0.4.0
OLAP Catalog                                  OLAPSYS              VALID       10.2.0.4.0
Oracle XML Database                           XDB                  INVALID     10.2.0.4.0
Oracle Text                                   CTXSYS               VALID       10.2.0.4.0
Oracle Expression Filter                      EXFSYS               VALID       10.2.0.4.0
Oracle Rule Manager                           EXFSYS               VALID       10.2.0.4.0
Oracle Workspace Manager                      WMSYS                VALID       10.2.0.4.3
Oracle Data Mining                            DMSYS                VALID       10.2.0.4.0
Oracle Database Catalog Views                 SYS                  VALID       10.2.0.4.0
Oracle Database Packages and Types            SYS                  VALID       10.2.0.4.0
JServer JAVA Virtual Machine                  SYS                  VALID       10.2.0.4.0
Oracle XDK                                    SYS                  VALID       10.2.0.4.0
Oracle Database Java Packages                 SYS                  VALID       10.2.0.4.0
OLAP Analytic Workspace                       SYS                  VALID       10.2.0.4.0
Oracle OLAP API                               SYS                  VALID       10.2.0.4.0

This time i have search Metalink again found something similar.

Datapump Export expdp Fails With ORA-600 [unable to load XDB library] [ID 736049.1]

where solution was given as below.

As the SYSDBA user, please run the following scripts :-

SQL>@/rdbms/admin/catmeta.sql
SQL>@/rdbms/admin/catmet2.sql
SQL>@/rdbms/admin/utlrp.sql

I executed above scripts and tried again this time i got below error.

Export: Release 10.2.0.4.0 - Production on Tue May 1 14:50:44 2012

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


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user dummy_schema
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user dummy_schema
About to export dummy_schema's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected BLOB, CLOB got CHAR
EXP-00000: Export terminated unsuccessfully

Since it was 10.2.0.4 ,I tried to run export using Datapump. It went through.

Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 4.590 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/AUDIT_OBJ
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS