ORA-01119 ORA-17502 ORA-15041

admin

The griddisks associated to the "DATA" diskgroup are not evenly balanced, FREE_MB shows an uneven size:
In order to solve this problem please execute the next steps:

1) Please manually rebalance the "DATA"  diskgroup as follows:

SQL> alter diskgroup DATA check all repair;

SQL> alter diskgroup DATA rebalance power 32;


2) Wait until the rebalance operation completes:

SQL> select * form gv$asm_operation;

3) Then create the tablespace as follows:


SQL> CREATE BIGFILE TEMPORARY TABLESPACE TEMP_APP TEMPFILE '+DATA' SIZE 10g autoextend on next 1g maxsize 50g;