Re: Cant Create Database

Shutdown the database first and retry.
Another reason, IIRC, is the ORACLE_SID not being equal to the sid in init<sid>.ora.

Hth,

Sybrand Bakker, Oracle DBA

"Jeff Smelser" <tradergt_at_bigfoot.com> wrote in message news:Pine.LNX.4.10.10009020921380.2326-100000_at_server.smelser.org...
> I get this when I try to create a database:
>
> Oracle Server Manager Release 3.1.6.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
> SVRMGR> SVRMGR> Connected.
> SVRMGR> ORACLE instance started.
> Total System Global Area 116068336 bytes
> Fixed Size 69616 bytes
> Variable Size 99049472 bytes
> Database Buffers 16777216 bytes
> Redo Buffers 172032 bytes
> SVRMGR> 2> 3> 4> 5> 6> 7> 8> 9>
> 10> CREATE DATABASE "orclrep"
> *
> ORA-01501: CREATE DATABASE failed
> ORA-01101: database being created currently mounted by some other instance
> SVRMGR> ORA-01507: database not mounted
> ORACLE instance shut down.
> SVRMGR> Disconnected.
> SVRMGR> SVRMGR> Server Manager complete.
>
>
> This is on redhat 6.1 using oracle EE edition 8.1.6... Commands are:
>
> #!/bin/sh
> ORACLE_SID=orclrep
> export ORACLE_SID
>
> /o02/app/oracle/product/8.1.5/bin/svrmgrl << EOF
> spool /o02/app/oracle/admin/orclrep/create/crdb1.log
> connect internal/oracle
> startup nomount pfile =
> "/o03/app/oracle/admin/orclrep/pfile/initorclrep.ora"
> CREATE DATABASE "orclrep"
> maxdatafiles 254
> maxinstances 8
> maxlogfiles 32
> character set US7ASCII
> national character set US7ASCII
> DATAFILE '/o03/app/oracle/oradata/orclrep/system01.dbf' SIZE 54M
> AUTOEXTEND ON NEXT 640K
> logfile '/o01/app/oracle/oradata/orclrep/redo01.log' SIZE 500K,
> '/o02/app/oracle/oradata/orclrep/redo02.log' SIZE 500K,
> '/o03/app/oracle/oradata/orclrep/redo03.log' SIZE 500K;
> shutdown
> disconnect
> spool off
> exit
>
>
> EOF
>
> I had DBASSIST create the .sh scripts so I can run them. Much faster. I
> have never had this problem before..
>
> Thanks,
> Jeff
>
>
Received on Sat Sep 02 2000 - 10:33:49 CDT