- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Create Database Failed with write error
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2007 08:09 AM
тАО03-02-2007 08:09 AM
Create Database Failed with write error
-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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2007 08:47 AM
тАО03-02-2007 08:47 AM
Re: Create Database Failed with write error
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2007 08:53 AM
тАО03-02-2007 08:53 AM
Re: Create Database Failed with write error
>bdf .
Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvfs002 6291456 18010 5881362 0% /a4pkg/fs002
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-02-2007 03:43 PM
тАО03-02-2007 03:43 PM
Re: Create Database Failed with write error
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-04-2007 04:19 AM
тАО03-04-2007 04:19 AM
Re: Create Database Failed with write error
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=914430
regards
Mobeen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-05-2007 10:53 PM
тАО03-05-2007 10:53 PM
Re: Create Database Failed with write error
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