How to resolve ORA-15025 when creating ASM diskgroup on Solaris

操作系统版本:Solaris10 Sparc 64bit 数据库版本:Oracle 10.2.0.4 在创建ASM Diskgroup的时候出现如下图报错。 检查当前系统裸设备的设置。 partition> p Current partition table (original): Total disk cylinders available: 53154 + 2 (reserved cylinders) Part Tag Flag Cylinders Size Blocks 0 root wm 0 0 (0/0/0) 0 1 swap wu 0 0 (0/0/0) 0 2 backup wu 0 – 53153 1.99TB (53154/0/0) 4269595050 3 unassigned wm…

How to resolve ORA-24005 when drop tablespace

SQL> drop tablespace EXAMPLE INCLUDING CONTENTS; drop tablespace EXAMPLE INCLUDING CONTENTS * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables EXAMPLE表空间是Oracle的示例表空间,通常保存着诸如OE, SH, IX, HR等示例用户的表数据,在尝试删除这个表空间的时候遇到上述的错误。 实际上错误是由于IX用户下的高级队列表对象引起的,高级队列表对象无法使用常规的drop命令删除,无论是删除包含AQ的表空间还是用户,都会报ORA-24005错误。 SQL> drop user IX cascade; drop user IX cascade * ERROR at line 1: ORA-00604: error occurred at…