segunda-feira, 29 de julho de 2013
quinta-feira, 25 de julho de 2013
Utilizando o EM12c para visualizar o valor das variáveis bind
04:38
No comments
Using EM12C to see bind variables
http://jhdba.wordpress.com/2013/07/24/using-em12c-to-see-bind-variables/
http://jhdba.wordpress.com/2013/07/24/using-em12c-to-see-bind-variables/
quarta-feira, 10 de julho de 2013
sexta-feira, 5 de julho de 2013
ORA-15032 ORA-15054
05:59
No comments
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
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.