Cant Create Database

From: Jeff Smelser <tradergt_at_bigfoot.com>
Date: Sat, 2 Sep 2000 09:27:57 -0400
Message-ID: <Pine.LNX.4.10.10009020921380.2326-100000@server.smelser.org>

I get this when I try to create a database:

Oracle Server Manager Release 3.1.6.0.0 - Production

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 - 08:27:57 CDT