Re: Can't create database - this must be an easy one...

James,

Did you make sure that the Oracle SID was changed for the session when you ran the STARTUP NOMOUNT and the Createdatabase script.

Andrew

James Paul wrote:

> I'm trying to create a database using Oracle 7.3 on NT Server 4. When I run
> my CreateDatabase script I get an ORA-01034 error - 'ORACLE not available'.
> Basically I did the folllowing:-
>
> (1) Installed Oracle
>
> (2) Ran scripts - Catproc, Standard, Dbmsutils, Catalog and Dbmsstdx
>
> (3) I created an instance of my db using Oradim73.
>
> (4) I checked in the Services applet and there is an instance running.
>
> (5) Run SVRMGR23 - connect internal and provide my db password. Get a
> message - 'Connected to an idle instance'. I assume this means I don't need
> to run 'STARTUP NOMOUNT pfile=e:\orant\database\initisel.ora'?
>
> (6) Run my CreateDatabse script and get an ORA-01034 error - 'ORACLE not
> available'
>
> What have I missed? Any suggestions would be gratefully welcomed.
>
> Thanks
> James Paul
Received on Fri Apr 30 1999 - 20:19:50 CDT