Re: create database fatal error

sybrandb@xxxxxxxxx wrote:

Surely. You are using the wrong tools for the wrong job.
Tools like OUI (Oracle Universal Installer) and DBCA (Database
Creation Assistant) all come with a silent mode.
Using silent mode, you would need to set up a template only once, and
you can use dbca from the commandline to create your database.

I agree, but its not my call.

Your second problem is you don't even try to understand error
messages.

With the enourmous complexity of Oracle systems its hard to understand anything without studying it or taking courses.

If you would have done so, you would have noticed your SYSTEM
tablespace is out of space.
Which is not surprising as a SYSTEM tablespace of 100M is a joke.
It needs to be 250M minimum.

I saw the error message but its not a very informative message if you dont know what it means

I revised the statment with larger numbers but I still get the same error message. I thought "size 500M" at the end of the system01.dbf was the correct place to fix the problem, but I was mistaken. Any info is highly appreciated.

create database ORACLE_SID
controlfile reuse undo tablespace "undotbs"
datafile
'ORACLE_BASE/oradata/ORACLE_SID/system01.dbf' size 500M
sysaux datafile
'ORACLE_BASE/oradata/ORACLE_SID/sysaux01.dbf' size 500M
logfile
'ORACLE_BASE/oradata/ORACLE_SID/redo01.dbf' size 50M,
'ORACLE_BASE/oradata/ORACLE_SID/redo02.dbf' size 50M
extent management local
default temporary tablespace mytemp
tempfile
'ORACLE_BASE/oradata/ORACLE_SID/temp01.dbf' SIZE 500M
noarchivelog
maxdatafiles 1000
maxlogfiles 10;


regards

tommy
.

Relevant Pages

  • Re: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS
    ... one which you could fix by removing the database). ... The bug report is below. ... > Informix Server Entries in sqlhosts file ... > # Error Message: ...
    (perl.dbi.users)
  • Re: Module Not Found
    ... Close the database. ... Still in the code window, choose Compile from the Debug menu. ... The error message could be related to something else that is going on, ... VB and press the cancel button I receive the error message ...
    (microsoft.public.access.formscoding)
  • Re: Cannot open my own Databases
    ... Windows Administrator and loads each of these service packs. ... If I have guessed correctly about the error message you see, ... See http://www.QBuilt.com for all your database needs. ... it's possible that the correct workgroup information file ...
    (microsoft.public.access.security)
  • Re: Begin... END; gives odd error:
    ... I am testing an Oracle interface layer, and created it as the System ... It doesn't matter if all this database stores is your grandmother's ... tablespace, a tablespace reserved for SYS and SYSTEM owned objects ... SQL> create user test identified by hokeypassword default tablespace ...
    (comp.databases.oracle.server)
  • RE: Form loading error
    ... Compact and repair your database; ... I just noticed that I get the same error message when I close the ... An error occured while loading Form_FrmXYZ. ... This Form (XYZ) is not the switchboard nor is it set to auto open. ...
    (microsoft.public.access.formscoding)