[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

create disk failing

Posted on 2013-06-06
4
Medium Priority
?
916 Views
Last Modified: 2013-06-12
I have these disks externally..
11/12/2012  01:51 AM               477 asm8
11/12/2012  08:09 PM     3,221,225,472 asm8-flat
06/03/2013  09:16 PM               550 ASMDATA1
06/03/2013  09:15 PM     2,147,221,504 ASMDATA1-f001
06/03/2013  09:16 PM     2,147,221,504 ASMDATA1-f002
06/03/2013  09:16 PM           524,288 ASMDATA1-f003
06/05/2013  10:16 PM    <DIR>          ASMDATA1.lck
06/03/2013  09:18 PM               550 ASMDATA2
06/03/2013  09:17 PM     2,147,221,504 ASMDATA2-f001
06/03/2013  09:18 PM     2,147,221,504 ASMDATA2-f002
06/03/2013  09:18 PM           524,288 ASMDATA2-f003
06/05/2013  10:16 PM    <DIR>          ASMDATA2.lck
06/03/2013  09:22 PM               550 ASMDATA3
06/03/2013  09:21 PM     2,147,221,504 ASMDATA3-f001
06/03/2013  09:22 PM     2,147,221,504 ASMDATA3-f002
06/03/2013  09:22 PM           524,288 ASMDATA3-f003
06/05/2013  10:16 PM    <DIR>          ASMDATA3.lck
06/03/2013  10:11 PM               550 ASMDATA4
06/03/2013  10:10 PM     2,147,221,504 ASMDATA4-f001
06/03/2013  10:11 PM     2,147,221,504 ASMDATA4-f002
06/03/2013  10:11 PM           524,288 ASMDATA4-f003
06/05/2013  10:16 PM    <DIR>          ASMDATA4.lck
06/03/2013  09:08 PM               486 OCR-VOTE1
06/03/2013  09:08 PM     1,073,741,824 OCR-VOTE1-f001
06/05/2013  10:16 PM    <DIR>          OCR-VOTE1.lck
06/05/2013  10:45 PM               486 OCR-VOTE2
06/03/2013  09:12 PM     1,073,741,824 OCR-VOTE2-f001
06/05/2013  10:16 PM    <DIR>          OCR-VOTE2.lck
06/03/2013  09:13 PM               486 OCR-VOTE3
06/03/2013  09:13 PM     1,073,741,824 OCR-VOTE3-f001
06/05/2013  10:16 PM    <DIR>          OCR-VOTE3.lck

my os is linux which is virtually in vmware..


why these commands failing...

[root@rc1 ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting <ENTER> without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface [grid]: grid
Default group to own the driver interface [asmdba]: asmdba
Start Oracle ASM library driver on boot (y/n) [y]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]
[root@rc1 ~]# /usr/sbin/oracleasm createdisk OCR_VOTE1 /dev/sdc1
Writing disk header: done
Instantiating disk: done
[root@rc1 ~]# /usr/sbin/oracleasm createdisk OCR_VOTE2 /dev/sdc2
Unable to query file "/dev/sdc2": No such file or directory
[root@rc1 ~]# /usr/sbin/oracleasm createdisk OCR_VOTE2 /dev/sdd1
Unable to query file "/dev/sdd1": No such file or directory
[root@rc1 ~]# /usr/sbin/oracleasm createdisk OCR_VOTE2 /dev/sde1
Unable to query file "/dev/sde1": No such file or directory
[root@rc1 ~]# /usr/sbin/oracleasm createdisk OCR_VOTE2 /dev/sdf1
Unable to query file "/dev/sdf1": No such file or directory
0
Comment
Question by:walkerdba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39226999
Obviously /dev/sdc2 doesn't exist?  Same for the others.

What disks do you have available to use as ASM disks?

ls -al /dev

Then make sure they aren't being used by something else.
0
 

Author Comment

by:walkerdba
ID: 39228282
[root@rc1 ~]# ls -al /dev
total 8
drwxr-xr-x 12 root   root        4600 Jun  6 12:09 .
drwxr-xr-x 24 root   root        4096 Jun  6 11:59 ..
crw-------  1 oracle root    14,   12 Jun  6 11:59 adsp
crw-------  1 root   root    10,  175 Jun  6 11:59 agpgart
crw-------  1 oracle root    14,    4 Jun  6 11:59 audio
drwxr-xr-x  3 root   root          60 Jun  6 11:59 bus
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 cdrom -> hdc
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 cdrom-hdc -> hdc
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 cdrw -> hdc
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 cdrw-hdc -> hdc
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 cdwriter -> hdc
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 cdwriter-hdc -> hdc
crw-------  1 oracle root     5,    1 Jun  6 11:59 console
lrwxrwxrwx  1 root   root          11 Jun  6 11:59 core -> /proc/kcore
drwxr-xr-x  6 root   root         120 Jun  6 11:59 disk
crw-rw----  1 root   root    14,    9 Jun  6 11:59 dmmidi
crw-------  1 oracle root    14,    3 Jun  6 11:59 dsp
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 dvd -> hdc
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 dvd-hdc -> hdc
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 dvdrw -> hdc
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 dvdrw-hdc -> hdc
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 dvdwriter -> hdc
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 dvdwriter-hdc -> hdc
lrwxrwxrwx  1 root   root          13 Jun  6 11:59 fd -> /proc/self/fd
brw-rw----  1 oracle floppy   2,    0 Jun  6 11:59 fd0
brw-rw----  1 oracle floppy   2,   84 Jun  6 11:59 fd0u1040
brw-rw----  1 oracle floppy   2,   88 Jun  6 11:59 fd0u1120
brw-rw----  1 oracle floppy   2,   28 Jun  6 11:59 fd0u1440
brw-rw----  1 oracle floppy   2,   44 Jun  6 11:59 fd0u1680
brw-rw----  1 oracle floppy   2,   60 Jun  6 11:59 fd0u1722
brw-rw----  1 oracle floppy   2,   76 Jun  6 11:59 fd0u1743
brw-rw----  1 oracle floppy   2,   96 Jun  6 11:59 fd0u1760
brw-rw----  1 oracle floppy   2,  116 Jun  6 11:59 fd0u1840
brw-rw----  1 oracle floppy   2,  100 Jun  6 11:59 fd0u1920
brw-rw----  1 oracle floppy   2,   12 Jun  6 11:59 fd0u360
brw-rw----  1 oracle floppy   2,   16 Jun  6 11:59 fd0u720
brw-rw----  1 oracle floppy   2,  120 Jun  6 11:59 fd0u800
brw-rw----  1 oracle floppy   2,   52 Jun  6 11:59 fd0u820
brw-rw----  1 oracle floppy   2,   68 Jun  6 11:59 fd0u830
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 floppy -> fd0
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 floppy-fd0 -> fd0
crw-rw-rw-  1 root   root     1,    7 Jun  6 11:59 full
srwx------  1 oracle root           0 Jun  6 11:59 gpmctl
brw-------  1 oracle disk    22,    0 Jun  6 11:59 hdc
crw-------  1 root   root    10,  228 Jun  6 11:59 hpet
prw-------  1 root   root           0 Jun  6 12:01 initctl
drwxr-xr-x  2 root   root         240 Jun  6 11:59 input
lrwxrwxrwx  1 root   root           9 Jun  6 11:59 js0 -> input/js0
crw-------  1 root   root     1,   11 Jun  6 11:59 kmsg
srw-rw-rw-  1 root   root           0 Jun  6 11:59 log
brw-r-----  1 root   disk     7,    0 Jun  6 11:59 loop0
brw-r-----  1 root   disk     7,    1 Jun  6 11:59 loop1
brw-r-----  1 root   disk     7,    2 Jun  6 11:59 loop2
brw-r-----  1 root   disk     7,    3 Jun  6 11:59 loop3
brw-r-----  1 root   disk     7,    4 Jun  6 11:59 loop4
brw-r-----  1 root   disk     7,    5 Jun  6 11:59 loop5
brw-r-----  1 root   disk     7,    6 Jun  6 11:59 loop6
brw-r-----  1 root   disk     7,    7 Jun  6 11:59 loop7
crw-rw----  1 root   lp       6,    0 Jun  6 11:59 lp0
lrwxrwxrwx  1 root   root          13 Jun  6 11:59 MAKEDEV -> /sbin/MAKEDEV
drwxr-xr-x  2 root   root          60 Jun  6 11:59 mapper
brw-r-----  1 root   disk     9,    0 Jun  6 11:59 md0
crw-r-----  1 root   kmem     1,    1 Jun  6 11:59 mem
crw-------  1 oracle root    14,    2 Jun  6 11:59 midi
crw-------  1 oracle root    14,    0 Jun  6 11:59 mixer
drwxr-xr-x  2 root   root          60 Jun  6 11:59 net
crw-rw-rw-  1 root   root     1,    3 Jun  6 11:59 null
crw-rw----  1 root   root    10,  144 Jun  6 11:59 nvram
crw-------  1 root   root     1,   12 Jun  6 11:59 oldmem
drwxr-xr-x  2 root   root           0 Jun  6 11:59 oracleasm
lrwxrwxrwx  1 root   root           3 Jun  6 11:59 par0 -> lp0
crw-rw----  1 root   lp      99,    0 Jun  6 11:59 parport0
crw-rw----  1 root   lp      99,    1 Jun  6 11:59 parport1
crw-rw----  1 root   lp      99,    2 Jun  6 11:59 parport2
crw-rw----  1 root   lp      99,    3 Jun  6 11:59 parport3
crw-r-----  1 root   kmem     1,    4 Jun  6 11:59 port
crw-------  1 root   root   108,    0 Jun  6 11:59 ppp
crw-rw-rw-  1 root   tty      5,    2 Jun  7 01:06 ptmx
drwxr-xr-x  2 root   root           0 Jun  6 11:58 pts
lrwxrwxrwx  1 root   root           4 Jun  6 11:59 ram -> ram1
brw-r-----  1 root   disk     1,    0 Jun  6 11:58 ram0
brw-r-----  1 root   disk     1,    1 Jun  6 11:58 ram1
brw-r-----  1 root   disk     1,   10 Jun  6 11:58 ram10
brw-r-----  1 root   disk     1,   11 Jun  6 11:58 ram11
brw-r-----  1 root   disk     1,   12 Jun  6 11:58 ram12
brw-r-----  1 root   disk     1,   13 Jun  6 11:58 ram13
brw-r-----  1 root   disk     1,   14 Jun  6 11:58 ram14
brw-r-----  1 root   disk     1,   15 Jun  6 11:58 ram15
brw-r-----  1 root   disk     1,    2 Jun  6 11:58 ram2
brw-r-----  1 root   disk     1,    3 Jun  6 11:58 ram3
brw-r-----  1 root   disk     1,    4 Jun  6 11:58 ram4
brw-r-----  1 root   disk     1,    5 Jun  6 11:58 ram5
brw-r-----  1 root   disk     1,    6 Jun  6 11:58 ram6
brw-r-----  1 root   disk     1,    7 Jun  6 11:58 ram7
brw-r-----  1 root   disk     1,    8 Jun  6 11:58 ram8
brw-r-----  1 root   disk     1,    9 Jun  6 11:58 ram9
lrwxrwxrwx  1 root   root           4 Jun  6 11:59 ramdisk -> ram0
crw-rw-rw-  1 root   root     1,    8 Jun  6 11:59 random
crw-------  1 root   root   162,    0 Jun  6 11:59 rawctl
brw-------  1 root   root     8,    2 Jun  6 11:58 root
crw-r--r--  1 root   root    10,  135 Jun  6 11:58 rtc
brw-r-----  1 root   disk     8,    0 Jun  6 11:58 sda
brw-r-----  1 root   disk     8,    1 Jun  6 11:59 sda1
brw-r-----  1 root   disk     8,    2 Jun  6 11:59 sda2
brw-r-----  1 root   disk     8,    3 Jun  6 11:58 sda3
brw-r-----  1 root   disk     8,   16 Jun  6 11:58 sdb
brw-r-----  1 root   disk     8,   32 Jun  6 11:58 sdc
brw-r-----  1 root   disk     8,   33 Jun  6 12:09 sdc1
brw-r-----  1 root   disk     8,   48 Jun  6 11:58 sdd
brw-r-----  1 root   disk     8,   64 Jun  6 11:58 sde
brw-r-----  1 root   disk     8,   80 Jun  6 11:58 sdf
brw-r-----  1 root   disk     8,   96 Jun  6 11:58 sdg
brw-r-----  1 root   disk     8,  112 Jun  6 11:58 sdh
crw-------  1 oracle root    14,    1 Jun  6 11:59 sequencer
crw-------  1 oracle root    14,    8 Jun  6 11:59 sequencer2
crw-------  1 root   root    21,    0 Jun  6 11:59 sg0
crw-------  1 root   root    21,    1 Jun  6 11:59 sg1
crw-------  1 root   root    21,    2 Jun  6 11:59 sg2
crw-------  1 root   root    21,    3 Jun  6 11:59 sg3
crw-------  1 root   root    21,    4 Jun  6 11:59 sg4
crw-------  1 root   root    21,    5 Jun  6 11:59 sg5
crw-------  1 root   root    21,    6 Jun  6 11:59 sg6
crw-------  1 root   root    21,    7 Jun  6 11:59 sg7
drwxrwxrwt  2 root   root          40 Jun  6 11:59 shm
crw-------  1 root   root    10,  231 Jun  6 11:59 snapshot
drwxr-xr-x  2 root   root         180 Jun  6 11:59 snd
lrwxrwxrwx  1 root   root          15 Jun  6 11:59 stderr -> /proc/self/fd/2
lrwxrwxrwx  1 root   root          15 Jun  6 11:59 stdin -> /proc/self/fd/0
lrwxrwxrwx  1 root   root          15 Jun  6 11:59 stdout -> /proc/self/fd/1
crw-------  1 root   root     4,    0 Jun  6 11:58 systty
crw-rw-rw-  1 root   tty      5,    0 Jun  6 11:59 tty
crw-rw----  1 root   root     4,    0 Jun  6 11:58 tty0
crw-------  1 root   root     4,    1 Jun  6 12:01 tty1
crw-rw----  1 root   tty      4,   10 Jun  6 11:58 tty10
crw-rw----  1 root   tty      4,   11 Jun  6 11:58 tty11
crw-rw----  1 root   tty      4,   12 Jun  6 11:58 tty12
crw-rw----  1 root   tty      4,   13 Jun  6 11:59 tty13
crw-rw----  1 root   tty      4,   14 Jun  6 11:59 tty14
crw-rw----  1 root   tty      4,   15 Jun  6 11:59 tty15
crw-rw----  1 root   tty      4,   16 Jun  6 11:59 tty16
crw-rw----  1 root   tty      4,   17 Jun  6 11:59 tty17
crw-rw----  1 root   tty      4,   18 Jun  6 11:59 tty18
crw-rw----  1 root   tty      4,   19 Jun  6 11:59 tty19
crw-------  1 root   root     4,    2 Jun  6 12:01 tty2
crw-rw----  1 root   tty      4,   20 Jun  6 11:59 tty20
crw-rw----  1 root   tty      4,   21 Jun  6 11:59 tty21
crw-rw----  1 root   tty      4,   22 Jun  6 11:59 tty22
crw-rw----  1 root   tty      4,   23 Jun  6 11:59 tty23
crw-rw----  1 root   tty      4,   24 Jun  6 11:59 tty24
crw-rw----  1 root   tty      4,   25 Jun  6 11:59 tty25
crw-rw----  1 root   tty      4,   26 Jun  6 11:59 tty26
crw-rw----  1 root   tty      4,   27 Jun  6 11:59 tty27
crw-rw----  1 root   tty      4,   28 Jun  6 11:59 tty28
crw-rw----  1 root   tty      4,   29 Jun  6 11:59 tty29
crw-------  1 root   root     4,    3 Jun  6 12:01 tty3
crw-rw----  1 root   tty      4,   30 Jun  6 11:59 tty30
crw-rw----  1 root   tty      4,   31 Jun  6 11:59 tty31
crw-rw----  1 root   tty      4,   32 Jun  6 11:59 tty32
crw-rw----  1 root   tty      4,   33 Jun  6 11:59 tty33
crw-rw----  1 root   tty      4,   34 Jun  6 11:59 tty34
crw-rw----  1 root   tty      4,   35 Jun  6 11:59 tty35
crw-rw----  1 root   tty      4,   36 Jun  6 11:59 tty36
crw-rw----  1 root   tty      4,   37 Jun  6 11:59 tty37
crw-rw----  1 root   tty      4,   38 Jun  6 11:59 tty38
crw-rw----  1 root   tty      4,   39 Jun  6 11:59 tty39
crw-------  1 root   root     4,    4 Jun  6 12:01 tty4
crw-rw----  1 root   tty      4,   40 Jun  6 11:59 tty40
crw-rw----  1 root   tty      4,   41 Jun  6 11:59 tty41
crw-rw----  1 root   tty      4,   42 Jun  6 11:59 tty42
crw-rw----  1 root   tty      4,   43 Jun  6 11:59 tty43
crw-rw----  1 root   tty      4,   44 Jun  6 11:59 tty44
crw-rw----  1 root   tty      4,   45 Jun  6 11:59 tty45
crw-rw----  1 root   tty      4,   46 Jun  6 11:59 tty46
crw-rw----  1 root   tty      4,   47 Jun  6 11:59 tty47
crw-rw----  1 root   tty      4,   48 Jun  6 11:59 tty48
crw-rw----  1 root   tty      4,   49 Jun  6 11:59 tty49
crw-------  1 root   root     4,    5 Jun  6 12:01 tty5
crw-rw----  1 root   tty      4,   50 Jun  6 11:59 tty50
crw-rw----  1 root   tty      4,   51 Jun  6 11:59 tty51
crw-rw----  1 root   tty      4,   52 Jun  6 11:59 tty52
crw-rw----  1 root   tty      4,   53 Jun  6 11:59 tty53
crw-rw----  1 root   tty      4,   54 Jun  6 11:59 tty54
crw-rw----  1 root   tty      4,   55 Jun  6 11:59 tty55
crw-rw----  1 root   tty      4,   56 Jun  6 11:59 tty56
crw-rw----  1 root   tty      4,   57 Jun  6 11:59 tty57
crw-rw----  1 root   tty      4,   58 Jun  6 11:59 tty58
crw-rw----  1 root   tty      4,   59 Jun  6 11:59 tty59
crw-------  1 root   root     4,    6 Jun  6 12:01 tty6
crw-rw----  1 root   tty      4,   60 Jun  6 11:59 tty60
crw-rw----  1 root   tty      4,   61 Jun  6 11:59 tty61
crw-rw----  1 root   tty      4,   62 Jun  6 11:59 tty62
crw-rw----  1 root   tty      4,   63 Jun  6 11:59 tty63
crw-rw----  1 root   root     4,    7 Jun  6 11:58 tty7
crw-rw----  1 root   tty      4,    8 Jun  6 11:59 tty8
crw-rw----  1 root   tty      4,    9 Jun  6 11:58 tty9
crw-rw----  1 root   uucp     4,   64 Jun  7 01:06 ttyS0
crw-rw----  1 root   uucp     4,   65 Jun  6 11:58 ttyS1
crw-rw----  1 root   uucp     4,   66 Jun  6 11:58 ttyS2
crw-rw----  1 root   uucp     4,   67 Jun  6 11:58 ttyS3
drwxr-xr-x  4 root   root         100 Jun  6 12:09 .udev
cr--r--r--  1 root   root     1,    9 Jun  6 11:59 urandom
crw-------  1 root   root   442,    0 Jun  6 11:59 usbdev1.1_ep00
crw-------  1 root   root   442,    0 Jun  6 11:59 usbdev1.1_ep81
crw-------  1 root   root   442,    1 Jun  6 11:59 usbdev1.2_ep00
crw-------  1 root   root   442,    1 Jun  6 11:59 usbdev1.2_ep81
crw-------  1 root   root   442,    1 Jun  6 11:59 usbdev1.2_ep82
crw-------  1 root   root   442,    2 Jun  6 11:59 usbdev1.3_ep00
crw-------  1 root   root   442,    2 Jun  6 11:59 usbdev1.3_ep81
crw-------  1 root   root   442, 2048 Jun  6 11:59 usbdev2.1_ep00
crw-------  1 root   root   442, 2048 Jun  6 11:59 usbdev2.1_ep81
crw-------  1 vcsa   tty      7,    0 Jun  6 11:59 vcs
crw-------  1 vcsa   tty      7,    1 Jun  6 12:01 vcs1
crw-------  1 vcsa   tty      7,    2 Jun  6 12:01 vcs2
crw-------  1 vcsa   tty      7,    3 Jun  6 12:01 vcs3
crw-------  1 vcsa   tty      7,    4 Jun  6 12:01 vcs4
crw-------  1 vcsa   tty      7,    5 Jun  6 12:01 vcs5
crw-------  1 vcsa   tty      7,    6 Jun  6 12:01 vcs6
crw-------  1 vcsa   tty      7,    7 Jun  6 12:01 vcs7
crw-------  1 vcsa   tty      7,  128 Jun  6 11:59 vcsa
crw-------  1 vcsa   tty      7,  129 Jun  6 12:01 vcsa1
crw-------  1 vcsa   tty      7,  130 Jun  6 12:01 vcsa2
crw-------  1 vcsa   tty      7,  131 Jun  6 12:01 vcsa3
crw-------  1 vcsa   tty      7,  132 Jun  6 12:01 vcsa4
crw-------  1 vcsa   tty      7,  133 Jun  6 12:01 vcsa5
crw-------  1 vcsa   tty      7,  134 Jun  6 12:01 vcsa6
crw-------  1 vcsa   tty      7,  135 Jun  6 12:01 vcsa7
crw-------  1 root   root    10,   63 Jun  6 11:59 vmci
crw-rw-rw-  1 root   root    10,   61 Jun  6 11:59 vsock
lrwxrwxrwx  1 root   root           4 Jun  6 11:59 X0R -> null
crw-rw-rw-  1 root   root     1,    5 Jun  6 11:59 zero
[root@rc1 ~]#
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39228707
>>[root@rc1 ~]# ls -al /dev

Do you see the problem?

You don't have disks /dev/sdc2, /dev/sdd1, /dev/sde1 or /dev/sdf1

Looks like you do have them without the '1' at the end but I cannot say if these should be used for ASM.

I suggest you work with your System Administrator to assist you in locating the correct disks on your system available to be used for ASM.
0
 

Author Closing Comment

by:walkerdba
ID: 39242894
yes
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question