problems creating new database

Giganews Newsgroups
Subject: problems creating new database
Posted by:  MichalF (faf…@gazeta.pl)
Date: 1 Sep 2006

I have the following problem creating oracle database (10.1.0.3.0):
init file:
visma.__db_cache_size=436207616
visma.__java_pool_size=4194304
visma.__large_pool_size=4194304
visma.__shared_pool_size=155189248
*.compatible='10.1.0.2.0'
*.control_files='/oracle/OraHome/oradata/visma/visma_control01.ctl','/oracle/OraHome/oradata/visma/visma_control02.ctl','/oracle/OraHome/oradata/visma/visma_control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='visma'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=200278016
*.processes=150
*.session_cached_cursors=200
*.sga_target=600834048
*.shared_pool_size=54525952
*.statistics_level='ALL'
*.undo_management='AUTO'
undo_tablespace='undotbs'
background_dump_dest='/oracle/admin/visma/bdump'
core_dump_dest='/oracle/admin/visma/cdump'
user_dump_dest='/oracle/admin/visma/udump'

Create database statement:
CREATE DATABASE visma
    user sys identified by *
    user system identified by *
  LOGFILE GROUP 1 ('/oracle/OraHome/oradata/visma/redo01.log') SIZE
200M,
          GROUP 2 ('/oracle/OraHome/oradata/visma/redo02.log') SIZE
200M,
          GROUP 3 ('/oracle/OraHome/oradata/visma/redo03.log') SIZE
200M,
      GROUP 4 ('/oracle/OraHome/oradata/visma/redo04.log') SIZE 200M
  MAXLOGFILES 5
  MAXLOGMEMBERS 5
  MAXLOGHISTORY 1
  MAXDATAFILES 100
  CHARACTER SET EE8MSWIN1250
  DATAFILE '/oracle/OraHome/oradata/visma/system01.dbf' SIZE 300M
REUSE
  EXTENT MANAGEMENT LOCAL
  SYSAUX DATAFILE '/oracle/OraHome/oradata/visma/sysaux01.dbf' SIZE
140M REUSE
    default tablespace tbs_1
  DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE '/oracle/OraHome/oradata/visma/temp01.dbf'
      SIZE 400M REUSE
  UNDO TABLESPACE undotbs
      DATAFILE '/oracle/OraHome/oradata/visma/undotbs01.dbf'
      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

As a result of running I get disconnected and the following trace:
/oracle/admin/visma/udump/visma_ora_3310.trc
Oracle Database 10g Release 10.1.0.3.0 - Production
ORACLE_HOME = /oracle/OraHome
System name:    Linux
Node name:    oraclepl
Release:    2.4.21-47.ELsmp
Version:    #1 SMP Wed Jul 5 20:38:41 EDT 2006
Machine:    i686
Instance name: visma
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 3310, image: oracle@oraclepl (TNS V1-V3)

*** 2006-09-02 00:57:36.888
*** SERVICE NAME:(SYS$USERS) 2006-09-02 00:57:36.888
*** SESSION ID:(162.1) 2006-09-02 00:57:36.888
Created Undo Segment _SYSSMU1$
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Offending statement at line 6083
CREATE  TABLESPACE TBS_1 DATAFILE  SEGMENT SPACE MANAGEMENT MANUAL
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near
line 6083
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name

What's wrong with that? Please help
TIA
Michal

Replies