quinta-feira, 25 de julho de 2013

Utilizando o EM12c para visualizar o valor das variáveis bind

quarta-feira, 10 de julho de 2013

sexta-feira, 5 de julho de 2013

ORA-15032 ORA-15054

ALTER DISKGROUP FRA01 DROP DISK "_DROPPED_0001_FRA01" FORCE;

ORA-15032: not all alterations performed ORA-15054: disk "_DROPPED_0001_FRA01" does not exist in diskgroup "FRA01"


[root@maiombe ~]# /etc/init.d/oracleasm querydisk -d DISK04
Disk "DISK04" is a valid ASM disk on device [8,65]

[root@maiombe ~]#  ls -l /dev |grep 8|grep 65
brw-r----- 1 root disk    8,  65 Jul  5 09:34 sde1

[root@maiombe ~]# dd if=/dev/zero of=/dev/sde1 bs=4k count=20000
20000+0 records in
20000+0 records out
81920000 bytes (82 MB) copied, 0.361043 seconds, 227 MB/s
[root@maiombe ~]# /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks:               [  OK  ]
[root@maiombe ~]# /etc/init.d/oracleasm listdisks
DISK01
DISK02
DISK03


[root@maiombe ~]# /etc/init.d/oracleasm createdisk DISK04 /dev/sde1
Marking disk "DISK04" as an ASM disk:                      [  OK  ]
[root@maiombe ~]# /etc/init.d/oracleasm listdisks
DISK01
DISK02
DISK03
DISK04

SQL> ALTER DISKGROUP FRA01 ADD DISK 'ORCL:DISK04';

Diskgroup altered.