Bonjour,
J'essaye de créer une nouvelle base de données.
Mais lorsque j'exécute mon script de création, j'ai un message d'erreur :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 CREATE DATABASE SECODVPT * ERREUR à la ligne 1 : ORA-01092: ORACLE instance terminated. Disconnection forced ORA-01501: CREATE DATABASE failed ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq' near line 5 ORA-00604: error occurred at recursive SQL level 1 ORA-19502: write error on file "/snecma/product/oracle/oradata/SECODVPT/system/UNDO_001_01.dbf", block number 9376 (block size=32768) ORA-27072: File I/O error Additional information: 4 Additional information: 9376 Additional information: 507904 ID de processus : 1014 ID de session : 210, Numéro de série : 1
Voici le contenu de mon script de création de base :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25 spool cre_database_SECODVPT.log startup nomount pfile='/snecma/product/oracle/sgbd/SECODVPT/pfile/initSECODVPT.ora'; CREATE DATABASE SECODVPT USER SYS IDENTIFIED BY SYS USER SYSTEM IDENTIFIED BY SYSTEM MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXDATAFILES 1000 MAXINSTANCES 1 CONTROLFILE REUSE CHARACTER SET WE8ISO8859P15 NATIONAL CHARACTER SET AL16UTF16 DATAFILE '/snecma/product/oracle/oradata/SECODVPT/system/SYS_001_01.dbf' SIZE 3072M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/snecma/product/oracle/oradata/SECODVPT/system/sysaux_01.dbf' SIZE 512M REUSE DEFAULT TEMPORARY TABLESPACE TEMP_001 TEMPFILE '/snecma/product/oracle/oradata/SECODVPT/system/TEMP_001_01.dbf' SIZE 2048M REUSE UNDO TABLESPACE UNDO_001 DATAFILE '/snecma/product/oracle/oradata/SECODVPT/system/UNDO_001_01.dbf' SIZE 2048M REUSE LOGFILE GROUP 1 ('/snecma/product/oracle/oradata/SECODVPT/system/LOG_011.rdo','/snecma/product/oracle/oradata/SECODVPT/system/LOG_012.rdo') SIZE 100M REUSE, GROUP 2 ('/snecma/product/oracle/oradata/SECODVPT/system/LOG_021.rdo','/snecma/product/oracle/oradata/SECODVPT/system/LOG_022.rdo') SIZE 100M REUSE, GROUP 3 ('/snecma/product/oracle/oradata/SECODVPT/system/LOG_031.rdo','/snecma/product/oracle/oradata/SECODVPT/system/LOG_032.rdo') SIZE 100M REUSE; spool off
Dans mon pfile, j'ai ceci :
Est ce que ça inspire quelqu'un?
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35 #background_dump_dest='/snecma/product/oracle/sgbd/SECODVPT/bdump' compatible=11.2.0.4 control_files='/snecma/product/oracle/oradata/SECODVPT/system/CTRL_001.ctl','/snecma/product/oracle/oradata/SECODVPT/system/CTRL_002.ctl' #core_dump_dest='/snecma/product/oracle/sgbd/SECODVPT/cdump' db_block_size=32768 db_cache_size=1073741824 db_file_multiblock_read_count=4 db_name='SECODVPT' fast_start_mttr_target=300 #hash_join_enabled=TRUE instance_name='SECODVPT' java_pool_size=1024 large_pool_size=536870912 nls_language='AMERICAN' nls_sort='BINARY' nls_territory='AMERICA' open_cursors=300 optimizer_index_caching=0 optimizer_index_cost_adj=100 pga_aggregate_target=1073741824 processes=150 query_rewrite_enabled='TRUE' remote_login_passwordfile='none' shared_pool_size=536870912 #sort_area_size=524288 #sql_trace=FALSE star_transformation_enabled='TRUE' timed_statistics=TRUE UNDO_MANAGEMENT=AUTO undo_retention=10800 undo_tablespace=UNDO_001 #user_dump_dest='/snecma/product/oracle/sgbd/SECODVPT/udump' audit_file_dest=/snecma/product/oracle/sgbd/SECODVPT/audit #gby_hash_aggregation_enabled = 'FALSE' #diagnostis_dest='/snecma/product/oracle/sgbd/SECODVPT/udump'
Partager