CREATE DATABASE with dbca fails

From: Sebastian Damm <slim.post_at_gmx.de>
Date: Wed, 27 Apr 2005 17:23:18 +0000 (UTC)
Message-ID: <slrnd6vik6.pip.slim.post_at_gibsmir.csn.tu-chemnitz.de>

Hello,

first of all, I have absolutely no clue of Oracle, and my usual fields of activity have nothing to do with Oracle, so please excuse my maybe kind of stupid question. But a friend asked me to get a combination of Oracle/Compiere running on a Linux box. So I tried it, but I am stuck for quite a while already at the point, where I have to create a database for Compiere.

Since I don't know the syntax, how an Oracle CREATE DATABAE statement must look like, I can't tell what's wrong with it. I want to use the dbca tool for creating the database. I follow all the steps and then I want to create the database, which fails (already at 2% progress) with the error "ORACLE-Instance terminated. Disconnection forced."

I let the tool generate scripts for me, so here is what it tried to do:

#v+

[oracle_at_zo scripts]$ cat CreateDB.sql connect SYS/&&sysPassword as SYSDBA
set echo on
spool /ora/10.1.0.3/assistants/dbca/logs/CreateDB.log startup nomount pfile="/ora/admin/compiere/scripts/init.ora"; CREATE DATABASE "compiere"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/ora/oradata/compiere/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/ora/oradata/compiere/sysaux01.dbf' SIZE 120M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/ora/oradata/compiere/temp01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED UNDO TABLESPACE "UNDOTBS1" DATAFILE '/ora/oradata/compiere/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF8

LOGFILE GROUP 1 ('/ora/oradata/compiere/redo01.log') SIZE 10240K,
GROUP 2 ('/ora/oradata/compiere/redo02.log') SIZE 10240K,
GROUP 3 ('/ora/oradata/compiere/redo03.log') SIZE 10240K

USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword"; spool off
[oracle_at_zo scripts]$
#v-

In the create Directory I have the following log file: (the last line means "ORACLE-Instance terminated. Disconnection forced.")

#v+

[oracle_at_zo create]$ cat CreateDB.log
ORACLE-Instance hochgefahren.
Total System Global Area 167772160 bytes

Fixed Size                   778212 bytes
Variable Size              57679900 bytes
Database Buffers          109051904 bytes
Redo Buffers                 262144 bytes

CREATE DATABASE "compiere"
*
FEHLER in Zeile 1:
ORA-01092: ORACLE-Instance beendet. Verbindungsabbruch erzwungen.

[oracle_at_zo create]$
#v-

And in the udump directory I have this file:

#v+

[oracle_at_zo udump]$ cat compiere_ora_3686.trc /ora/admin/compiere/udump/compiere_ora_3686.trc Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production With the Partitioning, Oracle Label Security, OLAP and Data Mining options ORACLE_HOME = /ora/10.1.0.3
System name: Linux

Node name:      zo.heat.nba
Release:        2.6.9-5.0.5.EL
Version:        #1 Tue Apr 19 14:33:20 CDT 2005
Machine:        i686

Instance name: compiere
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 3686, image: oracle_at_zo.heat.nba (TNS V1-V3)

• SERVICE NAME:(SYS$USERS) 2005-04-27 19:05:20.068
• SESSION ID:(162.1) 2005-04-27 19:05:20.068 ORA-00604: error occurred at recursive SQL level 1 ORA-00922: missing or invalid option Offending statement at line 2254 create user sys identified by *****. ORA-01501: CREATE DATABASE failed [Quoted] ORA-01519: error while processing file '?/rdbms/admin/sql.bsq', near line 2254 ORA-00604: error occurred at recursive SQL level 1 ORA-00922: missing or invalid option [oracle_at_zo udump]$
  #v-
  

Could anybody please tell me how to fix this error? I already played with the options of the dbca tool for about a thousand times, but couldn't figure it out, how to get a correct statement.

How would I just execute the (maybe corrected) files in the scripts directory?

System: Scientific Linux 4.0 (Kernel 2.6.9)

        Oracle 10g

Any help would be greatly appreciated.

Sebastian

-- 
Sebastian Damm ........................................ slim.post_at_gmx.de

Received on Wed Apr 27 2005 - 19:23:18 CEST