User`s guide

Remote Startup of a Database Instance
Administering Oracle Database 5-5
with no PFILE clause, Oracle locates the initialization parameter file by examining file
names in the following order:
1. sid.DBS.SPFILE.ORA
2. DBS.SPFILE.ORA
3. sid.DBS.INIT.ORA
If you want to use some other initialization file, then use the argument PFILE . For
example, to bring up a previously created database using an initialization file called
TEST.INIT.ORA , enter the following:
/START-PROGRAM $ORAC1120.SQLPLUS
* /NOLOG
At the SQL*Plus prompt, enter:
SQL> CONNECT / AS SYSDBA
SQL> STARTUP PFILE=TEST.INIT.ORA
5.3 Remote Startup of a Database Instance
This section describes the preparations for a remote startup using SQL*Plus:
1. Usually, Oracle Database 11g Release 2 listener parameter file ( LISTENER.ORA ) does
not contain a static service registration section (
SID_LIST ) for a database service. In
case of a remote startup you must define this section for the desired database. For
example:
SID_LIST_LISTENER = (SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)))
The listener must be running on the computer where the instance is to be started.
The listener must statically register the instance. If the listener does not run under
the same user ID as the instance you want to start, then you must define the
admissions to start a job under the user ID of the instance in the listener's
ORAENV
file or you must use SECOS, Fujitsu's Security Control System for BS2000/OSD.
For more information refer to the
Configuring the Network chapter in the Oracle
Net Services section of this guide.
2. Create a password file with the Oracle utility ORAPWD under the user ID of the
instance you want to administrate. For more information of how to use
ORAPWD ,
refer to Oracle Database Administrator's Guide. To run the
ORAPWD utility on BS2000,
use the following command:
/START-PROGRAM $ORAC1120.ORAPWD
*file=password_file password=my_password entries=10
3. The name of the password file is taken from the parameter SSSIDPWF . So you must
add this parameter to the
ORAENV file of the instance you want to start:
SSSIDPWF = password_file
4. The parameter REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE in the
initialization file of the instance.
REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE