Upgrade Guide
This topic provides instructions for applying service pack 3 (SP3) changes to your portal applications after you install that service pack. For instructions on installing service packs, see Installing Service Packs and Rolling Patches in the WebLogic Platform at:
http://download.oracle.com/docs/cd/E13196_01/platform/docs81/install/update.html.
This section contains information on the following subjects:
Regardless of the release—8.1 or 8.1 with service pack 2—from which you are upgrading, you will follow the same basic process to complete the upgrade.
You will need to do one of the following
If you choose to upgrade your existing SP2 domain to use the new SP3 libraries, upgrade instructions will depend on how you installed SP3. Table 6 -3 explains the options.
If you use WebLogic Integration's Smart Update, it should take care of modifying environment variables when SP3 is installed in a different directory. If the SP3 upgrade installer is used, you don't need to update any domain files, as these should already point to the new SP3 libraries.
You might need to update paths to point to the new JDK for SP3. These are:
JAVA_HOME
JAVA_VENDOR
JDK_HOME
JDK_TOOLS
These paths do not get picked up automatically after running the SP3 upgrade installer since they reside in a unique location.
To create a new SP3 domain that mirrors your existing SP2 domain, use the Configuration Wizard. See Creating a New WebLogic Domain at:
http://download.oracle.com/docs/cd/E13196_01/platform/docs81/confgwiz/newdom.html
Note: WebLogic Server should be shut down while performing steps to upgrade the existing database schema
Complete the following steps to make your WebLogic Platform 8.1 SP2 database schema 8.1 SP3-compliant:
http://download.oracle.com/docs/cd/E13218_01/wlp/docs81/db/4Schemas.html#1090619
http://download.oracle.com/docs/cd/E13218_01/wlp/docs81/db/4Schemas.html#1090619
81sp3_alter_table.sql
for the DBMS in which you are interested. You can find this file in the specific version folder for that DBMS under the folder <WebLogic-Home>\portal\db\<dbms>\<version>
; for example:C:\bea813\weblogic81\portal\db\pointbase\44
Note: The following step is special instructions for upgrading a PointBase database schema
Warning: SP3 Database upgrade scripts for PointBase cannot expand _LABEL
column lengths. BOOK_LABEL
, PAGE_LABEL
, and LOOK_FEEL_LABEL
columns will be expanded from Varchar(40) to Varchar(80) when running SP3 database upgrade scripts for all databases other than PointBase. New PointBase databases created with SP3 will properly defined the columns as Varchar(80).
Note: The following step is special instructions for upgrading a Sybase database schema. If you use Sybase and do not make the required database parameter changes before running the upgrade scripts, they will fail and could cause upgrade difficulties.
Listing 6-1 Setting Allow Select into Bulkcopy Option in Sybase
use master
go
sp_dboption WEBLOGIC,"select into/bulkcopy",true
go
use WEBLOGIC
go
checkpoint
go
Once Sybase database upgrade is complete, you can reset Allow Select into Bulkcopy to false for the WEBLOGIC Portal database, as shown in Listing 6-2.
Listing 6-2 Resetting Allow Select into Bulkcopy Option in Sybase
use master
go
sp_dboption WEBLOGIC,"select into/bulkcopy",false
go
use WEBLOGIC
go
checkpoint
go
The database is now upgraded to WebLogic Portal 8.1 SP3.
During the upgrade to WebLogic Platform 8.1SP3, some tables are renamed with an old_
prefix so that the upgrades can be performed successfully and data migrated to the newly created tables. Once you've successfully upgraded to SP3, you can manually drop tables with the old_
prefix from you schema. After a successful 8.1SP3 upgrade you can remove the following tables:
After you install a new service pack that includes portal library updates, you must update the libraries in the applications you have developed. Updating overwrites the existing libraries. To update your application libraries
Note: Before you begin, ensure that WebLogic Workshop 8.1 SP3 is running. If it isn't, you need to start it.
If you choose not to update a Web project's libraries with the dialog box, you can update the Web project later by right-clicking the Web project directory in the Application window and choosing Install > Update Portal Libraries.
To apply the service pack library updates to portal applications already deployed in production, redeploy those applications after you have updated them in WebLogic Workshop. See Deploying Portal Applications at
http://download.oracle.com/docs/cd/E13218_01/wlp/docs81/deploy/index.html
The final upgrade step is to redeploy the application on your server.