[linux-lvm] Problems while trying to crash Oracle database
Steven Dake
sdake at mvista.com
Sat May 10 08:37:14 UTC 2003
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 at LNXSRVZ /dev]# rm /dev/raw/raw41
>rm: remove `/dev/raw/raw41'? y
>[root at LNXSRVZ /dev]# rm /dev/raw/raw42
>rm: remove `/dev/raw/raw42'? y
>[root at LNXSRVZ /dev]# rm /dev/raw/raw43
>rm: remove `/dev/raw/raw43'? y
>[root at LNXSRVZ /dev]# rm /dev/raw/raw44
>rm: remove `/dev/raw/raw44'? y
>[root at 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 at sistina.com
>http://lists.sistina.com/mailman/listinfo/linux-lvm
>read the LVM HOW-TO at http://tldp.org/HOWTO/LVM-HOWTO/
>
>
>
>
>
More information about the linux-lvm
mailing list