topic Re: Create Database Failed with write error in Operating System - HP-UX

Create Database Failed with write error

NorrisHenry — Fri, 02 Mar 2007 16:09:07 GMT

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

Re: Create Database Failed with write error

Sundar_7 — Fri, 02 Mar 2007 16:47:57 GMT

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.

Re: Create Database Failed with write error

NorrisHenry — Fri, 02 Mar 2007 16:53:02 GMT

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

Re: Create Database Failed with write error

Yogeeraj_1 — Fri, 02 Mar 2007 23:43:47 GMT

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

Re: Create Database Failed with write error

Mobeen_1 — Sun, 04 Mar 2007 12:19:46 GMT

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

Re: Create Database Failed with write error

Subodh deshpande_1 — Tue, 06 Mar 2007 06:53:30 GMT

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