Ran into a problem trying to upgrade my Oracle instance from 10.2.0.1 to 10.2.0.4:
“Preparing to launch Oracle Universal Installer from /tmp/OraInstall2009-07-14_10-28-22AM. Please wait …oracle@dbserver:/u04/database$ Exception in thread “main” java.lang.UnsatisfiedLinkError: /tmp/OraInstall2009-07-14_10-28-22AM/jre/1.4.2/lib i386/motif21/libmawt.so: ld.so.1: java: fatal: libXm.so.4: open failed: No such file or directory”
but looks like it’s been seen before from looking at this thread on OpenSolaris.org
The workaround is to use the Java version that comes with OpenSolaris:
./runInstaller -jreLoc /usr/java/jre -ignoreSysPrereqs
Once that was complete it was easy to complete the upgrade:
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
Some time later:
TIMESTAMP
——————————————————————————–
COMP_TIMESTAMP UPGRD_END 2009-07-14 11:19:21
.
Oracle Database 10.2 Upgrade Status Utility 07-14-2009 11:19:21
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:14:04
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:02:48
Oracle XDK VALID 10.2.0.4.0 00:00:34
Oracle Database Java Packages VALID 10.2.0.4.0 00:00:30
Oracle Text VALID 10.2.0.4.0 00:00:51
Oracle XML Database VALID 10.2.0.4.0 00:02:28
Oracle Workspace Manager VALID 10.2.0.4.3 00:00:41
Oracle Data Mining VALID 10.2.0.4.0 00:00:24
OLAP Analytic Workspace VALID 10.2.0.4.0 00:00:27
OLAP Catalog VALID 10.2.0.4.0 00:01:04
Oracle OLAP API VALID 10.2.0.4.0 00:00:57
Oracle interMedia VALID 10.2.0.4.0 00:03:22
Spatial VALID 10.2.0.4.0 00:01:29
Oracle Expression Filter VALID 10.2.0.4.0 00:00:14
Oracle Enterprise Manager VALID 10.2.0.4.0 00:01:10
Oracle Rule Manager VALID 10.2.0.4.0 00:00:11
.
Total Upgrade Time: 00:31:22
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC> The above PL/SQL lists the SERVER components in the upgraded
DOC> database, along with their current version and status.
DOC>
DOC> Please review the status and version columns and look for
DOC> any errors in the spool log file. If there are errors in the spool
DOC> file, or any components are not VALID or not the current version,
DOC> consult the Oracle Database Upgrade Guide for troubleshooting
DOC> recommendations.
DOC>
DOC> Next shutdown immediate, restart for normal operation, and then
DOC> run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################
Next stop will be documenting using Swingbench to benchmark Oracle.