Oracle Database 12c pre-upgrade scripts and JAVAVM

This is a great example of why you should always review the README file when upgrading to a new release. Here is an issue that we found during customer beta testing, and that you will want to be aware of if you are upgrading to Oracle Database 12c and do not have the JAVAVM component in your database. The following text has been added to the 12.1 Readme under Section 1.1:

TITLE: Pre-Upgrade Tool Does Not Generate Output Logs

The pre-upgrade tool, preupgrd.sql, is not able to create a directory to
store the output files if the JAVAVM component either does not exist in the
database registry or is set to INVALID or OPTION OFF (reference Bug
14614756). For example:

SQL> @/tmp/preupgrd
Loading Pre-Upgrade Package ...
WARNING: Failed to open preupgrade.log for write access
   script will generate terminal output only
WARNING: Failed to open preupgrade_fixups.sql for write access
   script will not generate fixup scripts.

Results of the checks are located at:
*** Scripts/Logs are not being Generated *** preupgrade.log

The workaround is to manually create the output directory before running
preupgrd.sql by executing the following steps:

1. If ORACLE_BASE is defined in the environment settings, either create a
directory $ORACLE_BASE/cfgtoollogs/<db-unique-name>/preupgrade or create a
directory $ORACLE_HOME/cfgtoollogs/<db-unique-name>/preupgrade.

2. To get <db-unique-name>, use the following query:

   SELECT value FROM V$PARAMETER WHERE NAME = 'db_unique_name';

   Note that <db-unique-name> used in the directory path is case sensitive.

3. Rerun the preupgrd.sql tool.

As you can imagine, your upgrade will be smoother if you are aware of issues like this before you upgrade instead of running into them on your go-live weekend!

Comments:

Post a Comment:
Comments are closed for this entry.
About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite with reference customers. Acting as interlink between customers and the Upgrade Development.

Contact me either via XING or LinkedIn

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
12
13
15
16
18
19
20
21
22
24
25
26
27
28
29
30
   
       
Today
Slides Download Center
OOW Slides Download
Visitors since 17-OCT-2011
White Paper and Docs
Oracle Blogs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers