OCFS2 mount notice

if you preprare the rac environment with OCFS2 storage,be ware of the mount option, otherwise you will meet the error information as below when execute the "root.sh":

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

PROT-1: Failed to initialize ocrconfig
Failed to upgrade Oracle Cluster Registry configuration

———————————————————————————————————————

there are error msg in ocr logs which indicate the wrong FS mount option as below:

———————————————————————————————————————

 

2012-09-24 16:55:56.298: [ OCRCONF][2538053312]ocrconfig starts…
2012-09-24 16:55:56.302: [ OCRCONF][2538053312]Upgrading OCR data
2012-09-24 16:55:56.304: [  OCROSD][2538053312]utstoragetype: /ocfs/share_config/ocr is on FS type 1952539
503. Not supported.
2012-09-24 16:55:56.304: [  OCROSD][2538053312]utopen:6'': OCR location /ocfs/share_config/ocr configured
is not valid storage type. Return code [37].
2012-09-24 16:55:56.304: [  OCRRAW][2538053312]proprinit: Could not open raw device
2012-09-24 16:55:56.305: [ default][2538053312]a_init:7!: Backend init unsuccessful : [37]
2012-09-24 16:55:56.305: [ OCRCONF][2538053312]Exporting OCR data to [OCRUPGRADEFILE]
2012-09-24 16:55:56.305: [  OCRAPI][2538053312]a_init:7!: Backend init unsuccessful : [33]
2012-09-24 16:55:56.306: [ OCRCONF][2538053312]There was no previous version of OCR. error:[PROC-33: Oracl
e Cluster Registry is not configured]
2012-09-24 16:55:56.306: [  OCROSD][2538053312]utstoragetype: /ocfs/share_config/ocr is on FS type 1952539
503. Not supported.
2012-09-24 16:55:56.306: [  OCROSD][2538053312]utopen:6'': OCR location /ocfs/share_config/ocr configured
is not valid storage type. Return code [37].
2012-09-24 16:55:56.306: [  OCRRAW][2538053312]proprinit: Could not open raw device
2012-09-24 16:55:56.306: [ default][2538053312]a_init:7!: Backend init unsuccessful : [37]
2012-09-24 16:55:56.306: [  OCROSD][2538053312]utstoragetype: /ocfs/share_config/ocr is on FS type 1952539
503. Not supported.
2012-09-24 16:55:56.306: [  OCROSD][2538053312]utopen:6'': OCR location /ocfs/share_config/ocr configured
is not valid storage type. Return code [37].
2012-09-24 16:55:56.307: [  OCRRAW][2538053312]proprinit: Could not open raw device
2012-09-24 16:55:56.307: [  OCRAPI][2538053312]a_init:6b!: Backend init unsuccessful : [37]
2012-09-24 16:55:56.307: [ OCRCONF][2538053312]Failed to initialized OCR context. error:[PROC-37: Oracle Cluster Registry does not support the storage type co
nfigured]
2012-09-24 16:55:56.307: [ OCRCONF][2538053312]Exiting [status=failed]…
 

———————————————————————————————————————————

the reason what there are so many error msg is that you did not follow the mount instruction as below:

———————————————————————————————————————————
Comannd line:
#mount   -o     datavolume,    nointr,    noatime       /dev/sda1     /u01
Fstab:
/dev/sda1         /u01        ocfs2        _netdev,datavolume,nointr,noatime 0 0
———————————————————————————————————————————
 
this is quite necessary!
 
you can find more information in MOS: Recommended Ocfs2 1.4.1 mount options with DB volumes [ID 835839.1]
 
—EOF—

windows server 2012 trial test

windows server 2012 was released.

1.windows setup welcome page

 

2. select the version to install

it's the same as win2k8 as the installation page

3. login page for user

 

4.server manager

all the maintanenace entry was server manager

 

5. the start menu was hiden in the left corner and powershell was high light

 

-EOF-

hosts file in oracle rac

在RAC环境准备前期,需要准备RAC环境中的各个节点的hosts文件,其中一个片段如下,尤其需要注意127.0.0.1部分的细节:

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

 

A sample /etc/hosts file
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1                            localhost.localdomain              localhost
 
10.137.8.215                   stnsp001.us.oracle.com              stnsp001                # Also in DNS if available
10.137.8.233                   stnsp001-vip.us.oracle.com        stnsp001-vip         # Also in DNS if available
10.137.20.171                 stnsp001-rac.us.oracle.com       stnsp001-rac
 
————————————————————————————————————————————————–
 
127.0.0.1条目中需要避免含有当前节点的hostname,例如当前节点的hostname为stnsp001,在os安装完毕的时候,在127.0.0.1中会可能含有stnsp001关键字,需要将其remove掉,确保hostname对应的是public ip。
 
引自:RACGuides_Rac10gR2OnLinux.pdf
 

upgrade 10.2.0.3 to 10.2.0.5

It's better to read the readme file in the patch package and work exactly step by step as the readme file.

OS:rhel 5 update 5 x86_64

DB:oracle 10.2.0.3 single instance based on filesystem

1.stop the dbconsole,listener,oracle instance,isqlplus

2.go to the patchset file directory and run ./runInstaller in GUI environment

3.upgrade

(1)lsnrctl start

to start the listener

(2)startup upgrade to setp into the upgrade mode

 

 
Start the database in the UPGRADE mode:
 SQL> STARTUP UPGRADE
 
 (3)spool the upgrade information
 
Set the system to spool results to a log file for later analysis:
 SQL> SPOOL upgrade_info.log 
 
Run the Pre-Upgrade Information Tool:
 SQL> @/rdbms/admin/utlu102i.sql
 
Turn off the spooling of script results to the log file:
 SQL> SPOOL OFF
 
(4)check out the log of Running pre-upgrade utility tools(utlu102i.sql)
 
SQL> @$ORACLE_HOME/rdbms/admin/utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility    09-12-2012 05:34:57         
.                                                                               
**********************************************************************          
Database:                                                                       
**********************************************************************          
–> name:       TRADE                                                           
–> version:    10.2.0.3.0                                                      
–> compatible: 10.2.0.3.0                                                      
–> blocksize:  8192                                                            
.                                                                               
**********************************************************************          
Tablespaces: [make adjustments in the current environment]                      
**********************************************************************          
–> SYSTEM tablespace is adequate for the upgrade.                              
…. minimum required size: 310 MB                                              
–> UNDOTBS1 tablespace is adequate for the upgrade.                            
…. minimum required size: 393 MB                                              
…. AUTOEXTEND additional space required: 193 MB                               
–> SYSAUX tablespace is adequate for the upgrade.                              
…. minimum required size: 148 MB                                              
–> TEMP tablespace is adequate for the upgrade.                                
…. minimum required size: 58 MB                                               
.                                                                               
**********************************************************************          
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]             
**********************************************************************          
WARNING: –> "sga_target" needs to be increased to at least 327155712           
.                                                                               
**********************************************************************          
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]            
**********************************************************************          
— No renamed parameters found. No changes are required.                        
.                                                                               
**********************************************************************          
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************          
— No obsolete parameters found. No changes are required                        
.                                                                               
**********************************************************************          
Components: [The following database components will be upgraded or installed]   
**********************************************************************          
–> Oracle Catalog Views                 [upgrade]  VALID                               
–> Oracle Packages and Types    [upgrade]  VALID                               
–> Oracle Workspace Manager     [upgrade]  VALID                               
–> EM Repository                              [upgrade]  VALID                               
.                                                                               
**********************************************************************          
Miscellaneous Warnings                                                          
**********************************************************************          
WARNING: –> Database contains INVALID objects prior to upgrade.                
…. USER TRADE has 52 INVALID objects.                                         
.                                                                               
 
PL/SQL procedure successfully completed.
 
SQL> spool off
 
———————————————————————————————–
 
(3)run catupgrd.sql to upgrade
 
SQL> @?/rdbms/admin/catupgrd.sql
DOC>######################################################################
DOC>######################################################################
DOC> The following statement will cause an "ORA-01722: invalid number"
DOC> error if the user running this script is not SYS.  Disconnect
DOC> and reconnect with AS SYSDBA.
DOC>######################################################################
DOC>######################################################################
DOC>#
 
no rows selected
 
DOC>######################################################################
DOC>######################################################################
DOC> The following statement will cause an "ORA-01722: invalid number"
DOC> error if the database server version is not correct for this script.
DOC> Shutdown ABORT and use a different script or a different server.
DOC>######################################################################
DOC>######################################################################
DOC>#
 
no rows selected
 
DOC>#######################################################################
DOC>#######################################################################
DOC>   The following statement will cause an "ORA-01722: invalid number"
DOC>   error if the database has not been opened for UPGRADE.
DOC>
DOC>   Perform a "SHUTDOWN ABORT"  and
DOC>   restart using UPGRADE.
DOC>#######################################################################
DOC>#######################################################################
DOC>#
 
no rows selected
 
DOC>#######################################################################
DOC>#######################################################################
DOC> The following statements will cause an "ORA-01722: invalid number"
DOC> error if the SYSAUX tablespace does not exist or is not
DOC> ONLINE for READ WRITE, PERMANENT, EXTENT MANAGEMENT LOCAL, and
DOC> SEGMENT SPACE MANAGEMENT AUTO.
DOC>
DOC> The SYSAUX tablespace is used in 10.1 to consolidate data from
DOC> a number of tablespaces that were separate in prior releases.
DOC> Consult the Oracle Database Upgrade Guide for sizing estimates.
DOC>
DOC> Create the SYSAUX tablespace, for example,
DOC>
DOC> create tablespace SYSAUX datafile 'sysaux01.dbf'
DOC>     size 70M reuse
DOC>     extent management local
DOC>     segment space management auto
DOC>     online;
DOC>
DOC> Then rerun the catupgrd.sql script.
DOC>#######################################################################
DOC>#######################################################################
DOC>#
 
no rows selected
 
 
no rows selected

…………………………………………………………………
…………………………………………………………………
…………………………………………………………………
…………………………………………………………………
…………………………………………………………………
…………………………………………………………………
 
No errors.
old   2:   IF ('&EM_REPOS_MODE' = 'CENTRAL') THEN
new   2:   IF ('SYSAUX' = 'CENTRAL') THEN
old   3:     :script_name := '&EM_SQL_ROOT/ias/ias_procs.sql';
new   3:     :script_name := '?/sysman/admin/emdrep/sql/ias/ias_procs.sql';
old   5:     :script_name := '&EM_SQL_ROOT/core/latest/admin/admin_do_nothing.sql';
new   5:     :script_name := '?/sysman/admin/emdrep/sql/core/latest/admin/admin_do_nothing.sql';
 
PL/SQL procedure successfully completed.
 
 
1 row selected.
 
old   2:   IF ('&EM_REPOS_MODE' = 'CENTRAL') THEN
new   2:   IF ('SYSAUX' = 'CENTRAL') THEN
old   3:     :script_name := '&EM_SQL_ROOT/ocs/ocs_procs.sql';
new   3:     :script_name := '?/sysman/admin/emdrep/sql/ocs/ocs_procs.sql';
old   5:     :script_name := '&EM_SQL_ROOT/core/latest/admin/admin_do_nothing.sql';
new   5:     :script_name := '?/sysman/admin/emdrep/sql/core/latest/admin/admin_do_nothing.sql';
 
PL/SQL procedure successfully completed.
 
1 row selected.
 
old  13:                   WHERE owner ='&EM_REPOS_USER'
new  13:                   WHERE owner ='SYSMAN'
 
PL/SQL procedure successfully completed.
 
old  15:     :script_name := '&EM_SQL_ROOT/core/v10102/core_data_upgrade.sql';
new  15:     :script_name := '?/sysman/admin/emdrep/sql/core/v10102/core_data_upgrade.sql';
old  18:     :script_name := '&EM_SQL_ROOT/core/v101040/core_data_upgrade.sql';
new  18:     :script_name := '?/sysman/admin/emdrep/sql/core/v101040/core_data_upgrade.sql';
old  21:     :script_name := '&EM_SQL_ROOT/core/v101050/core_data_upgrade.sql';
new  21:     :script_name := '?/sysman/admin/emdrep/sql/core/v101050/core_data_upgrade.sql';
old  24:     :script_name := '&EM_SQL_ROOT/core/v101060/core_data_upgrade.sql';
new  24:     :script_name := '?/sysman/admin/emdrep/sql/core/v101060/core_data_upgrade.sql';
old  26:     :script_name := '&EM_SQL_ROOT/core/latest/admin/admin_do_nothing.sql';
new  26:     :script_name := '?/sysman/admin/emdrep/sql/core/latest/admin/admin_do_nothing.sql';
 
PL/SQL procedure successfully completed.
 
 
1 row selected.
 
 
PL/SQL procedure successfully completed.
 
 
PL/SQL procedure successfully completed.
 
 
Commit complete.
 
 
PL/SQL procedure successfully completed.
 
old  16:     :script_name := '&EM_SQL_ROOT/db/v10102/db_data_upgrade.sql';
new  16:     :script_name := '?/sysman/admin/emdrep/sql/db/v10102/db_data_upgrade.sql';
old  19:     :script_name := '&EM_SQL_ROOT/db/v101040/db_data_upgrade.sql';
new  19:     :script_name := '?/sysman/admin/emdrep/sql/db/v101040/db_data_upgrade.sql';
old  22:     :script_name := '&EM_SQL_ROOT/db/v102010/db_data_upgrade.sql';
new  22:     :script_name := '?/sysman/admin/emdrep/sql/db/v102010/db_data_upgrade.sql';
old  24:     :script_name := '&EM_SQL_ROOT/core/latest/admin/admin_do_nothing.sql';
new  24:     :script_name := '?/sysman/admin/emdrep/sql/core/latest/admin/admin_do_nothing.sql';
 
PL/SQL procedure successfully completed.
 
1 row selected.
 
Registering job types
old   2:   IF ('&EM_REPOS_MODE' = 'CENTRAL') THEN
new   2:   IF ('SYSAUX' = 'CENTRAL') THEN
old   3:     :script_name := '&EM_SQL_ROOT/ias/ias_data_upgrade.sql';
new   3:     :script_name := '?/sysman/admin/emdrep/sql/ias/ias_data_upgrade.sql';
old   5:     :script_name := '&EM_SQL_ROOT/core/latest/admin/admin_do_nothing.sql';
new   5:     :script_name := '?/sysman/admin/emdrep/sql/core/latest/admin/admin_do_nothing.sql';
 
old   2:   IF ('&EM_REPOS_MODE' = 'CENTRAL') THEN
new   2:   IF ('SYSAUX' = 'CENTRAL') THEN
old   3:     :script_name := '&EM_SQL_ROOT/ocs/ocs_data_upgrade.sql';
new   3:     :script_name := '?/sysman/admin/emdrep/sql/ocs/ocs_data_upgrade.sql';
old   5:     :script_name := '&EM_SQL_ROOT/core/latest/admin/admin_do_nothing.sql';
new   5:     :script_name := '?/sysman/admin/emdrep/sql/core/latest/admin/admin_do_nothing.sql';
 
Submitting DBMS jobs.
old   5:   IF NOT ('&EM_REPOS_MODE' = 'CENTRAL') THEN
new   5:   IF NOT ('SYSAUX' = 'CENTRAL') THEN
 
TIMESTAMP
——————————————————————————–
COMP_TIMESTAMP EM         2012-09-12 05:49:50
DBUA_TIMESTAMP EM         VALID       2012-09-12 05:49:50
 
 
TIMESTAMP
——————————————————————————–
COMP_TIMESTAMP UPGRD_END  2012-09-12 05:51:41
.
Oracle Database 10.2 Upgrade Status Utility           09-12-2012 05:51:41
.
Component                                Status         Version  HH:MM:SS
Oracle Database Server                    VALID      10.2.0.5.0  00:10:23
Oracle Workspace Manager                  VALID      10.2.0.5.0  00:00:46
Oracle Enterprise Manager                 VALID      10.2.0.5.0  00:01:05
.
Total Upgrade Time: 00:14:05
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC>   The above PL/SQL lists the SERVER components in the upgraded
DOC>   database, along with their current version and status.
DOC>
DOC>   Please review the status and version columns and look for
DOC>   any errors in the spool log file.  If there are errors in the spool
DOC>   file, or any components are not VALID or not the current version,
DOC>   consult the Oracle Database Upgrade Guide for troubleshooting
DOC>   recommendations.
DOC>
DOC>   Next shutdown immediate, restart for normal operation, and then
DOC>   run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL> spool off
 
————————————————————————————————————-
 
(4) recompile the invalid objects
 
SQL> @?/rdbms/admin/utlrp.sql
 
TIMESTAMP
——————————————————————————–
COMP_TIMESTAMP UTLRP_BGN  2012-09-12 06:03:09
DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
 
TIMESTAMP
——————————————————————————–
COMP_TIMESTAMP UTLRP_END  2012-09-12 06:03:35
DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
 
OBJECTS WITH ERRORS
——————-
                  0
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#
 
ERRORS DURING RECOMPILATION
—————————
                          0
SQL> spool off
 
job is done!
 
–EOF–

 
 
 

 

 

upgrade oracle 10.2.0.5 to oracle 10.2.0.5.4

 

help the customer to upgrade the oracle database single instance from 10.2.0.5 to 10.2.0.5.4. Here are the details of whole process,check it out.
 
environment info:redhat linux 5 update 5 x86_64,oracle 10205 single instance(no em,no isqlplus)
 
prepare the patch "p12419392_10205_Linux-x86-64.zip" and the corresponding OPatch tools "p6880880_102000_Linux-x86-64.zip" or you will get some error msg indicating the low version of opatch tools
 
//do precheck before opatch the PSU
[oracle@hundsun ~]$ /home/oracle/product/10.2.0/OPatch/opatch  prereq  CheckConflictAgainstOHWithDetail -phBaseDir ./12419392
Invoking OPatch 10.2.0.4.9
 
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /home/oracle/product/10.2.0
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.9
OUI version       : 10.2.0.5.0
OUI location      : /home/oracle/product/10.2.0/oui
Log file location : /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-09-12_08-04-28AM.log
 
Patch history file: /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.
————————————————————————————————————-
 
//get into the psu dir and opatch apply
 
[oracle@hundsun 12419392]$ /home/oracle/product/10.2.0/OPatch/opatch apply
Invoking OPatch 10.2.0.4.9
 
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /home/oracle/product/10.2.0
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.9
OUI version       : 10.2.0.5.0
OUI location      : /home/oracle/product/10.2.0/oui
Log file location : /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-09-12_08-08-15AM.log
 
Patch history file: /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt
 
ApplySession applying interim patch '12419392' to OH '/home/oracle/product/10.2.0'
ApplySession failed: ApplySession failed to prepare the system.
 
Patch 12419392 requires OPatch version 10.2.0.5.0.
The OPatch version being used (10.2.0.4.9) doesn't meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.
 
System intact, OPatch will not attempt to restore the system
 
OPatch failed with error code 73
 
—————————————
 
the version of opatch is not satisfy with the requirements, download the needed OPatch tool p6880880_102000_Linux-x86-64.zip
 
 
//check the opatch version
 
[oracle@hundsun OPatch]$ ./opatch -version
Invoking OPatch 10.2.0.5.1
 
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.
 
Syntax Error… Unrecognized Command or Option (-version): 1st argument must be one of the following:
      apply
      napply
      rollback
      nrollback
      lsinventory
      lsinv
      query
      util
      prereq
      version
      -help
      -h
 
Please use the option 'opatch  -help' to get correct syntax
 
OPatch failed with error code 14
——————————————————-
 
//try opatch apply
 
[oracle@hundsun ~]$ cd 12419392/
[oracle@hundsun 12419392]$ /home/oracle/OPatch/
-bash: /home/oracle/OPatch/: is a directory
[oracle@hundsun 12419392]$ /home/oracle/OPatch/opatch apply
Invoking OPatch 10.2.0.5.1
 
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /home/oracle/product/10.2.0
Central Inventory : /home/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.5.0
OUI location      : /home/oracle/product/10.2.0/oui
Log file location : /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-09-12_08-22-26AM.log
 
Patch history file: /home/oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt
 
ApplySession applying interim patch '12419392' to OH '/home/oracle/product/10.2.0'
 
Running prerequisite checks…
Patch 12419392: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.5.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.5.0 ]
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
 
(email,username are not the critical elements)
……………………………………………………….
 
Copying file to "/home/oracle/product/10.2.0/sysman/admin/emdrep/sql/core/latest/ecm/ecm_views.sql"
Copying file to "/home/oracle/product/10.2.0/sysman/admin/emdrep/sql/core/latest/sdk/sdk_views.sql"
 
Patching component oracle.sysman.console.db, 10.2.0.5.0…
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_plsqlobject/_createPLSqlObjectPage$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_plsqlobject/_createPLSqlObjectPage.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_plsqlobject/_editPLSqlObjectPage$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_plsqlobject/_editPLSqlObjectPage.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerAdvancedPage$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerAdvancedPage.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerEventPage$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerEventPage.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerGeneralPage$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_schema/_trigger/_triggerGeneralPage.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_confirmationDelete$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_confirmationDelete.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_confirmationWithOptions$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_confirmationWithOptions.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_dbObjectsList$__jsp_StaticText.class"
Updating jar file "/home/oracle/product/10.2.0/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_dbObjectsList.class"
Copying file to "/home/oracle/product/10.2.0/oc4j/j2ee/oc4j_applications/applications/em/em/admin/rep/editUserSummary.uix"
 
Patching component oracle.xdk.rsf, 10.2.0.5.0…
Updating archive file "/home/oracle/product/10.2.0/lib/libxml10.a"  with "lib/libxml10.a/lpxpar.o"
Updating archive file "/home/oracle/product/10.2.0/lib32/libxml10.a"  with "lib32/libxml10.a/lpxpar.o"
 
Patching component oracle.precomp.common, 10.2.0.5.0…
 
Patching component oracle.rdbms.rman, 10.2.0.5.0…
Running make for target client_sharedlib
Running make for target ioracle
Running make for target iwrap
Running make for target client_sharedlib
Running make for target proc
Running make for target irman
ApplySession adding interim patch '12419392' to inventory
 
Verifying the update…
Inventory check OK: Patch ID 12419392 is registered in Oracle Home inventory with proper meta-data.
 
Files check OK: Files from Patch ID 12419392 are present in Oracle Home.
 
The local system has been patched and can be restarted.
 
OPatch succeeded.
 
————————————————————
 
check the results:
 
[oracle@hundsun OPatch]$ ./opatch lsinventory -bugs_fixed|grep PSU
9952230    12419392  Wed Sep 12 08:27:39 CST 2012   DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)
10248542   12419392  Wed Sep 12 08:27:39 CST 2012   DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)
11724962   12419392  Wed Sep 12 08:27:39 CST 2012   DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)
12419392   12419392  Wed Sep 12 08:27:39 CST 2012   DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)
[oracle@hundsun OPatch]$
 
 
 

 

rpm prepare for rac install on linux

there are the rpm information listed on note which you can get from below

Document 811306.1 RAC and Oracle Clusterware Best Practices and Starter Kit (Linux)

check out the example on oel4 x86_64,you need to install each needed rpm package to avoid the coming error msg.

—————————————————————————————————

64-Bit Required RPM's

Red Hat,Oracle] Enterprise Linux 4:
 
binutils-2.15.92.0.2-13.0.0.0.2.x86_64 (you can install binutils-2.15.92.0.2-18.x86_64.rpm from RHEL4 Update 3.)
 
compat-db-4.1.25-9.x86_64.rpm
 
compat-gcc-32-c++ (with Patch 5240469 to correct bad genoccish file. see Note WebIV:430526.1))
 
compat-libstdc++-33-3.2.3-47.3.x86_64.rpm
 
compat-libstdc++-33-3.2.3-47.3.i386.rpm 
 
control-center-2.8.0-12.x86_64.rpm
 
gcc-3.4.3-47.x86_64.rpm
 
gcc-c++-3.4.3-47.x86_64.rpm   
 
glibc-2.3.4-2.9.x86_64.rpm   
 
glibc-2.3.4-2.9.i386.rpm   
 
glibc-common-2.3.4-2.9.x86_64.rpm   
 
glibc-devel-2.3.4-2.9.x86_64.rpm   
 
glibc-devel-2.3.4-2.9.i386.rpm   
 
glibc-headers-2.3.4-2.9.x86_64.rpm   
 
glibc-kernheaders-2.4-9.1.87.x86_64.rpm   
 
gnome-libs-1.4.1.2.90-44.1.x86_64
 
libaio-0.3.103-3.i386.rpm
 
libaio-0.3.103-3.x86_64.rpm   
 
libgcc-3.4.3-9.EL4
 
libstdc++-3.4.3-22.1.x86_64   
 
libstdc++-devel-3.4.3-22.1.x86_64   
 
make-3.80-5.x86_64.rpm
 
pdksh-5.2.14-30.x86_64.rpm   
 
sysstat-5.0.5-1.x86_64.rpm   
 
util-linux-2.12a-16.EL4.23.x86_64 (for raw devices)   
 
xorg-x11-deprecated-libs-6.8.1-23
 
xscreensaver-4.18-5.rhel4.2.x86_64.rpm   
 

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

it's quite easy to find the details, you need both x86 and x86_64 in some rpm packs

ORA-31655: 尚未为作业选择数据或元数据对象

 

帮客户迁移数据,发现一则问题,记录之。
 
//expdp导出dict用户的数据
 
expdp dict/password directory=dirtest dumpfile=expdp_dict.dmp logfile=expdp_dict.log
expdp能搞定的东西还真是不少,看下面标红的部分。
 
Export: Release 11.2.0.1.0 – Production on 星期一 9月 3 21:13:48 2012
 
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
 
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
启动 "DICT"."SYS_EXPORT_SCHEMA_01":  dict/******** directory=dirtest dumpfile=expdp_dict.dmp logfile=expdp_dict.log 
正在使用 BLOCKS 方法进行估计…
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE_DATA
使用 BLOCKS 方法的总估计: 4.687 MB
处理对象类型 SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
处理对象类型 SCHEMA_EXPORT/SEQUENCE/SEQUENCE
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE
处理对象类型 SCHEMA_EXPORT/TABLE/INDEX/INDEX
处理对象类型 SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
处理对象类型 SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
处理对象类型 SCHEMA_EXPORT/TABLE/COMMENT
处理对象类型 SCHEMA_EXPORT/VIEW/VIEW
处理对象类型 SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
处理对象类型 SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . 导出了 "DICT"."T_ELEMENT_CHANGE"                                             813.3 KB      6754 行
. . 导出了 "DICT"."T_ELEMENT_APPROVE"                                           109.7 KB      307 行
. . 导出了 "DICT"."T_ELEMENT_HISINFO"                                              107.1 KB     307 行
. . 导出了 "DICT"."T_ELEMENT_ELEMENTNODE"                                42.71 KB     418 行
. . 导出了 "DICT"."T_ELEMENT_ELEMENTNODE_AP"                         42.71 KB     418 行
. . 导出了 "DICT"."T_ELEMENT_ELEMENTNODE_BAK"                      52.45 KB     555 行
. . 导出了 "DICT"."T_ELEMENT_ELEMENTNODE_HIS"                       42.71 KB     418 行
. . 导出了 "DICT"."T_ELEMENT_INFO"                                                     103.4 KB     307 行
. . 导出了 "DICT"."T_ELEMENT_SYNONYMS"                                         63.96 KB     435 行
. . 导出了 "DICT"."T_ELEMENT_SYNONYMS_AP"                                  69.04 KB     435 行
. . 导出了 "DICT"."T_ELEMENT_SYNONYMS_HIS"                                69.04 KB     435 行
. . 导出了 "DICT"."T_SYS_USER"                                                               58.03 KB     464 行
. . 导出了 "DICT"."T_TEMP_FLOW_NODE_ELEMENT"                         95.81 KB    1107 行
. . 导出了 "DICT"."DICT_TEMP"                                                                  12.60 KB     301 行
. . 导出了 "DICT"."T_ATTACHMENT_INFO"                                              14.52 KB      37 行
. . 导出了 "DICT"."T_DATAFLOW_FLOWINFO"                                       12.02 KB      16 行
. . 导出了 "DICT"."T_DATAFLOW_FLOWINFO_AP"                                13.12 KB      16 行
. . 导出了 "DICT"."T_DATAFLOW_FLOWINFO_HIS"                              12.56 KB      16 行
. . 导出了 "DICT"."T_DATAFLOW_FLOWNODE"                                     10.41 KB      94 行
. . 导出了 "DICT"."T_DATAFLOW_FLOWNODE_AP"                              10.41 KB      94 行
. . 导出了 "DICT"."T_DATAFLOW_FLOWNODE_HIS"                            10.41 KB      94 行
. . 导出了 "DICT"."T_DATAFLOW_NODEINFO"                                       12.77 KB      34 行
. . 导出了 "DICT"."T_DATAFLOW_NODEINFO_AP"                               14.19 KB      34 行
. . 导出了 "DICT"."T_DATAFLOW_NODEINFO_HIS"                              13.55 KB      34 行
. . 导出了 "DICT"."T_DOCUMENT_INFO"                                                 9.625 KB       6 行
. . 导出了 "DICT"."T_ELEMENT_RANGE"                                                 37.35 KB     414 行
. . 导出了 "DICT"."T_ELEMENT_RANGE_AP"                                          42.20 KB     414 行
. . 导出了 "DICT"."T_ELEMENT_RANGE_HIS"                                        42.20 KB     414 行
. . 导出了 "DICT"."T_REPORT_INFO"                                                        9.679 KB       1 行
. . 导出了 "DICT"."T_SYS_LOG"                                                                  16.36 KB     112 行
. . 导出了 "DICT"."T_SYS_MENU"                                                               13.95 KB      34 行
. . 导出了 "DICT"."T_SYS_MENU_20111214"                                         12.32 KB      29 行
. . 导出了 "DICT"."T_SYS_OPTION"                                                           21.55 KB     144 行
. . 导出了 "DICT"."T_SYS_OPTION_20120116"                                      17.19 KB     100 行
. . 导出了 "DICT"."T_SYS_OPTION_TYPE"                                                7.398 KB      27 行
. . 导出了 "DICT"."T_SYS_ORG"                                                                   9.828 KB       8 行
. . 导出了 "DICT"."T_SYS_REF"                                                                    6.304 KB       2 行
. . 导出了 "DICT"."T_SYS_ROLE"                                                                 9.906 KB      15 行
. . 导出了 "DICT"."T_SYS_ROLEMENU"                                                    10.35 KB     101 行
. . 导出了 "DICT"."T_SYS_USERORG"                                                       5.429 KB       1 行
. . 导出了 "DICT"."T_SYS_USERROLE"                                                     8.093 KB     149 行
. . 导出了 "DICT"."T_SYS_USERROLE_BAK"                                           13.71 KB     459 行
. . 导出了 "DICT"."T_TAG_INFO"                                                                   8.148 KB       4 行
. . 导出了 "DICT"."T_TASK_STAGE"                                                                    7 KB       7 行
. . 导出了 "DICT"."T_TEMP_20111220"                                                      17.85 KB     140 行
. . 导出了 "DICT"."T_TEMP_USER_ROLE"                                                11.96 KB     148 行
. . 导出了 "DICT"."T_COMMISSION_INFO"                                                        0 KB       0 行
. . 导出了 "DICT"."T_DATAFLOW_RELATION"                                                  0 KB       0 行
. . 导出了 "DICT"."T_GRAPH_EDGE"                                                                 0 KB       0 行
. . 导出了 "DICT"."T_GRAPH_INFO"                                                                   0 KB       0 行
. . 导出了 "DICT"."T_GRAPH_VERTEX"                                                            0 KB       0 行
. . 导出了 "DICT"."T_SYS_DOCUMENT"                                                           0 KB       0 行
. . 导出了 "DICT"."T_SYS_MODULE"                                                                 0 KB       0 行
. . 导出了 "DICT"."T_SYS_PARAMETER"                                                         0 KB       0 行
. . 导出了 "DICT"."T_SYS_USERMODULE"                                                0 KB       0 行
. . 导出了 "DICT"."T_SYS_XXX"                                                                     0 KB       0 行
. . 导出了 "DICT"."T_TASK_APPROVE"                                                       0 KB       0 行
. . 导出了 "DICT"."T_TASK_COR_USER"                                                   0 KB       0 行
. . 导出了 "DICT"."T_TASK_INFO"                                                                0 KB       0 行
. . 导出了 "DICT"."T_TASK_OBJECT"                                                          0 KB       0 行
. . 导出了 "DICT"."T_TASK_USER_SETTING"                                           0 KB       0 行
已成功加载/卸载了主表 "DICT"."SYS_EXPORT_SCHEMA_01" 
******************************************************************************
DICT.SYS_EXPORT_SCHEMA_01 的转储文件集为:(文件集)
  E:DIRTESTEXPDP_DICT.DMP
作业 "DICT"."SYS_EXPORT_SCHEMA_01" 已于 21:15:06 成功完成
 
//数据很轻松被导出,然后测试恢复,新建一个用户导入expdp导出的dumpfile。
 
C:UsersAdministrator>impdp jack/jackpassword directory=dirtest dumpfile=expdp_dict.dmp logfile=impdp_jack.log
 
Import: Release 11.2.0.1.0 – Production on 星期一 9月 3 21:23:50 2012
 
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
 
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31655: 尚未为作业选择数据或元数据对象
ORA-39154: 外部方案中的对象已从导入中删除
已成功加载/卸载了主表 "JACK"."SYS_IMPORT_FULL_01"
启动 "JACK"."SYS_IMPORT_FULL_01":  jack/******** directory=dirtest dumpfile=expdp_dict.dmp logfile=impdp_jack.log
作业 "JACK"."SYS_IMPORT_FULL_01" 已于 21:23:52 成功完成
 
//可以看到报错了,ORA-31655。这是由于,你在做数据expdp导出时,使用的用户是dict,而此刻你想还原数据,导入的用户是jack。记得,exp和imp恢复时,还有个参数叫fromuser以及touser,作用就是将数据从一个用户导入到另外一个用户下。而在expdp与impdp中,同样遵循类似的逻辑,如果之前使用的是dict用户做impdp操作,而不是jack,相关的报错就不会出现了。
 
//在impdp中,fromuser、touser,将A用户下的备份片导入到创建好的B用户下,是通过remap_schema实现的,如下:
 
C:>impdp jack/jackpassword directory=dirtest dumpfile=expdp_dict.dmp logfile=impdp_jack.log remap_schema=dict:jack
 
Import: Release 11.2.0.1.0 – Production on 星期一 9月 3 21:35:20 2012
 
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
 
连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
已成功加载/卸载了主表 "JACK"."SYS_IMPORT_FULL_01" 
启动 "JACK"."SYS_IMPORT_FULL_01":  jack/******** directory=dirtest dumpfile=expdp_dict.dmp logfile=impdp_jack.log remap_schema=dict:jack 
处理对象类型 SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
处理对象类型 SCHEMA_EXPORT/SEQUENCE/SEQUENCE
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE
处理对象类型 SCHEMA_EXPORT/TABLE/TABLE_DATA
. . 导入了 "JACK"."T_ELEMENT_CHANGE"                   813.3 KB    6754 行
. . 导入了 "JACK"."T_ELEMENT_APPROVE"                  109.7 KB     307 行
. . 导入了 "JACK"."T_ELEMENT_HISINFO"                  107.1 KB     307 行
. . 导入了 "JACK"."T_ELEMENT_ELEMENTNODE"              42.71 KB     418 行
. . 导入了 "JACK"."T_ELEMENT_ELEMENTNODE_AP"           42.71 KB     418 行
. . 导入了 "JACK"."T_ELEMENT_ELEMENTNODE_BAK"          52.45 KB     555 行
. . 导入了 "JACK"."T_ELEMENT_ELEMENTNODE_HIS"          42.71 KB     418 行
. . 导入了 "JACK"."T_ELEMENT_INFO"                     103.4 KB     307 行
. . 导入了 "JACK"."T_ELEMENT_SYNONYMS"                 63.96 KB     435 行
. . 导入了 "JACK"."T_ELEMENT_SYNONYMS_AP"              69.04 KB     435 行
. . 导入了 "JACK"."T_ELEMENT_SYNONYMS_HIS"             69.04 KB     435 行
. . 导入了 "JACK"."T_SYS_USER"                         58.03 KB     464 行
. . 导入了 "JACK"."T_TEMP_FLOW_NODE_ELEMENT"           95.81 KB    1107 行
. . 导入了 "JACK"."DICT_TEMP"                          12.60 KB     301 行
. . 导入了 "JACK"."T_ATTACHMENT_INFO"                  14.52 KB      37 行
. . 导入了 "JACK"."T_DATAFLOW_FLOWINFO"                12.02 KB      16 行
. . 导入了 "JACK"."T_DATAFLOW_FLOWINFO_AP"             13.12 KB      16 行
. . 导入了 "JACK"."T_DATAFLOW_FLOWINFO_HIS"            12.56 KB      16 行
. . 导入了 "JACK"."T_DATAFLOW_FLOWNODE"                10.41 KB      94 行
. . 导入了 "JACK"."T_DATAFLOW_FLOWNODE_AP"             10.41 KB      94 行
. . 导入了 "JACK"."T_DATAFLOW_FLOWNODE_HIS"            10.41 KB      94 行
. . 导入了 "JACK"."T_DATAFLOW_NODEINFO"                12.77 KB      34 行
. . 导入了 "JACK"."T_DATAFLOW_NODEINFO_AP"             14.19 KB      34 行
. . 导入了 "JACK"."T_DATAFLOW_NODEINFO_HIS"            13.55 KB      34 行
. . 导入了 "JACK"."T_DOCUMENT_INFO"                    9.625 KB       6 行
. . 导入了 "JACK"."T_ELEMENT_RANGE"                    37.35 KB     414 行
. . 导入了 "JACK"."T_ELEMENT_RANGE_AP"                 42.20 KB     414 行
. . 导入了 "JACK"."T_ELEMENT_RANGE_HIS"                42.20 KB     414 行
. . 导入了 "JACK"."T_REPORT_INFO"                      9.679 KB       1 行
. . 导入了 "JACK"."T_SYS_LOG"                          16.36 KB     112 行
. . 导入了 "JACK"."T_SYS_MENU"                         13.95 KB      34 行
. . 导入了 "JACK"."T_SYS_MENU_20111214"                12.32 KB      29 行
. . 导入了 "JACK"."T_SYS_OPTION"                       21.55 KB     144 行
. . 导入了 "JACK"."T_SYS_OPTION_20120116"              17.19 KB     100 行
. . 导入了 "JACK"."T_SYS_OPTION_TYPE"                  7.398 KB      27 行
. . 导入了 "JACK"."T_SYS_ORG"                          9.828 KB       8 行
. . 导入了 "JACK"."T_SYS_REF"                          6.304 KB       2 行
. . 导入了 "JACK"."T_SYS_ROLE"                         9.906 KB      15 行
. . 导入了 "JACK"."T_SYS_ROLEMENU"                     10.35 KB     101 行
. . 导入了 "JACK"."T_SYS_USERORG"                      5.429 KB       1 行
. . 导入了 "JACK"."T_SYS_USERROLE"                     8.093 KB     149 行
. . 导入了 "JACK"."T_SYS_USERROLE_BAK"                 13.71 KB     459 行
. . 导入了 "JACK"."T_TAG_INFO"                         8.148 KB       4 行
. . 导入了 "JACK"."T_TASK_STAGE"                           7 KB       7 行
. . 导入了 "JACK"."T_TEMP_20111220"                    17.85 KB     140 行
. . 导入了 "JACK"."T_TEMP_USER_ROLE"                   11.96 KB     148 行
. . 导入了 "JACK"."T_COMMISSION_INFO"                      0 KB       0 行
. . 导入了 "JACK"."T_DATAFLOW_RELATION"                    0 KB       0 行
. . 导入了 "JACK"."T_GRAPH_EDGE"                           0 KB       0 行
. . 导入了 "JACK"."T_GRAPH_INFO"                           0 KB       0 行
. . 导入了 "JACK"."T_GRAPH_VERTEX"                         0 KB       0 行
. . 导入了 "JACK"."T_SYS_DOCUMENT"                         0 KB       0 行
. . 导入了 "JACK"."T_SYS_MODULE"                           0 KB       0 行
. . 导入了 "JACK"."T_SYS_PARAMETER"                        0 KB       0 行
. . 导入了 "JACK"."T_SYS_USERMODULE"                       0 KB       0 行
. . 导入了 "JACK"."T_SYS_XXX"                              0 KB       0 行
. . 导入了 "JACK"."T_TASK_APPROVE"                         0 KB       0 行
. . 导入了 "JACK"."T_TASK_COR_USER"                        0 KB       0 行
. . 导入了 "JACK"."T_TASK_INFO"                            0 KB       0 行
. . 导入了 "JACK"."T_TASK_OBJECT"                          0 KB       0 行
. . 导入了 "JACK"."T_TASK_USER_SETTING"                    0 KB       0 行
处理对象类型 SCHEMA_EXPORT/TABLE/INDEX/INDEX
处理对象类型 SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
处理对象类型 SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
处理对象类型 SCHEMA_EXPORT/TABLE/COMMENT
处理对象类型 SCHEMA_EXPORT/VIEW/VIEW
处理对象类型 SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
处理对象类型 SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
作业 "JACK"."SYS_IMPORT_FULL_01" 已于 21:35:49 成功完成
 
//导入完毕后,查询jack下面的table,view等对象,对比与源端,基本一致。
 
备注:expdp与impdp命令的结尾都无需加冒号";",否则也会遭遇报错的。
 
–EOF–