Oracle O/s-error Os 1502 The 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. ora 28056 solution Enter user-name: sys as sysdba Enter password: ERROR: ORA-28056: Writing audit records event log service is unavailable windows 7 to Windows Event Log failed OSD-00048: additional error information O/S-Error: (OS 1502) The event log file is full. DB Version : 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: 63912Registered: 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 d
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 5 Replies Latest reply on Feb 27, 2012 5:00 AM by 904205 unable o connect database 904205 Feb 27, 2012 4:24 AM Hi Experts, when i am trying to connect database in my local machine i am getting error like below from past 3 days. please help me for http://www.orafaq.com/forum/t/147256/ this problem, i have very important data in my db. Os:Win xp. Error is: SQL> conn scott/password ERROR: ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 0 Serial number: 0 SQL> conn sys/password AS SYSDBA ERROR: ORA-28056: Writing audit records to Windows Event Log failed OSD-248170904: Message 248170904 not found; product=RDBMS; facility=SOSD O/S-Error: (OS 1502) The event log file is full. ORA-01075: you are currently logged on https://community.oracle.com/thread/2354044 Thanks in Advance. surya. 194Views Tags: none (add) This content has been marked as final. Show 5 replies 1. Re: unable o connect database 912595 Feb 27, 2012 4:27 AM (in response to 904205) 1) Check if you are not running out of disk space first... 2) Check if OracleService
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) Database Recovery (2) Datafile (2) http://erpbasic.blogspot.com/2012/03/ora-28056-writing-audit-records-to.html DBA (8) DBCA (6) Deadlock (3) Device Management in 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 components (15) Oracle Database Creation (7) Oracle Instance (1) Oracle Managed event log 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 coding in BAAN ERP (10) Startup Oracle Database (5) Tablespace (9) Temp (7) Tools customization and oracle o/s-error os 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 log and start recording new events. To do so Go to Control Panel --> Administrative Tools --> Event Viewer --> Clear All Events. 2) We can also free a log and start recor