Create Database Failed with write error

[NorrisHenry]

Can anyonehelp me figure out what the HP-UX problem is creating a 100M redo log?

-H

SQL> startup nomount pfile="/oradata/A4DCUT/admin/create/init.ora";
ORACLE instance started.

Total System Global Area 2149012216 bytes
Fixed Size 729848 bytes
Variable Size 2030043136 bytes
Database Buffers 117440512 bytes
Redo Buffers 798720 bytes
SQL> CREATE DATABASE A4DCUT
2 MAXINSTANCES 1
3 MAXLOGHISTORY 1
4 MAXLOGFILES 5
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 1000
7 DATAFILE '/oradata/A4DCUT/system/system01.dbf' SIZE 500M REUSE
8 EXTENT MANAGEMENT LOCAL
9 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/A4DCUT/system/temp01.
bf' SIZE 500M REUSE
10 UNDO TABLESPACE "UNDOTBS1" DATAFILE '/oradata/A4DCUT/system/undotbs01.dbf'
SIZE 500M REUSE
11 CHARACTER SET WE8ISO8859P1
12 NATIONAL CHARACTER SET AL16UTF16
13 LOGFILE GROUP 1 ('/oradata/A4DCUT/redo1/redo01_01.log',
14 '/oradata/A4DCUT/redo2/redo01_02.log') SIZE 102400K,
15 GROUP 2 ('/oradata/A4DCUT/redo1/redo02_01.log',
16 '/oradata/A4DCUT/redo2/redo02_02.log') SIZE 102400K,
17 GROUP 3 ('/oradata/A4DCUT/redo1/redo03_01.log',
18 '/oradata/A4DCUT/redo2/redo03_02.log') SIZE 102400K,
19 GROUP 4 ('/oradata/A4DCUT/redo1/redo04_01.log',
20 '/oradata/A4DCUT/redo2/redo04_02.log') SIZE 102400K,
21 GROUP 5 ('/oradata/A4DCUT/redo1/redo05_01.log',
22 '/oradata/A4DCUT/redo2/redo05_02.log') SIZE 102400K;
CREATE DATABASE A4DCUT
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-19502: write error on file "/oradata/A4DCUT/redo2/redo05_02.log", blockno
80897 (blocksize=1024)
ORA-27072: skgfdisp: I/O error
HPUX-ia64 Error: 2: No such file or directory
Additional information: 80897

[Sundar_7]

Norris,

I guess the database creation failed most probably because of lack of space.

$ bdf /oradata/A4DCUT/redo2/

Make sure you have enough space in the filesystem before attempting the creation.

Thanks,

Sundar.

[NorrisHenry]

Thanks Sundar, it does have enough space. It's only a 100M redo log file.

>bdf .
Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvfs002 6291456 18010 5881362 0% /a4pkg/fs002

[Yogeeraj_1]

hi,

as the oracle user try to create a file in the directory /oradata/A4DCUT/redo2/ and see if you have got enough privileges.

touch /oradata/A4DCUT/redo2/aa.test

revert

kind regards
yogeeraj

[Mobeen_1]

Norris, it looks like this has already been addressed in the thread below

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=914430

regards
Mobeen

[Subodh deshpande_1]

1. Check out the permissions on the filesystem.
2. Check if there is space on the file system.
3. Verify if the file system is fine.
4. Verify if the file already exists in the filesystem.

Rgds
Subodh