Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0.1) [ID 1265268.1]
Database Server Upgrade/Downgrade Compatibility Matrix [ID 551141.1]
Upgrade Compatibility Matrix for Upgrading to 11.2.x
Minimum Version of the database that can be directly upgraded to Oracle 11g Release 2
Source Database Destination Database
9.2.0.8 (or higher) 11.2.x
10.1.0.5 (or higher) 11.2.x
10.2.0.2 (or higher) 11.2.x
11.1.0.6 (or higher) 11.2.x
Upgrade ADVERSION:
Apply the below ADPatch 7429271
Upgrade 9.2.0.5 to 9.2.0.8 Installation Steps Click here
[oracle@ebus 9.2.0]$ $ORACLE_HOME/appsutil/bin/adgentns.pl appspass=apps contextfile=$CONTEXT_FILE -removeserver
##########################################################################
Generate Tns Names
##########################################################################
Using java command: /disk2/PROD11/prod11db/9.2.0/jre/1.4.2/bin/java
JAVA_HOME :
Java version : 1.4.2_02
Classpath : /disk2/PROD11/prod11db/9.2.0/jre/1.4.2/lib/rt.jar:/disk2/PROD11/prod11db/9.2.0/jdbc/lib/ojdbc14.jar:/disk2/PROD11/prod11db/9.2.0/appsutil/java/xmlparserv2.zip:/disk2/PROD11/prod11db/9.2.0/appsutil/java
Loading ORACLE_HOME environment from /disk2/PROD11/prod11db/9.2.0
Logfile: /disk2/PROD11/prod11db/9.2.0/appsutil/log/PROD11_ebus/02161417/NetServiceHandler.log
adgentns.pl exiting with status 0
ERRORCODE = 0 ERRORCODE_END
[oracle@ebus 9.2.0]$ sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.8.0 - Production on Thu Feb 16 14:20:06 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL> @utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 02-16-2012 14:20:22
.
**********************************************************************
Database:
**********************************************************************
--> name: PROD11
--> version: 9.2.0.8.0
--> compatible: 9.2.0
--> blocksize: 8192
--> timezone file: V1
.
**********************************************************************
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: 7869 MB
--> ODM tablespace is adequate for the upgrade.
.... minimum required size: 10 MB
--> APPS_UNDOTS1 tablespace is adequate for the upgrade.
.... minimum required size: 1 MB
--> APPS_TS_QUEUES tablespace is adequate for the upgrade.
.... minimum required size: 21 MB
--> OLAP tablespace is adequate for the upgrade.
.... minimum required size: 16 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
WARNING: --> "compatible" must be set to at least 10.1.0
.
**********************************************************************
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]
**********************************************************************
--> optimizer_max_permutations 10.1 OBSOLETE
--> row_locking 10.1 OBSOLETE
--> undo_suppress_errors 10.1 OBSOLETE
--> max_enabled_roles 10.1 DEPRECATED
--> enqueue_resources 10.2 OBSOLETE
--> sql_trace 10.2 DEPRECATED
--> 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"
.
**********************************************************************
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] LOADED
--> OLAP Catalog [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [install]
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Data Mining [upgrade] VALID
--> Oracle OLAP API [upgrade] LOADED
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> The database has not been patched to release 9.2.0.8.0.
... Run catpatch.sql prior to upgrading.
Solution:
sql>@rdbms/admin/catpatch.sql
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 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 9.2.0.8.0 database timezone version
.... to the latest version which comes with the new release.
solution:
Timezone using 553812.1 Already the timezone is at 4!
SELECT version FROM v$timezone_file;
version 4 no problem
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
.... MDSYS
.... ODM
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 APPLSYS has 1 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.
.... USER MDSYS has dependent objects.
.
**********************************************************************
SYSAUX Tablespace:
[Create tablespace in the Oracle Database 11.2 environment]
**********************************************************************
--> New "SYSAUX" tablespace
.... minimum required size for database upgrade: 500 MB
.
Solution:
SQL> create tablespace SYSAUX datafile '/disk2/PROD11/prod11data/sysaux01.dbf' size 600M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
PL/SQL procedure successfully completed.
SQL>
Install 11.2.0.1 Oracle Database Software
Profile:
export ORACLE_HOME=/disk2/PROD11/prod11db/11.2.0/dbhome_1
export ORACLE_SID=PROD11
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export TNS_ADMIN=$ORACLE_HOME/network/admin/PROD11_ebus
export ORACLE_TERM=xterm
export ORACLE_OWNER=oracle
export TNS_ADMIN=$ORACLE_HOME/network/admin
export CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export LDPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORA_NLS10=$ORACLE_HOME/nls/data/9idata
[oracle@ebus old]$ pwd
/disk2/PROD11/prod11db/11.2.0/dbhome_1/nls/data/old
[oracle@ebus old]$ perl cr9idata.pl
Directory /disk2/PROD11/prod11db/11.2.0/dbhome_1/nls/data/9idata already exist. Overwriting...
Copying files to /disk2/PROD11/prod11db/11.2.0/dbhome_1/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /disk2/PROD11/prod11db/11.2.0/dbhome_1/nls/data/9idata!
[oracle@ebus old]$ cd $ORACLE_HOME/nls/data/9idata
shutdown application,database,listener...
and apply opatch
Apply additional 11.2.0.1 RDBMS patches
For UNIX/Linux platforms, apply the following RDBMS patches to the 11.2.0 Oracle home:
* 8570322
* 8685327
* 8761974
* 8771297
* 8772028 --replace by 12672969
* 8796511
* 8897784
* 8964142
For Linux and Linux x86-64 platforms, apply 8405205
[oracle@ebus 8570322]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-19-04PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8570322' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the lo
Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8570322' for restore. This might take a
Backing up files affected by the patch '8570322' for rollback. This might take a
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libgeneric11.a
Patching component oracle.rdbms.rsf, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libgeneric11.a
Running make for target client_sharedlib
Running make for target ioracle
ApplySession adding interim patch '8570322' to inventory
Verifying the update...
Inventory check OK: Patch ID 8570322 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8570322 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8570322]$ cd ../8685327/
[oracle@ebus 8685327]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-21-11PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8685327' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8685327' for restore. This might take a while...
Backing up files affected by the patch '8685327' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kkoap.o"
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/qksbg.o"
Running make for target ioracle
ApplySession adding interim patch '8685327' to inventory
Verifying the update...
Inventory check OK: Patch ID 8685327 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8685327 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8685327]$cd ../8761974/
[oracle@ebus 8761974]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-22-49PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8761974' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8761974' for restore. This might take a while...
Backing up files affected by the patch '8761974' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kko.o"
Running make for target ioracle
ApplySession adding interim patch '8761974' to inventory
Verifying the update...
Inventory check OK: Patch ID 8761974 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8761974 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8761974]$cd ../8771297/
[oracle@ebus 8771297]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-23-50PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8771297' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8771297' for restore. This might take a while...
Backing up files affected by the patch '8771297' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kkqvm.o"
Running make for target ioracle
ApplySession adding interim patch '8771297' to inventory
Verifying the update...
Inventory check OK: Patch ID 8771297 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8771297 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8771297]$ cd ../12672969/
[oracle@ebus 12672969]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-30-54PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '12672969' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '12672969' for restore. This might take a while...
Backing up files affected by the patch '12672969' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kkqobe.o"
Running make for target ioracle
ApplySession adding interim patch '12672969' to inventory
Verifying the update...
Inventory check OK: Patch ID 12672969 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 12672969 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 12672969]$ cd ../8796511/
[oracle@ebus 8796511]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-33-13PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8796511' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8796511' for restore. This might take a while...
Backing up files affected by the patch '8796511' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kzu.o"
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/ktt.o"
Running make for target ioracle
ApplySession adding interim patch '8796511' to inventory
Verifying the update...
Inventory check OK: Patch ID 8796511 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8796511 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8796511]$cd 8796511/
[oracle@ebus 8796511]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-33-13PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8796511' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8796511' for restore. This might take a while...
Backing up files affected by the patch '8796511' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kzu.o"
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/ktt.o"
Running make for target ioracle
ApplySession adding interim patch '8796511' to inventory
Verifying the update...
Inventory check OK: Patch ID 8796511 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8796511 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8796511]$ cd ../
[oracle@ebus patches]$ unzip p8897784_112010_LINUX.zip
Archive: p8897784_112010_LINUX.zip
creating: 8897784/
creating: 8897784/files/
creating: 8897784/files/lib/
creating: 8897784/files/lib/libserver11.a/
inflating: 8897784/files/lib/libserver11.a/kwqid.o
creating: 8897784/etc/
creating: 8897784/etc/config/
inflating: 8897784/etc/config/inventory.xml
inflating: 8897784/etc/config/actions.xml
creating: 8897784/etc/xml/
inflating: 8897784/etc/xml/GenericActions.xml
inflating: 8897784/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 8897784/README.txt
[oracle@ebus patches]$ cd ../8897784/
[oracle@ebus 8897784]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-34-19PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8897784' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8897784' for restore. This might take a while...
Backing up files affected by the patch '8897784' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kwqid.o"
Running make for target ioracle
ApplySession adding interim patch '8897784' to inventory
Verifying the update...
Inventory check OK: Patch ID 8897784 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8897784 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8897784]$cd ../8964142/
[oracle@ebus 8964142]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-35-20PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8964142' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8964142' for restore. This might take a while...
Backing up files affected by the patch '8964142' for rollback. This might take a while...
Patching component oracle.rdbms.dbscripts, 11.2.0.1.0...
Copying file to "/disk2/PROD11/prod11db/11.2.0/dbhome_1/rdbms/admin/catmeta.sql"
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kkzf.o"
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kkzl.o"
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/prsc.o"
Running make for target ioracle
ApplySession adding interim patch '8964142' to inventory
Verifying the update...
Inventory check OK: Patch ID 8964142 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8964142 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8964142]$
[oracle@ebus dbhome_1]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 16 15:41:52 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 535699456 bytes
Fixed Size 1337604 bytes
Variable Size 356517628 bytes
Database Buffers 163577856 bytes
Redo Buffers 14266368 bytes
Database mounted.
Database opened.
SQL>@rdbms/admin/catupgrd.sql
SQL>startup
ORACLE instance started.
Total System Global Area 535699456 bytes
Fixed Size 1337604 bytes
Variable Size 356517628 bytes
Database Buffers 163577856 bytes
Redo Buffers 14266368 bytes
Database mounted.
Database opened.
SQL>@../rdbms/admin/utlrp.sql
Create Listner using netca
Install Oracle Data Mining and OLAP
Verify that Oracle Data Mining and OLAP are installed in your database by using SQL*Plus to connect to the database as SYSDBA and running the following command:
SQL> connect / as sysdba;
SQL> select comp_id from dba_registry where comp_id='ODM' or comp_id='AMD';
If the query does not return ODM, then you do not have Oracle Data Mining installed. To install Data Mining, use SQL*Plus to connect to the database as SYSDBA and run the following command:
SQL> connect / as sysdba;
SQL> @$ORACLE_HOME/rdbms/admin/dminst.sql SYSAUX TEMP
If the query does not return AMD, then you do not have OLAP installed. To install OLAP, use SQL*Plus to connect to the database as SYSDBA and run the following command:
SQL> connect / as sysdba;
SQL> @$ORACLE_HOME/olap/admin/olap.sql SYSAUX TEMP
Fix Korean lexers (conditional)
If you upgraded from 10.1.0 or previous releases, use SQL*Plus to connect to the database as SYSDBA, and run drkorean.sql using the following command:
SQL> @$ORACLE_HOME/ctx/sample/script/drkorean.sql
List of indexes that use KOREAN_LEXER as top level lexer:
List of indexes that use KOREAN_LEXER as a sub lexer:
"APPLSYS"."FND_LOBS_CTX"
"CS"."CS_FORUM_MESSAGES_TL_N4"
"CS"."CS_KB_ELEMENTS_TL_N2"
"CS"."CS_KB_SETS_TL_N3"
"CS"."CS_KB_SOLN_CAT_TL_N1"
"ICX"."ICX_QUES_CTX"
Migrate KOREAN_LEXER to KOREAN_MORPH_LEXER
Rebuild all indexes that use korean lexer as top level lexer:
Reindex all documents that use KOREAN_LEXER as sub lexer
reindexing : "APPLSYS"."FND_LOBS" finished.
reindexing : "CS"."CS_FORUM_MESSAGES_TL" finished.
reindexing : "CS"."CS_KB_ELEMENTS_TL" finished.
reindexing : "CS"."CS_KB_SETS_TL" finished.
reindexing : "CS"."CS_KB_SOLN_CATEGORIES_TL" finished.
reindexing : "ICX"."ICX_QUESTIONS_TL" finished.
Run adgrants.sql
Copy $APPL_TOP/admin/adgrants.sql (adgrants_nt.sql for Windows) from the administration server node to the database server node. Use SQL*Plus to connect to the database as SYSDBA and run the script using the following command:
$ sqlplus "/ as sysdba" @adgrants.sql (or adgrants_nt.sql)
[APPS schema name]
Set CTXSYS parameter
Use SQL*Plus to connect to the database as SYSDBA and run the following command:
$ sqlplus "/ as sysdba"
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');
Grant create procedure privilege on CTXSYS
Copy $AD_TOP/patch/115/sql/adctxprv.sql from the administration server node to the database server node. If you are upgrading to Gather statistics for SYS schema
Copy $APPL_TOP/admin/adstats.sql from the administration server node to the database server node. If you are upgrading to R12, use the R12 version of the file. Note that adstats.sql has to be run in restricted mode. Use SQL*Plus to connect to the database as SYSDBA and use the following commands to restart the database in restricted mode, run adstats.sql, and restart the database in normal mode:
$ sqlplus "/ as sysdba"
SQL> shutdown normal;
SQL> startup restrict;
SQL> @adstats.sql
SQL> shutdown normal;
SQL> startup;
SQL> exit;
R12, use the R12 version of the file. Use SQL*Plus to connect to the database as APPS and run the script using the following command:
$ sqlplus apps/[APPS password] @adctxprv.sql \
[SYSTEM password] CTXSYS
Part 2 Click here
Database Server Upgrade/Downgrade Compatibility Matrix [ID 551141.1]
Upgrade Compatibility Matrix for Upgrading to 11.2.x
Minimum Version of the database that can be directly upgraded to Oracle 11g Release 2
Source Database Destination Database
9.2.0.8 (or higher) 11.2.x
10.1.0.5 (or higher) 11.2.x
10.2.0.2 (or higher) 11.2.x
11.1.0.6 (or higher) 11.2.x
Upgrade ADVERSION:
Apply the below ADPatch 7429271
Upgrade 9.2.0.5 to 9.2.0.8 Installation Steps Click here
[oracle@ebus 9.2.0]$ $ORACLE_HOME/appsutil/bin/adgentns.pl appspass=apps contextfile=$CONTEXT_FILE -removeserver
##########################################################################
Generate Tns Names
##########################################################################
Using java command: /disk2/PROD11/prod11db/9.2.0/jre/1.4.2/bin/java
JAVA_HOME :
Java version : 1.4.2_02
Classpath : /disk2/PROD11/prod11db/9.2.0/jre/1.4.2/lib/rt.jar:/disk2/PROD11/prod11db/9.2.0/jdbc/lib/ojdbc14.jar:/disk2/PROD11/prod11db/9.2.0/appsutil/java/xmlparserv2.zip:/disk2/PROD11/prod11db/9.2.0/appsutil/java
Loading ORACLE_HOME environment from /disk2/PROD11/prod11db/9.2.0
Logfile: /disk2/PROD11/prod11db/9.2.0/appsutil/log/PROD11_ebus/02161417/NetServiceHandler.log
adgentns.pl exiting with status 0
ERRORCODE = 0 ERRORCODE_END
[oracle@ebus 9.2.0]$ sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.8.0 - Production on Thu Feb 16 14:20:06 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL> @utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 02-16-2012 14:20:22
.
**********************************************************************
Database:
**********************************************************************
--> name: PROD11
--> version: 9.2.0.8.0
--> compatible: 9.2.0
--> blocksize: 8192
--> timezone file: V1
.
**********************************************************************
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: 7869 MB
--> ODM tablespace is adequate for the upgrade.
.... minimum required size: 10 MB
--> APPS_UNDOTS1 tablespace is adequate for the upgrade.
.... minimum required size: 1 MB
--> APPS_TS_QUEUES tablespace is adequate for the upgrade.
.... minimum required size: 21 MB
--> OLAP tablespace is adequate for the upgrade.
.... minimum required size: 16 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
WARNING: --> "compatible" must be set to at least 10.1.0
.
**********************************************************************
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]
**********************************************************************
--> optimizer_max_permutations 10.1 OBSOLETE
--> row_locking 10.1 OBSOLETE
--> undo_suppress_errors 10.1 OBSOLETE
--> max_enabled_roles 10.1 DEPRECATED
--> enqueue_resources 10.2 OBSOLETE
--> sql_trace 10.2 DEPRECATED
--> 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"
.
**********************************************************************
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] LOADED
--> OLAP Catalog [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [install]
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Data Mining [upgrade] VALID
--> Oracle OLAP API [upgrade] LOADED
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> The database has not been patched to release 9.2.0.8.0.
... Run catpatch.sql prior to upgrading.
Solution:
sql>@rdbms/admin/catpatch.sql
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 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 9.2.0.8.0 database timezone version
.... to the latest version which comes with the new release.
solution:
Timezone using 553812.1 Already the timezone is at 4!
SELECT version FROM v$timezone_file;
version 4 no problem
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
.... MDSYS
.... ODM
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 APPLSYS has 1 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.
.... USER MDSYS has dependent objects.
.
**********************************************************************
SYSAUX Tablespace:
[Create tablespace in the Oracle Database 11.2 environment]
**********************************************************************
--> New "SYSAUX" tablespace
.... minimum required size for database upgrade: 500 MB
.
Solution:
SQL> create tablespace SYSAUX datafile '/disk2/PROD11/prod11data/sysaux01.dbf' size 600M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
PL/SQL procedure successfully completed.
SQL>
Install 11.2.0.1 Oracle Database Software
Profile:
export ORACLE_HOME=/disk2/PROD11/prod11db/11.2.0/dbhome_1
export ORACLE_SID=PROD11
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export TNS_ADMIN=$ORACLE_HOME/network/admin/PROD11_ebus
export ORACLE_TERM=xterm
export ORACLE_OWNER=oracle
export TNS_ADMIN=$ORACLE_HOME/network/admin
export CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export LDPATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32
export ORA_NLS10=$ORACLE_HOME/nls/data/9idata
[oracle@ebus old]$ pwd
/disk2/PROD11/prod11db/11.2.0/dbhome_1/nls/data/old
[oracle@ebus old]$ perl cr9idata.pl
Directory /disk2/PROD11/prod11db/11.2.0/dbhome_1/nls/data/9idata already exist. Overwriting...
Copying files to /disk2/PROD11/prod11db/11.2.0/dbhome_1/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /disk2/PROD11/prod11db/11.2.0/dbhome_1/nls/data/9idata!
[oracle@ebus old]$ cd $ORACLE_HOME/nls/data/9idata
shutdown application,database,listener...
and apply opatch
Apply additional 11.2.0.1 RDBMS patches
For UNIX/Linux platforms, apply the following RDBMS patches to the 11.2.0 Oracle home:
* 8570322
* 8685327
* 8761974
* 8771297
* 8772028 --replace by 12672969
* 8796511
* 8897784
* 8964142
For Linux and Linux x86-64 platforms, apply 8405205
[oracle@ebus 8570322]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-19-04PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8570322' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the lo
Please shutdown Oracle instances running out of this ORACLE_HOME on the local sy
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8570322' for restore. This might take a
Backing up files affected by the patch '8570322' for rollback. This might take a
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libgeneric11.a
Patching component oracle.rdbms.rsf, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libgeneric11.a
Running make for target client_sharedlib
Running make for target ioracle
ApplySession adding interim patch '8570322' to inventory
Verifying the update...
Inventory check OK: Patch ID 8570322 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8570322 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8570322]$ cd ../8685327/
[oracle@ebus 8685327]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-21-11PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8685327' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8685327' for restore. This might take a while...
Backing up files affected by the patch '8685327' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kkoap.o"
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/qksbg.o"
Running make for target ioracle
ApplySession adding interim patch '8685327' to inventory
Verifying the update...
Inventory check OK: Patch ID 8685327 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8685327 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8685327]$cd ../8761974/
[oracle@ebus 8761974]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-22-49PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8761974' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8761974' for restore. This might take a while...
Backing up files affected by the patch '8761974' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kko.o"
Running make for target ioracle
ApplySession adding interim patch '8761974' to inventory
Verifying the update...
Inventory check OK: Patch ID 8761974 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8761974 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8761974]$cd ../8771297/
[oracle@ebus 8771297]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-23-50PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8771297' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8771297' for restore. This might take a while...
Backing up files affected by the patch '8771297' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kkqvm.o"
Running make for target ioracle
ApplySession adding interim patch '8771297' to inventory
Verifying the update...
Inventory check OK: Patch ID 8771297 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8771297 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8771297]$ cd ../12672969/
[oracle@ebus 12672969]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-30-54PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '12672969' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '12672969' for restore. This might take a while...
Backing up files affected by the patch '12672969' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kkqobe.o"
Running make for target ioracle
ApplySession adding interim patch '12672969' to inventory
Verifying the update...
Inventory check OK: Patch ID 12672969 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 12672969 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 12672969]$ cd ../8796511/
[oracle@ebus 8796511]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-33-13PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8796511' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8796511' for restore. This might take a while...
Backing up files affected by the patch '8796511' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kzu.o"
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/ktt.o"
Running make for target ioracle
ApplySession adding interim patch '8796511' to inventory
Verifying the update...
Inventory check OK: Patch ID 8796511 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8796511 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8796511]$cd 8796511/
[oracle@ebus 8796511]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-33-13PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8796511' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8796511' for restore. This might take a while...
Backing up files affected by the patch '8796511' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kzu.o"
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/ktt.o"
Running make for target ioracle
ApplySession adding interim patch '8796511' to inventory
Verifying the update...
Inventory check OK: Patch ID 8796511 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8796511 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8796511]$ cd ../
[oracle@ebus patches]$ unzip p8897784_112010_LINUX.zip
Archive: p8897784_112010_LINUX.zip
creating: 8897784/
creating: 8897784/files/
creating: 8897784/files/lib/
creating: 8897784/files/lib/libserver11.a/
inflating: 8897784/files/lib/libserver11.a/kwqid.o
creating: 8897784/etc/
creating: 8897784/etc/config/
inflating: 8897784/etc/config/inventory.xml
inflating: 8897784/etc/config/actions.xml
creating: 8897784/etc/xml/
inflating: 8897784/etc/xml/GenericActions.xml
inflating: 8897784/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 8897784/README.txt
[oracle@ebus patches]$ cd ../8897784/
[oracle@ebus 8897784]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-34-19PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8897784' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8897784' for restore. This might take a while...
Backing up files affected by the patch '8897784' for rollback. This might take a while...
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kwqid.o"
Running make for target ioracle
ApplySession adding interim patch '8897784' to inventory
Verifying the update...
Inventory check OK: Patch ID 8897784 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8897784 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8897784]$cd ../8964142/
[oracle@ebus 8964142]$ opatch apply
Invoking OPatch 11.1.0.6.6
Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /disk2/PROD11/prod11db/11.2.0/dbhome_1
Central Inventory : /etc/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.6
OUI version : 11.2.0.1.0
OUI location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/oui
Log file location : /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-02-16_15-35-20PM.log
Patch history file: /disk2/PROD11/prod11db/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '8964142' to OH '/disk2/PROD11/prod11db/11.2.0/dbhome_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/disk2/PROD11/prod11db/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8964142' for restore. This might take a while...
Backing up files affected by the patch '8964142' for rollback. This might take a while...
Patching component oracle.rdbms.dbscripts, 11.2.0.1.0...
Copying file to "/disk2/PROD11/prod11db/11.2.0/dbhome_1/rdbms/admin/catmeta.sql"
Patching component oracle.rdbms, 11.2.0.1.0...
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kkzf.o"
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/kkzl.o"
Updating archive file "/disk2/PROD11/prod11db/11.2.0/dbhome_1/lib/libserver11.a" with "lib/libserver11.a/prsc.o"
Running make for target ioracle
ApplySession adding interim patch '8964142' to inventory
Verifying the update...
Inventory check OK: Patch ID 8964142 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8964142 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@ebus 8964142]$
[oracle@ebus dbhome_1]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 16 15:41:52 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 535699456 bytes
Fixed Size 1337604 bytes
Variable Size 356517628 bytes
Database Buffers 163577856 bytes
Redo Buffers 14266368 bytes
Database mounted.
Database opened.
SQL>@rdbms/admin/catupgrd.sql
SQL>startup
ORACLE instance started.
Total System Global Area 535699456 bytes
Fixed Size 1337604 bytes
Variable Size 356517628 bytes
Database Buffers 163577856 bytes
Redo Buffers 14266368 bytes
Database mounted.
Database opened.
SQL>@../rdbms/admin/utlrp.sql
Create Listner using netca
Install Oracle Data Mining and OLAP
Verify that Oracle Data Mining and OLAP are installed in your database by using SQL*Plus to connect to the database as SYSDBA and running the following command:
SQL> connect / as sysdba;
SQL> select comp_id from dba_registry where comp_id='ODM' or comp_id='AMD';
If the query does not return ODM, then you do not have Oracle Data Mining installed. To install Data Mining, use SQL*Plus to connect to the database as SYSDBA and run the following command:
SQL> connect / as sysdba;
SQL> @$ORACLE_HOME/rdbms/admin/dminst.sql SYSAUX TEMP
If the query does not return AMD, then you do not have OLAP installed. To install OLAP, use SQL*Plus to connect to the database as SYSDBA and run the following command:
SQL> connect / as sysdba;
SQL> @$ORACLE_HOME/olap/admin/olap.sql SYSAUX TEMP
Fix Korean lexers (conditional)
If you upgraded from 10.1.0 or previous releases, use SQL*Plus to connect to the database as SYSDBA, and run drkorean.sql using the following command:
SQL> @$ORACLE_HOME/ctx/sample/script/drkorean.sql
List of indexes that use KOREAN_LEXER as top level lexer:
List of indexes that use KOREAN_LEXER as a sub lexer:
"APPLSYS"."FND_LOBS_CTX"
"CS"."CS_FORUM_MESSAGES_TL_N4"
"CS"."CS_KB_ELEMENTS_TL_N2"
"CS"."CS_KB_SETS_TL_N3"
"CS"."CS_KB_SOLN_CAT_TL_N1"
"ICX"."ICX_QUES_CTX"
Migrate KOREAN_LEXER to KOREAN_MORPH_LEXER
Rebuild all indexes that use korean lexer as top level lexer:
Reindex all documents that use KOREAN_LEXER as sub lexer
reindexing : "APPLSYS"."FND_LOBS" finished.
reindexing : "CS"."CS_FORUM_MESSAGES_TL" finished.
reindexing : "CS"."CS_KB_ELEMENTS_TL" finished.
reindexing : "CS"."CS_KB_SETS_TL" finished.
reindexing : "CS"."CS_KB_SOLN_CATEGORIES_TL" finished.
reindexing : "ICX"."ICX_QUESTIONS_TL" finished.
Run adgrants.sql
Copy $APPL_TOP/admin/adgrants.sql (adgrants_nt.sql for Windows) from the administration server node to the database server node. Use SQL*Plus to connect to the database as SYSDBA and run the script using the following command:
$ sqlplus "/ as sysdba" @adgrants.sql (or adgrants_nt.sql)
[APPS schema name]
Set CTXSYS parameter
Use SQL*Plus to connect to the database as SYSDBA and run the following command:
$ sqlplus "/ as sysdba"
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');
Grant create procedure privilege on CTXSYS
Copy $AD_TOP/patch/115/sql/adctxprv.sql from the administration server node to the database server node. If you are upgrading to Gather statistics for SYS schema
Copy $APPL_TOP/admin/adstats.sql from the administration server node to the database server node. If you are upgrading to R12, use the R12 version of the file. Note that adstats.sql has to be run in restricted mode. Use SQL*Plus to connect to the database as SYSDBA and use the following commands to restart the database in restricted mode, run adstats.sql, and restart the database in normal mode:
$ sqlplus "/ as sysdba"
SQL> shutdown normal;
SQL> startup restrict;
SQL> @adstats.sql
SQL> shutdown normal;
SQL> startup;
SQL> exit;
R12, use the R12 version of the file. Use SQL*Plus to connect to the database as APPS and run the script using the following command:
$ sqlplus apps/[APPS password] @adctxprv.sql \
[SYSTEM password] CTXSYS
Part 2 Click here
No comments:
Post a Comment