月度存档: 三月 2010

ORA-39213: Metadata processing is not available

I was asked to refresh database from prod to AT env, and Before the refreshment, I want to take a full export for the AT database with data pump, unfortunitly, I got following error,

———————————–

With the OLAP, Data Mining and Real Application Testing options
orA-39006: internal error
orA-39213: Metadata processing is not available
———————————–

and Finially I find the reason ,

The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly.

Solution:
conn / as sysdba
execute dbms_metadata_util.load_stylesheets ;
exit

test the expdp again.

Oracle Character set and National Character Set

##CHARACTER SET
specifies the character set the database uses to store data. You cannot change the database character set after creating the database. The supported character sets and default value of this parameter depend on your operating system.

You can specify any supported character set except the following fixed-width, multibyte character sets, which can be used only as the national character set:  

JA16SJISFIXED  
JA16EUCFIXED  
JA16DBCSFIXED  

parameter is NLS_CHARACTERSET.

## NATIONAL CHARACTER SET
specifies the national character set used to store data in columns specifically defined as NCHAR, NCLOB, or NVARCHAR2. You cannot change the national character set after creating the database. If not specified, the national character set defaults to the database character set. See oracle8 Reference for valid character set names.
parameter is NLS_NCHAR_CHARACTERSET in database

you can use following query to check the value of the value of bath parameters,

col parameter format a25
col value format a20
Select *
  FROM nls_database_parameters
Where parameter like ‘%NLS%’
/

solution for orA-39080

Get following error when trying to export full database with expdp,

———————————————–
Export: Release 10.2.0.4.0 – 64bit Production on Wednesday, 03 March, 2010 4:34:
13

Copyright (c) 2003, 2007, oracle.  All rights reserved.

Connected to: oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit
Production
With the OLAP, Data Mining and Real Application Testing options
orA-31626: job does not exist
orA-31637: cannot create job SYS_EXPORT_FULL_01 for user SYS
orA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
orA-06512: at “SYS.KUPV$FT_INT”, line 600
orA-39080: failed to create queues “KUPC$C_1_20100303043415” and “” for Data Pum
p job
orA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
orA-06512: at “SYS.KUPC$QUE_INT”, line 1606
orA-24203: operation failed, queue table SYS.KUPC$DATAPUMP_QUETAB has errors
———————————————–

and I applied oracle 2010 Jan CPU patches to the database recently. so that might be the reason.

Here is my solution,
继续阅读 »

error code 74 when applying oracle CPU patches

I was asked to apply oracle 2010 Jan CPU patches to one important database server, and I wasn’t worry at all since I applied several servers days before. But today, I got error , see error message below,

————————————-

ApplySession failed during prerequisite checks: Prerequisite check “CheckActiveF
ilesAndExecutables” failed.
System intact, OPatch will not attempt to restore the system
——————————————————————————–

The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 9169460 is a superset of the patch(es) [  8307238 ] in OH D:\Oracle\ora1020
——————————————————————————–

OPatch failed with error code = 74

Execution of ‘cmd /C “D:\dowinst\2010Jan_CPU\9169460\custom\scripts\post.bat” -a
pply 9169460 ‘:

Return Code = 0

The local system has been patched and can be restarted.

——————————————————————————–

继续阅读 »