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.
On Windows platforms, if you are not already running 8.0.6, it is not mandatory and not recommended to upgrade the Oracle8 home to 8.0.6.
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 :
You will be upgrading or migrating to Enterprise Server Release 8.1.7.0. The patch set upgrade will be done later in the section.
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.
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:
| 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. |
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.
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 32-bit Linux platform only:
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.
Perform steps 7 to 15 and 17 in the How to Install This Patch
Set section of the Oracle8i Release 8.1.7 patchset
release notes.
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 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.
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 32-bit 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 |
|
| September 10, 2003 |
|
| September 15, 2003 |
|
| September 17, 2003 |
|