Re: problems creating new database

MichalF wrote:
> 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

Well for one thing I doubt you can get the SYSTEM and SYSAUX objects into the allocated space.

SQL> select tablespace_name, sum(bytes)

   2 from dba_segments
   3 group by tablespace_name;

TABLESPACE_NAME                SUM(BYTES)
------------------------------ ----------
SYSAUX                          369819648
SYSTEM                          530120704

That said you haven't gotten that far into the build. I have never seen an error message referring to sql.bsq and would suggest you open it up and find out what is at or near line 6083. Otherwise ... metalink + SR.

-- 
Daniel Morgan
Puget Sound Oracle Users Group