Re: Problem creating any databases

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/06/09
Message-ID: <394098d0@news.iprimus.com.au>#1/1

<ddf_dba_at_my-deja.com> wrote in message news:8hlogh$33o$1_at_nnrp1.deja.com...
> In article <8hk542$tsb$1_at_nnrp1.deja.com>,
> xafloc_at_my-deja.com wrote:
> > Hello all.
> >
> > I have just installed Oracle 8i on a Red Hat 6.2 system. All has gone
 well
> > up to this point, but I am running into problems creating databases.
> >
> > When I run the scripts created from dbassist, I get this:
> >
> > SVRMGR> connect internal
> > Connected.
> > SVRMGR> create database "elinux"
> > 2> ;
> > create database "elinux"
> > *
> > ORA-01012: not logged on
> > SVRMGR>
> >

I don't see a startup command in there. If you don't have an instance running (in nomount stage, obviously) you're not going to get very far.

Try a 'startup' before issuing the 'create database' command.

HJR
> > I am not sure what is going on, except that it is not working.
 Can someone
> > point me to something to check, or something I may have forgotten to
 do, etc.
> > This system has been patched with the latest patch for Linux.
> >
> > Thanks
> >
> > Darren
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >

>

> Darren,

>

> It would appear that the quotation marks around the database name are
> the culprits. Remove the quotes and try to run the script again. I
> have yet to create a database with the name in quotations and the Oracle
> documentation does not list any quotation marks in the command syntax.

>

> David Fitzjarrell
> Oracle DBA

>
>

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jun 09 2000 - 00:00:00 CDT