Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
Fine-Grained Auditing and Standby Database.

Fine-Grained Auditing and Standby Database.

2005-08-31       - By Arnon, Yuval

Reply:     1     2     3  

Hi,

We have implemented FGA on one of our tables( on s specific column) in
the production database..
When trying to query the column from this table in our Standby Databases
we get these errors:


ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL level 1
ORA-01001 (See ORA-01001.ora-code.com): invalid cursor
ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL level 2
ORA-16000 (See ORA-16000.ora-code.com): database open for read-only access


Does anyone know if it is possible to turn off FGA in a standby
database.

TIA.

Yuval.

This transmission may contain information that is privileged, confidential and
exempt from disclosure under applicable law.  If you, oracle-l@(protected),
are not the intended recipient, you are hereby notified that any disclosure,
copying, distribution, or use of the information contained herein (including
any reliance thereon) is STRICTLY PROHIBITED.  If you received this
transmission in error, please immediately contact the sender and destroy the
material in its entirety, whether in electronic or hard copy format.



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2>Hi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2>We have implemented FGA on one of our tables( on s
specific
column) in the production database.. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2>When trying to query the column from this table in our
Standby Databases we get these errors:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Courier
color=#0000ff size=2>ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL level
1<BR>ORA-01001 (See ORA-01001.ora-code.com): invalid cursor<BR>ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL
level 2<BR>ORA-16000 (See ORA-16000.ora-code.com): database open for read-only access</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2>Does anyone know if it is possible to turn off FGA in a
standby database.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2>TIA.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=292154818-31082005><FONT face=Arial
color=#0000ff size=2>Yuval.</FONT></SPAN></DIV></BODY><!--[object_id=
#webloyalty.com#]--><P><SPAN class=920560820-04022003><FONT size=1><FONT face
=Arial color=#c0c0c0>This transmission may contain information that is
privileged, confidential and exempt from disclosure under applicable law.&nbsp;
If you, oracle-l@(protected), are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution, or use of the information
contained herein (including any reliance thereon) is STRICTLY PROHIBITED.&nbsp;
If you received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic or hard
copy format.&nbsp; [clavin.webloyalty.com]</FONT></FONT></SPAN></P></HTML>