Oracle A423961 Manual Do Utilizador

☞

3 – 18

Oracle7 Server Getting Started for Windows NT 

Follow these steps to create a new database:

1.

Start the instance with the Instance Manager, or follow the
instructions in the Oracle Service section earlier in this chapter.

2.

Set the Oracle SID environment variable to equal the SID. For
example:

SET ORACLE_SID=ABC

If you will use this instance often, you can set the ORACLE_SID key
to equal the SID in the Windows NT Registry. To do this, start the
Registry’s editor, choose Software and Oracle.

3.

Start Server Manager from the command line and connect to the
database as follows:

SVRMGR>CONNECT INTERNAL/PASSWORD

   If you receive the errors DBA–00314 or ORA–09352,

the Oracle SID environment variable is not set to the instance’s
SID. See Step 2 above.

4.

Start an Oracle7 instance without mounting a database. If the
initialization parameter file you are using is not named

INIT

sid.ORA

 or is not located in the 

\ORANT\DATABASE

directory of the computer executing Server Manager, use the PFILE
option with the STARTUP statement:

SVRMGR>STARTUP NOMOUNT [PFILE=path\filename]

5.

If you created a SQL script file earlier, execute the CREATE
DATABASE statement stored in that script file by typing:

SVRMGR>@[path]filename

where filename is the name of the file containing the SQL statement.

If you did not create a SQL script for the CREATE DATABASE
statement, enter the statement directly at the SVRMGR prompt.

Oracle7 Server for Windows NT automatically creates the redo log
file(s) and database file(s) that you specify in the CREATE
DATABASE statement. It also creates the control files listed in the
CONTROL_FILES initialization parameter.

6.

After entering the CREATE DATABASE statement, you should run
the SQL script CATALOG.SQL to create the Oracle7 Server for
Windows NT data dictionary views and the script CATPROC.SQL if
you will be using PL/SQL.