Problem in startup nomount .

[dbapro1146]

I have PROD database in my machine

[oracle@oracle TEST]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 9.7G 9.0G 208M 98% /
none 1014M 0 1014M 0% /dev/shm
/dev/sda2 4.9G 263M 4.4G 6% /var
/dev/sdb1 20G 639M 19G 4% /root/test

I need to create a another database (TEST) at location /root/test/TEST

first i run dbca and configure scripts CreateDB.sql .

My first database PROD at location /u01/PROD
My ORACLE_HOME = /u01/app/oracle/product/10.2.0.1


this TEST datbase is not started and giving error as follows


SQL> connect / as sysdba;
Connected to an idle instance.
SQL>
SQL>
SQL>
SQL> startup nomount;
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925



Give me soluiton asap

[davey23uk]

you dont have the necessary file structure in place to create the audit files

[gandolf989]

you dont have the necessary file structure in place to create the audit files

He seems confused about the meaning of asap ""

[vnktummala]

permissions!!!

make sure "oracle" user has permissions on /root/test file system

also, as Devey suggested, make sure you have necessary file structure in place for all dump destinations.

Thanks,

[naman20k]

originally posted by vnktummala
that make sure that oracle user has permission on /root/test file system
first u have to check the permission on root

[vnktummala]

what??

poster is trying to create the DB in /root/test so oracle should have permissions on /root/test. permissions on /root is irrelevant here.

Thanks,