ORA-01097

I did this on Oracle 11.2.0.2.7. While testing something completely different, I noticed that you cannot close a database from a session which has an uncommitted transaction:

 

SQL> show user

USER is "SYS"

SQL> delete aud$;

 

38 rows deleted.

 

SQL> shutdown

ORA-01097: cannot shutdown while in a transaction - commit or rollback first

SQL> commit

  2  /

 

Commit complete.

 

SQL> shutdown

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>