Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Create Database Failed with write error

NorrisHenry
Occasional Visitor

Create Database Failed with write error

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
5 REPLIES
Sundar_7
Honored Contributor

Re: Create Database Failed with write error

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.
Learn What to do ,How to do and more importantly When to do ?
NorrisHenry
Occasional Visitor

Re: Create Database Failed with write error

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
Honored Contributor

Re: Create Database Failed with write error

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Mobeen_1
Esteemed Contributor

Re: Create Database Failed with write error

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

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