sql>startup mount exclusive
ORACLE instance started.Total System Global Area 1610612736 bytes
Fixed Size 2073192 bytes
Variable Size 486542744 bytes
Database Buffers 1107296256 bytes
Redo Buffers 14700544 bytes
Database mounted.
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
这是什么原因?
ORACLE instance started.Total System Global Area 1610612736 bytes
Fixed Size 2073192 bytes
Variable Size 486542744 bytes
Database Buffers 1107296256 bytes
Redo Buffers 14700544 bytes
Database mounted.
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
这是什么原因?
Cause: The audit_trail initialization parameter was set to "DB" (or TRUE), which is incompatible with a database opened for read-only access.
Action: When the database is opened for read-only access, the audit_trail initialization parameter can only be set to "OS" or "NONE" (FALSE). 你准是打开数据库审计了。把audit_trail参数改一下就可以了。