1 2 Previous Next 15 Replies Latest reply: Dec 2, 2013 6:36 AM by AK_AppsDBA RSS

    upgrade 10gr2 to 11gR2 manually

    AK_AppsDBA

      while running catupgrd.sql script getting below error .

       

       

      SELECT version_script AS file_name FROM DUAL

             *

      ERROR at line 1:

      ORA-20000: Upgrade not supported from version 10.2.0.1.0

      ORA-06512: at "SYS.VERSION_SCRIPT", line 49

       

       

      Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

        • 1. Re: upgrade 10gr2 to 11gR2 manually
          Anar Godjaev

          Please check following link: Step by Step Upgrading Oracle 10g to Oracle 11g | samadhandba

           

          From Link:

           

          A direct upgrade from 10.2 to 11.2 is not supported in 10.2.0.1, you have to be at least in 10.2.0.2.

          So depending on 32 bit or 64 bit first apply the patch for 10.2.0.2 with respective patchset.

          Then Oracle 11.2.0.2 is delivered with the Patchset 10098816. You don’t have to install Oracle 11.2.0.1 as starting with Oracle 11.2 every Patchset is already a full installation.

           

           

           

           

           

          • 2. Re: upgrade 10gr2 to 11gR2 manually
            DK2010

            Hi,

             

            Follow the Oracle Doc for the Process Check this ID:Complete Checklist to Upgrade the Database to 11gR2 using DBUA (Doc ID 870814.1)

             

            HTH

            • 3. Re: upgrade 10gr2 to 11gR2 manually
              AK_AppsDBA

              i checked metalink ID 870814.1 which for DBUA. but i wants to upgrade manually

              • 4. Re: upgrade 10gr2 to 11gR2 manually
                DK2010

                Hi,

                 

                Have you checked the ID :Complete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1)

                 

                HTH

                • 5. Re: upgrade 10gr2 to 11gR2 manually
                  Srini Chavali-Oracle

                  As documented in the upgrade guide - Preparing to Upgrade Oracle Database - you need to be at least on 10.2.0.2 version to directly upgrade (either with DBUA or manually via scripts) to 11gR2.

                   

                  So the first step here would be to apply the 10.2.0.2 patch - then follow the steps in 837570.1

                   

                  HTH
                  Srini

                  • 6. Re: upgrade 10gr2 to 11gR2 manually
                    AK_AppsDBA

                    thanks its very helpful docs.

                    • 7. Re: upgrade 10gr2 to 11gR2 manually
                      AK_AppsDBA

                      upgraded 10.2.0.1 to 11.2.0

                      1 applied patch-set 4547817

                      2 then used time zone patch 5632264

                      3 installed 11g home

                          10g home =/u01/oracle/product/10.2.0/db_1

                          11g home =/u01/oracle/product/11.2.0/dbhome_1

                      4  @utlu11i2.sql

                      5 exec dbms_stats.gather_dictionary_stats

                         exec dbms_stats.gather_schema_stats('SYS')

                         exec dbms_stats.gather_schema_stats('SYSMAN')

                      6 @catupgrd.sql;

                      7 @utlu112s;

                      8 @catuppst.sql;

                       

                       

                      finally

                       

                      SQL> select * from v$version;

                       

                      BANNER
                      --------------------------------------------------------------------------------
                      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
                      PL/SQL Release 11.2.0.1.0 - Production
                      CORE    11.2.0.1.0      Production
                      TNS for Linux: Version 11.2.0.1.0 - Production
                      NLSRTL Version 11.2.0.1.0 - Production

                       

                      SQL> select comp_name,version,status from dba_registry;

                      COMP_NAME                           VERSION                     STATUS
                      ----------------------------------- ------------------------------ -----------
                      Oracle Enterprise Manager          11.2.0.1.0                     VALID
                      OLAP Catalog                            11.2.0.1.0                     VALID
                      Spatial                                       11.2.0.1.0                     VALID
                      Oracle Multimedia                       11.2.0.1.0                     VALID
                      Oracle XML Database                  11.2.0.1.0                     VALID
                      Oracle Text                                 11.2.0.1.0                     VALID
                      Oracle Data Mining                      11.2.0.1.0                     VALID
                      Oracle Expression Filter               11.2.0.1.0                     VALID
                      Oracle Rule Manager                    11.2.0.1.0                     VALID
                      Oracle Workspace Manager          11.2.0.1.0                     VALID
                      Oracle Database Catalog Views     11.2.0.1.0                     VALID

                       

                      COMP_NAME                           VERSION                        STATUS
                      ----------------------------------- ------------------------------ -----------
                      Oracle Database Packages and Types  11.2.0.1.0                VALID
                      JServer JAVA Virtual Machine           11.2.0.1.0                    VALID
                      Oracle XDK                                     11.2.0.1.0                    VALID
                      Oracle Database Java Packages       11.2.0.1.0                    VALID
                      OLAP Analytic Workspace              11.2.0.1.0                   INVALID
                      Oracle OLAP API                            11.2.0.1.0                     VALID

                       

                      17 rows selected.

                       

                      when m checking invalid objects.

                      its showing 47 invalid objects again i used utlrp.sql but invalid objects remains as same.

                       

                      SQL>@utlrp.sql;

                       

                      SQL> select count(*) from dba_objects where status='INVALID';

                       

                        COUNT(*)
                      ----------
                              47

                       

                       

                       

                       


                      • 8. Re: upgrade 10gr2 to 11gR2 manually
                        Srini Chavali-Oracle

                        Pl review 753041.1

                         

                        Did you follow all of the steps in 837570.1 without errors ?

                         

                        HTH
                        Srini

                        • 9. Re: upgrade 10gr2 to 11gR2 manually
                          Anar Godjaev

                          How To Diagnose Components With NON VALID Status In DBA_REGISTRY After an Upgrade (Doc ID 753041.1)


                          Or please check following link:


                          For example: A! Help: Upgrading from 10.2.0.4 to 11.2.0.3


                          This link contains information. Suggested Reading....





                          • 10. Re: upgrade 10gr2 to 11gR2 manually
                            DK2010

                            Hi,

                             

                            have you checked the upgrade log file,You can check the Doc Id for solution :OLAP Analytic Workspace Component Fails To Install with ORA-43856 In SYS.DBMS_AW_BUILD (Doc ID 1565321.1)

                            • 11. Re: upgrade 10gr2 to 11gR2 manually
                              AK_AppsDBA

                              checked out doc 753041.1

                              i executed script

                              @?/olap/admin/apspatch.sql

                              showing below error ...

                               

                              ORA-00600: internal error code, arguments: [kck_rls_check must use (11,0,0,0,0) or lower], [xsixcd.c], [90], [11.2.0.1.0], [], [], [], [], [], [], [], []
                              Incident details in: /u01/trace/diag/rdbms/mydb/mydb/incident/incdir_5190/mydb_ora_4161_i5190.trc
                              Fri Nov 29 09:49:16 2013
                              Trace dumping is performing id=[cdmp_20131129094916]
                              Errors in file /u01/trace/diag/rdbms/mydb/mydb/trace/mydb_ora_4161.trc  (incident=5191):
                              ORA-00600: internal error code, arguments: [kck_rls_check must use (11,0,0,0,0) or lower], [xsixcd.c], [90], [11.2.0.1.0], [], [], [], [], [], [], [], []
                              Incident details in: /u01/trace/diag/rdbms/mydb/mydb/incident/incdir_5191/mydb_ora_4161_i5191.trc
                              Trace dumping is performing id=[cdmp_20131129094917]

                               

                              ORA-00600: internal error code, arguments: [kck_rls_check must use (11,0,0,0,0) or lower], [xsixcd.c], [90], [11.2.0.1.0], [], [], [], [], [], [], [], []
                              Fri Nov 29 09:59:25 2013
                              Sweep [inc][6183]: completed
                              Sweep [inc][6182]: completed
                              Sweep [inc][6181]: completed
                              Sweep [inc][6180]: completed

                              • 12. Re: upgrade 10gr2 to 11gR2 manually
                                AK_AppsDBA

                                i checked 1565321.1

                                SQL> select VALUE from v$OPTION where PARAMETER = 'OLAP';

                                         VALUE

                                           -------

                                          TRUE

                                 

                                 

                                SQL> sho parameter db_secure

                                 

                                NAME                                 TYPE        VALUE
                                ------------------------------------ ----------- ------------------------------
                                db_securefile                        string      PERMITTED

                                • 13. Re: upgrade 10gr2 to 11gR2 manually
                                  Anar Godjaev

                                  HI,

                                   

                                  In my practice when ORA-00600 error occurs then I directly open Oracle SR. Because ORA-00600 error is not approved by DBAs. I recommend you to open SR..

                                   

                                  Thank you

                                  • 14. Re: upgrade 10gr2 to 11gR2 manually
                                    Karan Kukreja

                                    Raise a SR with oracle for 0ra-600 error.

                                    1 2 Previous Next