Re: Still can't create a database ... but making progress!

John

Looks like you got part way through building a database, and you're in the mounted state. To fix this, exit from svrmgr, restart it, connect as internal or sysdba (whichever you prefer), then do a "startup nomount". Now try the database creation command. It may still fail if you have files that were built from the previous run, in which case you should get rid of the old files.

Alternatively, you could be pointing at a different DB. Is this the only one you have on the box? If not, check the value of %ORACLE_SID% and make sure you're pointing the the SID for the database to be built, not one that already exists.

HTH. Pete

Inquisitor wrote:

> Hi All ...
>
> Thanks to the respondents of my previous post! ...
>
> I'm now running svrmgr (Oracle 7.3) on NT4.0 and receive the following
> during an attempted database create, after 'connect internal' and/or
> 'connect / as sysdba':
>
> SVRMGR> create database pbidb;
> create database pbidb
> *
> ORA-01501: CREATE DATABASE failed
> ORA-01100: database already mounted
> SVRMGR>
>
> This is followed by a period of disk activity, which is
> remedied only by shutting down the Oracle instance.
>
> Any ideas on this one? ...
>
> Thanks again for any help!
>
> John

Received on Wed Sep 15 1999 - 11:12:37 CDT