Database Reference
In-Depth Information
Finalizing the Configuration
You've just completed the installation of e-Business Suite on ODA, but it's still far from being properly configured
for running your production environment. The database resides on one of the ODA nodes on its local disks (ASM
and RAC are not used). The application tier has no server redundancy. In this portion of the chapter, you'll find out
how to finalize the configuration of your new e-Business Suite system to use both server nodes, ASM, RAC, and two
application server virtual machines to ensure the best possible availability.
Create a New 11.2 Oracle Home
The R12.2 installation process delivered an 11.2.0.3 database home that was installed in a temporary mount point that
you created on the local disks in one of the ODA nodes. This configuration is fully capable of running the e-Business
Suite database, but it's not recommended, as the goal is to minimize any nonstandard changes to the ODA. In this
section, you'll find out how to create an ODA-compatible 11.2.0.3 Database Oracle Home and how to adjust it for
e-Business Suite.
Creating a new Oracle Home is a very simple process on ODA. Executing the
oakcli create dbhome
command
creates a new database home on both ODA database nodes simultaneously. You'll also need to provide the version of
the database home you want to install.
14
The tool will ask you to enter
root
,
oracle
and
sysasm
passwords and will
spool lots of output; and in the end, it will print out the name of the freshly created Oracle Homes:
[root@s1 ~]#
oakcli create dbhome -version 11.2.0.3.7
...
INFO: 2013-08-25 12:58:43: Installing a new home: OraDb11203_home3 at /u01/app/oracle/
product/11.2.0.3/dbhome_3
...
SUCCESS: 2013-08-25 13:05:21: Successfully created the database home OraDb11203_home3
It's also important to change the permissions of the Oracle binary in the new Oracle Homes on both DB nodes to
allow the database access to the ASM disks. Log on as the
grid
user on both nodes and run the
setasmgidwrap
utility
as explained in Listing 11-15.
Listing 11-15.
Fixing the Permissions of the Oracle Binaries
[grid@s1 ~]$
. oraenv
ORACLE_SID = [grid] ?
+ASM1
The Oracle base has been set to /u01/app/grid
[grid@s1 ~]$
$ORACLE_HOME/bin/setasmgidwrap o=/u01/app/oracle/product/11.2.0.3/dbhome_3/bin/oracle
The next step in the preparation process is the installation of the Examples CD on top of the new Oracle Home.
This is a specific requirement for e-Business Suite, and it has to be completed manually. The version of the new Oracle
Home is 11.2.0.3.7, so you need to install the Examples CD content from the installation package of Oracle Database
11.2.0.3, which is available from My Oracle Support as patch 10404530. Checking the Read Me information of the
patch reveals the exact file (“disk”) you need to download—
p10404530_112030_Linux-x86-64_6of7.zip
. Upload the
installation disk of the Examples CD to any ODA Base, unzip it, and run the
runInstaller
from the examples folder.
Again, you'll need the graphical environment to be able to launch the installation wizard. Point the installer to the
new Oracle Home and it will install the Examples CD content to both Oracle Homes (one on each ODA server).
14
See My Oracle Support note 888888.1.
