Solved

create disk failing

Posted on 2013-06-06
4
809 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
  • 2
  • 2
4 Comments
 
LVL 76

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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problem to start Neon 20 51
Linux Scripting 3 47
report returning null 21 50
Error installing extension Linux 4 27
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

707 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now