OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » LogOn Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LogOn Problem [message #196914]

Mon, 09 October 2006 02:23

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

Report message to a moderator

Re: LogOn Problem [message #196952 is a reply to message #196914]

Mon, 09 October 2006 05:55

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?

Report message to a moderator

Re: LogOn Problem [message #197044 is a reply to message #196914]

Mon, 09 October 2006 13:08

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

Report message to a moderator

Re: LogOn Problem [message #197092 is a reply to message #197044]

Tue, 10 October 2006 00:45

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.

Report message to a moderator

Re: LogOn Problem [message #197097 is a reply to message #197092]

Tue, 10 October 2006 01:04

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.

Report message to a moderator

Re: LogOn Problem [message #229560 is a reply to message #197097]

Mon, 09 April 2007 02:24

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

Report message to a moderator

Re: LogOn Problem [message #229569 is a reply to message #229560]

Mon, 09 April 2007 02:42

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

Report message to a moderator

Previous Topic:	Rename table
Next Topic:	ORA-04031: unable to allocate 16384 bytes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:48:20 CDT 2024