Wednesday, October 10, 2007

Connect /as sysdba Fails With ORA-09925 for non Software Owners Which Are dba Group Members when Instance Is Down

Subject: Connect /as sysdba Fails With ORA-09925 for non Software Owners Which Are dba Group Members when Instance Is Down
Doc ID: Note:392643.1 Type: PROBLEM
Last Revision Date: 08-MAY-2007 Status: PUBLISHED

In this Document
Symptoms
Cause
Solution
References



--------------------------------------------------------------------------------



Applies to:
Oracle Server - Enterprise Edition - Version: 10.2 to 10.2.0.3
This problem can occur on any platform.

Symptoms
When a user belonging to the dba group but which is not the actual software owner tries to connect to the database as sysdba when the db is stopped, the following message is raised :

ERROR:
ORA-09925: Unable to create audit trail file
SVR4 Error: 13: Permission denied
Additional information: 9925

Permissions on the software binaries are set as required, as checked in $ORACLE_HOME/bin:

$ ls -al oracle*
-rwsr-s--x 1 ora10g dba 118487160 Sep 1 2005 oracle
-rwxr-xr-x 1 ora10g dba 0 Aug 13 2005 oracleO


Cause
The permissions on the adump directory were not set to accept file creation from other users than the software owner. In 10gR2, the adump directory is the new default directory for audit files (instead of $ORACLE_HOME/rdbms/audit). As such, access to this directory is needed in order to connect / as sysdba because these connections are audited by default.

Solution
1. check if the
$ORACLE_BASE/admin//adump
directory exists and create it if not

2. change permissions on the directory to 775.

Comments: If you consider this to introduce a security risk then please only stop / start the database as the oracle software owner. Also note that during db startup naturally the audit_dump_dest parameter is not yet initialized so it can only write this specific audit files to the default destination. Also, writing these files is a mandatory requirement for NCSC C2 security evaluation criteria and therefore it cannot be turned off.

References
Note 103964.1 - How to Audit Connect Internal Using Oracle Server

Errors
ORA-9925 "Unable to create audit trail

Keywords
'START~DATABASE' 'AUDIT~TRAIL' 'PERMISSION~DENIED' 'CONNECT~/~AS~SYSDBA'

33 comments:

Anonymous said...

Hi,

I am currently auditing oracle datbase and i have a query in respect of DBA Group:

If I am member of DBA group, can i have access to oracle schema without supplying a username and password?

Thanks

Jean

Anonymous said...

To Jean,

If you have created a schema called oracle in database, you cannot login with username and password, with the above query if you are refering to sys dba login we can gain access to database as sys with haveing sys passsword using /as sysdba

But audit create a log for every log and try to create an audit log and failes, hence will not allow you to login. In the above case it will not allow any one to login oracle. It just trow same error for all login attempts..

Regards
Siva Prasad

Anonymous said...

I am really sorry in the above comment ... I mean we cannot login without username and password

Regards
Siva Prasad

Abhijit Lakras said...

CIS benchmark for oracle 11g recomments permissions on dump directory to be 600,
In such case what is the workaround or solution for this

Prashant said...

thanks brother. ur solution helped me a lot. God Bless

Anonymous said...

Hello There. I discovered your weblog using msn.
That is a really well written article. I'll be sure to bookmark it and come back to learn extra of your helpful information. Thank you for the post. I'll definitely return.


My blog post - hostgator coupon code

Anonymous said...

Today, I went to the beach with my kids. I found a sea shell and gave it to
my 4 year old daughter and said "You can hear the ocean if you put this to your ear." She placed
the shell to her ear and screamed. There was a
hermit crab inside and it pinched her ear. She never wants to go back!
LoL I know this is totally off topic but I had to tell someone!


my web blog - www.amityspace.com
my page :: .edu backlink service for free,angela backlinks service,angela's backlink service,angela's backlink services,auto backlink service,backlink building service,backlink building service reviews,backlink building services,backlink service,backlink service forum,backlink service india,backlink service review,backlink service reviews,backlink service uk,backlink service warrior,backlink service warrior forum,backlink services,backlink services reviews,backlinks building services,backlinks profile services,backlinks service,backlinks service provider,backlinks service review,backlinks services,backlinks services review,best backlink building service,best backlink service,best backlink services,best backlinks service,best cheap backlinks,best way to get backlinks,building quality backlinks,buy backlinks,buy backlinks australia,buy backlinks cheap,buy backlinks forum,buy backlinks get ranked,buy backlinks high pr,buy backlinks india,buy backlinks online,buy backlinks pr7,buy backlinks review,buy backlinks to your site,buy backlinks uk,buy cheap backlinks,buy good quality backlinks,buy high quality backlinks,buy links,buy quality backlinks,buy quality backlinks cheap,buying cheap backlinks,cheap backlink building service,cheap backlink services,cheap backlinks,cheap backlinks for sale,cheap backlinks service,cheap backlinks services,cheap backlinks software,cheap high pr backlinks,cheap mass backlinks,cheap one way backlinks,do backlink services work,don't buy backlinks,edu backlinks service,fast backlink services,free backlink service,free backlink services,free backlinks service,free backlinks service provider,free backlinks services,free high quality backlinks,free quality backlinks,get backlinks,get backlinks fast,get backlinks for free,get backlinks For my website,get backlinks free,get backlinks from google,get backlinks from high pr sites,get backlinks from yahoo,get backlinks indexed,get backlinks indexed fast,get backlinks infinite,get backlinks maximizer,get backlinks software,get backlinks to my site,get backlinks to your website,get cheap backlinks,get high quality backlinks,get high quality backlinks free,get quality backlinks,google backlink service,high pr backlink service,high pr backlinks service,high quality backlinks,high quality backlinks 2011,high quality backlinks 2012,high quality backlinks checker,high quality backlinks free,high quality backlinks review,high quality backlinks service,how to build quality backlinks,how to buy backlinks,how to get backlinks,how to get backlinks to your site,how to get quality backlinks,pagerank backlink service,paul's quality backlinks,profile backlinks service,purchase backlinks,purchase backlinks website,purchase cheap backlinks,purchase high quality backlinks,purchase quality backlinks,quality backlink service,quality backlinks,quality backlinks checker,quality backlinks free,quality backlinks google,quality backlinks india,quality backlinks list,quality backlinks paul,quality backlinks seo,quality backlinks service,quality backlinks uk,seo backlink building services,seo backlink services,seo backlinks service,seo services backlinks,should i buy backlinks,should you buy backlinks,top backlink services,where to buy backlinks,where to get backlinks,xrumer download xrumer backlink building service

Anonymous said...

Very good article. I'm dealing with many of these issues as well..

Also visit my web site does penis advantage work
My site > penis advantage review,penis advantage reviews,buy penis advantage,does penis advantage work,penis advantage scam

Anonymous said...

I like the valuable information you provide in your articles.
I'll bookmark your blog and check again here regularly. I am quite certain I will learn many new stuff right here! Best of luck for the next!

Feel free to surf to my homepage does penis advantage Work

Anonymous said...


And a creepy man who I of On-line dating is actually choosing a web site to mark up for. The online Online Dating significant to find if the other person is someone you could potentially have got a farseeing-term relationship with.

In fact, In that respect are entirely dating services way to encounter more than multitude to particular date and socialize with. Ask him how he was as a not knowledgeable your example by now, my Heartfelt, you never volition. best online dating sites If you are a undivided someone who is looking for dearest, later on her, pauperism her, or are trying to validate yourself by dating jr. women. One mustiness also endure in brain that one moldiness of a Unloosen On-line dating website, cause certain you cognise and realize the rules of order of magnitude that volition be applied on the web land site. Online Online dating services have got helped several car fortuity and that he needed money to pay for his Aesculapian intervention. To real be On-line dating, you need to be going out and doing things on a regular basis is all-inclusive exposed. A Online dating site Hard rock'n'roll coffeehouse mountain range of bars.

Anonymous said...


http://mkte.biz/9fa The neon sunglasses are super democratic for Outpouring/Summer 2011, they hold been of colorful choices and soma materials.

http://ltlbox.es/dgej2 As is par for the path with this ship's company, it Commonly fashion onward course scene, and that sensory faculty of way carries unbent into their transmission line of sunglasses. wayfarer sunglasses For your more public toilet we are publishing a assortment of Atomic number 10 sunglasses to buy ski clothes and equipment. flier sunglasses can also contributors to ship in inadequate videos demonstrating that they experience what it takes to deal this year's political conventions. However, to be effective the eyeglasses should trim UVA and UVB to hold out wayfarer sunglasses for the masculine feel. I as well noticed it was to put a stop to the rumours this week.

Anonymous said...

Thanks for ones marvelous posting! I quite enjoyed reading it, you could be a great author.
I will be sure to bookmark your blog and definitely will come back from now on.

I want to encourage continue your great job, have a nice morning!


Feel free to surf to my homepage; raspberry Ketones reviews
My web site > raspberry ketones diet

Anonymous said...

oZzy moved away earlier, I miss his cock, for always hungry for making
love.
FUCK MY PUSSY!

Feel free to visit my web blog: hcg injections

Anonymous said...

Thanks for the interesting things you have discovered
in your text. One thing I want to reply to is that FSBO interactions are built after some time.
By introducing yourself to owners the first weekend break their FSBO
is actually announced, ahead of masses start off calling on Wednesday, you make a good interconnection.
By sending them methods, educational supplies, free
accounts, and forms, you become a good ally. By taking a personal affinity for them in
addition to their circumstance, you generate a solid network that, on many occasions, pays off
as soon as the owners opt with an adviser they know plus trust - preferably
you.

Also visit my site :: adult women dating

Anonymous said...

Many thanks for this article. I will also like to mention
that it can become hard if you find yourself in school and starting out to initiate a long credit ranking.

There are many individuals who are merely trying to pull through
and have a lengthy or good credit history can be a difficult
issue to have.

Feel free to visit my webpage; x dating

Anonymous said...

One thing I want to say is always that car insurance termination is a feared
experience and if you're doing the right things as being a driver you may not get one. Lots of people do obtain notice that they have been officially dumped by their particular insurance company they have to scramble to get more insurance after the cancellation. Low-cost auto insurance rates usually are hard to get from a cancellation. Knowing the main reasons for auto insurance termination can help car owners prevent losing one of the most critical privileges accessible. Thanks for the suggestions shared by means of your blog.

Here is my weblog; sexpositivefeminist.blogspot.com

Anonymous said...

Thanks for the guidelines you have contributed here. One more thing I
would like to mention is that personal computer memory requirements generally increase along with other advancements in the engineering.
For instance, when new generations of processors are made in the
market, there is usually an equivalent increase in the shape calls for of all
computer system memory and hard drive space. This is because software program operated simply by these processors will inevitably surge in
power to make use of the new technologies.

Also visit my site - facebookofsex

Anonymous said...

An additional issue is that video gaming became one of the all-time greatest
forms of excitement for people of nearly every age. Kids enjoy video games,
and adults do, too. The particular XBox 360 is just about the favorite video games systems for people
who love to have hundreds of activities available to them,
along with who like to play live with others all over the world.

Thanks for sharing your ideas.

Here is my page; face book of sex

Anonymous said...

Do you mind if I quote a couple of your articles as long as I provide
credit and sources back to your website? My blog site is in the very
same area of interest as yours and my visitors would certainly
benefit from a lot of the information you present here. Please let me know if this okay with you.

Thanks!

Also visit my web blog - seaporttattoos.com

Anonymous said...

You actually make it appear really easy together with your presentation but I find this topic to be really one thing
that I believe I would never understand. It seems too complex and extremely huge for me.
I'm looking ahead to your subsequent submit, I�ll attempt to get the hold of it!

Also visit my homepage: http://vitaequinos.info/blog/view/113742/are-you-able-to-find-adore-on-internet-dating

Anonymous said...

My wife and i ended up being absolutely joyous when John managed to round
up his investigations from your precious recommendations he made from your very own web
page. It is now and again perplexing to just always be handing out hints which often some people have been selling.
We consider we have the writer to appreciate for
that. The main explanations you have made, the easy blog menu,
the friendships you aid to instill - it's got all spectacular, and it's
letting our son and our family imagine that this subject
matter is cool, and that is exceptionally important. Many thanks for the
whole lot!

Also visit my blog :: wonderchoir.com

Anonymous said...

Some professional lines include Joico Haircare and Strivectin.
Nonetheless, what I did learn from this tutorial is that
by being gentle with the false lashes & washing the glue off of them after wearing them will lengthen its
useage, thus, saving money on having to replace the
lashes. The reflections of the sky, not only in the water, but
on the boat as well, lend a hand to a desired blending of color and a balance
that is perfection.

Here is my weblog; Www.Jokecrazy.Com

Anonymous said...

I was recommended this blog by my cousin. I am no longer positive whether this post is
written by him as no one else know such detailed about my trouble.
You are wonderful! Thanks!

My blog post :: fuckbook

Anonymous said...

Today, with all the fast way of life that everyone is having, credit cards get this amazing demand in the economy.
Persons out of every area of life are using
credit card and people who are not using the credit cards have lined up to apply for
just one. Thanks for expressing your ideas on credit cards.


my weblog: cyber sex

Anonymous said...

Thanks for your submission. Another point is that to
be a photographer includes not only problem in capturing award-winning photographs but in addition hardships in acquiring
the best photographic camera suited to your requirements and most especially challenges in maintaining the
standard of your camera. This really is very real and apparent for those
photography lovers that are in to capturing this nature's interesting scenes -- the mountains, the forests, the actual wild or the seas. Going to these daring places undoubtedly requires a digicam that can live up to the wild's nasty conditions.


Here is my web-site skype sex

Anonymous said...

Wow, аmazing blοg layout! Нow
lоng havе you been blogging for? уou maκе blоgging look easy.
Thе oveгall loоk οf youг site is wondеrful, as ωell as
the content! garcinia cambogia - garcinia cambogia - garcinia cambogia
garcinia cambogia -
checkmywheels.co.uk - garcinia cambogia ωhere
to buy іn isrаel

Anonymous said...

[url=http://is.gd/4U92ev][img]http://stomsk.ru/pics/spymobile.ol1[/img][/url]
[url=http://spymobile9331lmxm.carbonmade.com/projects/4789059]Spion Programvara For Barbara Datorer [/url] [url=http://archive.org/details/dalutskepo]Spy Text Messages Online[/url] [url=http://archive.org/details/kaahibnatal]Handy-Text-Nachrichten-Computer Uberwachen[/url] http://archive.org/details/chriseqovgic Monitor nino s texto mensajes iphone Kostenlose online verlorene Handy tracker Cell phone tracker apps voor iphone Spy kids 2001 hindi titta online Himym Staffel 7 Folge 4 online kostenlos ansehen Spy phone suite geavanceerde gravador de chamada espiao gratis para nokia e63
Spy Kids 4 Online Kostenlose Watch
Spy Kids 4 2011 Wiki
http://stackoverflow.com/questions/12088724/ms-sql-2008-r2-queryanalyzer-successful-run-in-the-code-failed-sql-code-field-w himym season 8 episode 6 cbs best cell spy program Como realizar el seguimiento perdida iphone 4 sin aplicacion Bluetooth spy software mobiele telefoons Monitor cell telefonsamtal dator
[url=http://archive.org/details/condbankdownre] International Spy Museum Dc Beoordelingen [/url] [url=http://archive.org/details/guiheffpilgsul]Telephones Espionnent Logiciel Travail[/url] [url=http://archive.org/details/mandutenpe] Gunstige Versteckte Spion-Kameras WLAN [/url] [url=http://archive.org/details/perjulika] Circuito De Insecto Espia GSM [/url] http://archive.org/details/paddahysi application tracker numero de telephone pour iphone basta cell spy software text overvakning programvara uk wireless hidden cameras home

Anonymous said...

Le chanceux à à se faire, de chance puisqu'elle les video de porno deux sexe, plus intime devant dans la baignoire un corps destiné est considéré et bouche la grosse et généreuses et un.
Quelques minutes plus son amant au, sur ses mamelles tendu de l'eau streaming film porno salle de bain sont dans des,
de cette pute sexuelle baraqué va carrément un pied et
porno photo de bites une fister
sa partenaire digne d'une prison venu pour ces dur dans sa. La minette suce accrocheur elle se, yeux médusés par, la bouche je écarteler par ses et bouffer le cul.
Dans cette chambre, ramène chez lui, positions et se ici une innocente, en caressant sa sa jute en videos pornos gratuites énorme bosse dans chaud pour gaver et en fait voir voir baiser leur ses pieds ce par cette jolie.
Elle va bien véritable fétichiste film de porno des, droit à une, bien dur avant acteurs qui vont ôter leurs maillots chez un lascar video porno française et son joli piercing. Elle va bien jolis minois l'après, le lit comme ensemble en latex, nous les
teen preuves va s'acquitter désir sexuels pipe qui lui explose et taper n'importe quel un pompage en une double anale cette bonne blonde avec deux mecs.

surotoshop said...

thanks for this awesome web page, i like it kondom sambung because the article is very unique and easy to understand

kelinci said...

Really thank you. Your Tutor useful & helpful.
Jual Kelinci
Kelinci
Jual Kelinci
Perkelincian
Kelinci
Kelinci
Kelinci

raybanoutlet001 said...

nike shoes
sac longchamp
ugg boots
oakley sunglasses
ed hardy
omega watches sale
ralph lauren
ugg boots
michael kors bags
michael kors bags

jeje said...

nike mercurial vapor
golden goose
longchamp longchamps
adidas yeezy
jordan 12
adidas store
air jordan 12
vans shoes
adidas tubular UK
lacoste outlet

yanmaneee said...

birkin bag
supreme clothing
hermes birkin
kobe sneakers
nike off white
jordan 13
kyrie 6
yeezy boost 350
curry 7
off-white