Re: Problem creating any databases

Make sure that your ORACLE_HOME environment variable is set.

And make sure that in ORACLE_HOME/dbs there is a initORACLE_SID.ora file which is pointing to your real init.ora file in the ORACLE_HOME/admin/ORACLE_SID/pfile directory.

Or you could do:

startup nomount pfile='the full path and name of the init.ora file'

Good luck!

In article <8hmng0$qtq$1_at_nnrp1.deja.com>,   xafloc_at_my-deja.com wrote:
>
> > > 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 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.
> With or Without the " marks, it does the same exact thing.
>
> I have now re-installed Oracle 3 times, and I get the exact same
 results each
> time. I suspect it may have something to do with my setup...but I
 have no
> idea what. I have set it up using the instructions available on
 technet.
>
> This is becoming very frustrating.
>
> Any help appreciated,
>
> Darren
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Out the Ethernet, past the firewall, through the router, down the
T1...nothing but Net

In order to email me remove the '_not' from my email address.


Sent via Deja.com http://www.deja.com/
Before you buy.