From: Steven Dake <sdake@mvista.com>
To: linux-lvm@sistina.com
Subject: Re: [linux-lvm] Problems while trying to crash Oracle database
Date: Sat May 10 08:37:14 2003 [thread overview]
Message-ID: <3EB16F3C.50807@mvista.com> (raw)
In-Reply-To: <A11077E28200D51182EA00D0B775525307142799@xin02.india.hp.com>
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/
>
>
>
>
>
next prev parent reply other threads:[~2003-05-10 8:37 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2003-04-29 19:58 [linux-lvm] Problems while trying to crash Oracle database HERUR,CHANNABASAPPA (HP-India,ex2)
2003-05-10 8:37 ` Steven Dake [this message]
2003-05-11 8:33 ` Fred Ruffet
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=3EB16F3C.50807@mvista.com \
--to=sdake@mvista.com \
--cc=linux-lvm@sistina.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox