12.1.1 With ODA PDF
12.1.1 With ODA PDF
12.1.1 With ODA PDF
Page 1 of 14
Type: REFERENCE
In this Document
Purpose
Details
Executive Overview
Oracle E-Business Suite
Why Oracle E-Business Suite on Oracle Database Appliance?
Preparing to deploy Oracle E-Business Suite databases on Oracle Database Appliance
Oracle Database Appliance Configuration Customization
1. Extend logical volumes and create staging directory
2. Install required additional Linux RPMs
3. Install Database examples to target home
4. Create NLS directory to target home
Installing Oracle E-Business Suite using Rapid Install
Invoke Rapid Install Wizard on Database Node
Invoke Rapid Install Wizard on Application Node
Post Basic Installation Procedure
Patch applications tier for 11.2 interoperability
Patch database tier for 11.2 interoperability
Set Oracle binary permissions in target ORACLE_HOME
Run Pre-upgrade checklist and address findings
Prepare database for upgrade
Upgrade database to version 11.2 using DBUA
Post-install steps for patches
Change database initialization parameters
Move database files, control file, and spfile to Automatic Storage Management (ASM)
Finalize Oracle E-Business Suite Setup
Install AutoConfig on DB Tier
Cleanup current schema configuration
Create static listener configuration
Reload listener configuration
Generate and update Context file
Run AutoConfig on DB Tier
Update Grid Infrastructure (GI) Network files
Update OCR
Run adgrants.sql and grant create procedure privilege on CTXSYS
Update TNS alias on App tier
Validate Workflow Rules Set
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 2 of 14
APPLIES TO:
Oracle Appliance Kit - Version 2.5.0.0 and later
Information in this document applies to any platform.
PURPOSE
The purpose of this note is to illustrate the high level deployment of an Oracle E-Business Suite 12.1 database
on Oracle Database Appliance.
DETAILS
Executive Overview
Oracle Database Appliance is a simple, reliable, and affordable Engineered System from Oracle. It consists of
hardware and software integrated to work together that saves customers time and money by simplifying
deployment, maintenance, and support of high availability database solutions. The bare metal (non-virtualized)
deployment of Oracle Database Appliance is an ideal option to host the database tier for small and medium size
implementations of Oracle E-Business Suite. This white paper discusses the benefits of utilizing Oracle
Database Appliance as the database tier for Oracle E-Business Suite and the associated deployment as well as
data migration steps. This white paper does not contain implementation steps for the complete Oracle EBusiness Suite stack on Oracle Database Appliance Virtualized Platform.
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 3 of 14
Partitioning
Real Applications Clusters
Advanced Security
Advanced Compression
Active Data Guard
Real Application Testing
Advanced Analytics
Golden Gate
Manageability
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 4 of 14
instructions given in My Oracle Support Knowledge Document: How to customize available disk space for
installing your application on the Oracle Database Appliance (ODA) (Doc ID 1457717.1).
For example
lvextend -L +25G /dev/mapper/VolGroupSys-LogVolOpt
resize2fs /dev/mapper/VolGroupSys-LogVolOpt
lvextend -L +25G /dev/mapper/VolGroupSys-LogVolU01
resize2fs /dev/mapper/VolGroupSys-LogVolU01
The Oracle E-Business Suite installation media needs to be locally available before installation can begin. The
installation media can be copied to a locally created staging area or mounted via NFS.
For example
mkdir -p /opt/oracle/stage
chown -R oracle:oinstall /opt/oracle/stage
libstdc++-devel-4.1.2-14.el5.i386
gdbm-1.8.0-26.2.1.i386
libXp-1.0.0-8.1.el5.x86_64
libXi-1.0.1-4.el5_4.i386
db4-4.3.29-10.el5_5.2.i386
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 5 of 14
$ perl $ORACLE_HOME/nls/data/old/cr9idata.pl
Note: The recommended rapidwiz version to use for your deployment is 12.1.1.13 or higher.
Note that the initial deployment is performed on a single Oracle Database Appliance node. The configuration
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 6 of 14
may be extended to a RAC configuration at a later stage, if desired. The process of extending a single instance
database configuration to a clustered database configuration is presented later in this white paper.
Once the installation on the Application tier has completed, the post installation steps need to be carried out,
which are described in the next section.
$ su - grid
$ $GRID_HOME/bin/setasmgidwrap o=$RDBMS_HOME/bin/oracle
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 7 of 14
SQL> ORACLE_HOME/rdbms/admin/utlu112i.sql
Also an entry should be added to the /etc/oratab for the database. For example,
PROD:/u01/app/oracle/PROD/db/tech_st/11.2.0:N
It is advisable to run the pre-upgrade checklist again to verify that all requirements have been properly
addressed before proceeding.
Note: The diagnostic_dest parameter is derived from $ORACLE_BASE (if used) or $ORACLE_HOME
environment variable setting.
SQL> alter system set compatible='11.2.0.3' scope=spfile;
SQL> alter system reset diagnostic_dest;
The database is restarted to mount state using srvctl for changes to take effect.
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 8 of 14
Move database files, control file, and spfile to Automatic Storage Management (ASM)
- Data files
$ rman target /
RMAN> backup as copy database format '+DATA';
RMAN> switch database to copy;
- Control file
RMAN> restore controlfile to '+DATA/PROD/control01.dbf' from
'/u01/app/oracle/PROD/db/apps_st/data/cntrl01.dbf';
SQL> alter system set control_files='+DATA/PROD/control01.dbf' scope=spfile;
- spfile
RMAN> backup spfile;
RMAN> restore spfile to '+DATA/PROD/spfileprod.ora';
$ srvctl modify database -d PROD -p '+DATA/PROD/spfileprod.ora';
$$ADPERLPRG $AD_TOP/bin/admkappsutil.pl
$ cd $ORACLE_HOME
$ cp /cloudfs/app/oracle/PROD/inst/apps/PROD_slcac459/admin/out/appsutil.zip .
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 9 of 14
$ unzip -o appsutil.zip
$ cp -r /u01/app/oracle/PROD/db/tech_st/11.1.0/appsutil/jre .
$ sqlplus apps/apps
SQL> exec fnd_conc_clone.setup_clean;
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = PROD)
)
)
During the enquiry phase, configure the context file to use SCAN. After generating the context file, update the
variable s_virtual_hostname to refer to the database node VIP.
For example,
<host oa_var="s_virtual_hostname">dbnode-vip</host>
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 10 of 14
Update OCR
Update the OCR to setup TNS_ADMIN set to the GI network admin files.
$ srvctl setenv database -d PROD -T \ TNS_ADMIN=/u01/app/11.2.0/grid/network/admin
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 11 of 14
Note: For ease of reading, the entry is broken into multiple lines using a line break.
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 12 of 14
Note: Additional information on database migration options and Oracle E-Business Suite supported versions
can be found in the appendix A.
The cloning process may include preparing the source environment, copying the database to Oracle Database
Appliance, and completing post-cloning steps.
Once the database files have been copied, execute the following steps in the Oracle Database Appliance
environment to complete the cloning process.
1. Configure database initialization parameters based on Oracle Database Appliance DBCA templates. The
following parameters need to be set for all databases:
_disable_interface_checking=true
_gc_undo_affinity=false
_gc_policy_time=0
_enable_numa_support=false
_file_size_increase_increment=2143289344
db_recovery_file_dest='+RECO'
db_create_file_dest='+DATA'
db_create_online_log_dest_1='+REDO'
db_block_checksum=full
db_block_checking=full
db_lost_write_protect=typical
filesystemio_options=setall
use_large_pages=only
2. Move REDO log files to +REDO diskgroup on Solid State Disks (SSDs).
For each redolog group, add an additional member with '+REDO' diskgroup as the location.
SQL> alter database add logfile member '+REDO' to group 1;
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 13 of 14
SQL> alter database drop logfile member '<non REDO diskgroup path>';
Conclusion
Oracle Database Appliance is an engineered system from Oracle that is easy to deploy, manage, and maintain.
This paper describes how to implement an Oracle E-Business Suite database on Oracle Database Appliance and
outlines the best practices
Transportable Tablespaces
The Transportable Tablespace feature can be used to migrate an Oracle E-Business Suite database to an Oracle
Database Appliance environment. This method requires some down time on the source database.
Transportable Database
The Transportable Database feature can also be used to migrate an Oracle E-Business Suite database to an
Oracle Database Appliance environment. This method cannot be used for migrating across different Endian
formats. The source system must be 11.2 and the platform must be little Endian. This method also requires
some down time on the source database.
Data Pump
Oracle Data Pump provides the most flexible approach to migrate a database from an external environment to
Oracle Database Appliance as it can operate across database versions. Data Pump is also an excellent choice
when performing cross-platform database migrations. However, extracting, moving, and loading data from the
source system to the target system can be a long process and could require extended downtime depending on
the size of the database being migrated.
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015
Document 1566935.1
Page 14 of 14
Appendix B: References
1. My Oracle Support Knowledge Document: 406982.1 -- Cloning Oracle Applications Release 12 with Rapid
Clone
2. My Oracle Support Knowledge Document: 1362116.1 -- ODA (Oracle Database Appliance): How to
Convert Single-Instance database to RAC on Oracle Database Appliance Using RCONFIG Utility
3. My Oracle Support Knowledge Document: 1457717.1 -- How to customize available disk space for
installing your application on the Oracle Database Appliance (ODA)
4. My Oracle Support Knowledge Document: 761566.1 -- Oracle E-Business Suite Installation and Upgrade
Notes Release 12 (12.1.1) for Linux x86-64
5. My Oracle Support Knowledge Document: 1058763.1 -- Interoperability Notes EBS R12 with Database
11gR2
6. My Oracle Support Knowledge Document: 823587.1 -- Using Oracle 11g Release 2 Real Application
Clusters with Oracle E-Business Suite Release 12
https://support.oracle.com/epmos/faces/DocContentDisplay?_adf.ctrl-state=mt8r1v5vt_210...
5/7/2015