Monthly Archives: January 2010

ASM disk rebalance ORA-15041

I wanted to free up some space from the existing ASM disks in a EXTERNAL DG. So added a new disk SQL> ALTER DISKGROUP DG1 ADD DISK ‘/dev/rdsk/c2t20120002AC000212d27s6’ / And set the rebalance power to maximum SQL> ALTER DISKGROUP DG1 … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | 1 Comment

Oracle Compressed Tables

Compressed tables use fewer data blocks on disk, reducing disk space requirements. Let see how to implement this. SQL> CREATE TABLE COMPRESS_DATA AS SELECT * FROM ALL_OBJECTS WHERE 1=0; SQL> SELECT TABLE_NAME, COMPRESSION, ROW_MOVEMENT FROM USER_TABLES; TABLE_NAME COMPRESS ROW_MOVE —————————— … Continue reading

Posted in Oracle Table Handling | Tagged | Leave a comment

ORA-15150: instance lock mode ‘EXCLUSIVE’ conflicts with other ASM instance(s)

I was trying to create a standalone ASM instance on a Solaris box. Where I started getting ORA-15150 instance lock mode ‘EXCLUSIVE’ conflicts with other ASM instance(s) error. Checked processes at operating system level $ ps -ef grep +ASM oracle … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | Leave a comment

dbca failure when creating database on ASM (ORA-01503, ORA-15001, ORA-01034)

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName oradb -sid oradb -sysPassword oracle -systemPassword oracle -datafileDestination +DATA -storageType ASM -asmSysPassword oracle Database creation failed, with following error stack Copying database files DBCA_PROGRESS : 1% DBCA_PROGRESS : 3% DBCA_PROGRESS : 11% ORA-19624: operation … Continue reading

Posted in Oracle Automatic Storage Management, Oracle Database Creation Assistant | Tagged | 2 Comments

Resolving ORA-15075 & ORA-15033 in RAC ASM environment

I wanted to add 2 disks to my NORMAL REDUNDANCY diskgroup with 2 failgroups in a RAC environment. This is how my existing group look like SELECT GROUP_NUMBER, NAME, TOTAL_MB, FREE_MB, USABLE_FILE_MB FROM V$ASM_DISKGROUP / GROUP_NUMBER NAME TOTAL_MB FREE_MB USABLE_FILE_MB … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | 1 Comment

INS-40910 in 11gR2 CRS install

Recently while installing 11gr2 RAC I faced this issue. At after specifying VIP’s in CRS install I got INS-40910 From Oracle Database Error Messages INS-40910: enter the virtual IP: string is invalid. Cause: The virtual IP cannot resolve the IP … Continue reading

Posted in Oracle Cluster Ready Services, Oracle Real Application Cluster | Tagged | Leave a comment