Operating System Error = 1502the Event Log File Is Full
is full [message #411266] Thu, 02 July 2009 22:40 rajabaskar Messages: 13Registered: June 2007 Location: chennai Junior Member Hi , I got below error while connecting the oracle database. Enter user-name: sys as sysdba Enter password: ERROR: ORA-28056: Writing audit records to Windows Event Log ora-28056: writing audit records to windows event log failed failed OSD-00048: additional error information O/S-Error: (OS 1502) The event log file is full. DB Version event log service is unavailable windows 7 : 11.1.0.7 O/s : Windows Xp (32 bit) Please help me.. Best Regards Rajabaskar Thangaraj Report message to a moderator Re: Oracle 11g event log file is full [message #411269 is a reply to message #411266] Thu, 02 July 2009 22:51 ebrian Messages: 2794Registered: April 2006 Senior Member Free some space on the volume where the event log is located, purge some records out of the Windows Event viewer or change the properties of the log to a larger size and/or overwrite events. [Updated on: Thu, 02 July 2009 22:53]Report message to a moderator Re: Oracle 11g event log file is full [message #411270 is a reply to message #411269] Thu, 02 July 2009 23:00 rajabaskar Messages: 13Registered: June 2007 Location: chennai Junior Member Enough space in C drive.. In same pc, i am able to connect the oracle 10g database. While i am connecting oracle 11g database, i have faced this issue. BR Rajabaskar Report message to a moderator Re: Oracle 11g event log file is full [message #411273 is a reply to message #411270] Thu, 02 July 2009 23:06 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Quote:purge some records out of the Windows Event viewer change the properties of the log to a larger size and/or overwrite events. Did you do that? Regards Michel Report message to a moderator Re: Oracle 11g event log file is full [message #411274 is a reply to message #411266] Thu, 02 July 2009 23:08 animesh_nz19 Messages: 7Registered: July 2009 Junior Member This is because the AUDITING is enabled in the database. Set AUDIT_TRAIL=NONE and then try to start database. If you want AUDIT to be enabled, then check with your OS admin on why Oracle is not able to write to event log. In windows when audit_trail=OS is set all the audit entries are logged in eventviewer. You can also change audit_trail=db so that audit entries are recorded in SYS.AUD$ table. << This will also solve your problem. Report message to a moderator Re: Oracle 11g event log file is full [message #411276 is a reply to message #411274] Thu, 02 July 2009 23:12 ebrian Messages: 2794Registered: April 2006 Senior Member animesh_nz19 wrote on Fri
Appearance Subscribe l l FOLLOW US TWITTER GOOGLE+ FACEBOOK GET UPDATES BY EMAIL Enter your email below to get exclusive access to our best articles and tips before everybody else. RSS ALL ARTICLES FEATURES ONLY TRIVIA Search How-To Geek Fixing "The Event Log is Full" Error on Windows XP I was working on a project for work when I suddenly got the strangest error: "The Event Log is Full". Seriously? What I didn't remember is that Windows XP doesn't automatically overwrite events less than 7 days old from the event log, so when it's full, most applications that try and http://www.orafaq.com/forum/t/147256/ write to the event log are going to break. You can easily fix this problem by changing the event logs to overwrite old events regardless of the date, or just increase the size that the log is allowed to grow to. Note: If your event log is so huge within 7 days that you are getting this error, there's probably something seriously wrong. You should inspect your event log to understand what is http://www.howtogeek.com/howto/windows/fixing-the-event-log-is-full-error-on-windows-xp/ causing all of the errors… more on that in a future article. Increasing Event Log Size Open up Event Viewer by typing in eventvwr into the Start \ Run box, or you can find it under Administrative tools section of Control Panel. You'll notice over on the right-hand side of the window that the current size of my Application and System Event Logs are 512 KB… Now you can right-click on one of the Event Logs in the list, and choose Properties from the menu. In this dialog you can do a number of things… you could clear the log, increase the size, or just set the system to overwrite events as needed. I chose to increase the maximum size of the event log, and then also to overwrite events as needed. For those of you using Windows Vista, you'll notice that the default settings in Vista are to overwrite as needed, and the maximum size is way bigger. Guess my setting choices make sense then… Again, if your Application or System event logs are growing so gigantic that you are getting this error, you should really look into the root cause by carefully examining the entries in the logs. JOIN THE DISCUSSION Tweet Lowell Heddings, better known online as the How-To Geek, spends all his f
tools (5) BSE (3) collection Classes (9) Collections (14) Control file (7) Data Block (5) Data Dictionary (11) Database Auditing (5) Database Management in BAAN ERP (4) http://erpbasic.blogspot.com/2012/03/ora-28056-writing-audit-records-to.html Database Recovery (2) Datafile (2) DBA (8) DBCA (6) Deadlock (3) Device Management in https://oaisys.wikispaces.com/share/view/27817977 BAAN ERP (2) directory structure (3) Enterprise tools (21) ERP (4) Exception (13) Form management in BAAN ERP (3) Generics (11) Inheritance in Java (15) Initialization Parameter (9) Instance Memory Structure (4) Java Interface (7) Java Question (42) Logical Storage (11) Manually Database Creation (10) Materialized View (2) NoArchivelog (6) Oracle Background Process (14) oracle event log components (15) Oracle Database Creation (7) Oracle Instance (1) Oracle Managed Files (9) Oracle Problems (12) PFile (5) Physical Storage (8) PL/SQL (3) Planning DB Files (1) Procedure (3) RDBMS (2) Recovery (5) Recovery Catalog (3) Redo Log (8) Report management in BAAN ERP (3) Server Process (3) Session management in BAAN ERP (1) SGA (2) Shutdown Oracle Database (5) SPfile (4) SQL in BAAN ERP (3) standard software operating system error coding in BAAN ERP (10) Startup Oracle Database (5) Tablespace (9) Temp (7) Tools customization and development (6) Troubleshooting (6) Undo (4) User Process (3) Version Release Customization (3) View (6) ORA-28056: Writing audit records to Windows Event Log failed 16:33 Navneet Singh No comments I got a PC which ran out from disk space & Oracle was not working. The error was ORA-28056. I need to delete all the event log & then reconnect it again. Here you can see what happened & it get resolved. C:\Documents and Settings\navneet>sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 7 15:44:02 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to an idle instance. SQL> startup ORA-28056: Writing audit records to Windows Event Log failed OSD-157797404: Message 157797404 not found; product=RDBMS; facility=SOSD O/S-Error: (OS 1502) The event log file is full. SQL> exit Disconnected Solution of the Problem : This was because the Event Viewer log is full and could not log anymore events. The solution is to clear the event log .To solve this issue follow any of the following steps. 1) When a log is full, it stops recording new events. Clearing the log is one way to free the lo
Using Gmail with Tracer Email service Return to Discussion Help · About · Blog · Pricing · Privacy · Terms · Support · Upgrade Contributions to https://oaisys.wikispaces.com/ are licensed under a Creative Commons Attribution Share-Alike 3.0 License. Portions not contributed by visitors are Copyright 2016 Tangient LLCTES: The largest network of teachers in the world Turn off "Getting Started" Home ... Loading...