Solved

create database manually

Posted on 2013-02-01
5
295 Views
Last Modified: 2013-02-20
[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=234881024
newdb.__java_pool_size=4194304
newdb.__large_pool_size=4194304
newdb.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
newdb.__pga_aggregate_target=255852544
newdb.__sga_target=381681664
newdb.__shared_io_pool_size=0
newdb.__shared_pool_size=130023424
newdb.__streams_pool_size=0
#*.audit_file_dest='/u01/app/oracle/admin/newdb/adump'
#*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/newdb/control01.ctl','/u01/app/oracle/flash_recovery_area/newdb/control02.ctl'
*.db_block_size=8192
*.db_domain='localdomain'
*.db_name='newdb'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=newdbXDB)'
#*.memory_target=636485632
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
0
Comment
Question by:walkerdba
5 Comments
 
LVL 36

Accepted Solution

by:
Geert Gruwez earned 500 total points
Comment Utility
set your audit trail to none

*.audit_trail='none'
0
 
LVL 12

Expert Comment

by:praveencpk
Comment Utility
>>#*.audit_file_dest='/u01/app/oracle/admin/newdb/adump'
#*.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
0
 
LVL 35

Expert Comment

by:YZlat
Comment Utility
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-trail.html
0
 
LVL 35

Expert Comment

by:YZlat
Comment Utility
The other thing to check is whether you have sufficient permission for adup directory.

Do:

cd /u01/app/oracle/admin/newdb
ls -a adump

or

ls - a /u01/app/oracle/admin/newdb/adump

to see the permissions
0
 

Author Closing Comment

by:walkerdba
Comment Utility
yes
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now