problems creating new database

From: MichalF <faflu_at_gazeta.pl>
Date: 1 Sep 2006 16:13:56 -0700
Message-ID: <1157152436.290264.30420@m73g2000cwd.googlegroups.com>

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_at_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 Received on Fri Sep 01 2006 - 18:13:56 CDT