OraFAQ Forum: Server Administration » ORA:16000: database open for read-only access during Select on standby 11gr2 read only.

Home » RDBMS Server » Server Administration » ORA:16000: database open for read-only access during Select on standby 11gr2 read only.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA:16000: database open for read-only access during Select on standby 11gr2 read only. [message #450239]

Mon, 05 April 2010 20:58

sonumalhi
Messages: 62
Registered: April 2008

Member

Experts

I am facing a strange issue on 11gR2 (OEL 5.4) standby readonly with apply database.
It's throwing 16000: database open for read-only access during SELECT's .
Here is snapshot of errors.

Can anyone throw some light what could be the problem?
I am totally running out of ideas.

ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access


SQL> l
  1* SELECT t0.airportID, t0.archived, t0.assetTag, t0.bluetoothID, t0.cmBundle, t0.createdDate, 
t0.currentProductTaskID, t0.ethernetID, t0.failOrReworkCount, t0.highestCompletedTaskTypeID, t0.lastModDate, t0.lastStationID,
 t0.modCount, t0.modelID, t0.oemSerialNumber, t0.orgSerialNumber, t0.pdmVersion, t0.preburnComplete, 
t0.productID, t0.reworked, t0.secondaryEthernetID, 
t0.serialNumber, t0.shipped, t0.specialBuildTypeID, 
t0.testBundle, t0.testingComplete, t0.unitDisposition, 
t0.validated, t0.vendor, t0.WOM, t0.zingerDate, t0.zingerType 
FROM Product t0 WHERE t0.serialNumber ='CCQCH009DCP'
SQL> /
SELECT t0.airportID, t0.archived, t0.assetTag, t0.bluetoothID, t0.cmBundle, t0.createdDate, t0.currentProductTaskID, 
t0.ethernetID, t0.failOrReworkCount, t0.highestCompletedTaskTypeID, t0.lastModDate, t0.lastStationID, 
t0.modCount, t0.modelID, t0.oemSerialNumber, t0.orgSerialNumber, t0.pdmVersion, t0.preburnComplete, t0.productID, t0.reworked, 
t0.secondaryEthernetID, t0.serialNumber, t0.shipped, t0.specialBuildTypeID, t0.testBundle, t0.testingComplete, 
t0.unitDisposition, t0.validated, t0.vendor, t0.WOM, t0.zingerDate, t0.zingerType 
FROM Product t0 WHERE t0.serialNumber ='CCQCH009DCP'
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access


SQL> select count(*) from product;

  COUNT(*)
----------
  73871833

SQL> select name, database_role, protection_mode from v$database;

NAME	  DATABASE_ROLE    PROTECTION_MODE
--------- ---------------- --------------------
INDIGO	  PHYSICAL STANDBY MAXIMUM PERFORMANCE

SQL> ed
Wrote file afiedt.buf

  1* select name, database_role, protection_mode,open_mode from v$database
SQL> /

NAME	  DATABASE_ROLE    PROTECTION_MODE	OPEN_MODE
--------- ---------------- -------------------- --------------------
INDIGO	  PHYSICAL STANDBY MAXIMUM PERFORMANCE	READ ONLY WITH APPLY

SQL> SELECT t0.airportID, t0.archived, t

Thanks in Advance .

--Mehtab

[Updated on: Tue, 06 April 2010 01:14] by Moderator

Report message to a moderator

Re: ORA:16000: database open for read-only access during Select on standby 11gr2 read only. [message #450258 is a reply to message #450239]

Tue, 06 April 2010 01:15

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Check for any audit trigger.

Please keep your lines in 80 characters.
Trim the spaces.
Use "Preview Button" before "Submit".

Regards
Michel

Report message to a moderator

Re: ORA:16000: database open for read-only access during Select on standby 11gr2 read only. [message #450324 is a reply to message #450239]

Tue, 06 April 2010 07:54

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

See this thread

Report message to a moderator

Re: ORA:16000: database open for read-only access during Select on standby 11gr2 read only. [message #450334 is a reply to message #450258]

Tue, 06 April 2010 08:26

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

I've just done a test using dbms_fga to audit access to a nominated column, and (as Michel suggests) I can count(*) no problem because that uses only the primary key index, but a select of my FGA monitored column throws ora-16000.
If this is your problem, I suppose it is another example of how any code that causes side-effects is a BAD THING. I always think of FGA as being a "select trigger", and a security nightmare.

Report message to a moderator

Re: ORA:16000: database open for read-only access during Select on standby 11gr2 read only. [message #450355 is a reply to message #450239]

Tue, 06 April 2010 11:46

sonumalhi
Messages: 62
Registered: April 2008

Member

Thanks for prompt replies guys.

There is no audit trigger that we have created may be some default triggers are there .

How can we check the default triggers is causing problems.

Is dbms_fga is the problem?

--Mehtab

Report message to a moderator