ORA-16006

ORA-16006: audit_trail destination incompatible with database open mode

SQL> ALTER DATABASE OPEN READ ONLY;
ALTER DATABASE OPEN READ ONLY
*
ERROR at line 1:
ORA-16006: audit_trail destination incompatible with database open mode 


SQL> SHOW PARAMETER AUDIT_TRAIL

============================
audit_trail                   string           DB

Here need to change Audit_trail parameter DB to none.

SQL> ALTER SYSTEM SET audit_trail=none SCOPE=SPFILE;

System altered.

SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> STARTUP MOUNT
ORACLE instance started.
Database mounted.

SQL> ALTER DATABASE OPEN READ ONLY;
Database altered.