Oracle8i Parallel Server Administration, Deployment, and Performance Release 2 (8.1.6) A76970-01 |
|
This chapter describes starting up and shutting down instances. It discusses the following topics:
This chapter discusses these topics in the following sections:
This section provides procedures for starting instances with Oracle Parallel Server enabled or disabled by explaining:
You can start instances using either SQL*Plus or the Oracle Enterprise Manager as described in the Oracle8i Parallel Server Setup and Configuration Guide.
Starting Oracle Parallel Server instances is procedurally identical to starting a single instance with these exceptions:
If you use the Oracle Database Configuration Assistant to create your database, specifically request that it create an Oracle Parallel Server database so it sets PARALLEL_SERVER to TRUE in your initialization file. To start a database with Oracle Parallel Server disabled, use the default value of FALSE for the PARALLEL_SERVER parameter on your instance.
If you attempt to start an instance and mount a database in shared mode while another instance is currently recovering the same database, your new instance cannot mount the database until the recovery is complete.
Rather than repeatedly attempting to start the instance, use the STARTUP RETRY statement. This causes the new instance to retry mounting the database every five seconds until it succeeds or has reached the retry limit. Use the syntax:
STARTUP OPEN database_name RETRY
To set the maximum number of times the instance attempts to mount the database, use the SQL*Plus SET command with the RETRY option; you can specify either an integer (such as 10) or the keyword INFINITE.
If the database can only be opened by being recovered by another instance, then using the RETRY will not repeat connection attempts. For example, if the database was mounted in exclusive mode by one instance, then trying the STARTUP RETRY command in shared mode does not work for another instance.
Before you can set instances and connect to them, you must install and configure Net8 for the Oracle Parallel Server nodes and any clients that access these nodes. This allows clients to establish remote connections to the nodes.
SQL*Plus commands operate on the current instance with some exceptions as noted under the next heading. The current instance can be either the local, default instance on which you initiated your SQL*Plus session, or it can be a remote instance. Because the SQL*Plus prompt does not indicate which instance is the current instance, be sure you direct your commands to the correct instance.
Initiating a SQL*Plus session and connecting to the database without specifying an instance directs all SQL*Plus commands to the local instance. In this case, the default instance is also the current instance.
To switch the current instance from the local instance to a remote instance, do one of the following:
CONNECT SYSTEM/MANAGER@net_service_name
SET INSTANCE net_service_name
Then issue another CONNECT command with only your user ID and password. Specifying a remote instance with the CONNECT command while connected to the database by way of an instance allows you to switch from one instance to another without disconnecting.
When using SET INSTANCE to specify an instance on a remote node for the STARTUP command, the parameter file for the remote instance must be accessible by the local node.
The SHOW INSTANCE command displays the net service name for the current instance. SHOW INSTANCE returns the value "LOCAL" if you have not used SET INSTANCE during the SQL*Plus session.
To reset to the default instance, use SET INSTANCE without specifying a net service name or specify "LOCAL". Do not follow the SET INSTANCE command with the word "DEFAULT"; this indicates a connect string for an instance named "DEFAULT".
Connecting as SYSOPER or SYSDBA allows you to perform privileged operations, such as instance startup and shutdown. Multiple SQL*Plus sessions can connect to the same instance at the same time. SQL*Plus automatically disconnects you from the first instance whenever you connect to another one.
See Also:
|
Shutting down an Oracle Parallel Server instance is procedurally identical to shutting down a single instance with these exceptions:
The following topics are described in this section:
Table 4-1 describes how common SQL*Plus commands apply to instances.
Most SQL statements apply to the current instance. For example, the statement ALTER DATABASE ADD LOGFILE only applies to the instance to which you are currently connected, rather than the default instance or all instances.
ALTER SYSTEM CHECKPOINT LOCAL also applies to the current instance. By contrast, ALTER SYSTEM CHECKPOINT or ALTER SYSTEM CHECKPOINT GLOBAL applies to all instances.
ALTER SYSTEM SWITCH LOGFILE applies only to the current instance. To force a global log switch, use the ALTER SYSTEM ARCHIVE LOG CURRENT statement. The THREAD option of ALTER SYSTEM ARCHIVE LOG allows you to archive online redo log files for a specific instance.
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|