9
Managing the Oracle8i Enterprise Edition

This chapter describes post-installation notes on the following topics:

Starting the Oracle8i Enterprise Edition

Before you start the Oracle8i Enterprise Edition, both an instance and a database must exist on your local system. If you did not install the Oracle8i Enterprise Edition, consult the person who did.

This section presents the following topics:

Before Start Up

Prior to starting up an Oracle database/instance, the Oracle shareable images must be installed. To install the Oracle shareable images, issue the following DCL commands:

Run ORAUSER.COM, specifying the full directory path. For example:

$ @<disk_device>:[ORACLE8.UTIL]ORAUSER.COM

where:

<disk_device>:[ORACLE8.UTIL] is the UTIL directory under the ORACLE root directory pointed to by the logical name ORA_ROOT.

You must perform steps 2 and 3 under the following conditions:

After the ORACLE image has been removed, but before the Oracle8i Enterprise Edition is started
After running the REMORACLE.COM command file (which de-installs the global sections loaded by INSORACLE.COM)

Whenever the computer is booted.

WARNING:
Running INSORACLE.COM might cause problems with any currently running instance that uses the shareable images that these command files install. Take this into account if you create an instance-specific automatic startup procedure that invokes the INSORACLE file.

Run the ORA_RDBMS:INSORACLE.COM file.
```
$INSORACLE
```
This file installs the shared global sections that make a shareable ORACLE image known to the system. The ORACLE<image_id>.EXE file must have proper protection when you run INSORACLE. The account where you run INSORACLE.COM must have CMKRNL privilege.
If you plan to install shared images, run the file ORA_INSTALL:ORA_INSUTL.COM to create ORA_UTIL:INSUTILITY.COM.

INSUTILITY.COM installs Oracle products other than the Oracle8i Enterprise Edition (such as Oracle Forms and SQL*Plus) in shared memory.

Starting Oracle8i via ORACLEINS

To start Oracle8i using ORACLEINS, do the following steps:

Run the database-specific ORAUSER file using the following syntax:
```
$ @ORA_DB:ORAUSER_<dbname> <sid> <setup_nodename>
```

Run ORACLEINS:
```
$ ORACLEINS
```

Select option 3, "Reconfigure existing products, manage the database, or load demo tables," from the Oracle Installation Startup Menu.
Press [RETURN] when prompted to specify the root directory.
Press [RETURN] when prompted to specify the device where you mounted the distribution medium.
Select option 2, "Instance Creation, Startup, and Shutdown Menu," from the Main Menu.

Select option 2, "Startup an Existing Instance," from the Instance Creation, Startup, and Shutdown Menu. The following message is displayed:

Currently known database SIDs: 
	[list of known SIDs] 
Press [RETURN] to quit with no action.
NOTE: The SID can be a maximum of 6 characters in length.
What is the SID for the instance to startup?

Type the SID of the instance that you want to start and press [RETURN]. The instance identified by this SID is started and the database associated with this instance is opened in exclusive mode.

Starting Oracle8i via STARTUP Files

You can also use command files to start Oracle8i. The file you execute depends on whether you are running in exclusive or in parallel mode.

Run one of the following STARTUP command files for the instance you want to start:

$ @ORA_DB:STARTUP_<dbname> <sid> <setup_nodename>

These files are located in the database-specific directory identified by the logical name ORA_DB. When you start up the instance, be sure to specify the SID of the instance and its setup node.

Starting Oracle8i via Server Manager

You can also start an instance of Oracle8i using Server Manager. See the section, "Starting the Server," in this chapter for instructions about setting up Server Manager. Then, refer to the generic (platform-independent) Oracle Server documentation for instructions about using Server Manager.

You might choose to complete startup tasks separately when monitoring instance performance, for example, or you might want to start an instance and open a database after making some modifications.

Identifying the Current Instance

When starting up the Oracle8i Enterprise Edition, you start up the current instance. The current Oracle8i instance is identified by the value of the logical name ORA_SID. For example, if the value of ORA_SID is currently V817, the current instance is the instance with the SID V817. If you have not reassigned the ORA_SID logical name, the value of ORA_SID is the SID specified during installation. To change the current instance before starting the Oracle8i Enterprise Edition with Server Manager, you must reassign the value of ORA_SID.

If the ORA_SID is missing or incorrect, you receive the following error:

ORA-07582, spstp: ORA_SID has an illegal value

Specifying Startup Parameters

When the current Oracle8i instance is started, the SGA is created and initialized with the startup parameters set in the distributed parameter file, INIT.ORA, in the ORA_DB directory. When using Server Manager, you can use another startup file that sets different parameter values by including the PFILE option with the STARTUP command to identify an alternative parameter file. If the directory location of the alternative parameter file is not in the current directory, include it:

SVRMGR> STARTUP PFILE=ORA_DB:INIT2.ORA

Starting the Server

To start Oracle8i, you must have the process rights identifier ORA_DBA or ORA_<sid>_DBA assigned to your user account in the OpenVMS rights database and you must run two .COM files that make the logical name assignments required to run Oracle8i.

Before starting up Oracle8i, run the ORAUSER_<dbname>.COM to set the desired instance.

After running the above .COM files, run Server Manager and execute the appropriate STARTUP command(s), as documented in the Oracle8i Server Administrator's Guide. You can issue the single Server Manager command, STARTUP, or execute the three separate Server Manager commands documented in the Oracle8i Server Administrator's Guide to start the Oracle8i Enterprise Edition.

The Server Manager command STARTUP starts the current ORACLE instance, creating the SGA in OpenVMS shared memory and creating the detached processes. It then mounts the database and opens it.

Starting Oracle8i Automatically

To start Oracle8i automatically whenever you start OpenVMS, submit the Oracle8i start procedure as a batch job from the system startup file. This batch job must:

Execute the ORAUSER.COM file to define the logical names and symbols referenced by Oracle8i
Run as the operating system DBA account user
Run ORA_RDBMS:INSORACLE.COM to install the global sections required by Oracle8i
Execute one of the startup command files to start Oracle8i:
```
$ @ORA_DB:STARTUP_<dbname>
```
Run ORA_UTIL:INSUTILITY.COM if you previously ran ORA_INSTALL:ORA_INSUTL.COM to install Oracle products as shared images

Sample Startup File

A sample startup file that starts two Oracle8i systems automatically after a system reboot is shown below:

$!  STARTORAV8.COM
$!  This script shows how one might start two Oracle
$!  database instances at system boot time.
$!---------------------------------------------------------
$!  Get the name of the node.
$!
$  NODENAME = F$GETSYI("NODENAME")
$!
$!    Acquire CMKRNL privilege to install ORACLE
$!    IMAGES.  Exit with error if you are not so
$!    authorized.
$!
$  SET PROCESS/PRIVILEGES=CMKRNL
$  IF (F$PRIVILEGE("CMKRNL") .EQS. "FALSE") THEN EXIT 2
$!
$!     Define symbols specific to this version of ORACLE
$!     code by running the appropriate ORAUSER.COM:
$!
$  @DISK$ORACLE:[ORACLE.V8.UTIL]ORAUSER
$!
$!     Install shared images:
$!
$  INSORACLE          ! Install shared ORACLE image
$!
$!     Start a database instance.
$!
$  INSTSID = "PROD1"        ! Define SID
$  DB_NAME = "PROD"         ! Define database name
$  GOSUB START_DATABASE
$!
$!     Start a second database instance.
$!
$  INSTSID = "PROD2"        ! Define sid
$  DB_NAME = "TEST"         ! Define database name
$  GOSUB START_DATABASE
$  EXIT
$!
$!     Invoke the database-specific startup script.  Assumes
$!     that ORA_DB for each database is under ORA_ROOT.
$!     This need not be the case.
$!
$START_DATABASE:
$  @ORA_ROOT:[DB_'DB_NAME']STARTUP_'DB_NAME' -
	'INSTSID' 'NODENAME'
$  RETURN

In this sample startup file, the systems share the same copy of Oracle8i code. The example assumes that the Oracle8i root directory is DISK$ORACLE:[ORACLE.V8].

Run this file as a batch job under the Oracle8i account as part of the standard system startup procedure. Keep this file in the Oracle8i account login directory.

For example, if the Oracle8i account resides in DISK$ORACLE:[ORACLE] and the startup script is named STARTORAV8.COM, then start this script at boot time by adding the following lines to SYS$MANAGER:SYSTARTUP_VMS.COM:

$ FILSPC = "DISK$ORACLE:[ORACLE]STARTORAV8"
$ SUBMIT		-
	/USER=ORACLE8				-
	/AFTER="+00:05:00"					-
	/LOG='FILSPC'.LOG					-
	'FILSPC'

Creating Additional Oracle Databases and Instances

The only supported way of creating additional Oracle databases and instances is by using ORACLEINS.

The way to create additional Oracle databases is similar to when you created your initial database/instance.

For additional information, see Chapter 5.

Shutting Down an Oracle Database/Instance

The following three methods can be used to shut down an Oracle database instance:

Shutting down Oracle8i via ORACLEINS
Shutting down Oracle8i via SHUTDOWN file
Shutting down Oracle8i via Server Manager
Shutting down Oracle8i via SQLPLUS

After all instances on a node have been shut down, you can deinstall the shareable images if desired by using REMORACLE.

Shutting Down Oracle8i via ORACLEINS

To shut down Oracle8i using ORACLEINS:

Using Server Manager, ensure that there are no open sessions.

Run the database-specific ORAUSER file:

	$ @ORA_DB:ORAUSER_<dbname> <sid> <setup_nodename>

Run ORACLEINS:
```
	$ ORACLEINS
```
Select option 3, "Reconfigure existing products, manage the database, or load demo tables," from the ORACLE Installation Startup Menu.
Press [RETURN] when prompted to specify the root directory.
Press [RETURN] when prompted to specify the location of the savesets.
Select option 2, "Instance Creation, Startup, and Shutdown Menu," from the Main Menu.

Select option 4, "Shutdown an Existing Instance," from the Instance Creation, Startup, and Shutdown Menu. The following message is displayed:

			Currently known database SIDs: 
			[list of known SIDs]

	Press [RETURN] to quit with no action.
	NOTE: The SID can be a maximum of 6 characters in length.
	What is the SID for the instance you want to shut down?

Type the SID of the instance that you want to stop and press [RETURN]. The ORACLEINS utility will now do an orderly shutdown of the specified instance.

Shutting Down Oracle8i via the SHUTDOWN File

To shut down the currently running ORACLE instance, use the following command file:

$ @ORA_DB:SHUTDOWN_<dbname>.COM <sid> <setup_nodename>

This file is located in the database-specific directory identified by the logical name ORA_DB. When you shut down the instance, be sure to specify the SID of the instance and its setup node.

Sample Shutdown File

A sample shutdown file that shuts down two Oracle8i systems automatically is shown below:

$!
$!   NAME:  STOPORAV8.COM
$!   Note that this script will hang if users are still

$!   connected to the databases unless you modify the
$!   shutdown scripts to issue SHUTDOWN IMMEDIATE commands.
$!----------------------------------------------------------
$!
$!    Get the name of the node:
$!
$  NODENAME = F$GETSYI("NODENAME")
$!
$!    Acquire CMKRNL privilege to remove the Oracle
$!    shareable images.  Exit with error if you are not so
$!    authorized.
$!
$  SET PROCESS/PRIVILEGES=CMKRNL
$  if (F$PRIVILEGE("CMKRNL") .EQS. "FALSE") THEN EXIT 2
$!
$!    Define symbols and logical names specific to this version
$!    of the Oracle code by running ORAUSER.COM
$!
$!
$  @DISK$ORACLE:[ORACLE.V8.UTIL]ORAUSER
$!
$!    Shut down a database instance
$!
$  INSTSID = "PROD1"                ! Define SID
$  DB_NAME = "PROD"                 ! Define Database Name
$  GOSUB DO_SHUTDOWN
$!
$!    Shut down a second database instance
$!
$  INSTSID = "PROD2"                ! Define SID
$  DB_NAME = "TEST"                 ! Define Database Name
$  GOSUB DO_SHUTDOWN
$!
$!
$!    De-install Oracle shareables
$!
$  REMORACLE 
$  EXIT
$!
$  DO_SHUTDOWN:
$  @ORA_ROOT:[DB_'DB_NAME']SHUTDOWN_'DB_NAME' 'INSTSID'-
	'NODENAME'
$  RETURN

Shutting Down Oracle8i via Server Manager

You can shut down an instance of Oracle8i using Server Manager. See the section, "Starting the Server," in this chapter for instructions on setting up Server Manager. Refer to the generic (platform-independent) Oracle Server documentation for instructions about using Server Manager.

Deinstalling Shareable Images

After shutting down all Oracle8i instances on a node, and before relinking, deinstall the shareable images (and shutdown the bequeath adapter) by entering the following statement:

	$ REMORACLE

9 Managing the Oracle8i Enterprise Edition