walkerdba
asked on
create database manually
[oracle@term dbs]$ export ORACLE_SID=newdb
[oracle@term dbs]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 1 00:52:30 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on
SQL> exit
--------------------------
my initnewdb.ora file
newdb.__db_cache_size=2348
newdb.__java_pool_size=419
newdb.__large_pool_size=41
newdb.__oracle_base='/u01/
newdb.__pga_aggregate_targ
newdb.__sga_target=3816816
newdb.__shared_io_pool_siz
newdb.__shared_pool_size=1
newdb.__streams_pool_size=
#*.audit_file_dest='/u01/a
#*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/
*.db_block_size=8192
*.db_domain='localdomain'
*.db_name='newdb'
*.db_recovery_file_dest='/
*.db_recovery_file_dest_si
*.diagnostic_dest='/u01/ap
*.dispatchers='(PROTOCOL=T
#*.memory_target=636485632
*.open_cursors=300
*.processes=150
*.remote_login_passwordfil
*.undo_tablespace='UNDOTBS
[oracle@term dbs]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Fri Feb 1 00:52:30 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on
SQL> exit
--------------------------
my initnewdb.ora file
newdb.__db_cache_size=2348
newdb.__java_pool_size=419
newdb.__large_pool_size=41
newdb.__oracle_base='/u01/
newdb.__pga_aggregate_targ
newdb.__sga_target=3816816
newdb.__shared_io_pool_siz
newdb.__shared_pool_size=1
newdb.__streams_pool_size=
#*.audit_file_dest='/u01/a
#*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/
*.db_block_size=8192
*.db_domain='localdomain'
*.db_name='newdb'
*.db_recovery_file_dest='/
*.db_recovery_file_dest_si
*.diagnostic_dest='/u01/ap
*.dispatchers='(PROTOCOL=T
#*.memory_target=636485632
*.open_cursors=300
*.processes=150
*.remote_login_passwordfil
*.undo_tablespace='UNDOTBS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Most likely this is not the firs time you are attempting to run the installation with that particulr SID. Check this out:
http://elena-sqldba.blogspot.com/2013/01/ora-0992
5-unable-to-create-audit-t
http://elena-sqldba.blogspot.com/2013/01/ora-0992
5-unable-to-create-audit-t
The other thing to check is whether you have sufficient permission for adup directory.
Do:
cd /u01/app/oracle/admin/newd
ls -a adump
or
ls - a /u01/app/oracle/admin/newd
to see the permissions
Do:
cd /u01/app/oracle/admin/newd
ls -a adump
or
ls - a /u01/app/oracle/admin/newd
to see the permissions
ASKER
yes
#*.audit_trail='db'<<
This was commented while creating the database or you commented while posting, also let us know is this the complete init.ora file you have uploaded in the post which you were using for creating the DB.
>>ORA-09925: Unable to create audit trail file<<
The above error clearly states that it cann't create the audit file.
here is the doc with step by step process
http://docs.oracle.com/cd/B28359_01/server.111/b28310/create003.htm