Home » RDBMS Server » Security » cannot startup the DB because Audit file directory not exist (oracle 11gr2 centos 5.3 )
cannot startup the DB because Audit file directory not exist [message #455774] Wed, 12 May 2010 23:29 Go to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 26649
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/
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 26649
Registered: January 2009
Location: SoCal
Senior Member
edit alert_RAHSII.log to create new pfile then use it to start DB
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66794
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
oravijay
Messages: 43
Registered: March 2010
Member
Thanks Michel
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 Go to previous messageGo to next message
BlackSwan
Messages: 26649
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'
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 Go to previous message
oravijay
Messages: 43
Registered: March 2010
Member
Thanks for all Viewers
Previous Topic: MANAGE GROUP OF USERS
Next Topic: Oracle not asking for password
Goto Forum:
  


Current Time: Thu Jan 23 23:07:59 CST 2020