Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-2002 : error while writing to audit trail

Karan KukrejaDec 20 2010 — edited Dec 28 2010

Hi all ,

I am oracle 11g and on SPARC OS.

I enabled audit in my database by setting the parameter audit_trail=DB and then i restarted my instance.

On doing so the database started but whenever i am trying to connect using pl/sql developer , i am getting the following list of errors :

ORA-00604 : error occured at recursive SQL level 1
ora-00904 : "DBID" invalid identifier
Ora-02002 : error while writing to audit trail
ORA-00604 : error occured at recursive SQL level 1
ora-00904 : "DBID" invalid identifier

I checked on the net for ora-02002 and increased the size of the system tablespace from 750 M to 1000M.

My system tablespace is dictionary managed.

bounced the database also , but still getting the same errors.

please help

regards
KKukreja

Edited by: ~JuniorDBA~ on Dec 20, 2010 8:59 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 25 2011

Added on Dec 20 2010

#general-database-discussions

29 comments

56,587 views