OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » connect as sysdba

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

connect as sysdba [message #142583]

Sun, 16 October 2005 04:32

gjayasekar
Messages: 45
Registered: October 2005

Member

hi,
i am trying to connect as sysdba from my solaris system
then i have got a error like this
pl help me to solve it
thanks
jai

err
SQL> conn sys/sys as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
SVR4 Error: 28: No space left on device
Additional information: 9925
ORA-01075: you are currently logged on

Attachment: err.txt
(Size: 0.27KB, Downloaded 1150 times)

Report message to a moderator

Re: connect as sysdba [message #142584 is a reply to message #142583]

Sun, 16 October 2005 05:03

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

As the error explains ,

I think OS level Auditing is ON on your machine and the device which stores audit info is running out of space.

Look into your init.ora file for Auditing options .

for getting the location , look into parameter AUDIT_FILE_DEST.

Report message to a moderator

Re: connect as sysdba [message #143063 is a reply to message #142584]

Wed, 19 October 2005 00:04

gjayasekar
Messages: 45
Registered: October 2005

Member

hi,
thanks
how to solve the above problem pl explain me
thanks
jai

Report message to a moderator

Re: connect as sysdba [message #143068 is a reply to message #143063]

Wed, 19 October 2005 00:16

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Quote:

how to solve the above problem pl explain me

--> Either turn off the auditing if you dont need it, or

--> Change AUDIT_FILE_DEST parameter value pointing to a free filesystem on your box.

Read this for more details .

http://ocpdba.net/10gdoc/server.101/b10755/initparams013.htm

and try to read the documentation related to Oracle Auditing feature ( you will get everything there)

Report message to a moderator

Re: connect as sysdba [message #144302 is a reply to message #142583]

Tue, 25 October 2005 18:55

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

If your system does have space and such. Try this:
>slqplus
Enter user-name: <sys / as sysdba> (mind the spaces)
Enter password: <anything, it still connects as sys>

Then:
alter user sys identified by <your-new-password>;

Report message to a moderator

Previous Topic:	Urgently needed solution for Error:-- ORA-00607
Next Topic:	User Creation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 12:13:26 CST 2025