Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
=================================================================
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
=================================================================
! Oracle database auditing has to be turned off before altering the database in READ ONLY mode.
1. Got ORA-16006 when running "alter database open read only":
Error: ORA-16006
Text: 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).
.
2. change the value of audit_trail=none in initnanprod1.ora
audit_trail = none
3. open the database in read only mode
sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on Mon May 26 13:26:43 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 178227688 bytes
Fixed Size 104936 bytes
Variable Size 110841856 bytes
Database Buffers 67108864 bytes
Redo Buffers 172032 bytes
SQL> alter database mount;
Database altered.
SQL> alter database open read only;
Database altered.
|
4. log in as system
create user test identified by aaa;
ORA-00604: error occurred at recursive SQL level 1
ORA-00372: file 1 cannot be modified at this time
ORA-01110: data file 1: '/fs/u01/oracle_data/testdb/system01.dbf'
