Interoperability NotesOracle Applications Release 11.0
|
| Attention: These notes apply to UNIX and Windows NT/2000 platforms. However, you may need to modify some instructions slightly depending upon your platform. For example, these notes typically use UNIX syntax when specifying a directory, so Windows NT/2000 users will need to substitute the appropriate syntax when accessing that directory(folder). |
This section contains instructions for upgrading an existing Oracle Applications Release 11.0 database from Oracle8 Enterprise Edition Release 8.0.x, or from an older Oracle8i Enterprise Edition Release 8.1 to Oracle8i Enterprise Edition Release 8.1.7.
If you are already using Oracle8i Enterprise Edition Release 8.1.7 database, do not proceed. Follow the instructions in Section 2.
Shut down the Oracle Applications forms server, Oracle Web Applications Server, Concurrent Manager and any other applications processes.
Some of the database initialization parameters have changed or become obsolete in Oracle8i Enterprise Edition Release. Details are available in the Oracle8i Migration Guide. If any such parameter exists in the database initialization file (init.ora), you must remove them or comment them out from the initialization file of the Oracle Applications Release 11.0 database.
The following events are required in the database initialization file to maintain the compatibility of PL/SQL constructs supported in Oracle 7 and earlier releases of Oracle8. Add them to the init.ora file if they do not already exist.
Make sure that none of the environment settings, such as ORACLE_HOME, PATH, ORA_NLS, etc. refer to the existing Oracle8 Enterprise Edition Release 8.0.x, or earlier Oracle8i Enterprise Edition Release environment. You must install the latest Oracle8i Enterprise Edition Release into a separate ORACLE_HOME.
Follow the instructions in the Oracle8i Installation Guide to perform the installation. We recommend the Custom installation type with at least the following components :
Do not run any SQL scripts at this time.
For all UNIX/Linux platforms:
For Windows platform:
The above 5 patches are included in the 8.1.7.4.6 patch set on
Windows. If the patch set is not yet available, you may
continue with your upgrade, but you should download this patch
set from OracleMetaLink and apply it to your database
instance as soon as the patch set is available.
For Linux platform only:
You will be upgrading or migrating directly to Enterprise Server
Release 8.1.7.x. You may disregard the admonition in the 8.1.7.x
README that warns that you cannot upgrade directly to 8.1.7.x.
Upgrade the database. If you are upgrading from a previous
Oracle8i release, then you must also follow the
instructions for upgrading Oracle interMedia Text from
the migration document as well as the Oracle interMedia
text related step from the 8.1.7.x patchset release notes.
There is no need to execute any database update steps from
the 8.1.7.x patchset release notes.
Copy the addbctx.sql script from patch 1239901
into the $ORACLE_HOME/apps/admin directory. If the
apps/admin directory does not exist in your ORACLE_HOME,
please create it. Run addbctx.sql in SQL*Plus while
connected as SYSTEM. This script requires the following
parameters in the order specified:
Do not use the environment variable for ORACLE_HOME inside the
SQL*Plus command, use the fully expanded path of the database
server ORACLE_HOME.
You must also execute the interMedia related step in the 8.1.7.x
patchset release notes.
The TWO_TASK environment variable on UNIX, or the LOCAL
environment setting on Windows NT/2000, must be set to the connect
string of the Applications database that you define. The
ORACLE_SID environment setting must not be set. Use SQL*Plus to
test the connection.
Run AD Administration on each Release 11 server to which
this situation applies and choose the "Relink Applications
programs" option from the Maintain Applications Files
menu. Make sure to select all products for relinking.
There may be other invalid objects in other schemas, such as SYS,
SYSTEM, CTXSYS, etc. You may use the $AD_TOP/sql/adcompsc.pls
script to compile objects in these schemas. Run the script in
SQL*Plus, connecting as any schema. The script takes 3 parameters:
Apply the following RDBMS patches to the 8.1.7 Oracle home:
Additional issues with Applications running on 8.1.7 may
have been identified since this document was authored.
Check the Certify section of OracleMetaLink for the
latest issues.
Ensure that there is sufficient free space in the SYSTEM
tablespace (greater than 500 MB) and for the Rollback
segments (greater than 750 MB).
Refer to Oracle8i Migration Release 3 (8.1.7)
for complete instructions on how to upgrade the database.
Ensure that you have the latest version of the manual, which
can be found on the
Oracle Technology Network.
If the Oracle Applications Release 11.0 databases is
still using Oracle8 Enterprise Edition release, it
contains Oracle ConText objects. Oracle8i
replaces Oracle ConText with Oracle
interMedia Text. Patch 1239901 contains the
addbctx.sql script which drops all Oracle ConText
database objects and replaces
them with Oracle interMedia Text objects. Obtain
and unzip this patch.
Parameter
Default Value
Available Values
Recommended Value
Description
Remove ConText
FALSE
TRUE or FALSE
TRUE
Earlier releases has Oracle ConText
installed. You must remove it by setting this paramter
to TRUE.
Default Tablespace
None
User Defined
CTXSYS
Default tablespace for Oracle
interMedia schema. Ensure that this tablespace
exists.
Temporary Tablespace
None
User Defined
TEMP
Temporary tablespace for Oracle
interMedia schema.
interMedia Shared Library
None
<ORACLE8.1.7.4 HOME>/ctx/lib/libctxx8.so
on UNIX platforms
,or
<ORACLE8.1.7.4 HOME>\bin\oractxx8.dll
on Windows NT/2000
full pathname of the Oracle interMedia
shared library in the database server Oracle Home.
The Net8 listener must be configured such that the database can be
accessed from the Oracle Applications Release 11.0 file system and
the Oracle8 technology stack. Refer to the
Net8 Administrator's Guide. Start the listener
once it has been configured.
Attention:
When the following steps refer to "each Release 11
server", it is implied that we are referring to each
Release 11 server except the database
server - i.e. the forms server, web server,
administration server, and concurrent processing
server.
Configure the SQL*Net client on each Release 11 server such
that the Oracle
Applications Release 11.0 file system can connect to the
Oracle8i Enterprise Edition Release Applications
database. Refer to Net8 Administrator's Guide.
Use AutoPatch to apply patch 1239901. First apply the
c1239901.drv driver file to the Oracle Applications file
system on each Release 11 server. Then update the Oracle
Applications database by applying the d1239901.drv driver
file on the administration server.
If any of your Release 11 servers are running UNIX, you must
manually copy the new adrelink file that comes with patch
1239901 from the $AD_TOP/bin directory to the
$APPL_TOP/admin directory on each Release 11 server that is
running UNIX. Back up the existing file in $APPL_TOP/admin
before you copy the new file. This file contains fixes for
relinking Oracle Applications with the Oracle8 Enterprise
Edition Release 8.0.x technology stack.
Use AutoPatch to apply patch 1244775. First apply the
c1244775.drv driver file to the Oracle Applications file
system on each Release 11 server. Then update the Oracle
Applications database by applying the d1244775.drv driver
file on the administration server.
If any of your Release 11 servers are running UNIX, and you
are upgrading the Oracle8 Enterprise Edition technology
stack on those servers to Release 8.0.6.1 from any earlier
Oracle8 Enterprise Edition release, you must relink all
Oracle Applications executables on those servers.
Most of the database objects will be marked as invalid due to the
database upgrade. To compile the objects that belong
to the APPS schema, run AD Administration and choose the "Compile
APPS schema(s)" option from the Maintain Applications Database
Objects menu.
The process is complete.
Follow instructions in this section, only if you have an existing Oracle Applications Release 11.0 installation using Oracle8i Enterprise Edition Release 8.1.7.1 Database.
Oracle Applications will be unavailable to users until all tasks in this section are completed.
Oracle8i Release 8.1.7 patchset release notes contains database update steps required for this patchset. Follow the instructions in the How to Install This Patch Set section to upgrade the Oracle Applications Databases.
For all UNIX/Linux platforms:
For Windows platform:
The above 5 patches are included in the 8.1.7.4.6 patch set on Windows. If the patch set is not yet available, you may continue with your upgrade, but you should download this patch set from OracleMetaLink and apply it to your database instance as soon as the patch set is available.
For Linux platform only:
Many database objects will become invalid due to the database upgrade. Compile the objects that belong to the APPS schema. Run AD Administration on the administration server and choose the "Compile APPS schema(s)" option from the Maintain Applications Database Objects menu.
Oracle Applications Release 11.0 supports Oracle8i Enterprise Edition Release through server partitioning. The Oracle Applications file system continues to use one ORACLE_HOME using the Oracle8 Server Release 8.0 technology stack. An Oracle8i Enterprise Edition Release database server is installed in a second ORACLE_HOME, which is not necessarily on the same machine as the Oracle Applications file system.
Oracle Applications Release 11.0 database objects and data are stored in the database, which is located in the second ORACLE_HOME. Net8 handles communication between the Oracle Applications file system and the Oracle8i Enterprise Edition Applications database.
The following diagram illustrates the layers in a server partitioning model with two ORACLE_HOMEs. The server partitioning model works whether the Oracle8 ORACLE_HOME and the Oracle8i ORACLE_HOME are on the same machine or on different machines. If they are on the same machine, they must be in separate directories.
| APPL_TOP ORACLE HOME | Database ORACLE HOME | |
|---|---|---|
|
Applications 11.0 File System Oracle8 Release 8.0.x Home Developer/2000 Server 1.6.1 Web Applications Server 3.0 Net8 client |
Ü Net8 Þ |
Oracle8i Database Server Applications 11.0 Database interMedia Text Net8 listener |
| Change Log | |
|---|---|
| Date | Description |
| Nov 05, 2001 |
|
| March 1, 2002 |
|
| May 31, 2002 |
|
| June 6, 2002 |
|
| December 19, 2002 |
|