Starting a database using instance manager, Starting a database using server manager, Shutting down an instance/database – Oracle A423961 User Manual

Page 69

Advertising
background image

3 – 11

Using Oracle7 Server for Windows NT

Starting a Database Using Instance Manager

Databases can be started using Instance Manager (by selecting the
Services and Instance checkboxes in Startup After Creation), or from
ORADIM73 command line mode.

Starting a Database Using Server Manager

To start the database using Server Manager, follow these steps:

1.

Start Server Manager by typing (at the command prompt):

C:\>SVRMGR73

2.

Connect to the database using your username:

SVRMGR> CONNECT username [/password]

When you use Server Manager in line mode, if you do not include a
password in your CONNECT statement and a password has been
set, Server Manager prompts you to enter one.

When you use Server Manager in screen mode, if you do not include
a password in your CONNECT statement and a password has been
set, Server Manager displays an error message. To enter your
password without typing it on the command line, choose Connect
from the Session menu.

3.

Start up the database by typing the following:

SVRMGR> STARTUP [PFILE=path\filename]

where path\filename specifies an initialization parameter file other
than the default,

INITsid.ORA

. This example starts the database

using a file named

INIT2.ORA

:

SVRMGR> STARTUP PFILE=C:\ORANT\RDBMS73\INIT2.ORA

After completing these steps, you can make local connections to Oracle7
Server.

Shutting Down an Instance/Database

In Release 7.3, you can startup and shutdown a database using Server
Manager, Database Manager, or ORADIM73 command line mode.
Instance Manager does not provide that functionality, except while
creating/deleting an instance.

Advertising