Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem: Using Oracle E-Business Suite with a Split Configuration Database Tier on Oracle 11g Release 1
Solution:
• Section 1: Introduction
Oracle E-Business Suite architecture and migration overview
• Section 2: Prerequisites
Tasks to perform before migrating the Oracle E-Business Suite database
• Section 3: Migration Procedure
Steps to migrate the database
• Section 4: Post-migration Tasks
Tasks to complete the migration process
• Section 5: Validation Tasks
Tasks to validate proper configuration of the split configuration system
Section 1: Introduction
Oracle E-Business Suite is made up of a three-tier architecture, where a tier is a logical grouping of services that may be distributed across one or more physical machines.
Note
Refer to Oracle Applications Concepts for a complete description of the Oracle E-Business Suite architecture and definition of terms.
An Oracle E-Business Suite Release 11i deployment where the platform used for the application tier is different from the platform used for the database tier is an example of a mixed platform, or split configuration, architecture. This enables use of database platforms that do not support the application tier components of Oracle E-Business Suite.
The steps in the following sections guide you through the process of migrating an Oracle E-Business Suite database from the source platform to the target split configuration database tier platform.
________________________________________
Section 2: Prerequisites
This section describes the requirements for Oracle E-Business Suite releases, software component versions, and patch installation that must be met before the database is migrated to 11.1.0.6 or later on the split configuration database tier platform.
1. Make any necessary software version upgrades
Software Minimum Version Location Details
Oracle E-Business Suite Release 11.5.10 CU2 Database tier and application tier Your system must be Release 11.5.10.2.
AutoConfig Latest version with 10202042 (for Windows 2008) Database tier and application tier Implement AutoConfig or upgrade to the latest version. SeeUsing AutoConfig to Manage System Configurations with Oracle Applications 11i (My Oracle Support Note 165195.1).
If you are on Windows 2008, apply patch patch 10202042
Database 11.1.0.6 Database tier The original (source) database must be 11.1.0.6 or higher. See My Oracle Support Note 452783.1, Interoperability Notes: Oracle E-Business Suite Release 11i with Oracle 11g Release 1 (11.1.0) to upgrade the database to 11.1.0.x.
See My Oracle Support for more information on certified database versions for your operating system.
2. Create the RDBMS ORACLE_HOME on the target machine
Install Oracle 11g Database Release 11.1.0.6 or later on the target machine. Perform all steps in the Database Installation subsection of Section 1 in My Oracle Support Note 452783.1, Interoperability Notes: Oracle E-Business Suite Release 11i with Oracle 11g Release 1 (11.1.0).
Attention
A full backup of the Oracle E-Business Suite system should be taken before carrying out the migration to the target machine, over and above normal backup procedures.
________________________________________
Section 3: Migration Procedure
Perform the steps below to migrate the E-Business Suite database from the original platform to the target platform.
Note
The Oracle E-Business Suite system will be unavailable during the migration process.
1. Shut down the application tier services
Log on to each machine in the application tier and stop the Oracle E-Business Suite services.
$ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]
$ adstpall.sh apps/[APPSpwd]
2. De-register the original database server machine
De-register the original database server machine from the AutoConfig repository in the Applications database.
As the ORACLE user, log on to the machine with the existing database and run the following commands:
$ cd [RDBMS ORACLE_HOME]/appsutil/bin
$ perl adgentns.pl appspass=[APPSpwd] \
contextfile=[CONTEXT_FILE] -removeserver
3. Create a .trc file to use as template to re-create the control files on the target machine
Run the following command on the source database to create a .trc file, which you will use to recreate the control files on the target machine in a later step.
$ sqlplus/nolog
SQL> connect / as sysdba
SQL> alter database backup controlfile to trace
4. Shut down the original (source) database
Perform a SHUTDOWN NORMAL on the source database, and stop the database listener.
5. (Option A) Migrate HP-UX PA-RISC database to HP-UX Itanium
Follow these steps to migrate the database from HP-UX PA-RISC to HP-UX Itanium:
a. Copy the database (.dbf) files from the source machine to the target machine
b. Copy the database configuration files (including init.ora)
c. If the directories where the source and target database files reside are the same, copy the database control files. Otherwise, recreate the database control files.
(Option B) Migrate Linux 32-bit database to Linux x86-64
Perform the following steps to move the Linux 32-bit database to Linux x86-64:
d. Copy the database (.dbf) files from the source machine to the target machine
e. Copy the database configuration files (including init.ora)
f. Modify the configuration files as specified in the database documentation. This includes setting _system_trig_enabled=false
g. Start up the database
h. Recreate the database control files
i. Migrate the database from 32-bit to 64-bit (recompile pl/sql modules and change the word size) by running utlirp.sql and utlrp.sql (in ORACLE_HOME/rdbms/admin/). Refer to the usage and notes sections in each of these scripts for instructions on how to run them.
j. Remove _system_trig_enabled=false from init.ora
k. Shutdown and restart the database normally
(Option C) Migrate Windows 32-bit database to Windows x64
Perform the following steps to move the Windows 32-bit database to Windows x64:
l. Copy the database (.dbf) files from the source machine to the target machine
m. Copy the database configuration files (including init.ora)
n. Modify the configuration files as specified in the database documentation. This includes setting _system_trig_enabled=false
o. Start up the database
p. Recreate the database control files
q. Migrate the database from 32-bit to 64-bit (recompile pl/sql modules and change the word size) by running utlirp.sql and utlrp.sql (in ORACLE_HOME/rdbms/admin/). Refer to the usage and notes sections in each of these scripts for instructions on how to run them.
r. Remove _system_trig_enabled=false from init.ora
s. Shutdown and restart the database normally
(Option D) Migrate database on other platforms to HP-UX Itanium, Linux x86-64, or Windows x64
In the case where the source database operating system and architecture is different from that of the target operating system, the source database must be exported and then imported into the newly created target database. For this scenario, follow the procedure described in My Oracle Support Note 557738.1, Export/Import Process for Oracle E-Business Suite Release 11i Database Instances Using Oracle Database 11g Release 1, to migrate the database.
Note
Omit the step (in Note 557738.1) of creating the 11.1.0.6 RDBMS Oracle home on the target machine. This step was performed as part of the Prerequisite section of this document, before the system downtime.
6. Migrate OLAP analytical workspaces (Conditional)
Note
All customers who have OLAP installed AND are migrating from a 32-bit platform to a 64-bit platform must migrate OLAP analytical workspaces by performing this step.
7. Perform the steps as documented in My Oracle Support Note 352306.1, Upgrading OLAP from 32 to 64 bits, to migrate OLAP analytical workspaces from 32 to 64 bits if you have performed a full database migration with step 5b or 5c above.
________________________________________
Section 4: Post-Migration Tasks
If you performed Option A, B, or C in step 5 of Section 3, perform these additional interoperability steps on the new database.
1. Natively recompile PL/SQL code (optional)
If you are on a UNIX/Linux platform, you can choose to run Oracle E-Business Suite 11i PL/SQL database objects in natively compiled mode with Oracle Database 11g. See the "Compiling PL/SQL Program Units for Native Execution" section of Chapter 12 of Oracle Database PL/SQL Language Reference 11g Release 1 (11.1).
When modifying the initialization parameters pertaining to the PL/SQL native compilation, usedocument 216205.1, on My Oracle Support as a guideline.
2. Start the new database listener
If the Oracle Net listener for the database instance in the new Oracle home has not already been started, you must start it now. Since AutoConfig has not yet been implemented, start the listener with the lsnrctl executable (UNIX/Linux) or the Services applet (Windows). See the Oracle Database Net Services Administrator's Guide 11g Release 1 (11.1) for more information.
3. Implement and run AutoConfig on the database server node
Implement and run AutoConfig in the new Oracle home on the database server node. If the database listener of the new Oracle home is defined differently than the old Oracle home, you must also run AutoConfig on each application tier server node to update the system with the new listener.
See Using AutoConfig to Manage System Configurations with Oracle Applications 11i on My Oracle Support for instructions on how to implement and run AutoConfig.
Shut down all processes, including the database and the listener, and restart them to load the new environment settings.
4. Re-create custom database links
a. If the Oracle Net listener in the 11.1.0 Oracle home is defined differently than the one used by the old Oracle home, you must re-create any custom self-referential database links that exist in the Applications database instance. To check for the existence of database links, use SQL*Plus on the database server node to connect to the Applications database instance as APPS and run the following query:
b. $ sqlplus apps/[apps password]
c. SQL> select db_link from dba_db_links;
d. The EDW_APPS_TO_WH and APPS_TO_APPS database links, if they exist, should have been updated with the new port number by AutoConfig in a previous step.
If you have custom self-referential database links in the database instance, use the following commands to drop and recreate them:
$ sqlplus apps/[apps password]
SQL> drop database link [custom database link];
SQL> create database link [custom database link] connect
to [user] identified by [password] using
'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=[hostname])
(PORT=[portnumber]))(CONNECT_DATA=(SID=[ORACLE_SID])))';
where [custom database link], [user], [password],[hostname], and [ORACLE_SID] are all as they were in the source database link definition, and [port number] is the port number of the new Oracle Net listener for the database instance.
5. Reconfigure the application tier to connect to the target database machine
Log on to each application tier machine and perform the following steps:
a. Update the application tier context file
Update the following variables in the Applications context file to match the target database configuration:
Variable Name Value
s_dbhost New database hostname
s_dbdomain New database domain name
s_dbport New database listener port.
s_apps_jdbc_connect_descriptor NULL
s_isDB NO
b. Run AutoConfig on the application tier
Make sure that the new database and listener are running, and run AutoConfig on the application tier:
$ cd [COMMON_TOP]/admin/scripts/[CONTEXT_NAME]
$ adautocfg.sh
c. Start all application tier services
Restart all services on the application tier.
$ adstrtal.sh apps/[APPSpwd]
6. Recreate Concurrent Manager Service (Windows only) (conditional)
If the database resided locally before migration, the Concurrent Manager Service has been configured with a dependency on the local Oracle service. Since the Oracle database is now on a separate tier, this dependency should be removed using:
$ cd %COMMON_TOP%\admin\install\[Context_Hostname]
$ adsvcm.cmd -deinstall
After executing the commands, make sure the service has been removed on the service panel.
Users should then re-create the Concurrent Manager Service with:
$ adsvcm.cmd [APPS user]/[APPS password]
After executing the commands, make sure the service has been added on the service panel and does not include the dependency on the local Oracle service.
________________________________________
Section 5: Validation Tasks
Verify that the application tier is configured to use the new 11g database:
1. Verify the database server hostname and database release version
Go to the Oracle E-Business Suite Rapid Install Portal, and log on to the E-Business Suite home page as the sysadmin user. Select a responsibility (such as the System Administrator responsibility). Click on any form, such as the Concurrent->Requests form. From the Help menu click "About Oracle Applications", and verify that the server hostname and release version correspond to those of the target database.
2. Run Diagnostics for HTML-based Applications (Self-service)
Return to the E-Business Suite home page and select the System Administration responsibility. Click on each link in the Diagnostics section.
3. Run CRM Diagnostics
Return to the E-Business Suite home page and select the CRM HTML Administrator responsibility. Click on Diagnostics, and select the Basic tab. Click on Run All Groups, and examine the test results.
References:
Using Oracle E-Business Suite with a Split Configuration Database Tier
on Oracle 11g Release 1 [ID 562983.1]
No comments:
Post a Comment