Home » Infrastructure » Linux » Manual DB creation error (Oracle 11g on Centos-6.3_x86_64)
Manual DB creation error [message #581279] Thu, 04 April 2013 01:58 Go to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
Hi Experts,

I'm unable to create databsae manually on 11G, Please see the attachment for the details and the steps I followed.


Regards,
Unni.
Re: Manual DB creation error [message #581281 is a reply to message #581279] Thu, 04 April 2013 02:06 Go to previous messageGo to next message
Littlefoot
Messages: 19711
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's no attachment there.
Re: Manual DB creation error [message #581282 is a reply to message #581279] Thu, 04 April 2013 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And before you add your attachment, feedback to your previous topic and tell us how you solve the problem.
If you don't want other get profit to your problem and topic then I see no reason we continue to help you.

Regards
Michel
Re: Manual DB creation error [message #581283 is a reply to message #581282] Thu, 04 April 2013 03:35 Go to previous messageGo to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
Hello Michel,

I'm new to this forum..pardon me for the mistake...I'll write the feedback now itself...

Concerning to this issue. I've attached the steps I followed ..

regards
Unni.

Re: Manual DB creation error [message #581284 is a reply to message #581283] Thu, 04 April 2013 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No problem, I will help as soon as you feedback.

regards
Michel
Re: Manual DB creation error [message #581286 is a reply to message #581283] Thu, 04 April 2013 03:55 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory

Check the audit directory exists and accessible to oracle:
audit_file_dest='/media/volume-01/u01/app/oracle/admin/oracl/adump'

Is this really "oracl" and not "oracle", or the db name: AG_PUB?

Regards
Michel

[Updated on: Thu, 04 April 2013 03:57]

Report message to a moderator

Re: Manual DB creation error [message #581287 is a reply to message #581286] Thu, 04 April 2013 04:02 Go to previous messageGo to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
the audit directory doesn't exist...

as i mentioned earlier ..a folder having name of the existing database is present in the "/media/volume-01/u01/app/oracle/admin" directory...apart from that nothing.

shall i create the audit directory..?

Regards
Unni.
Re: Manual DB creation error [message #581316 is a reply to message #581287] Thu, 04 April 2013 07:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course.

Regards
Michel
Re: Manual DB creation error [message #581368 is a reply to message #581316] Fri, 05 April 2013 01:52 Go to previous messageGo to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
Hi Michel,

I created the audit file location and is accessible by the user 'oracle', but the problem still persisting..

Please see the attachment for detail..

Regards,
Unni.
Re: Manual DB creation error [message #581370 is a reply to message #581368] Fri, 05 April 2013 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I bet the parameter and the directory you created do not match in the spfile.

Regards
Michel

[Updated on: Fri, 05 April 2013 02:08]

Report message to a moderator

Re: Manual DB creation error [message #581371 is a reply to message #581370] Fri, 05 April 2013 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And kill all processes that returns the following:
ps -eaf|grep $ORACLE_SID

Regards
Michel
Re: Manual DB creation error [message #581380 is a reply to message #581371] Fri, 05 April 2013 02:41 Go to previous messageGo to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
dude

If I kill the above said processes , does it affect any already running services..?
Re: Manual DB creation error [message #581386 is a reply to message #581380] Fri, 05 April 2013 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 59505
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this not the database you are trying to create?
In this case, no one is using it.

Regards
Michel
Re: Manual DB creation error [message #581387 is a reply to message #581386] Fri, 05 April 2013 03:51 Go to previous message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
Hi Michel,

Eureka Eureka... the issue solved ...

I killed all the above said processes ..and created the spfile again...this time it got succeeded ..and i'm able to create database successfully...

Thanks a lot for your help.


Regards,
Unni.
Previous Topic: spliting a xml file based on no.of records in linux
Next Topic: Error in invoking target 'ntcontab.o' of makefile $ORACLE_HOME/network/lib/ins_net_client.mk
Goto Forum:
  


Current Time: Fri Oct 31 07:12:11 CDT 2014

Total time taken to generate the page: 0.12097 seconds