Re: How to start an oracle instance

From: osy45 <member18536_at_dbforums.com>
Date: Tue, 21 Oct 2003 02:05:46 -0400
Message-ID: <3504309.1066716346_at_dbforums.com>


did you check the existence of the file?

by default the initSID.ora File is located in

$ORACLE_HOME/dbs

you can startup pfile=<pfilefilespec>

or with 92 you can build from an initSID.ora file a spfile

using sqlplus then invoking "create spfile from pfile "

the spfile is then the file Oracle 9i is looking for to startup

--
Posted via http://dbforums.com
Received on Tue Oct 21 2003 - 08:05:46 CEST

Original text of this message