Oracle8 Server Unleashed:Installation and Upgrades

Installation Preparation and Installation

This section helps you prepare the environment for installing the Oracle8 server. To achieve the objective, you set up the UNIX environment. There are certain tasks that need be done as the root and Oracle user. You also need to perform certain setup tasks for individual Oracle products.

Step 1. To set up the UNIX environment, you need to set Solaris-specific kernel parameters, which include SHMMAX, SHMMIN, SHMSEG, SEMMNS, SEMMNI, and SEMMSL (SEMMSL can be set equal to PROCESSES, the initialization parameter). The value of SHMMAX indicates the maximum allowable size of the shared memory used. You can add these parameters in the /etc/system file.
You need to have the adequate shared memory to accommodate the SGA. It requires configuring the UNIX kernel Interprocess Communication Parameters. Use the ipcs command to list the current shared memory and shared segments.
The total shared memory equals SHMMAX times SHMSEG.
The Oracle Installer will automatically create the directories listed in Table 6.3. The access permissions on Oracle directories and files should match those in Table 6.3.

**Table 6.3.** Access permissions on Oracle directories and files.Table 6.3 from Oracle8 Installation Guide for Sun Solaris, p. 4-4. Copyright© 1997, Oracle Corporation. All rights reserved.

Directories/Files	Permissions

`$ORACLE_HOME/network/trace`	777 (for Development database)
	730 (for Production database)
`$ORACLE_HOME/lib`	644 (provides read-only access)
`$ORACLE_HOME/bin`	6751^*
`$SQL`, Shell, and other admin scripts	644
`$ORACLE_HOME/rdbms/log`	751
All control, database,	640 log files

^*6 sets the setuid bit so the executables are executed as the Oracle user and DBA group, regardless of who executes them.

Step 2. You require at least four mount points, all at the same level of directory structure. Three mount points are consumed by the database (OFA-compliant), and one by the source software.

Step 3. Create a DBA group for the OSDBA role. Members of this group have DBA privileges.

Step 4. Create a UNIX Oracle account, a member of the DBA group. This account owns the Oracle distribution. The Installer should be run under this account.

Step 5. Create the local bin directory; in Solaris, it is /opt/bin.

Step 6. Create an oratab file containing the information about the Oracle instance:


cdrom_mount_point/orainst/oratab.sh script create/set the

permissions of

this file in /var/opt/oracle directory.

Log into the Oracle account to perform the following steps:

Step 7. Set umask to 022.

Step 8. Choose the appropriate DISPLAY by setting the machine name.

Step 9. Set the following variables appropriately in the .profile or .login file of the Oracle account: ORACLE_TERM, ORACLE_BASE, ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH, PATH, SRCHOME, TWO_TASK, and TMPDIR.

Note:
ORA_NLS33 can be set optionally if you want to create the database with a character set other than US7ASCII.
The search PATH must include: $ORACLE_HOME/bin, /bin, /opt/bin, /usr/bin, and /usr/ccs/bin in the search order.

After setting the environment variables in the .profile or .login file, update the environment in the current shell session:


$ . .profile ( Bourne Shell)

$ source .login ( cshell)

To install individual Oracle products, perform the steps as necessary for your installation.

Installing Documentation

Oracle documentation is available in two categories: OS-specific and generic. Both documentations are available in HTML and PDF formats.

You can install OS specific documentation during installation from the source CD-ROM. The generic or product documentation is available on a separate CD-ROM and can be installed in a separate Installer session.

At this point, execute the product-specific steps as necessary for your installation.

Post-Installation Steps for Oracle8 Server

As an example, let’s look at the Recovery Manager (RMAN) and Time Series Cartridge post-installation steps.

New Installations—Recovery Manager

Recovery Manager is an automated utility to perform recovery and is installed as part of the Oracle8 server. This is a new feature introduced in Oracle8. It stores information in a separate catalog database. The catalog database should be essentially on a separate machine to provide maximum fault resistance.

Note:
RMAN can also be used in a restricted mode without a recovery catalog in certain situations.

The following are the steps to create a recovery catalog:

1. Install an Oracle8 server on a different machine and create a database for the recovery catalog. You could create the default database with the Installer.

2. Create a user in the recovery catalog database to be the Recovery Manager user.

3. Log into Recovery Manager user, execute the catrman.sql script in the $ORACLE_HOME/rdbms/admin directory. Execute the script using svrmgrl.

Above steps consolidated from Oracle8 Installation Guide for Sun Solaris, Copyright© 1997, Oracle Corporation. All rights reserved.

You can look in the installation guide for appropriate postinstallation steps for different products on your platform.

New Installations—Time Series Cartridge

The Installer performs the following steps when the Create Database Objects option is selected.

Install the UTLREF package as it is needed by the cartridge:

1. As DBA, execute


svrmgr> @ORACLE_HOME/rdbms/admin/utlref.sql

2. Create the ORDSYS account if needed. As DBA, execute


svrmgr> create user ORDSYS identified by <password>;

3. Set the privileges:


svrmgr> grant connect, resource, create library to ORDSYS;

4. Install Time Series Cartridge types and procedures:


svrmgr>connect ORDSYS/<password>;

svrmgr> @ORACLE_HOME/ord/ts/admin/ordinst.sql

Table of Contents

Используются технологии uCoz