OraFAQ Forum: Security » cannot startup the DB because Audit file directory not exist

Home » RDBMS Server » Security » cannot startup the DB because Audit file directory not exist (oracle 11gr2 centos 5.3 )

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

cannot startup the DB because Audit file directory not exist [message #455774]

Wed, 12 May 2010 23:29

oravijay
Messages: 43
Registered: March 2010

Member

Hello Everybody

I cannot able to stratup the database since i have configfured the audit dumps to the external harddisk of the

server.Today my External harddisk is crashed.

when i give

sql>connect / as sysdba

SQL> connect / as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925

I have checked my alert logs

<txt>OS Audit file could not be created; failing after 5 retries

currently the database has been running with spfile
How can i login to sys user or any user.?
what parameters i have change in pfile ?
Is it needed to create any password file to login to sys user?
I can't able to startup the database through pfile or spfile without connecting to any user.

i cannot login to internal user and login through SVRMGL utility.
ORA-09275: CONNECT INTERNAL is not a valid DBA connection

please,suggest your possible ways to startup my Database

Thanks in Advance
Vijay

Report message to a moderator

Re: cannot startup the DB because Audit file directory not exist [message #455776 is a reply to message #455774]

Wed, 12 May 2010 23:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORA-09275: CONNECT INTERNAL is not a valid DBA connection
above has not been valid since V8

post results from following command

env | sort

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: cannot startup the DB because Audit file directory not exist [message #455777 is a reply to message #455774]

Wed, 12 May 2010 23:56

oravijay
Messages: 43
Registered: March 2010

Member

env | sort
_=/bin/env
DISPLAY=localhost:11.0
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/rahs2orcl
HOSTNAME=nixon
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=rahs2orcl
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/rahs2orcl
OLDPWD=/
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_HOSTNAME=nixon
ORACLE_SID=RAHSII
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/home/rahs2orcl/bin
PWD=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/audit
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_CLIENT=192.168.6.59 2012 22
SSH_CONNECTION=192.168.6.59 2012 192.168.6.56 22
SSH_TTY=/dev/pts/2
TERM=xterm
USER=rahs2orcl

Report message to a moderator

Re: cannot startup the DB because Audit file directory not exist [message #455778 is a reply to message #455777]

Wed, 12 May 2010 23:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

edit alert_RAHSII.log to create new pfile then use it to start DB

Report message to a moderator

Re: cannot startup the DB because Audit file directory not exist [message #455795 is a reply to message #455774]

Thu, 13 May 2010 01:20

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-09925: Unable to create audit trail file
 *Cause:  ORACLE was not able to create the file being used to hold
          audit trail records.
 *Action: Check the UNIX error number for a possible operating system error.
          If there is no error, contact ORACLE customer support.

Modify audit_file_dest parameter or create a directory or a link for the audit file destination.

Regards
Michel

Report message to a moderator

Re: cannot startup the DB because Audit file directory not exist [message #455854 is a reply to message #455778]

Thu, 13 May 2010 03:48

oravijay
Messages: 43
Registered: March 2010

Member

"edit alert_RAHSII.log to create new pfile then use it to start DB "

sorry what do you mean? Let me know more in detail

Thanks
vijay

Report message to a moderator

Re: cannot startup the DB because Audit file directory not exist [message #455856 is a reply to message #455795]

Thu, 13 May 2010 03:49

oravijay
Messages: 43
Registered: March 2010

Member

Thanks Michel

Report message to a moderator

Re: cannot startup the DB because Audit file directory not exist [message #455920 is a reply to message #455854]

Thu, 13 May 2010 09:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when the DB starts, parameters with non-default values are written to alert logfile.
Therefore you could use alert logfile to create a new pfile & then
STARTUP PFILE='iniRAHSII.ora'

Report message to a moderator

Re: cannot startup the DB because Audit file directory not exist [message #455995 is a reply to message #455920]

Fri, 14 May 2010 00:27

oravijay
Messages: 43
Registered: March 2010

Member

Thanks for all Viewers

Report message to a moderator

Previous Topic:	MANAGE GROUP OF USERS
Next Topic:	Oracle not asking for password

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 17:29:27 CDT 2023