Go to main content

Oracle® Solaris Cluster Data Service for Oracle E-Business Suite up to Release 12.1 Guide

Exit Print View

Updated: April 2016
 
 

Configuration Requirements

The configuration requirements in this section apply only to HA for Oracle E-Business Suite up to release 12.1.

Caution

Caution  -  If your data service configuration does not conform to these requirements, the data service configuration might not be supported.

Determine Which Oracle Solaris Zone Oracle E-Business Suite up to Release 12.1 Will Use

Oracle Solaris zones provide a means of creating virtualized operating system environments within an instance of the Oracle Solaris OS. Oracle Solaris zones allow one or more applications to run in isolation from other activity on your system. For complete information about installing and configuring Oracle Solaris zones, refer to Introduction to Oracle Solaris Zones .

You must determine which Oracle Solaris zone Oracle E-Business Suite up to release 12.1 will use. Oracle E-Business Suite can run within the global zone configuration.

Running the AutoConfig Command

When you are required to run the AutoConfig command and your database tier or application tier uses a logical host, you must ensure that the logical host interpositioning is in place for the AutoConfig command. See Step 7 in How to Install and Configure Oracle E-Business Suite up to release 12.1 for instructions on setting the customSID_app-logical-host.env file for the application tier. For the database tier you must manually set the environment variables LD_PRELOAD_32, LD_PRELOAD_64, and SC_LHOSTNAME before running AutoConfig.

How to Run the AutoConfig Command

The following task shows how to run the Autoconfig command after upgrading the Oracle Database to 11.2.0.3. The upgrade is part of the installation of Oracle E-Business Suite up to release 12.1 12.1 on Oracle Solaris 11, where the physical hostname was used incorrectly.

In the example below, the physical hostnames are pvino1 and pvino2. The logical hostnames used for the database tier and application tier are vino-1 and vino-2 respectively.

  1. On a cluster member, become an administrator that provides solaris.cluster.modify authorization.
  2. Ensure that the logical hostname is available.
    1. You can manually add the logical interface or ensure that the Oracle Solaris Cluster logical host resource is online on the node where you intend to run the AutoConfig command. 
      root@pvino1:~# ifconfig net0 addif vino-1 netmask 255.255.255.0 up
Created new logical interface net0:1
root@pvino1:~#
root@pvino1:~# ifconfig net0 addif vino-2 netmask 255.255.255.0 up
Created new logical interface net0:2
root@pvino1:~#

      You can also run the follow command to ensure that the logical hostname is available:

    root@pvino1:~# clrs status db-lh apps-lh
=== Cluster Resources ===
Resource Name       Node Name      State        Status Message
-------------       ---------      -----        --------------
db-lh               pvino2         Offline      Offline - LogicalHostname offline.
pvino1         Online       Online - LogicalHostname online.

apps-lh             pvino2         Offline      Offline - LogicalHostname offline.
pvino1         Online       Online - LogicalHostname online.
root@pvino1:~# ping vino-1
vino-1 is alive
root@pvino1:~# ping vino-2
vino-2 is alive
  3. Perform the necessary setup tasks and run the AutoConfig command.
    1. As the Oracle database user, set the environment variables for the database tier. 
      root@pvino-1:~# uname -n
pvino1
root@pvino1:~# su - oracle
Oracle Corporation   SunOS 5.11   11.0  November 2011
-bash-4.1$
-bash-4.1$ export LD_PRELOAD_32=/usr/lib/secure/libschost.so.1
-bash-4.1$ export LD_PRELOAD_64=/usr/lib/secure/sparcv9/libschost.so.1
-bash-4.1$ SC_HOSTNAME=vino-1.us.oracle.com
-bash-4.1$ export LD_PRELOAD_32= LD_PRELOAD_64 SC_LHOSTNAME
-bash-4.1$ uname -n
vino-1.us.oracle.com
-bash-4.1$
    2. Ensure that the new Oracle Home listener file references the logical host. 
      -bash-4.1$ cd $ORACLE_HOME/network/admin
-bash-4.1$ pwd
/db/d01/oracle/PROD/db/tech_st/11.2.0/network/admin
-bash-4.1$ ls -l
total 8
drwxr-xr-x   2 oracle   dba            8 Jan 12 08:37 PROD_vino-1
drwxr-xr-x   2 oracle   dba            5 Jan  5 07:51 samples
-rw-r--r--   1 oracle   dba          205 May 11  2011 shrept.lst
-bash-4.1$ cd PROD_vino-1
-bash-4.1$ ls -l
total 19
-rw-r--r--   1 oracle   dba         1609 Jan 12 08:37 listener.ora
-rw-r--r--   1 oracle   dba            2 Jan  9 08:33 listener_ifile.ora
-rw-r-----   1 oracle   dba          382 Jan 10 01:46 sqlnet.log
-rw-r--r--   1 oracle   dba          875 Jan 12 08:37 sqlnet.ora
-rw-r--r--   1 oracle   dba            2 Jan  9 08:33 sqlnet_ifile.ora
-rw-r--r--   1 oracle   dba         1998 Jan 12 08:37 tnsnames.ora
-bash-4.1$ more listener.ora
#
# $Header: ad8ilsnr.ora 120.3.12010000.3 2010/03/09 07:07:03 jmajumde ship $
#
# ###############################################################
#
# This file is automatically generated by AutoConfig.  It will be read and
# overwritten.  If you were instructed to edit this file, or if you are not
# able to use the settings created by AutoConfig, refer to Metalink Note
# 387859.1 for assistance.
#
# ###############################################################
#
# Net8 definition for Database listener
#
LISTENER_PROD =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vino-1.us.oracle.com)(PORT = 1521))
)
)
...
    3. Start the 11.2.0.3 Database and Listener .
    4. Optional: Clean the current configuration.

      This step is required only if you have an incorrect entry within FND_NODES. In this example, PVINO1 is not required. In this example, you must also run AutoConfig for the database tier and application tier when you install Oracle E-Business Suite up to release 12.1 12.1 on Oracle Solaris 11.

      -bash-4.1$ sqlplus apps/apps
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 12 08:07:09 2012
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select node_name, node_mode, support_cp, support_web, support_admin, \
support_forms from FND_NODES;

NODE_NAME                      N S S S S
------------------------------ - - - - -
VINO-1                         O N N N N
AUTHENTICATION                 O N N N N
PVINO1                         O N N N N
VINO-2                         O Y Y Y Y

SQL> exec fnd_conc_clone.setup_clean
PL/SQL procedure successfully completed.

SQL> select node_name, node_mode, support_cp, support_web, support_admin, \
support_forms from FND_NODES;
no rows selected

SQL> exit
    5. As the Oracle Database user, generate the new Database Context file. 
      -bash-4.1$ uname -n
pvino-1
-bash-4.1$
-bash-4.1$ export LD_PRELOAD_32=/usr/lib/secure/libschost.so.1
-bash-4.1$ export LD_PRELOAD_64=/usr/lib/secure/sparcv9/libschost.so.1
-bash-4.1$ SC_LHOSTNAME=vino-1.us.oracle.com
-bash-4.1$ export LD_PRELOAD_32 LD_PRELOAD_64 SC_LHOSTNAME
-bash-4.1$ uname -n
vino-1.us.oracle.com
-bash-4.1$ cd $ORACLE_HOME/appsutil/bin
-bash-4.1$ ls -l
total 704
-rwxr-xr-x   1 oracle   dba         2689 Jan  9 06:59 TXKScript.pl
-rwxr-xr-x   1 oracle   dba        19728 Jan  9 06:59 adbldxml.pl
-rw-r--r--   1 oracle   dba        13224 Jan  9 06:59 adchkcfg.cmd
-rwxr-xr-x   1 oracle   dba         4767 Jan  9 06:59 adchkcfg.sh
-rwxr-xr-x   1 oracle   dba         4836 Jan  9 06:59 adchkutl.sh
-rwxr-xr-x   1 oracle   dba        55747 Jan  9 06:59 adclone.pl
-rwxr-xr-x   1 oracle   dba         1012 Jan  9 06:59 adclone.sh
-rwxr-xr-x   1 oracle   dba        27277 Jan  9 06:59 adclonectx.pl
-rw-r--r--   1 oracle   dba        13470 Jan  9 06:59 adconfig.cmd
-rwxr-xr-x   1 oracle   dba        38255 Jan  9 06:59 adconfig.pl
-rwxr-xr-x   1 oracle   dba         4490 Jan  9 06:59 adconfig.sh
-rw-r--r--   1 oracle   dba        12119 Jan  9 06:59 adcustomizer.cmd
-rwxr-xr-x   1 oracle   dba         5919 Jan  9 06:59 adcustomizer.sh
-rw-r--r--   1 oracle   dba        12754 Jan  9 06:59 adcvm.cmd
-rwxr-xr-x   1 oracle   dba         6737 Jan  9 06:59 adcvm.sh
-rwxr-xr-x   1 oracle   dba        20185 Jan  9 06:59 addlnctl.pl
-rwxr-xr-x   1 oracle   dba        18139 Jan  9 06:59 adgentns.pl
-rw-r--r--   1 oracle   dba        13451 Jan  9 06:59 adtmplreport.cmd
-rwxr-xr-x   1 oracle   dba         7200 Jan  9 06:59 adtmplreport.sh
-rw-r--r--   1 oracle   dba         2585 Jan  9 06:59 adxerr.pl
-rw-r-----   1 oracle   dba          382 Jan 12 08:37 sqlnet.log
-rwxr-xr-x   1 oracle   dba         2768 Jan 12 08:38 \
txkDBSecUserAuditActionBanner.pl
-rwxr-xr-x   1 oracle   dba        14728 Jan  9 06:59 txkGenCtxInfRep.pl
-rwxr-xr-x   1 oracle   dba        18354 Jan  9 06:59 txkHealthCheckReport.pl
-rwxr-xr-x   1 oracle   dba        15573 Jan  9 06:59 txkInventory.pl
-rwxr-xr-x   1 oracle   dba         4435 Jan  9 06:59 txkrun.pl
-bash-4.1$
      Note -  If you are upgrading the Oracle Database, you must generate a new context file using adbldxml.pl for the database tier. 
      -bash-4.1$ perl adbldxml.pl
Starting context file generation for db tier..
Using JVM from /db/d01/oracle/PROD/db/tech_st/11.2.0/jdk/jre/bin/java \
to execute java programs.
APPS Password: apps
The log file for this adbldxml session is located at:
/db/d01/oracle/PROD/db/tech_st/11.2.0/appsutil/log/adbldxml_01120836.log
Couldn't determine the localHost name.
Enter localHost name: vino-1
Enter the value for Display Variable: :10
The context file has been created at:
/db/d01/oracle/PROD/db/tech_st/11.2.0/appsutil/PROD_vino-1.xml
    6. After you generate the new Database Context file, run the AutoConfig command for the database tier.

      You can run adautocfg.sh, unless you are upgrading the Oracle Database.

      -bash-4.1$ pwd
/db/d01/oracle/PROD/db/tech_st/11.2.0/appsutil/scripts/PROD_vino-1
-bash-4.1$ ls -l adautocfg.sh
-rwx------   1 oracle   dba         1539 Jan 12 08:37 adautocfg.sh
-bash-4.1$
    7. If you have upgraded your Oracle database and generated a new context file, the output appears similar to the following: 
      -bash-4.1$ adconfig.sh contextfile=/db/d01/oracle/PROD/db/tech_st/11.2.0 \
/appsutil/PROD_vino-1.xml
Enter the APPS user password:
The log file for this session is located at: /db/d01/oracle/PROD/db/tech_st/11.2.0 \
/appsutil/log/PROD_vino-1/01120837/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /db/d01/oracle/PROD/db/tech_st/11.2.0
Classpath                  : :/db/d01/oracle/PROD/db/tech_st/11.2.0/jdbc \
/lib/ojdbc5.jar:/db/d01/oracle/PROD/db/tech_st/11.2.0/appsutil/java \
/xmlparserv2.jar:/db/d01/oracle/PROD/db/tech_st/11.2.0/appsutil/java: \
/db/d01/oracle/PROD/db/tech_st/11.2.0/jlib/netcfg.jar:/db/d01/oracle/ \
PROD/db/tech_st/11.2.0/jlib/ldapjclnt11.jar
Using Context file         : /db/d01/oracle/PROD/db/tech_st/11.2.0/ \
appsutil/PROD_vino-1.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.
-bash-4.1$
-bash-4.1$ sqlplus apps/apps

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 12 08:44:01 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select node_name, node_mode, support_cp, support_web, support_admin, \
support_forms from FND_NODES;

NODE_NAME		       N S S S S
---------------------------------
VINO-1			      O N N N N

SQL> exit
  4. As the Oracle Application user, run the AutoConfig command on each application tier. 
    root@pvino1:~# uname -n
pvino1
root@pvino1:~# su - applmgr
Oracle Corporation	  SunOS 5.11	11.0	 November 2011
-bash-4.1$
-bash-4.1$ cat /apps/d01/oracle/PROD/apps/apps_st/appl/customPROD_vino-2.env
LD_PRELOAD_32=/usr/lib/secure/libschost.so.1
LD_PRELOAD_64=/usr/lib/secure/sparcv9/libschost.so.1
SC_LHOSTNAME=vino-2.us.oracle.com

export LD_PRELOAD_32 LD_PRELOAD_64 SC_LHOSTNAME
-bash-4.1$ . /apps/d01/oracle/PROD/apps/apps_st/appl/customPROD_vino-2.env
-bash-4.1$ uname -n
vino-2.us.oracle.com
-bash-4.1$
-bash-4.1$ cd $ADMIN_SCRIPTS_HOME
-bash-4.1$ ls -l
total 353
-rwx------   1 applmgr  dba         7391 Jan 16 02:35 adalnctl.sh
-rwx------   1 applmgr  dba         8437 Jan 16 02:35 adapcctl.sh
-rwx------   1 applmgr  dba         1564 Jan 16 02:35 adautocfg.sh
-rwx------   1 applmgr  dba        18044 Jan 16 02:35 adcmctl.sh
-rwx------   1 applmgr  dba         7275 Jan 16 02:35 adexecsql.pl
-rwx------   1 applmgr  dba        10516 Jan 16 02:35 adforms-c4wsctl.sh
-rwx------   1 applmgr  dba        11119 Jan 16 02:35 adformsctl.sh
-rwx------   1 applmgr  dba        11326 Jan 16 02:35 adformsrvctl.sh
-rwx------   1 applmgr  dba         8192 Jan 16 02:35 adoacorectl.sh
-rwx------   1 applmgr  dba         8200 Jan 16 02:35 adoafmctl.sh
-rwx------   1 applmgr  dba        11084 Jan 16 02:35 adopmnctl.sh
-rwx------   1 applmgr  dba        15476 Jan 16 02:35 adpreclone.pl
-rwx------   1 applmgr  dba         8446 Jan 16 02:35 adstpall.sh
-rwx------   1 applmgr  dba         8491 Jan 16 02:35 adstrtal.sh
-rwx------   1 applmgr  dba         2244 Jan 16 02:35 gsmstart.sh
drwxr-xr-x   2 applmgr  dba           10 Jan  4 05:55 ieo
-rwx------   1 applmgr  dba         2566 Jan 16 02:35 java.sh
-rwx------   1 applmgr  dba         6699 Jan 16 02:36 jtffmctl.sh
drwxr-xr-x   2 applmgr  dba            3 Jan  4 05:55 msc
-rwxrwxr--   1 applmgr  dba         6644 Jan 16 02:36 mwactl.sh
-rwxrwxr--   1 applmgr  dba         6645 Jan 16 02:36 mwactlwrpr.sh
-rw-r--r--   1 applmgr  dba         1468 Jan 10 07:54 sqlnet.log
-bash-4.1$
-bash-4.1$ ./adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /apps/d01/oracle \
/PROD/inst/apps/PROD_vino-2/admin/log/01120906/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location  : /apps/d01/oracle/PROD/ \
inst/apps/PROD_vino-2
Classpath                   : /apps/d01/oracle/PROD/apps/apps_st \
/comn/java/lib/appsborg2.zip:/apps/d01/oracle/PROD/apps/apps_st \
/comn/java/classes
Using Context file          : /apps/d01/oracle/PROD/inst/apps \
/PROD_vino-2/appl/admin/PROD_vino-2.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
-bash-4.1$
-bash-4.1$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jan 12 09:09:49 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select node_name, node_mode, support_cp, support_web, \
support_admin, support_forms from FND_NODES;

NODE_NAME		       N S S S S
---------------  ------ - - - - -
AUTHENTICATION          O N N N N
VINO-1			      O N N N N
VINO-2			      O Y Y Y Y

SQL>
Copyright © 2006, 2016, Oracle and/or its affiliates. All rights reserved. 
Previous
Next