10.1.0.4 2005-05-14 - By Andrey V. Prudovsky
hmm.. I get the same error, in case of "bugging" hardware (this be a
nonstable working XEON 2.0 MP).
First, Ithink U must look at Disc/RAID controller and a module ("driver")
for them
Andrew Edunov <and@(protected)> ???????? 14.05.2005 16:33:54:
> Hi All!!
>
> Some problem with oracle when i try to create tablespace:
>
> SQL> CREATE TABLESPACE QUEEN_IDX DATAFILE
> 2 '/u07/oracle/oradata/sunset/queen_idx_01.dbf' SIZE 2048M
> AUTOEXTEND OFF,
> 3 '/u08/oracle/oradata/sunset/queen_idx_02.dbf' SIZE 2048M
> AUTOEXTEND OFF,
> 4 '/u09/oracle/oradata/sunset/queen_idx_03.dbf' SIZE 2048M
> AUTOEXTEND OFF,
> 5 '/u07/oracle/oradata/sunset/queen_idx_04.dbf' SIZE 2048M
> AUTOEXTEND OFF,
> 6 '/u08/oracle/oradata/sunset/queen_idx_05.dbf' SIZE 2048M
> AUTOEXTEND OFF,
> 7 '/u09/oracle/oradata/sunset/queen_idx_06.dbf' SIZE 2048M
> AUTOEXTEND OFF
> 8 NOLOGGING
> 9 ONLINE
> 10 PERMANENT
> 11 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
> 12 BLOCKSIZE 8K
> 13 SEGMENT SPACE MANAGEMENT AUTO
> 14 FLASHBACK ON;
>
> CREATE TABLESPACE QUEEN_IDX DATAFILE
> *
> ERROR at line 1:
> ORA-19502 (See ORA-19502.ora-code.com): write error on file
> "/u07/oracle/oradata/sunset/queen_idx_01.dbf",
> blockno 17664 (blocksize=8192)
> ORA-27061 (See ORA-27061.ora-code.com): waiting for async I/Os failed
> Linux Error: 5: Input/output error
> Additional information: -1
> Additional information: 1048576
>
> Somebody know something about this problem?
>
> P.S.: Sles9 kernel-bigsmp-2.6.5-7.139 libaio-0.3.98-18.3
> libaio-devel-0.3.98-18.3
>
> --
> Andrew Edunov
> IT Administrator / MSK
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>
|
|
