Peoplesoft Application : Oracle database 10.2.0.4 upgrade

Upgrade a database of a Peoplesoft Application doesn't change to upgrade a standard database.

For the upgrade to 10.2.0.4 Oracle database, you'll need an additional required patch for Linux #6376928.

After upgraded the binaries, don't forget to patch the database as well and to run the utlrp.sql script.
startup upgrade
@$ORACLE_HOME/rdbms/admin/utlu102i.sql
@$ORACLE_HOME/rdbms/admin/catupgrd.sql
shutdown immediate
startup
@$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ -----------
Oracle Database Catalog Views
10.2.0.4.0 VALID

Oracle Database Packages and Types
10.2.0.4.0 VALID


2 rows selected.

WARNING : don't forget to modify the rights as well on the library file (as oracle user, under $ORACLE_HOME/lib) for the OS user who start the Application server :
[ora102@orion:/apps/oracle/10.2.0/lib]$ ls -lrt libclntsh.so*
lrwxrwxrwx 1 ora102 oinstall 12 Jan 8 21:02 libclntsh.so.9.0 -> libclntsh.so
lrwxrwxrwx 1 ora102 oinstall 17 May 13 21:48 libclntsh.so -> libclntsh.so.10.1
-rwxr-x--- 1 ora102 oinstall 19009171 May 13 21:49 libclntsh.so.10.1
[ora102@orion:/apps/oracle/10.2.0/lib]$ chmod a+rx libclntsh.so.10.1
[ora102@orion:/apps/oracle/10.2.0/lib]$ ls -lrt libclntsh.so*
lrwxrwxrwx 1 ora102 oinstall 12 Jan 8 21:02 libclntsh.so.9.0 -> libclntsh.so
lrwxrwxrwx 1 ora102 oinstall 17 May 13 21:48 libclntsh.so -> libclntsh.so.10.1
-rwxr-xr-x 1 ora102 oinstall 19009171 May 13 21:49 libclntsh.so.10.1
[ora102@orion:/apps/oracle/10.2.0/lib]$
If you forget the step above, you may encoutered issue on the Application server start (Missing or invalid version of SQL library libpsora)

It was quite fast, despite the size and number of objects of the Peoplesoft databases.