Interoperability NotesOracle Applications Release 10.7
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 migrating or upgrading an existing Oracle Applications Release 10.7 database from Oracle7 Server Release 7.3.4, from Oracle8 Enterprise Edition Release 8.0.x, or from older Oracle8i Enterprise Edition Release 8.1 to the current Oracle8i Enterprise Edition Release.
If you are already using Oracle8i Enterprise Edition Release 8.1.7 database, do not proceed. Follow the instructions in Section 2.
If you are using Oracle Web Application Server 3.0.2 on the Solaris operating system, you also require the Web Server patch 1673924. Follow the instructions in the readme file included in the patch.
| Product | Patch Level | ||
|---|---|---|---|
| AP | Payables | Patch Set V (or higher) | |
| AR | Receivables | Patch Set W (or higher) | |
| AS | Sales & Marketing | Patch Set H (or higher) | |
| AX | Global Accounting Engine | Patch Set F (or higher) | |
| OE | Order Entry | Patch Set J (or higher) | |
| PO | Purchasing | Patch Set M (or higher) | |
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 10.7 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 Oracle7 Server Release 7.3.4, 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.
| Attention: On Windows NT/2000 machines, the Oracle7 Server installation architecture requires special handling to support multiple ORACLE_HOME directories. If you wish to put both ORACLE_HOMEs on the same Windows NT/2000 machine, you must install Release 7.3.4 first, and then install Release 8.1.7 into a separate directory. You should already have 7.3.4 installed, so this is not a problem. |
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 migration scripts at this time.
If your Oracle Applications database is currently using Oracle8 Enterprise Edition Release 8.0.x or earlier Oracle8i Enterprise Edition Release, you must upgrade the database to Oracle8i Enterprise Edition Release.
Refer to Oracle8i Migration Release 3 (8.1.7) for a description of these methods and complete instructions on how to migrate or upgrade the database. Ensure that you have the latest version of the manual, which can be found on the Oracle Technology Network.
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.
Migrate or upgrade the database only, unless you have installed additional components for your own customizations. Additional components such as interMedia or JServer are not used by Oracle Applications Release 10.7.
Do not run any SQL scripts documented in the patchset release notes 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:
Perform other steps only if you have installed
additional components for your own customizations.
Configure the SQL*Net client on the machine where Oracle
Applications Release 10.7 is installed such that the Oracle
Applications Release 10.7 file system can connect to the
Oracle8i Enterprise Edition Release Applications
database. Refer to Understanding SQL*Net, Release 2.3.
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.
Most of the database objects will be marked as invalid due to the
database migration or 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.
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 9 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 10.7 file system and
the Oracle7 Server Release 7.3.4 technology stack. Refer to the
Net8 Administrator's Guide. Start the listener
once it has been configured.
Log in to the machine where Oracle Applications Release 10.7 is
installed as the user who manages the Oracle7 Server technology
stack. (If you are using Release 10.7 NCA, log in to the
Applications concurrent manager server, not the forms
server.) Make sure
that all of the environment settings, such as ORACLE_HOME, PATH,
ORA_NLS, etc. refer to the Oracle7 Server Release 7.3.4 technology
stack environment. They must not refer to the new Oracle8i
Enterprise Edition Release environment.
If you are already using Oracle Applications Release 10.7 in a
server partitioning environment with a previous
Oracle8i Enterprise Edition release, you should have
already applied these patches
to your environment and can skip this step.
Product
Patch Number
Special Instructions
Application Install
499648
apply only the copy driver only. Do not apply the
db494405.drv driver and ignore the special
instructions in the readme.txt.
Oracle Receivables
480129
use adpatch utility with patch.drv driver
Applications Install
487890
use adpatch utility with patch.drv driver. Ignore the
special instructions in the readme.txt. See the comments
in the ADXGNPNS.sql script
Oracle Payroll
583816
use adpatch utility with patch.drv and d583816.drv
driver file.
Oracle Master Scheduling
622114
use adpatch utility with patch.drv and d622114.drv
driver file.
Oracle Assets
1054707
use adpatch utility with patch.drv and d1054707.drv
driver file.
You may use the standard utility utlrp.sql (found in
$ORACLE_HOME/rdbms/admin) to compile all the invalid objects in
the Oracle Applications.
The process is complete.
Follow instructions in this section, only if you have an existing Oracle Applications Release 10.7 installation using Oracle8i Enterprise Edition Release 8.1.7 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:
Perform other steps only if you have installed additional components for your own customizations.
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 10.7 supports Oracle8i Enterprise Edition Release through server partitioning. The Oracle Applications file system continues to use one ORACLE_HOME using the Oracle7 Server Release 7.3.4 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 10.7 database objects and data are stored in the database, which is located in the second ORACLE_HOME. SQL*Net and 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 Oracle7 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 | |
|---|---|---|
|
Oracle APPS 10.7 File System Oracle7 Release 7.3.4 Tech Stack SQL*Net V2 client |
Ü
SQL*Net
Þ
Ü Net8 Þ |
Oracle8i Database Server Oracle APPS 10.7 Database Net8 listener |
| Change Log | |
|---|---|
| Date | Description |
| June 22, 2001 |
|
| March 1, 2002 |
|
| May 30, 2002 |
|
| June 6, 2002 |
|
| October 25, 2002 |
|
| December 19, 2002 |
|
| September 10, 2003 |
|