10 'PSU', 11 'Patchset 11.2.0.2.0');1 row created.SQL> COMMIT;Commit complete.SQL> SPOOL offSQL> SET echo offCheck the following log file for errors:/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_DATH_APPLY_2014Sep21_05_11_37.logSQL> SQL> spool upgrade3.logSQL> @?/rdbms/admin/utlrp.sqlTIMESTAMP--------------------------------------------------------------------------------COMP_TIMESTAMP UTLRP_BGN 2014-09-21 05:14:47DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalidDOC> objects in the database. Recompilation time is proportional to theDOC> number of invalid objects in the database, so this command may takeDOC> a long time to execute on a database with a large number of invalidDOC> objects.DOC>DOC> Use the following queries to track recompilation progress:DOC>DOC> 1. Query returning the number of invalid objects remaining. ThisDOC> 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 numberDOC> should increase with time.DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;DOC>DOC> This script automatically chooses serial or parallel recompilationDOC> based on the number of CPUs available (parameter cpu_count) multipliedDOC> 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 parallelDOC> recompilation. Jobs are created without instance affinity so that theyDOC> can migrate across RAC nodes. Use the following queries to verifyDOC> whether UTL_RECOMP jobs are being created and run correctly:DOC>DOC> 1. Query showing jobs created by UTL_RECOMPDOC> SELECT job_name FROM dba_scheduler_jobsDOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';DOC>DOC> 2. Query showing UTL_RECOMP jobs that are runningDOC> SELECT job_name FROM dba_scheduler_running_jobsDOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';DOC>#PL/SQL procedure successfully completed.TIMESTAMP--------------------------------------------------------------------------------COMP_TIMESTAMP UTLRP_END 2014-09-21 05:34:14DOC> The following query reports the number of objects that have compiledDOC> with errors (objects that compile with errors have status set to 3 inDOC> obj$). If the number is higher than expected, please examine the errorDOC> messages reported with each object (using SHOW ERRORS) to see if theyDOC> point to system misconfiguration or resource constraints that must beDOC> fixed before attempting to recompile these objects.DOC>#OBJECTS WITH ERRORS------------------- 0DOC> The following query reports the number of errors caught duringDOC> recompilation. If this number is non-zero, please query the errorDOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errorsDOC> are due to misconfiguration or resource constraints that must beDOC> fixed before objects can compile successfully.DOC>#ERRORS DURING RECOMPILATION--------------------------- 0Function created.PL/SQL procedure successfully completed.Function dropped.PL/SQL procedure successfully completed.SQL> SQL> [oracle@ora-rac01 ~]$ srvctl remove database -d dathRemover o banco de dados dath? (y/[n]) y[oracle@ora-rac01 ~]$ SQL> show parameter spfileNAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile stringSQL> create spfile='+DATA/DATH/spfiledath.ora' from pfile='/home/oracle/initdath1.ora';File created.[oracle@ora-rac01 dbs]$ srvctl add database -d dath -o $ORACLE_HOME -y AUTOMATIC -a "DATA,RECO"[oracle@ora-rac01 dbs]$ srvctl add instance -d dath -i dath1 -n ora-rac01[oracle@ora-rac01 dbs]$ srvctl add instance -d dath -i dath2 -n ora-rac02[oracle@ora-rac01 ~]$ srvctl start database -d dath -o open[oracle@ora-rac01 ~]$ srvctl status database -d dathA instancia dath1 esta em execucao no no ora-rac01A instancia dath2 esta em execucao no no ora-rac02Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsSQL> select instance_name, status from gv$instance;INSTANCE_NAME STATUS---------------- ------------dath1 OPENdath2 OPEN Bem e isso, finalizamos nossa atualizacao do ambiente de Cluster Oracle RAC 11gR2, saimos da release 11.2.0.2 para 11.2.0.3, espero que