Home » RDBMS Server » Server Administration » LogOn Problem
LogOn Problem [message #196914] Mon, 09 October 2006 02:23 Go to next message
thiyagaraj
Messages: 41
Registered: August 2006
Member
Hi

We have our DBMS_JOB to take the daily export dump.Today while i check the export dump log file,it shows me the following error.Also we have enabled the auditing on the DB.
errors:
EXP-00056: ORACLE error 9945 encountered
ORA-09945: Unable to initialize the audit trail file
SVR4 Error: 28: No space left on device
EXP-00030: Unexpected End-Of-File encountered while reading input
EXP-00000: Export terminated unsuccessfully


I know that this error is due to the audit destination full.So i had deleted half of the *.aud files in the destination.After that when i tried to log on as "SYS" it throws me this error message:

SQL> conn /as sysdba
ERROR:
ORA-09817: Write to audit file failed.
SVR4 Error: 28: No space left on device
ORA-01075: you are currently logged on


But it allows me to anter as "SYSTEM" in to the DB.
Please clear my doubt and give me the solution to the problem.

Thanks
Raaj. Embarassed
Re: LogOn Problem [message #196952 is a reply to message #196914] Mon, 09 October 2006 05:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Connections as SYSDBA are always audited, that's why you can connect as SYSTEM and not as SYS. Have you verified you have write privileges to the audit directory?
Re: LogOn Problem [message #197044 is a reply to message #196914] Mon, 09 October 2006 13:08 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

And how can u delete below files.
i had deleted half of the *.aud files
Re: LogOn Problem [message #197092 is a reply to message #197044] Tue, 10 October 2006 00:45 Go to previous messageGo to next message
thiyagaraj
Messages: 41
Registered: August 2006
Member
Thanks ebrian.
Dear user52,
Are u asking me the command? or do u want to pointout the thing which i have deleted the aud files.
Re: LogOn Problem [message #197097 is a reply to message #197092] Tue, 10 October 2006 01:04 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

My mean is u delete ur file Physical ( OS select and delete) or with cmd.
Re: LogOn Problem [message #229560 is a reply to message #197097] Mon, 09 April 2007 02:24 Go to previous messageGo to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

Finally, how can we delete audit files.
From cmd prompt?
I am using Oracle 10g. Is it safe to delete .aud file from adump folder from Linux server.
I am getting the same error message mentioned on login to sys.

Please reply immediately.

Amit
Re: LogOn Problem [message #229569 is a reply to message #229560] Mon, 09 April 2007 02:42 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
check Metalink Note >Doc ID: Note:69642.1 Point NO. 8.

Regards
Taj
Previous Topic: Rename table
Next Topic: ORA-04031: unable to allocate 16384 bytes
Goto Forum:
  


Current Time: Sat Dec 10 18:29:35 CST 2016

Total time taken to generate the page: 0.04282 seconds