[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: [linux-lvm] Problems while trying to crash Oracle database



you could try kill -9 ? :)

HERUR,CHANNABASAPPA (HP-India,ex2) wrote:

Hi ,
I am basically trying to crash the oracle database which has been
created using raw logical volumes . When I use 'dd' command to crash the
oracle database I find that the database is actually not crashing .


	I used the following steps to create Oracle database on raw logical
volumes .


1. Created Physical Volumes's using pvcreate command # pvcreate /dev/sdp
pvcreate -- physical volume "/dev/sdp" successfully created


# pvcreate /dev/sdq
pvcreate -- physical volume "/dev/sdq" successfully created

2. Created Volume Groups's
# vgcreate vg06 /dev/sdp
vgcreate -- INFO: using default physical extent size 4.00 MB
vgcreate -- INFO: maximum logical volume size is 255.99 Gigabyte
vgcreate -- doing automatic backup of volume group "vg06"
vgcreate -- volume group "vg06" successfully created and activated

# vgcreate vg07 /dev/sdq
vgcreate -- INFO: using default physical extent size 4.00 MB
vgcreate -- INFO: maximum logical volume size is 255.99 Gigabyte
vgcreate -- doing automatic backup of volume group "vg07"
vgcreate -- volume group "vg07" successfully created and activated

3. Created Logical Volume's

# lvcreate -l 25 -n control01.ctl /dev/vg06
lvcreate -- doing automatic backup of "vg06"
lvcreate -- logical volume "/dev/vg06/control01.ctl" successfully created

# lvcreate -l 25 -n control02.ctl /dev/vg06
lvcreate -- doing automatic backup of "vg06"
lvcreate -- logical volume "/dev/vg06/control02.ctl" successfully created

# lvcreate -l 100 -n system01.dbf /dev/vg06
lvcreate -- doing automatic backup of "vg06"
lvcreate -- logical volume "/dev/vg06/system01.dbf" successfully created

# lvcreate -l 100 -n log01.log /dev/vg07
lvcreate -- doing automatic backup of "vg07"
lvcreate -- logical volume "/dev/vg07/log01.log" successfully created

# lvcreate -l 100 -n log02.log /dev/vg07
lvcreate -- doing automatic backup of "vg07"
lvcreate -- logical volume "/dev/vg07/log02.log" successfully created

4. Removed the existing raw devices

[root LNXSRVZ /dev]# rm /dev/raw/raw41
rm: remove `/dev/raw/raw41'? y
[root LNXSRVZ /dev]# rm /dev/raw/raw42
rm: remove `/dev/raw/raw42'? y
[root LNXSRVZ /dev]# rm /dev/raw/raw43
rm: remove `/dev/raw/raw43'? y
[root LNXSRVZ /dev]# rm /dev/raw/raw44
rm: remove `/dev/raw/raw44'? y
[root LNXSRVZ /dev]# rm /dev/raw/raw45
rm: remove `/dev/raw/raw45'? y

5.Recreate raw devices using 'mknod' command

# mknod /dev/vg06/rsystem01.dbf c 162 41
# mknod /dev/vg06/rcontrol01.ctl c 162 42
# mknod /dev/vg06/rcontrol02.ctl c 162 43
# mknod /dev/vg07/rlog01.log c 162 44
# mknod /dev/vg07/rlog02.log c 162 45


6. Used 'raw' command to bind raw device to block device


# raw /dev/vg06/rsystem01.dbf /dev/vg06/system01.dbf
/dev/raw/raw41: bound to major 58, minor 19
# raw /dev/vg06/rcontrol01.ctl /dev/vg06/control01.ctl
/dev/raw/raw42: bound to major 58, minor 17
# raw /dev/vg06/rcontrol02.ctl /dev/vg06/control02.ctl
/dev/raw/raw43: bound to major 58, minor 18
# raw /dev/vg07/rlog01.log /dev/vg07/log01.log
/dev/raw/raw44: bound to major 58, minor 20
# raw /dev/vg07/rlog02.log /dev/vg07/log02.log
/dev/raw/raw45: bound to major 58, minor 21


7. CHANGED THE FILE PERMISSIONS
# chmod 766 /dev/vg06
# chmod 766 /dev/vg06/*
# chmod 766 -R /dev/vg07 # chmod 766 -R /dev/vg07/* # chown oracle:oinstall -R /dev/vg07


# ll /dev/vg06/*
brwxrw-rw-    1 oracle   oinstall  58,  17 Apr 29 14:06
/dev/vg06/control01.ctl
brwxrw-rw-    1 oracle   oinstall  58,  18 Apr 29 14:06
/dev/vg06/control02.ctl
crwxrw-rw-    1 oracle   oinstall 109,   6 Apr 29 14:05 /dev/vg06/group
crwxrw-rw-    1 oracle   oinstall 162,  42 Apr 29 14:10
/dev/vg06/rcontrol01.ctl
crwxrw-rw-    1 oracle   oinstall 162,  43 Apr 29 14:10
/dev/vg06/rcontrol02.ctl
crwxrw-rw-    1 oracle   oinstall 162,  41 Apr 29 14:10
/dev/vg06/rsystem01.dbf
brwxrw-rw-    1 oracle   oinstall  58,  19 Apr 29 14:06
/dev/vg06/system01.dbf

# ll /dev/vg07/*
crwxrw-rw-    1 oracle   oinstall 109,   7 Apr 29 14:05 /dev/vg07/group
brwxrw-rw-    1 oracle   oinstall  58,  20 Apr 29 14:06 /dev/vg07/log01.log
brwxrw-rw-    1 oracle   oinstall  58,  21 Apr 29 14:07 /dev/vg07/log02.log
crwxrw-rw-    1 oracle   oinstall 162,  44 Apr 29 14:10 /dev/vg07/rlog01.log
crwxrw-rw-    1 oracle   oinstall 162,  45 Apr 29 14:10 /dev/vg07/rlog02.log

9. init$ORACLE_SID.ora file had the following contents

db_name = rawlvm1

db_files = 400

db_file_multiblock_read_count = 16

db_block_buffers = 550

shared_pool_size = 5000000

log_checkpoint_interval = 10000

processes = 100

parallel_max_servers = 8

log_buffer = 32768

global_names = TRUE

control_files = (/dev/raw/raw42, /dev/raw/raw43)

db_block_checksum = true

db_block_size = 4096

background_dump_dest = /u00/app/oracle/admin/hard/rawlvm/bdump

core_dump_dest = /u00/app/oracle/admin/hard/rawlvm/cdump

user_dump_dest = /u00/app/oracle/admin/hard/rawlvm/udump

10. Created oracle database

SQL> startup nomount;
ORACLE instance started.

Total System Global Area   53178448 bytes
Fixed Size                   450640 bytes
Variable Size              50331648 bytes
Database Buffers            2252800 bytes
Redo Buffers                 143360 bytes
SQL>
SQL> create database "rawlvm1"
 2    controlfile reuse
 3    maxinstances 8
 4    maxlogfiles 32
 5    datafile
 6         '/dev/raw/raw41' size 40M reuse
 7      logfile
 8         '/dev/raw/raw44'  size 20M ,
 9         '/dev/raw/raw45'  size 20M ;

Database created.

Please let me know if there is something fundamentally wrong in the
above steps used for creating Oracle database . After creating the database
I used the following 'dd' command to crash the database


dd if=/boot/vmlinux-2.4.2-2 of=/dev/sdp

	Strangely this command does'nt seem to crash the database . Can
anybody help me out to crash the Oracle database ?



_______________________________________________
linux-lvm mailing list
linux-lvm sistina com
http://lists.sistina.com/mailman/listinfo/linux-lvm
read the LVM HOW-TO at http://tldp.org/HOWTO/LVM-HOWTO/









[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]