Contents
How do I resolve ORA 16000 database open for read only?
How do I fix the ORA-16000 error? Cause: The database has been opened for read-only access. Attempts to modify the database using inappropriate DML or DDL statements generate this error. Action: In order to modify the database, it must first be shut down and re-opened for read-write access.
How do I change a database from read only to read write mode in Oracle?
read only and read write are modifiers of the alter database OPEN clause. since an instance may mount and open only one database (you have to “kill it” and create a new instance – set of processes plus memory), you have to in effect shutdown and restart the instance to go from read only to read write or vice versa.
How do I create a read only database link in Oracle?
- do i have other option?
- As Alex points out, you could create a new user on the local database, create the database link as a private link in that new schema, create views in the new local schema that query the remote tables, then grant the local test user SELECT access on those views.
Why is the Ora 16000 database open for read only access?
Answer: The oerr utility shows this for the ORA-16000 error: ORA-16000: database open for read-only access. Cause: The database has been opened for read-only access. Attempts to modify the database using inappropriate DML or DDL statements generate this error.
How to alter database open for read only access?
SQL> alter database open read only; Database altered. SQL> alter tablespace cisadm read only; alter tablespace cisadm read only * ERROR at line 1: ORA-16000: database open for read-only access SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started.
How is a read only database cloned in Oracle?
A read-only database is cloned from a read-write production database. The read-only database is brought to sync with the production database everyday and is used only for reporting. At times, users are unable to connect to the database, otherwise they can login to the read-only database without any problem.
How big is a read only database in SQL?
SQL> startup mount ORACLE instance started. Total System Global Area 2147840008 bytes Fixed Size 745480 bytes Variable Size 1207959552 bytes Database Buffers 838860800 bytes Redo Buffers 100274176 bytes Database mounted. SQL> alter tablespace cisadm read only; alter tablespace cisadm read only * ERROR at line 1: ORA-01109: database not open