Re: build.sql script question

Hi,

You'll need to run the script from within Server Manager (svrmgrl). Before executing, ensure that the init.ora file is in the correct location (usually $ORACLE_HOME/dbs), that the Oracle SID is correctly set and that the control files are correctly specified.

Also, before the "create database" command can execute, you need the Oracle Instance in a NOMOUNT state.

Good Luck,
Andrew

Sweth Chandramouli wrote:

> i'm using the oracle press oracle 7.3 dba handbook to try
> to write some scripts to build my database, based on the sample
> script they give in appendix a of that book. now that i have
> "scriptified" my normal db creation process, however, i am faced
> with the embarrasing conclusion that i don't know what to do with
> that script. should it be run from sqlplus, or svrmgrl, or where?
> i didn't know that svrmgrl could take @script input, but i didn't
> think that one could 'connect internal' from sqlplus, either.
> tia for any advice.
>
> -- sweth.
>
> --
> Sweth Chandramouli
> IS Coordinator, The George Washington University
> <sweth_at_gwu.edu> / (202) 994 - 8521 (V) / (202) 994 - 0458 (F)
> *
Received on Tue Mar 30 1999 - 17:58:00 CST