4 Replies Latest reply on May 24, 2017 4:48 AM by Shaik

    10G to 11G upgrade

    Ibrahim Malek

      Dear friends

       

      there is a custom built job that links some objects between the siebel CRM & the GL of the acc company here in this EBS

      any recommendations in how to deal with this part? or it must be recreated after the upgrade?

       

      SQL> @/oracle/prod/d01/utlu112i.sql

      Oracle Database 11.2 Pre-Upgrade Information Tool    05-23-2017 17:45:04

      .

      **********************************************************************

      Database:

      **********************************************************************

      --> name:          PROD

      --> version:       10.2.0.3.0

      --> compatible:    10.2.0

      --> blocksize:     8192

      --> platform:      Solaris[tm] OE (64-bit)

      --> timezone file: V3

      .

      **********************************************************************

      Tablespaces: [make adjustments in the current environment]

      **********************************************************************

      --> SYSTEM tablespace is adequate for the upgrade.

      .... minimum required size: 15019 MB

      --> APPS_UNDOTS1 tablespace is adequate for the upgrade.

      .... minimum required size: 322 MB

      --> TEMP1 tablespace is adequate for the upgrade.

      .... minimum required size: 61 MB

      --> APPS_TS_QUEUES tablespace is adequate for the upgrade.

      .... minimum required size: 238 MB

      --> APPS_TS_TX_DATA tablespace is adequate for the upgrade.

      .... minimum required size: 49432 MB

      --> CTXD tablespace is adequate for the upgrade.

      .... minimum required size: 34 MB

      --> ODM tablespace is adequate for the upgrade.

      .... minimum required size: 15 MB

      --> OLAP tablespace is adequate for the upgrade.

      .... minimum required size: 31 MB

      --> SYSAUX tablespace is adequate for the upgrade.

      .... minimum required size: 3040 MB

      .

      **********************************************************************

      Flashback: OFF

      **********************************************************************

      **********************************************************************

      Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]

      **********************************************************************

      -- No update parameter changes are required.

      .

      **********************************************************************

      Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]

      **********************************************************************

      -- No renamed parameters found. No changes are required.

      .

      **********************************************************************

      Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]

      **********************************************************************

      --> background_dump_dest         11.1       DEPRECATED   replaced by

      "diagnostic_dest"

      --> user_dump_dest               11.1       DEPRECATED   replaced by

      "diagnostic_dest"

      --> core_dump_dest               11.1       DEPRECATED   replaced by

      "diagnostic_dest"

      --> plsql_native_library_dir     11.2       OBSOLETE

      --> plsql_native_library_subdir_ 11.2       OBSOLETE

      .

      **********************************************************************

      Components: [The following database components will be upgraded or installed]

      **********************************************************************

      --> Oracle Catalog Views         [upgrade]  VALID

      --> Oracle Packages and Types    [upgrade]  VALID

      --> JServer JAVA Virtual Machine [upgrade]  VALID

      --> Oracle XDK for Java          [upgrade]  VALID

      --> Real Application Clusters    [upgrade]  INVALID

      --> OLAP Analytic Workspace      [upgrade]  VALID

      --> OLAP Catalog                 [upgrade]  VALID

      --> Oracle Text                  [upgrade]  VALID

      --> Oracle XML Database          [upgrade]  VALID

      --> Oracle Java Packages         [upgrade]  VALID

      --> Oracle interMedia            [upgrade]  VALID

      --> Spatial                      [upgrade]  VALID

      --> Data Mining                  [upgrade]  VALID

      --> Oracle OLAP API              [upgrade]  VALID

      .

      **********************************************************************

      Miscellaneous Warnings

      **********************************************************************

      WARNING: --> Database is using a timezone file older than version 11.

      .... After the release migration, it is recommended that DBMS_DST package

      .... be used to upgrade the 10.2.0.3.0 database timezone version

      .... to the latest version which comes with the new release.

      WARNING: --> Database contains schemas with stale optimizer statistics.

      .... Refer to the Upgrade Guide for instructions to update

      .... schema statistics prior to upgrading the database.

      .... Component Schemas with stale statistics:

      ....   SYS

      ....   OLAPSYS

      ....   CTXSYS

      ....   XDB

      ....   MDSYS

      WARNING: --> Database contains INVALID objects prior to upgrade.

      .... The list of invalid SYS/SYSTEM objects was written to

      .... registry$sys_inv_objs.

      .... The list of non-SYS/SYSTEM objects was written to

      .... registry$nonsys_inv_objs.

      .... Use utluiobj.sql after the upgrade to identify any new invalid

      .... objects due to the upgrade.

      .... USER PUBLIC has 2 INVALID objects.

      .... USER ACCI has 1 INVALID objects.

      .... USER SQLTXADMIN has 47 INVALID objects.

      .... USER APPS has 6 INVALID objects.

      WARNING: --> Database contains schemas with objects dependent on network

      packages.

      .... Refer to the Upgrade Guide for instructions to configure Network ACLs.

      .... USER APPS has dependent objects.

      WARNING: --> There are outstanding unresolved distributed transactions.

      .... Resolve outstanding distributed transactions prior to upgrade.

      WARNING: --> Sync standby database prior to upgrade.

      WARNING:--> recycle bin in use.

      .... Your recycle bin turned on.

      .... It is REQUIRED

      .... that the recycle bin is empty prior to upgrading

      .... your database.

      .... The command:  PURGE DBA_RECYCLEBIN

      .... must be executed immediately prior to executing your upgrade.

      .

       

       

      PL/SQL procedure successfully completed.

       

       

      SQL> ^[[A^[[A^