OLAP Catalog VALID 11.2.0.3.0 Spatial VALID 11.2.0.3.0 Oracle Multimedia VALID 11.2.0.3.0 Oracle XML Database VALID 11.2.0.3.0 Oracle Expression Filter VALID 11.2.0.3.0 Oracle Database Catalog Views VALID 11.2.0.3.0 Oracle Database Packages and Types VALID 11.2.0.3.0 Oracle Real Application Clusters INVALID 11.2.0.3.0 JServer JAVA Virtual Machine VALID 11.2.0.3.0 COMP_NAME STATUS VERSION -------------------------------------------------- ----------- ------------------------------ Oracle XDK 11.2.0.3.0 Oracle Database Java Packages 11.2.0.3.0 OLAP Analytic Workspace VALID 11.2.0.3.0 Oracle OLAP API VALID 11.2.0.3.0 15 rows selected. Upgrade the statistics table SQL> exec dbms_stats.upgrade_stat_table('applfnd','fnd_stattab'); PL/SQL procedure successfully completed. Create the updated 11.2.0.3 pfile [oracle@kens-orasql-002-uat ~]$ cd $ORACLE_HOME/dbs [oracle@kens-orasql-002-uat dbs]$ ls spfile* –lrt -rw-r----- 1 oracle oinstall 4608 Sep 18 12:29 spfileCLMTS10G.ora
OLAP Catalog VALID 11.2.0.3.0 Spatial VALID 11.2.0.3.0 Oracle Multimedia VALID 11.2.0.3.0 Oracle XML Database VALID 11.2.0.3.0 Oracle Expression Filter VALID 11.2.0.3.0 Oracle Database Catalog Views VALID 11.2.0.3.0 Oracle Database Packages and Types VALID 11.2.0.3.0 Oracle Real Application Clusters INVALID 11.2.0.3.0 JServer JAVA Virtual Machine VALID 11.2.0.3.0 COMP_NAME STATUS VERSION -------------------------------------------------- ----------- ------------------------------ Oracle XDK 11.2.0.3.0 Oracle Database Java Packages 11.2.0.3.0 OLAP Analytic Workspace VALID 11.2.0.3.0 Oracle OLAP API VALID 11.2.0.3.0 15 rows selected. Upgrade the statistics table SQL> exec dbms_stats.upgrade_stat_table('applfnd','fnd_stattab'); PL/SQL procedure successfully completed. Create the updated 11.2.0.3 pfile [oracle@kens-orasql-002-uat ~]$ cd $ORACLE_HOME/dbs [oracle@kens-orasql-002-uat dbs]$ ls –lrt spfile* -rw-r----- 1 oracle oinstall 4608 Sep 18 12:29 spfileCLMTS10G.ora