Home > Return Code > Dba_audit_trail Return Code Values

Dba_audit_trail Return Code Values

Contents

Contact Us - Dbvisit : Protection - Recovery - Continuity - Archive - Top ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve The corresponding name of the action type is in the ACTION_NAME column. Since posting the first message, I believe I have found a solution. As an example, AUDIT TABLE audits all CREATE and DROP TABLE statements. check over here

Please wait..." } retry count 2 { ... The characters are: - - None S - Success F - Failure B - Both LOGOFF_TIME DATE Date and time of user log off LOGOFF_LREAD NUMBER Logical reads for Generated Wed, 28 Dec 2016 10:38:41 GMT by s_hp87 (squid/3.5.20) The method can be one of the following: DATABASE - Authentication was done by password NETWORK - Authentication was done by Oracle Net Services or the Advanced Security option PROXY -

Dba_audit_trail Return Code Values

This will be fixed in the next release. SQL> truncate table aud$;Table truncated.1.audit table by access;BOTH successful or not successful statement2.audit table by access whenever successful;SUCCESSFUL statement only3.audit table by access whenever not successful;NOT SUCCESSFUL statement only4.audit table by The trace file is usually in /usr/tmp and ends with .trc.

New datafile(s) have been added to the primary database. Tom Tay View Public Profile Find all posts by Tom Tay #9 07-08-2012, 08:29 PM Arjen Visser Dbvisit Team Join Date: Jan 2008 Location: Auckland, New Zealand Posts: Standby Database oracle_database started nomount. 201207071829 - ORA-01507: database not mounted Dbvisit Standby terminated. Ora-02004 Starting Standby Database oracle_database...

Results 1 to 3 of 3 Thread: DBA_AUDIT_TRAIL Returncode column Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Oracle Audit Return Code List Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Standby Database oracle_database started nomount 201207061326 - ORA-01507: database not mounted Dbvisit Standby terminated. This file should be present on standby as /usr/local/dbvisit/logs/standby_HCAPLIVE.ctl Steps to perform on standby ==== SQL>shutdown abort; SQL>startup nomount; >rman nocatalog RMAN>connect target / run { allocate channel c1 type disk;

It was my misunderstanding that was the block. Oracle Return Code 1005 Reply With Quote 11-08-2002,12:24 PM #5 gopi View Profile View Forum Posts Tree Hugger Join Date Dec 2001 Location Keene, NH Posts 510 Now I understand! Page 1 of 2 1 2 > Thread Tools Search this Thread Display Modes #1 07-06-2012, 06:58 PM Tom Tay Junior Member Join Date: Jul 2012 Posts: Any hint or suggestion?

Oracle Audit Return Code List

Arjen Visser View Public Profile Visit Arjen Visser's homepage! http://www.ibm.com/support/knowledgecenter/SSLTBW_2.1.0/com.ibm.zos.v2r1.csfb400/csfb4za2571.htm Standby Database oracle_database started . ================================================== =========== dbv_oraStartStop ended on standby2: Sat Jul 7 18:28:56 2012 ================================================== =========== $ dbvisit oracle_database================================================== =========== Dbvisit Standby Database Technology (6.0.30.8993) (pid 368694) dbvisit started Dba_audit_trail Return Code Values But here is an example: # Attempt to catch the return code from f77 # set rc [catch { exec f77 -c myff2.f } msg ] set errc $errorCode; set erri Dba_audit_trail Return Code 1017 Symptom The total number of documents in the index is unexpectedly dropping after each main index build.

From trc log,20120707 11:43:00 main::cmn_cat-> SQL> SQL> SQL> SQL> select name, controlfile_type,open_mode from v$database 20120707 11:43:00 main::cmn_cat-> * 20120707 11:43:00 main::cmn_cat-> ERROR at line 1: 20120707 11:43:00 main::cmn_cat-> ORA-01507: database not check my blog SQL> startup nomount; ORACLE instance started. Tom Tay View Public Profile Find all posts by Tom Tay Page 1 of 2 1 2 > « Previous Thread | Next Thread » Thread Tools Show Printable Version Email If you use Version 8.4, you can view the log files with the enterprise search administration console. Dba_audit_trail Return Code List

I have looked through my reference books and searched MetaLink, but have been unable to find anything. The time now is 10:38 PM. I would like to obtain the description of the returncode error code from somewhere inside the database. http://homecomputermarket.com/return-code/oracle-audit-return-code-list.html Related View USER_AUDIT_TRAIL displays all audit trail entries related to the current user.

Some useful values: 0 - Action succeeded 2004 - Security violation PRIV_USED VARCHAR2(40) System privilege used to execute the action CLIENT_ID VARCHAR2(64) Client identifier in each Oracle session ECONTEXT_ID Oracle Audit Trail Return Codes Please think of the fact, that the executable is not maintained by us, it's a company external executable! Theses failure codes are used as exit code of the C executable.Catching the close on the blocked command channel to the C executable let the exit code be stored in side

Please shut it down first.

Thursday, February 1, 2007 Audit Database Type of Auditing1.Standard Auditing2.FGA (Fine Grained Auditing)3.SYS ( sysdba or sysoper) DBA_AUDIT_EXISTS lists audit trail entries produced by AUDIT NOT EXISTS.DBA_AUDIT_OBJECT contains audit trail records Advanced Search Forum Oracle Forums Oracle Database Administration AUDIT returncode lookup If this is your first visit, be sure to check out the FAQ by clicking the link above. Reply With Quote 04-30-08,12:43 #3 buckeye234 View Profile View Forum Posts Registered User Join Date Sep 2002 Location Ohio Posts 204 Thanks very much for the reply. Oracle Audit Action Codes List Or is this a tcl speciality to be platform independent by supporting only an 1 byte sized integer as exit code in command channels?male - 14th Sep. 2004: (my own answer)Its

But still encountered same problem dbv_oraStartStop restart oracle_database================================================== =========== Dbvisit Standby Database Technology (6.0.30.8890) (pid 372832) dbv_oraStartStop started on standby2 : Sat Jul 7 18:28:51 2012 () ================================================== =========== Shutting down Find all posts by Arjen Visser #3 07-07-2012, 05:14 PM Tom Tay Junior Member Join Date: Jul 2012 Posts: 9 The dbvisit version is 6.0.30.8890 $ dbv_oraStartStop start Diagnosing the problem Review the dropped document log files for the index, which you can find at ES_NODE_ROOT/data/collection_ID. have a peek at these guys See Viewing log files about dropped documents for more information.

Powered by Blogger. But we get only the last byte of the exit code.example: the original failure & exit code is 655, the exit code in tcl via errorCode is 143 (655 & 255 The numeric value in this column corresponds to the numeric value in an ORA-99999 error message. I'd like to include both the returncode and a description of the returncode in the output of the script.

Results 1 - 10 of about 2,310,000 for oracle error codes. 1st response http://www.ora-code.com/ or you can roll your own by iterating across all possible values via oerr You can lead This FORTRAN code returns failure code integers using 4Bytes (INTEGER*4). The average person thinks he's above average!