Can't create Oracle Instance with symbolic link to Raw devices
Date: 26 Jul 2002 03:42:13 -0700
Message-ID: <83f59352.0207260242.2a87862c_at_posting.google.com>
Dear all,
I tried to create an Oracle Instance on our HP-UX (64-bit) with
symbolic link to Raw devices with no luck. The following is what I did
brw-rw--w- 1 oracle dba 64 0x01001d Jul 26 13:30
orcl_redo2
2. make symbolic lin to those raw device as follow:
3. Run create database sql script as follow:
connect internal
(vg01)
and change owner to oracle. for example like :
brw-rw--w- 1 oracle dba 64 0x01001e Jul 26 13:30
orcl_redo3
brw-rw--w- 1 oracle dba 64 0x01001b Jul 26 13:29
orcl_system
brw-rw--w- 1 oracle dba 64 0x010020 Jul 26 13:30
orcl_temp
crw-rw--w- 1 oracle dba 64 0x010021 Jul 26 13:30
rorcl_data01
crw-rw--w- 1 oracle dba 64 0x010022 Jul 26 13:31
rorcl_idx01
crw-rw--w- 1 oracle dba 64 0x010023 Jul 26 13:41
rorcl_other
......etc.
ln -sf /dev/vg01/rorcl_data01 data01.dbf
ln -sf /dev/vg01/rorcl_rds rds01.dbf
ln -sf /dev/vg01/rorcl_system system01.dbf
ln -sf /dev/vg01/rorcl_temp temp01.dbf
ln -sf /dev/vg01/rorcl_idx01 tsidx01.dbf
.... etc.
startup nomount pfile=/oradata/orcl/pfile/initorcl.ora
create database "orcl"
maxinstances 1
maxlogfiles 32
maxdatafiles 200
character set "US7ASCII"
datafile '/oradata/orcl/data/system01.dbf' size 20M
logfile '/oradata/orcl/redo/redo01.log' size 10M,
'/oradata/orcl/redo/redo02.log' size 10M,
'/oradata/orcl/redo/redo03.log' size 10M;
and it generated error message as follow:
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near
line 407
ORA-00604: error occurred at recursive SQL level 1
ORA-19502: write error on file "/oradata/orcl/data/system01.dbf",
blockno 5057
(blocksize=4096)
ORA-27072: skgfdisp: I/O error
HP-UX Error: 2: No such file or directory
Additional information: 5057
I don't know the procedure is correct or not??? PLEASE ADVISE.
THANK YOU... KEN Received on Fri Jul 26 2002 - 12:42:13 CEST