Getting below listed error while trying to shutdown the database.
SQL> shutdown immediate;
ORA-01654: unable to extend index SYS.I_COL_USAGE$ by 3 in tablespace SYSTEM
Below is the detailed notes about the error from trace file.
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
ALTER DATABASE CLOSE NORMAL
ORA-1654: unable to extend index SYS.I_COL_USAGE$ by 3 in tablespace SYSTEM
ORA-1654: unable to extend index SYS.I_COL_USAGE$ by 3 in tablespace SYSTEM
ORA-1654 signalled during: ALTER DATABASE CLOSE NORMAL...
Can someone please suggest the solution?