3 Tools and Utilities for Oracle E-Business Suite Certified Configuration

This chapter provides information about optional implementation and administration utilities available for Oracle E-Business Suite Certified Configuration. This chapter contains the following topics:

Administration Utilities
NLS Toolkit

CAUTION:

These utilities are intended for use by experienced implementors and administrators. Incorrect use of these utilities can cause data loss or errors in software setup.

Administration Utilities

This section provides information on the following administration utilities:

Database Administration Scripts
Oracle Internet Directory Administration Scripts
OLAP Administration Scripts
Using VERITAS NetBackup for Oracle Recovery Manager To Back Up the Database

Database Administration Scripts

Two database administration (DBA) scripts are available. The scripts are in the directory /mount_point/oracle/product/920/admin/SID_hostname/scripts. Table 3-1 describes each script.

Table 3-1 DBA Scripts

Script	Description
`shutdown_apps.sh`	Stops the current Oracle Applications environment.
`startup_apps.sh`	Starts the current Oracle Applications environment.

Oracle Internet Directory Administration Scripts

The Oracle Internet Directory (OID) administration script is named oidenv.sh [start|stop]. The script is located in the directory /oid_mount_point/oracle/product/901/appsutil/scripts.

The script create_ctrl.sql runs in Server Manager. It recreates the database control file in the current Oracle Internet Directory environment.

The script oidenv.sh [start|stop] script starts or stops the Oracle Internet Directory environment. To use this script, make sure that you log in as the OID user.

OLAP Administration Scripts

There are two OLAP administration script available. The scripts are located in the directory /olap_mount_point/oracle/admin/SID/script. Table 3-2 describes the scripts.

Table 3-2 OLAP Administration Scripts

Script Description

Script	Description
exapcctl.sh [start\|stop]	Starts or stops the Web server. User must be logged in as the `OLAP` user.
exexpctl.sh [start\|stop]	Starts or stops Oracle Express Server if the `/usr/local/bin/super` script is on the system. User must be logged in as the `OLAP` user. If the script is not available, then the `root` user can start and stop the server using the following commands: # cd $OLAP_HOME/bin # express [start\|stop]

exapcctl.sh [start|stop]

Starts or stops the Web server. User must be logged in as the OLAP user.

exexpctl.sh [start|stop]

Starts or stops Oracle Express Server if the /usr/local/bin/super script is on the system. User must be logged in as the OLAP user.

If the script is not available, then the root user can start and stop the server using the following commands:

# cd $OLAP_HOME/bin
# express [start|stop]

Using VERITAS NetBackup for Oracle Recovery Manager To Back Up the Database

To back up the database, use VERITAS NetBackup for Oracle Recovery Manager. Use the following procedure to run an Oracle Recovery Manager (RMAN) script to perform a database backup on the Oracle E-Business Suite Certified Configuration:

Set the following the environment variables for the client that will run the backup:

NB_ORA_SERV=backup server
NB_ORA_CLASS=Oracle class
NB_ORA_SCHED=Oracle schedule

The following is an example of the settings:

NB_ORA_SERV=congee.us.oracle.com
NB_ORA_CLASS=Oracle_tst
NB_ORA_SCHED=Oracle

Run a few file system backups to ensure the client is properly registered on the server.
Verify that you set the following environment variables:
- ORACLE_HOME
- ORACLE_SID
- NB_ORA_CLASS
- NB_ORA_SCHED
- NB_ORA_SERV
Perform a database backup using the RMAN script. The following is an example of the rman script:
```
     run {
             allocate channel t1 type 'SBT_TAPE';
             backup database;
            }
```
The preceding example backs up the entire database to the VERITAS Netbackup server.

Note:
Specify the channel type as SBT_TAPE or tape in order to send the backups to the server.
Save the script as x.rman.

Using the following command syntax, run the x.rman script:

$ORACLE_HOME/bin/rman nocatalog target user/password with sysdba \
privs cmdfile path/x.rman

NLS Toolkit

The NLS Toolkit is in the directory /admin/ebso/nls. The toolkit enables you to install either a base language or an additional language into your Oracle E-Business Suite Certified Configuration environment. To use the toolkit, you must have installed AUTOVERIFY in the $OAP_HOME/autoverify directory. Table 3-3 lists the current supported languages.

Table 3-3 Language Codes

Language	Language Code `LANG`
Arabic	AR
Brazilian Portuguese	PTB
Canadian French	FRC
Croatian	HR
Czech	CS
Danish	DK
Dutch	NL
European French	F
European Portuguese	PT
European Spanish	E
Finnish	SF
German	D
Greek	EL
Hebrew	IW
Hungarian	HU
Italian	I
Japanese	JA
Korean	KO
Latin American Spanish	ESA
Norwegian	N
Polish	PL
Romanian	RO
Russian	RU
Simplified Chinese	ZHS
Slovak	SK
Swedish	S
Taiwan Chinese	ZHT
Thai	TH
Turkish	TR

Before running the tool, perform the following steps:

Stop all application processes.
Increase the applmgr mount point by 6 GB for each language that you want to add.
To stage the patch, create 6 GB of temporary space for each language. Make sure that the apps user can write to the temporary space.
Make available the NLS patch for the language that you want to install from the standard Oracle E-Business Suite Release 11i (11.5.9) NLS install CD-ROM. Do not run the script adcrptop.sh, as this will be run by the script.
Turn off database archiving. This avoids generating an excessive number of archive log files while patching the application.
As the apps user, run nlsenv_1159.sh to start the tool:
```
$ cd /admin/ebso/nls/bin
$ ./nlsenv_1159.sh LANG TYPE
```
In the preceding syntax example, substitute one of the language codes in Table 3-3, "Language Codes" for the LANG variable, and B or I for the TYPE variable. Use B if you are installing the language as the base language, or I if you are installing it as an additional installed language.

When prompted, enter the following information:

System password - Enter the SQL*Plus system user password.
Applsys Password - Enter the SQL*Plus applsys user password.

To add more than one language:

Wait for the script nlenv_1159.sh to finish.
Mount the NLS patch of the next language you want to add.
Rerun the script nlsenv_1159.sh.

Note:

If you need to change the base language back to the default US English language, then unzip the file /admin/ebso/nls/US/1159/usbase.zip into a temporary location, and use ADPATCH to apply the patch driver. Doing this reinstalls the US English seed data.