11g Cluster Architecture

1-Cluster Architecture:

The oracle cluster-ware is started by OS init daemon as shown below:

During the installation of Oracle Clusterware, the init.ohasd startup script is copied to /etc/init.d. This script is responsible for setting up environment variables and then starting the Oracle Clusterware daemons and processes.

The Oracle High Availability Services daemon (ohasd) is responsible for starting in proper order, monitoring, and restarting other local Oracle daemons, up through the crsd daemon,which manages clusterwide resources. When init starts ohasd on Clusterware startup,ohasd starts orarootagent, cssdagent, and oraagent. These processes then carry out the following tasks:

• orarootagent starts crsd.

- crsd starts another orarootagent process responsible for root-owned CRS

resources including the SCAN VIPS.

• cssdagent starts cssd (ocssd).

• oraagent starts mdnsd, evmd, ASM, ctssd, and gpnpd. oraagent also starts

gsd, Oracle Notification Service (ONS), and the listeners.

Some of the high availability daemons will be running under the root user with real-time

priority, and others will be running under the Clusterware owner with user-mode priorities

after they are started. When a command is used to stop Oracle Clusterware, the daemons will

be stopped, but the ohasd process will remain running.

2-Cluster Processes:

Oracle Clusterware comprises several processes that facilitate cluster operations. The Cluster

Ready Service (CRS), Cluster Synchronization Service (CSS), Event Management (EVM),

and Oracle Notification Service (ONS) components communicate with other cluster

component layers in the same cluster database environment. These components are also the

main communication links between Oracle Database, applications, and the Oracle Clusterware

high availability components. In addition, these background processes monitor and manage

database operations. The following list describes some major Oracle Clusterware background

processes. The list includes components that are processes on Linux and UNIX, or services on

Windows.

• Cluster Ready Service (CRS): Is the primary program for managing high availability

operations in a cluster. The CRS process manages two types of CRS resources:

- Cluster resources: A cluster resource is an Oracle Clusterware resource. Cluster

resources are viewed, added, modified, or removed using the crsctl command.

- Local resources: A local resource runs on every node in the cluster (no failover)

and can be, for example, a listener, ASM, a disk group, or Oracle Notification

Service (ONS).

• The CRS daemon (crsd) manages cluster resources based on configuration information

that is stored in Oracle Cluster Registry (OCR) for each resource. This includes start,

stop, monitor, and failover operations. The crsd process generates events when the

status of a resource changes.

When you have Oracle RAC installed, the crsd process monitors the Oracle database

instance, listener, and so on, and automatically restarts these components when a failure

occurs. When a CRS resource fails, the CRS daemon attempts to restart it, if the resource

is so configured. CRS fails the resource over to another node (again, if it is configured to

do so) after exhausting restart attempts.

• Cluster Synchronization Service (CSS): Manages the cluster configuration by

controlling which nodes are members of the cluster and by notifying members when a

node joins or leaves the cluster. If you are using certified third-party clusterware, then

CSS processes interfaces with your clusterware to manage node membership

information. CSS has three separate processes: the CSS daemon (ocssd), the CSS

Agent (cssdagent), and the CSS Monitor (cssdmonitor). The cssdagent

process monitors the cluster and provides input/output fencing. This service formerly

was provided by Oracle Process Monitor daemon (oprocd), also known as

OraFenceService on Windows. A cssdagent failure results in Oracle Clusterware

restarting the node.

• Disk Monitor daemon (diskmon): Monitors and performs input/output fencing for

Oracle Exadata Storage Server. As Exadata storage can be added to any Oracle RAC

node at any point in time, the diskmon daemon is always started when ocssd is

started.

• Event Manager (EVM): Is a background process that publishes Oracle Clusterware

events

• Multicast domain name service (mDNS): Allows DNS requests. The mDNS process is

a background process on Linux and UNIX, and a service on Windows.

• Oracle Grid Naming Service (GNS): Is a gateway between the cluster mDNS and

external DNS servers. The GNS process performs name resolution within the cluster.

• Oracle Notification Service (ONS): Is a publish-and-subscribe service for

communicating Fast Application Notification (FAN) events

• oraagent: Extends clusterware to support Oracle-specific requirements and complex

resources. It runs server callout scripts when FAN events occur. This process was known

as RACG in Oracle Clusterware 11g Release 1 (11.1).

• Oracle root agent (orarootagent): Is a specialized oraagent process that helps

CRSD manage resources owned by root, such as the network, and the Grid virtual IP

address

• Cluster kill daemon (oclskd): Handles instance/node evictions requests that have

been escalated to CSS

• Grid IPC daemon (gipcd): Is a helper daemon for the communications infrastructure

Component	Processes	Owner
Cluster Ready Service (CRS)	crsd	Root
Cluster Synchronization Service (CSS)	ocssd,cssdmonitor, cssdagent	grid owner,root,root
Event Manager (EVM)	evmd, evmlogger	grid owner
Cluster Time Synchronization Service (CTSS)	octssd	root
Oracle Notification Service (ONS)	ons, eons	grid owner
Oracle Agent	oraagent	grid owner
Oracle Root Agent	orarootagent	root
Grid Naming Service (GNS)	gnsd	root
Grid Plug and Play (GPnP)	gpnpd	grid owner
Multicast domain name service (mDNS)	mdnsd	grid owner

Monitoring Rman

In this section i want to discuss how to monitor the RMAN sessions:

Query V$SESSION and V$PROCESS to identify the relationship between server sessions and RMAN

channels.

 COLUMN CLIENT_INFO FORMAT a30
 COLUMN SID FORMAT 999
 COLUMN SPID FORMAT 9999
 SELECT s.sid, p.spid, s.client_info,s.event
 FROM v$process p, v$session s
 WHERE p.addr = s.paddr
 AND CLIENT_INFO LIKE 'rman%';

We can Monitor the progress of backup and restore operations by querying V$SESSION_LONGOPS as shown below:

SQL> SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
 ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE"
 FROM V$SESSION_LONGOPS
 WHERE OPNAME LIKE 'RMAN%'
 AND OPNAME NOT LIKE '%aggregate%'
 AND TOTALWORK != 0
 AND SOFAR <> TOTALWORK;
SID SERIAL# CONTEXT SOFAR TOTALWORK %_COMPLETE
--- ------- ------- ------- --------- ----------
20  90       1      9470     15360   61.65
39  100      1      15871    28160   56.36

I wish those sample examples help you out.

Regards
Mohamed ELAzab

Using data Pump to export and import in case of characterset conversion and in case of no characterset conversion

I want to share 2 cases where we want to export and import into the same character set and export and import into different character set.

NO Character set Conversion:

We export the data from production as follows:
1-Create a parfile and name it ADAPTER.PAR

=================================
Contents of the file:
=================================
schemas=ADAPTER
dumpfile=ADAPTER-20-9-2012.dmp
directory=DPUMP_DIR3
logfile=USG-20-09-12.log
FLASHBACK_SCN=7890710186518

================================

Then export  from the database as follows:
C:\expdp mazab@CCDB parfile='ADAPTER.PAR'

transfer the file using scp command:

scp /filepath/ADAPTER-20-09-2012.dmp oracle@Your_IP:/data/DB/TIMDB/DPUMP
=======================================================
=======================================================
Then import the dump as follows:
========================================================
login to TIMDB:
export ORACLE_SID=TIMDB

impdp directory=TIM_DATA_PUMP dumpfile=ADAPTER-9-5-2011.dmp logfile=ADAPTER-9-5-2011.log schemas=adapter REMAP_SCHEMA=adapter:adapters_ea4 remap_tablespace=ADAPTER:TIM_EA3

Please consider the tablespaces on production and remap them in testing.

 Characterset Conversion:


We export the data from production as follows:
1-Create a parfile and name it SUB.PAR
2-Get scn from the production database to avoid parent child constraints error when importing into TIMDB.
=================================
Contents of the file:
=================================
schemas=SUB
dumpfile=SUB-20-09-2012.dmp
directory=DPUMP_DIR3
logfile=SUB20-09-12.log
QUERY =SUB.SMS_ARCHIVE:"where 1=2"
QUERY =SUB.REQUEST_PARAMETER_ARCHIVE:"where 1=2"
QUERY =SUB.REQUEST_ARCHIVE:"where 1=2"
QUERY =SUB.MOBILE_TRADER_STG:"where 1=2"
QUERY =SUB.TRANSACTION:"where 1=2"
QUERY =SUB.TRANSACTION_PARAMETERS:"where 1=2"
QUERY =SUB.Transaction_Archive:"where 1=2"
QUERY =SUB.Request:"where 1=2"
QUERY =SUB.SMS:"where 1=2"
QUERY =SUB.Transaction_Parameters_Archive:"where 1=2"
QUERY =Mobile_trader:"where 1=2"
FLASHBACK_SCN=7882306652406

================================

Then export  from the database as follows:
C:\expdp mazab@RSDSDB parfile='SUB.PAR'

transfer the file using scp command:

scp /filepath/SUB-20-09-2012.dmp oracle@Your_IP:/data/DB/TIMDB/DPUMP
=======================================================
=======================================================
Then import the dump as follows:
========================================================
login to TIMDB:
export ORACLE_SID=TIMDB

impdp directory=TIM_DATA_PUMP dumpfile=SUB-20-09-2012.dmp logfile=SUB-20-09-2012.log schemas=sub REMAP_SCHEMA=sub:SUB_EA4 remap_tablespace=sub_idx:TIM_EA3,sub:TIM_EA3 content=metadata_only exclude=index exclude=constraint exclude=statistics exclude=trigger exclude=grant
==============================================
==============================================
SQL> drop table semantics$;
SQL>create table semantics$(s_owner varchar2(40),
                       s_table_name varchar2(40),
                       s_column_name varchar2(40),
                       s_data_type varchar2(40),
                       s_char_length number)
===================================================
@insert.sql
@cursor.sql
drop table semantics$;
==================================================
impdp directory=TIM_DATA_PUMP dumpfile=SUB-20-09-2012.dmp logfile=SUB-20-09-2012.log schemas=sub REMAP_SCHEMA=SUB:sub_EA4 remap_tablespace=sub_idx:TIM_EA3,sub:TIM_EA3 content=data_only
=====================================================
impdp directory=TIM_DATA_PUMP dumpfile=SUB-SUB-20-09-2012.dmp logfile=SUB-20-09-2012.log schemas=sub REMAP_SCHEMA=SUB:sub_EA4 remap_tablespace=sub_idx:TIM_EA3,sub:TIM_EA3 content=metadata_only include=index include=constraint include=statistics include=trigger transform=storage:n
============================================
Contents of the cursors:
==========
@insert.sql
============
insert into semantics$
  select C.owner, C.table_name, C.column_name, C.data_type, C.char_length
    from all_tab_columns C, all_tables T
  where C.owner = T.owner
    and T.owner = upper('&&schema')
    and C.table_name = T.table_name
    and C.char_used = 'B'
-- only need to look for tables who are not yet CHAR semantics.
--  and T.partitioned != 'YES'
-- exclude partitioned tables  (removed condition!)
    and C.table_name not in (select table_name from all_external_tables where owner = upper('&&schema'))
    and C.data_type in ('VARCHAR2', 'CHAR')
  -- You can exclude or include tables or schemas as you wish, by adjusting
  -- "and T.owner not in" as per your requirements
/
===========
@cursor.sql
===========
declare
  cursor c1 is select * from semantics$;
  v_statement varchar2(255);
  v_nc number(10);
  v_nt number(10);
begin
  execute immediate
    'select count(*) from semantics$' into v_nc;
  execute immediate
    'select count(distinct s_table_name) from semantics$' into v_nt;
  dbms_output.put_line
    ('ALTERing ' || v_nc || ' columns in ' || v_nt || ' tables');
  for r1 in c1 loop
    v_statement := 'ALTER TABLE ' || r1.s_owner || '.' || r1.s_table_name;
    v_statement := v_statement || ' modify (' || r1.s_column_name || ' ';
    v_statement := v_statement || r1.s_data_type || '(' || r1.s_char_length;
    v_statement := v_statement || ' CHAR))';
    --dbms_output.put_line(v_statement);
    execute immediate v_statement;
  end loop;
  dbms_output.put_line('Done');
end;
/
=========================================
Please consider the tablespaces on production and remap them in testing.

Migration from character set AR8ISO8859P6 to AL32UTF8 using csscan and csalter

This topic should cover a simple example for migrating data from  AR8ISO8859P6 to AL32UTF8 using data pump.

The steps involved in character set conversion are listed below.

• Export data
• CLUSTER_DATABASE=FALSE (*RAC Only*)
• SHUTDOWN IMMEDIATE
• STARTUP
• CSSCAN
• SHUTDOWN IMMEDIATE
• STARTUP RESTRICT
• CSALTER
• CLUSTER_DATABASE=TRUE (*RAC Only*)
• SHUTDOWN IMMEDIATE
• STARTUP
• Import data

[oracle@radbstage1 oracleup3]$ csscan FULL=Y FROMCHAR=AR8ISO8859P6 TOCHAR=AL32UTF8 ARRAY=1024000 LOG=charcheck CAPTURE=Y PROCESS=4





Character Set Scanner v2.2 : Release 11.2.0.3.0 - Production on Wed Sep 5 12:07:14 2012



Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.





Username: sys/password as sysdba



Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options



Enumerating tables to scan...



. process 1 scanning SYSTEM.AUD$[AAAOQsAABAAAOZYAAA]

. process 2 scanning SYS.SOURCE$[AAAADgAABAAAAXgAAA]]

...................

. process 1 scanning SYSMAN.MGMT_TYPE_PROPERTIES[AAAOg9AACAAAF5wAAA]Message 9999 not found;  product=CSMIG; facility=CSS



. process 3 scanning SYSMAN.MGMT_ARU_OUI_COMPONENTS[AAAOljAACAAAGBIAAA]

. ..................

. process 1 scanning SYS.DUAL[AAAAB0AABAAAAOgAAA]Message 9999 not found;  product=CSMIG; facility=CSS



. process 4 scanning SYS.TRIGGERJAVAC$[AAAACoAABAAAAU4AAA]]

. ....................................

. process 4 scanning SYSMAN.MGMT_TASK_QTABLE[AAAOYKAACAAAFY4AAA]Message 9999 not found;  product=CSMIG; facility=CSS



. process 2 scanning SYSMAN.MGMT_CATEGORIES[AAAOg2AACAAAF64AAA]A]

......................................

. process 2 scanning EXFSYS.RLM$VALIDPRIVS



Creating Database Scan Summary Report...



Creating Individual Exception Report...



Scanner terminated successfully.

The CSSCAN generate 3 files charcheck.txt, charcheck.err and charcheck.out.

Checking the contents of the charcheck.txt showed that the Application user data has some data inside tables that needs conversion.

You must backup those data first then drop those tables.I my case i exported the schemas then droped the schemas containing those data.

;;; 
Export: Release 11.2.0.3.0 - Production on Wed Sep 5 10:01:57 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  /******** AS SYSDBA directory=DATA_PUMP_DIR dumpfile=schemas-backup-5-9-2012.dmp logfile=schemas-backup-5-9-2012.log schemas=APPADMTST,RFETECMUCADM,RFETECMUCAPP,RFETEPRTADM,RFETEPRTAPP,RFETEUCADM,RFETEUCAPP,RFETEUCDAT,RTETECMUCADM,RTETECMUCAPP,RTETEPRTADM,RTETEPRTAPP,RTETEUCADM,RTETEUCAPP,RTETEUCDAT 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3.327 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/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/DB_LINK
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/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_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/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
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
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
. . exported "RTETEUCADM"."SCH_T_FILE_PART"              149.8 MB  604267 rows
. . exported "RTETEUCADM"."IM_L_TRANSACTION_BLOCK"       124.2 MB 1599134 rows
............................................
. . exported "RTETEUCDAT"."ROAM_TAP_AGG":"DEF"               0 KB       0 rows
. . exported "RTETEUCDAT"."SUBS_BSCS":"DEF"                  0 KB       0 rows
. . exported "RTETEUCDAT"."SUBS_BSCS_AGG":"DEF"              0 KB       0 rows
. . exported "RTETEUCDAT"."TAP_OUT_IOT"                      0 KB       0 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
  /oracle/oracle11/product/11.2.0/dbhome_1/rdbms/log/schemas-backup-5-9-2012.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:05:00

The contents of the data dictionary showed that some data dictionary needs to be converted :

Data Dictionary Tables:

Datatype                    Changeless      Convertible       Truncation            Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2                    18,427,017              412                0                0
CHAR                            16,903                0                0                0
LONG                           204,199                0                0                0
CLOB                         1,336,770           31,521                0                0
VARRAY                          20,577                0                0                0
--------------------- ---------------- ---------------- ---------------- ----------------
Total                       20,005,466           31,933                0                0
Total in percentage             99.841%           0.159%           0.000%           0.000%

As you can see the re 412 VARCHAR2 are convertible and regarding the 31,521 CLOB.The "Convertible"  CLOB in   Data Dictionary  will be handled by Csalter.

No manual action is required on CLOB "Convertible"   because CSALTER will handle it.

Now we should drop the schemas containing the data under User / Application Data that need action before using Csalte or the csalter will not work.

After backing data/database and dropping this data you can check if you have done your job well by running the below query:

conn / AS sysdba
SELECT DISTINCT z.owner_name
|| '.'
|| z.table_name
|| '('
|| z.column_name
|| ') - '
|| z.column_type
|| ' - '
|| z.error_type
|| ' ' UserColumns
FROM csmig.csmv$errors z
WHERE z.owner_name NOT IN
(SELECT DISTINCT username FROM csmig.csm$dictusers
)
ORDER BY UserColumns
/

to check the data dictionary tables that need manual interaction when using csalter that generated the 412 varchar2 above use this query:

conn / AS sysdba
SELECT DISTINCT z.owner_name
|| '.'
|| z.table_name
|| '('
|| z.column_name
|| ') - '
|| z.column_type
|| ' - '
|| z.error_type
|| ' ' NotHandledDataDictColumns
FROM csmig.csmv$errors z
WHERE z.owner_name IN
(SELECT DISTINCT username FROM csmig.csm$dictusers
) minus
SELECT DISTINCT z.owner_name
|| '.'
|| z.table_name
|| '('
|| z.column_name
|| ') - '
|| z.column_type
|| ' - '
|| z.error_type
|| ' ' DataDictConvCLob
FROM csmig.csmv$errors z
WHERE z.error_type ='CONVERTIBLE'
AND z.column_type = 'CLOB'
AND z.owner_name IN
(SELECT DISTINCT username FROM csmig.csm$dictusers
)
ORDER BY NotHandledDataDictColumns
/

In my case it showed that the error in table  SYS.WRI$_*  and Typically this is seen in SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.

Refering to note:

Solving Convertible or Lossy data in Data Dictionary objects when changing the NLS_CHARACTERSET [ID 258904.1]

This is being solved by applying the below steps:

To clear EPVALUE of SYS.WRI$_OPTSTAT_HISTGRM_HISTORY execute:

Do not update or truncate SYS.WRI$_OPTSTAT_HISTGRM_HISTORY itself

Conn / as sysdba
-- check the current retention of stats
-- the default value is 31
select systimestamp - dbms_stats.get_stats_history_availability from dual;
-- now disable stats retention
exec dbms_stats.alter_stats_history_retention(0);
-- remove all stats

DECLARE
ts  TIMESTAMP WITH TIME ZONE;
BEGIN
SELECT SYSTIMESTAMP INTO ts FROM dual;
dbms_stats.purge_stats(ts);
END;

-- check there are no more left

select count(*) from SYS.WRI$_OPTSTAT_HISTGRM_HISTORY;

-- this will clear SYS.WRI$_OPTSTAT_HISTGRM_HISTORY(EPVALUE )

-- now run the csscan again to see the new fixes we did and then run csalter.
exec dbms_stats.alter_stats_history_retention(31);

Running the csscan showed that no data dictionary tables need conversion and the csalter successfully worked :

The content of charcheck.txt after running csscan and csalter:

[Data Dictionary Conversion Summary]

Data Dictionary Tables:

Datatype                    Changeless      Convertible       Truncation            Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2                    16,275,600                0                0                0
CHAR                            16,860                0                0                0
LONG                           204,199                0                0                0
CLOB                         1,243,848           31,585                0                0
VARRAY                          20,577                0                0                0
--------------------- ---------------- ---------------- ---------------- ----------------
Total                       17,761,084           31,585                0                0
Total in percentage             99.822%           0.178%           0.000%           0.000%

The data dictionary can be safely migrated using the CSALTER script

[Application Data Conversion Summary]

Datatype                    Changeless      Convertible       Truncation            Lossy
--------------------- ---------------- ---------------- ---------------- ----------------
VARCHAR2                             0                0                0                0
CHAR                                 0                0                0                0
LONG                                 0                0                0                0
CLOB                                 0                0                0                0
VARRAY                               0                0                0                0
--------------------- ---------------- ---------------- ---------------- ----------------
Total                                0                0                0                0
Total in percentage              0.000%           0.000%           0.000%           0.000%

Running CSALTER script:

[oracle@radbstage1 oracleup3]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 5 12:09:24 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> @?/rdbms/admin/csalter.plb

0 rows created.


Function created.


Function created.


Procedure created.

This script will update the content of the Oracle Data Dictionary.
Please ensure you have a full backup before initiating this procedure.
Would you like to proceed (Y/N)?y
old   6:     if (UPPER('&conf') <> 'Y') then
new   6:     if (UPPER('y') <> 'Y') then
Checking data validity...
begin converting system objects
1 row in table SYS.RULE$ is converted
2778 rows in table SYS.SCHEDULER$_EVENT_LOG are converted
2555 rows in table SYS.WRH$_SQLTEXT are converted
1788 rows in table SYSMAN.MGMT_IP_REPORT_ELEM_PARAMS are converted
20551 rows in table SYS.WRI$_ADV_SQLT_PLANS are converted
27 rows in table SYS.WRI$_REPT_FILES are converted
21 rows in table SYS.WRI$_DBU_HWM_METADATA are converted
10072 rows in table SYS.WRI$_ADV_RATIONALE are converted
130 rows in table SYSMAN.MGMT_IP_ELEM_DEFAULT_PARAMS are converted
5591 rows in table SYS.WRI$_ADV_OBJECTS are converted
31 rows in table SYSMAN.MGMT_IP_SQL_STATEMENTS are converted
3326 rows in table SYS.WRI$_ADV_ACTIONS are converted
171 rows in table SYS.WRI$_DBU_FEATURE_METADATA are converted
179 rows in table SYS.METASTYLESHEET are converted
5 rows in table SYS.WRI$_ADV_DIRECTIVE_META are converted
5301 rows in table SYS.WRI$_ADV_SQLT_PLAN_STATS are converted
64548 rows in table SYS.WRH$_SQL_PLAN are converted
164 rows in table SYS.WRI$_DBU_FEATURE_USAGE are converted

PL/SQL procedure successfully completed.

Alter the database character set...
CSALTER operation completed, please restart database

PL/SQL procedure successfully completed.


0 rows deleted.


Function dropped.


Function dropped.


Procedure dropped.

Restart the database and import data back :

;;; 
Import: Release 11.2.0.3.0 - Production on Wed Sep 5 13:01:12 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Master table "SYS"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_SCHEMA_01":  /******** AS SYSDBA directory=DATA_PUMP_DIR dumpfile=schemas-backup-5-9-2012.dmp logfile=schemas-backup-import-5-9-2012.log schemas=APPADMTST,RFETECMUCADM,RFETECMUCAPP,RFETEPRTADM,RFETEPRTAPP,RFETEUCADM,RFETEUCAPP,RFETEUCDAT,RTETECMUCADM,RTETECMUCAPP,RTETEPRTADM,RTETEPRTAPP,RTETEUCADM,RTETEUCAPP,RTETEUCDAT 
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/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/DB_LINK
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/TABLE_DATA
. . imported "RTETEUCADM"."SCH_T_FILE_PART"              149.8 MB  604267 rows
...........................................
. . imported "RTETEUCDAT"."SUBS_BSCS_AGG":"DEF"              0 KB       0 rows
. . imported "RTETEUCDAT"."TAP_OUT_IOT"                      0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_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/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
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
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
Job "SYS"."SYS_IMPORT_SCHEMA_01" completed  at 13:07:53

End of the steps.Hope this helps.

Mohamed ELAzab