4
Oracle Parallel Server Management

You can control the activity of Oracle Parallel Servers and their instances using Oracle Parallel Server Management.

Oracle Parallel Server Management is supported with Oracle Enterprise Manager as described in the Oracle8i Parallel Server Setup and Configuration Guide. Oracle Parallel Server Management may also be run from the command line using the OPSCTL utility. This chapter describes using the OPSCTL utility from the command line for Windows NT.

The following topics are covered:

• Oracle Parallel Server Management using OPSCTL
• OPSCTL START Command Line Usage
• OPSCTL STOP Command Line Usage

 

 

Oracle Parallel Server Management using OPSCTL

The OPSCTL utility allows you to manage all Oracle Parallel Server instances from each node. You can choose to start or stop all instances on an individual node.
 

Note: The following requirements are met if you followed all the steps in Oracle8i Parallel Server Setup and Configuration Guide.

OPSCTL requires the following:

• The name of each service must be exactly the same as the Oracle SID for that instance (and exactly the same as they appear in the registry).
• The database initialization files must follow a format of INITSID.ORA and INITDB_NAME.ORA and be located in the ORACLE_BASE\ADMIN\DB_NAME\SID\PFILE directory.
• The database initialization files for all instances of your Oracle Parallel Server must exist on the node where OPSCTL.EXE is run.
• A new Windows NT user with the same name as the one you are using to access your Oracle Enterprise Manager console workstation must be created on all nodes of your Oracle Parallel Server.




OPSCTL.EXE uses this user to start services on remote machines, so this user must have the equivalent of administrator access on each of the nodes. You can either use the default Oracle Enterprise Manager Console credential to access your Oracle Parallel Server or supply a different account name/password combination when creating a startup/shutdown job. In either case, the account used must have DBA privileges on an instance of Oracle Parallel Server in order to start or stop that instance.

OPSCTL START Command Line Usage

OPSCTL START -CCONNECT_STRING -NDATABASE_NAME  [-ISID, SID] [-F] [-T] [-U] [-M] 

[-Y|-E] [-v] [-h]

 

Note: [] indicates optional items.

where:

-CCONNECT_STRING	connect string, such as INTERNAL/MANAGER
-NDATABASE_NAME	name of the Oracle Parallel Server database name to start; defined in the INITDB_NAME.ORA file
-ISID, SID	to start specified instance(s) only
-F	startup of instances following an ABORT shutdown; default is IMMEDIATE
-T	RESTRICTED SESSION privileges only
-U	database not to be mounted upon startup
-M	mount, but do not open the database
-Y	retry database opening if recovery is in progress
-E	EXCLUSIVE mount and open
-V	verbose
-H	print usage

To start all instances:

C:\> CD ORACLE_HOME\BIN
C:\ORACLE_HOME\BIN> OPSCTL START -CINTERNAL/PASSWORD -NDATABASE_NAME

To start an individual instance:

C:\> CD ORACLE_HOME\BIN
C:\ORACLE_HOME\BIN> OPSCTL START -ISID -CINTERNAL/PASSWORD -NDATABASE_NAME

OPSCTL STOP Command Line Usage

OPSCTL STOP -CCONNECT_STRING -NDATABASE_NAME  [-ISID, SID] [-F] [-T] [-U] [-M] 

[-v] [-h]

 

Note: [] indicates optional items.

where:

-CCONNECT_STRING	connect string, such as INTERNAL/MANAGER
-NDATABASE_NAME	name of the Oracle Parallel Server database name to stop; defined in the INITDB_NAME.ORA file
-ISID, SID	to stop specified instance(s) only
-F	shutdown of instances in ABORT mode; default is IMMEDIATE
-T	RESTRICTED SESSION privileges only
-U	database not to be mounted upon startup
-M	NORMAL mode of shutdown; default is IMMEDIATE
-V	verbose
-H	print usage

To stop all instances:

C:\> CD ORACLE_HOME\BIN
C:\ORACLE_HOME\BIN> OPSCTL STOP -CINTERNAL/PASSWORD -NDATABASE_NAME

To stop an individual instance:

C:\> CD ORACLE_HOME\BIN
C:\ORACLE_HOME\BIN> OPSCTL STOP -ISID -CINTERNAL/PASSWORD -NDATABASE_NAME