Cannot create database

[Benoît]

Hi,

Could someone tell me what am I missing?
ORA-01092: ORACLE instance terminated. Disconnection forced


There are my links to raw devices :

lrwxr-xr-x 1 oraclepr dba 31 Aug 31 10:40 SID_raw_cmwlite -> /dev/vgSID/rSID_raw_cmwlite
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_raw_control01 -> /dev/vgSID/rSID_raw_control01
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_raw_control02 -> /dev/vgSID/rSID_raw_control02
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_raw_control03 -> /dev/vgSID/rSID_raw_control03
lrwxr-xr-x 1 oraclepr dba 30 Aug 31 10:40 SID_raw_data01 -> /dev/vgSID/rSID_raw_data01
lrwxr-xr-x 1 oraclepr dba 30 Aug 31 10:40 SID_raw_data02 -> /dev/vgSID/rSID_raw_data02
lrwxr-xr-x 1 oraclepr dba 30 Aug 31 10:40 SID_raw_data03 -> /dev/vgSID/rSID_raw_data03
lrwxr-xr-x 1 oraclepr dba 30 Aug 31 10:40 SID_raw_data04 -> /dev/vgSID/rSID_raw_data04
lrwxr-xr-x 1 oraclepr dba 29 Aug 31 10:40 SID_raw_drsys -> /dev/vgSID/rSID_raw_drsys
lrwxr-xr-x 1 oraclepr dba 31 Aug 31 10:40 SID_raw_index01 -> /dev/vgSID/rSID_raw_index01
lrwxr-xr-x 1 oraclepr dba 31 Aug 31 10:40 SID_raw_index02 -> /dev/vgSID/rSID_raw_index02
lrwxr-xr-x 1 oraclepr dba 27 Aug 31 10:40 SID_raw_odm -> /dev/vgSID/rSID_raw_odm
lrwxr-xr-x 1 oraclepr dba 30 Aug 31 10:40 SID_raw_spfile -> /dev/vgSID/rSID_raw_spfile
lrwxr-xr-x 1 oraclepr dba 32 Aug 31 10:40 SID_raw_srvmconf -> /dev/vgSID/rSID_raw_srvmconf
lrwxr-xr-x 1 oraclepr dba 30 Aug 31 10:40 SID_raw_system -> /dev/vgSID/rSID_raw_system
lrwxr-xr-x 1 oraclepr dba 28 Aug 31 10:40 SID_raw_temp -> /dev/vgSID/rSID_raw_temp
lrwxr-xr-x 1 oraclepr dba 29 Aug 31 10:40 SID_raw_tools -> /dev/vgSID/rSID_raw_tools
lrwxr-xr-x 1 oraclepr dba 29 Aug 31 10:40 SID_raw_undo1 -> /dev/vgSID/rSID_raw_undo1
lrwxr-xr-x 1 oraclepr dba 29 Aug 31 10:40 SID_raw_undo2 -> /dev/vgSID/rSID_raw_undo2
lrwxr-xr-x 1 oraclepr dba 28 Aug 31 10:40 SID_raw_user -> /dev/vgSID/rSID_raw_user
lrwxr-xr-x 1 oraclepr dba 27 Aug 31 10:40 SID_raw_xdb -> /dev/vgSID/rSID_raw_xdb
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_thread_MlogA1 -> /dev/vgSID/rSID_thread_MlogA1
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_thread_MlogA2 -> /dev/vgSID/rSID_thread_MlogA2
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_thread_MlogB1 -> /dev/vgSID/rSID_thread_MlogB1
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_thread_MlogB2 -> /dev/vgSID/rSID_thread_MlogB2
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_thread_OlogA1 -> /dev/vgSID/rSID_thread_OlogA1
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_thread_OlogA2 -> /dev/vgSID/rSID_thread_OlogA2
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_thread_OlogB1 -> /dev/vgSID/rSID_thread_OlogB1
lrwxr-xr-x 1 oraclepr dba 33 Aug 31 10:40 SID_thread_OlogB2 -> /dev/vgSID/rSID_thread_OlogB2


There is my pfile:

*.aq_tm_processes=0
*.background_dump_dest='/oracle/admin/SID/bdump'
*.compatible='9.2.0'
*.control_files='/oracle/oradata/SID/SID_raw_control01', '/oracle/oradata/SID/SID_raw_control02', '/oracle/oradata/SID/SID_raw_control03'
*.core_dump_dest='/oracle/admin/SID/cdump'
*.db_block_size=8192
*.db_cache_advice='OFF'
*.db_cache_size=250M
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='SID'
*.fast_start_mttr_target=900
*.hash_join_enabled=TRUE
*.hpux_sched_noage=180
*.instance_name='SID'
*.java_pool_size=100M
*.job_queue_processes=2
*.large_pool_size=50M
*.log_archive_dest_1='location=/oracle/SID/arch'
*.log_archive_dest_2=''
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='SID_%t_%s.arc'
*.log_archive_start=TRUE
*.log_buffer=5242880
*.nls_date_language='FRENCH'
*.nls_iso_currency='FRANCE'
*.nls_language='FRENCH'
*.nls_territory='FRANCE'
*.open_cursors=1000
*.parallel_automatic_tuning=true
*.parallel_max_servers=24
*.parallel_min_servers=4
*.pga_aggregate_target=1000M
*.pre_page_sga=true
*.processes=1000
*.query_rewrite_enabled='FALSE'
*.recovery_parallelism=4
*.remote_login_passwordfile='exclusive'
*.REPLICATION_DEPENDENCY_TRACKING=false
*.shared_pool_size=200M
*.sort_area_size=2097152
*.standby_archive_dest='/oracle/SID/arch/drp/'
*.standby_file_management='auto'
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=900
*.undo_tablespace='UNDOTBS'
*.user_dump_dest='/oracle/admin/SID/udump'


SQL File is beg.sql:
create database SID
user sys identified by oraclepr
user system identified by manager
logfile '/oracle/oradata/SID/SID_thread_MlogA1' size 500M,
'/oracle/oradata/SID/SID_thread_OlogA1' size 500M
maxlogfiles 32
force logging
character set "WE8ISO8859P15"
datafile '/oracle/oradata/SID/SID_raw_system' size 500M
default temporary tablespace temp
undo tablespace undotbs datafile '/oracle/oradata/SID/SID_raw_undo1';


There is what I do:

smcpp11:oracle:/oracle>sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.3.0 - Production on Me Aou 31 17:19:58 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/oracle/admin/SID/pfile/initSID.ora'
ORACLE instance started.

Total System Global Area 727674832 bytes
Fixed Size 737232 bytes
Variable Size 452984832 bytes
Database Buffers 268435456 bytes
Redo Buffers 5517312 bytes
SQL> @/oracle/admin/SID/beg.sql
create database SID
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

[Steven E. Protter]

What user owns the disk areas?

Is it the same user that owns the oracle binaries?

http://www.google.com/url?sa=t&ct=res&cd=1&url=http%3A//oracle.ittoolbox.com/groups/groups.asp%3Fv%3Doracle-db-l%26i%3D805709&ei=_M4VQ_HQKo7maJTo5e0N

Might help a bit.

SEP

[Jean-Luc Oudart]

Hi Benoit

I refer to Metalink Note:332476.1 "Create Database Failed With ORA-01092"

I think this is to do with the fact you did not specify a datafile for tablespace temp

Regards
Jean-Luc

[Yogeeraj_1]

hi,

can you try the same using the DBCA?

As mentioned above, there may be something missing in the script..

regards
yogeeraj

[Ganesha Sridhara]

Following string is from Oracle site:
-------------------------

The problem can be caused if no datafile clause is specified for a tablespace defined in create database.

In the example,No datafile clause for default tablespace clause specified.

Solution
1.In create database statement , Modify the default tablespace clause to include datafile clause .

2.Set DB_CREATE_FILE_DEST .If this parameter is specified datafile clause is not needed and Oracle will create datafiles in the destination specified.
-------------------------

Regards
Ganesha Sridhara

[Benoît]

Found solution using scripts created by DBCA.