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 an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.