Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create Databse Problem
You need to set your ORACLE_SID to the NEW instance!
Startup nomount does nothing more than starting the background processes,
and work always, also when the database doesn't exist.
So please
$ORACLE_SID = <new instance>; export $ORACLE_SID
svrmgrl
connect internal
startup nomount (and you won't need the pfile, if the filename is standard,
ie $ORACLE_HOME/dbs/init<NEW_SID>.ora)
Then create your database. It may be advisable though
a) to have that command in a script
b) to
spool createdb${ORACLE_SID}.log
before you do the create database, in order not to miss out any errors.
Hth,
--
Sybrand Bakker, Oracle DBA
<elizabeth1000_at_my-deja.com> wrote in message
news:7v2pj8$uh6$1_at_nnrp1.deja.com...
> I know this is an extremely newby question but please bear with me.
>
> I am on a UNIX box and have created my config and init files for the
> new instance I've been told to create.
>
> There are currently 3 instances running on this box, my SID
> environmental variable points at one of them.
>
> I go into svrmgrl and connect internal, then type "startup nomount
> pfile= and give it the name of my file, this is what the book says to
> do prior to issuing the create database command.
>
> It tells me Oracle is already started shut it down first. Well I can't
> shut it down because people are using the database.
>
> It seems like I shouldn't be connecting to an instance thats in use?
> But if I don't connect to an active database how do I issue the
> create database command?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 26 1999 - 00:13:29 CDT