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

a)You should do step#3 before step#2.
b) Your database (or instance) has been created in step#3.

     Now run step#2 to bind the Oracle's applications & tools to kernel. c) before connect to Oracle with SVRMGR23, do this

    >set ORACLE_SID='your database id'
    then >SVRMGR23 <enter>
    when you get to the message - 'Connected to an idle instance'     > startup
will get your database/instance running.

James Paul wrote in message ...
>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 Sat May 01 1999 - 08:06:16 CDT