Monthly Archives: August 2007

Oracle Database 10.2 Upgrade Information Utility Output

Posted by on August 30, 2007 No comments

SQL> @ utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility 08-30-2007 18:57:10
.
**********************************************************************
Database:
**********************************************************************
–> name: PROD
–> version: 9.2.0.8.0
–> compatible: 9.2.0
–> blocksize: 8192
.
**********************************************************************
Logfiles: [make adjustments in the current environment]
**********************************************************************
–> The existing log files are adequate. No changes are required.
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
–> SYSTEM tablespace is adequate for the upgrade.
…. minimum required size: 7139 MB
–> CTXD tablespace is adequate for the upgrade.
…. minimum required size: 17 MB
–> APPLSYSD tablespace is adequate for the upgrade.
…. minimum required size: 18597 MB
–> CCTD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> ARD tablespace is adequate for the upgrade.
…. minimum required size: 268 MB
–> OKCD tablespace is adequate for the upgrade.
…. minimum required size: 33 MB
–> AMVD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> XNPD tablespace is adequate for the upgrade.
…. minimum required size: 9 MB
–> XDPD tablespace is adequate for the upgrade.
…. minimum required size: 8 MB
–> IEOD tablespace is adequate for the upgrade.
…. minimum required size: 4 MB
–> IBUD tablespace is adequate for the upgrade.
…. minimum required size: 1 MB
–> IEMD tablespace is adequate for the upgrade.
…. minimum required size: 8 MB
–> JTFD tablespace is adequate for the upgrade.
…. minimum required size: 63 MB
–> ASOD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> TEMP tablespace is adequate for the upgrade.
…. minimum required size: 58 MB
–> APPS_UNDOTS1 tablespace is adequate for the upgrade.
…. minimum required size: 286 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
WARNING: –> “streams_pool_size” is not currently defined and needs a value of
at least 50331648
WARNING: –> “session_max_open_files” needs to be increased to at least 20
.
**********************************************************************
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]
**********************************************************************
–> “optimizer_max_permutations”
–> “row_locking”
–> “undo_suppress_errors”
–> “log_archive_start”
–> “max_enabled_roles”
–> “enqueue_resources”
.
**********************************************************************
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
…The ‘JServer JAVA Virtual Machine’ JAccelerator (NCOMP)
…is required to be installed from the 10g Companion CD.
–> Oracle XDK for Java [upgrade] VALID
–> Oracle Java Packages [upgrade] VALID
–> Oracle Text [upgrade] VALID
–> Oracle XML Database [install]
–> Real Application Clusters [upgrade] INVALID
–> Oracle interMedia [upgrade] VALID
…The ‘Oracle interMedia Image Accelerator’ is
…required to be installed from the 10g Companion CD.
–> Spatial [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: –> Passwords exist in some database links.
…. Passwords will be encrypted during the upgrade.
…. Downgrade of database links with passwords is not supported.
WARNING: –> Deprecated CONNECT role granted to some user/roles.
…. CONNECT role after upgrade has only CREATE SESSION privilege.
WARNING: –> Database contains stale optimizer statistics.
…. Refer to the 10g Upgrade Guide for instructions to update
…. statistics prior to upgrading the database.
…. Component Schemas with stale statistics:
…. SYS
…. CTXSYS
…. ORDSYS
…. MDSYS
WARNING: –> Database contains INVALID objects prior to upgrade.
…. USER APPS has 4 INVALID objects.
…. USER DISCOVERER has 1 INVALID objects.
…. USER PERFSTAT has 1 INVALID objects.
…. USER SPOTLIGHT has 2 INVALID objects.
…. USER SYS has 5 INVALID objects.
…. USER VTAS_I3_ORCL has 40 INVALID objects.
.
**********************************************************************
SYSAUX Tablespace:
[Create tablespace in the Oracle Database 10.2 environment]
**********************************************************************
–> New “SYSAUX” tablespace
…. minimum required size for database upgrade: 500 MB
.

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> spool off

Patch List – Production Upgrade

Posted by on August 12, 2007 No comments
Sno Patch Number Description Remarks
1 4238286 Tums
2 4712852 AD.i.4 Patch Got An issue while applying on
Apps Node while Relinking Refer
Log Notes
3 5107107 AutoConfig Update
Patch
4 4318672 Technology Stack
Utility Patch
5 9iAS Installation This Patch will Install This Step includes set of
iAS and Developer Patches which is same in Main
Project Plan
6 9i Upgrade Database Upgrade This steps includes set of
Patches which is same in Main
Project Plan
Note : After Database Upgrade Process
Got an issue while Starting up the Instance
Refer log Notes
7 3180164 New Product and New TBS
8 3480000 Maintenance Patch Got an Issue while applying on Admin Node
refer to Log Notes and also it took 3 days on
admin node
9 3275245 Online Help Patch This Patch Will be Applied after Go-Live
10 5117525 Jinitiator Upgrade Patch This patch should apply as a Part of Jinitiator
11 JDK Upgrade
12 5759055 TXK and ADX patch This Patch is should be applied as part of 10g
Upgrade as Pre-Reqs
13 4653225 10g Upgrade This Patch should as 10g pre-req Upgrade
14 10g Upgrade Actual 10g upgrade process
15 5753621 Receivables Patch
16 3636980 Diagnostic Patch
17 5529008 Diag Support Patch

Pre-Upgrade Checks On Production

Posted by on August 12, 2007 No comments

1. Check the Invalid Objects in the existing Production Instance and Spool the output

2. Check the Size of existing SGA in Production

3. Check the Number of Tablespaces along with free space

4. Check the Number of Datafiles/Log/Control files in Production

5. Run Autoconfig on both Both Nodes just to make sure that autoconfig run successful on both nodes…Note: This must be done when users logout from application

6. Relink any Executable eg.FNDLIBR using adadmin or adrelink command on both nodes just to make sure that there is no relink issue for any module

7. Check the Installed or Shared Modules on existing Production Instance along with it Patch Level

8. Turn Off Archive Log mode

Note: Except step 5,6,8 spool the output and store it for further reference

Additional steps:

a. Obtain URL, port of instance

b. Obtain username and password of essential Oracle users (apps, system, sys) and OS users (applmgr, root)

c. Obtain username, password for user with System Administrator responsibility, to test concurrent programs (e.g. Active Users)

d. Determine and note location of database files, log files, control files, archive log files

e. Note location of top directories (APPL_TOP, COMMON_TOP, ORA_TOP, DB_TOP, DATA_TOP)

f. Determine status of archivelog mode (and turn off if necessary)

g. Record PERL location and version

h. Rerun AutoConfig on database, application tiers to ensure it is working

I. Run adrelink on database, application to ensure it is working

j. Source environment and ensure environment variables correct (e.g. APPLCSF)

k. Ensure UNIX commands available (cc, ld, make/gnumake, ar)

ojspcompile.pl Errors With ‘Xml File Not Found’

Posted by on August 5, 2007 No comments

After running patch 4712852,

error! could not find autoconfigure’s XMLFILE

Solution: Metalink Doc ID: 374676.1 (Subject: Ojspcompile.pl Errors With ‘Xml File Not Found’ During Patching In a RAC Environment)

had the following solution:

To implement the solution, please execute the following steps:

1. Apply 4709948, ‘TXK (FND) AUTOCONFIG TEMPLATE ROLLUP PATCH M (APRIL 2006)’
2. Retest.

This patch is included in patch 5759055, which will be applied next.

SOLUTION:

Rreran patch 4712852, perl -x /emca/PROD/prodappl/jtf/11.5.0/admin/scripts/ojspCompile.pl –compile –quiet
ran successfully.