Saturday, April 16, 2011

Where is my alert log file in 11g??



Alert log file in oracle database 11g has been put in a separate folder known as "diag"..


Type the below command from sqlplus prompt to get the desired location:


SQL> select value from v$parameter where name ='user_dump_dest';


VALUE
---------------------------------------------------------------------


d:\oracle\diag\rdbms\noida\noida\trace 


Above  is the location where you can find your alert log file:


where noida is the name of the instance.


enjoy:-)

23 comments:

Anonymous said...

This is the perfect website for anybody who wants to find out
about this topic. You understand a whole lot its almost tough to argue with you (not that I personally would want to…HaHa).
You certainly put a brand new spin on a subject that has been written about for
ages. Great stuff, just wonderful!

Have a look at my webpage - password hacking software

Anonymous said...

Have you ever considered writing an e-book or guest authoring on other websites?
I have a blog based upon on the same topics you discuss and would really like to have you share some stories/information.
I know my viewers would value your work. If you're even remotely interested, feel free to send me an e-mail.

my weblog sharecash surveys

Anonymous said...

This is really interesting, You're a very skilled blogger. I've joined your feed and look forward to seeking more of your wonderful post.
Also, I have shared your web site in my social networks!


Look at my blog post ... Tube downloader

Anonymous said...

I will right away grasp your rss feed as I can't in finding your e-mail subscription link or newsletter service. Do you have any? Kindly allow me recognize in order that I may subscribe. Thanks.

Also visit my weblog :: 1.6 Hack

Anonymous said...

Very interesting points you have remarked, thanks for posting
. "Without courage, wisdom bears no fruit." by Baltasar Gracian.


my weblog :: twitter password

Anonymous said...

I have been browsing online more than three hours these days, but
I never found any interesting article like yours. It's lovely value enough for me. Personally, if all webmasters and bloggers made just right content as you did, the web might be much more useful than ever before.

my web blog :: hack a twitter

Anonymous said...

It's awesome to visit this web site and reading the views of all friends concerning this piece of writing, while I am also eager of getting knowledge.

Also visit my web blog: software sms

Anonymous said...

I will immediately grasp your rss as I can't find your e-mail subscription hyperlink or e-newsletter service. Do you've any?
Kindly permit me understand in order that I could subscribe.

Thanks.

Feel free to visit my weblog psn card

Anonymous said...

No matter if some one searches for his required thing, so he/she desires to be available that in detail, thus
that thing is maintained over here.

My web page ... sms pc

Anonymous said...

you're truly a excellent webmaster. The site loading velocity is incredible. It seems that you are doing any unique trick. Furthermore, The contents are masterpiece. you've performed a fantastic
task on this subject!

Here is my web page :: dragonvale dragon

Anonymous said...

Hello there, You have done an excellent job.
I'll certainly digg it and in my view recommend to my friends. I am sure they will be benefited from this site.

Stop by my web blog HOW TO EARN EASY MONEY ONLINE

Anonymous said...

It's truly very complex in this full of activity life to listen news on TV, therefore I just use web for that reason, and obtain the hottest information.

Also visit my website :: earn money with

Anonymous said...

At this moment I am ready to do my breakfast, once having
my breakfast coming yet again to read additional news.



Feel free to surf to my web-site: minecraft premium account

Anonymous said...

Fantastic beat ! I wish to apprentice at the same time as you amend your site,
how can i subscribe for a blog site? The account helped me a acceptable deal.
I had been a little bit familiar of this your broadcast provided
shiny clear idea

Also visit my homepage - Earn money simply for your opinions

Anonymous said...

I was recommended this blog by my cousin. I'm not sure whether this post is written by him as no one else know such detailed about my problem. You're wonderful!

Thanks!

My web site :: mass sender

Anonymous said...

Hi there to all, how is the whole thing, I think every one is
getting more from this site, and your views are nice designed
for new viewers.

Feel free to surf to my page castleville cheats

Anonymous said...

finasteride 5mg buy propecia singapore - what is the cost of using propecia

Anonymous said...

Hi there, You have done a great job. I will certainly digg it and personally recommend to
my friends. I'm confident they'll be benefited from this website.


Also visit my blog car town blue points

Anonymous said...

If you want a Premium Minecraft Account check out this generator.
With it you can generate a unique Minecraft Premium Account which no one else has!
You can Download the Free Premium Minecraft Account Generator http://www.
minecraftdownload2013.tk

Greetings I am so thrilled I found your webpage, I really found you by error,
while I was searching on Digg for something else, Nonetheless I
am here now and would just like to say cheers for a remarkable
post and a all round entertaining blog (I also love the theme/design), I don't have time to read through it all at the moment but I have bookmarked it and also included your RSS feeds, so when I have time I will be back to read much more, Please do keep up the fantastic work.

Anonymous said...

Way cool! Some extremely valid points! I appreciate you penning this write-up plus the
rest of the website is also very good.

Here is my webpage; download soundcloud

Anonymous said...

If you are going for most excellent contents like I do,
just pay a quick visit this web page daily since it gives quality contents, thanks

my web-site :: sharecash

Zheng junxai5 said...

zhengjx20160428
michael kors outlet
oakley sunglasses wholesale
kate spade outlet
ray ban sunglasses
timberlands
nike sb janoski
coach outlet online
michael kors outlet
tory burch shoes
kobe shoes
hollister kids
mont blanc pen
jordan retro 4
coach factory outlet online
michael kors bags
retro 11
oakley sunglasses wholesale
nike air max uk
true religion outlet store
adidas uk
michael kors bags
ray ban sunglasses uk
michael kors outlet clearance
louis vuitton handbags
gucci outlet
adidas wings
coach outlet store online
michael kors outlet online
coach outlet
tory burch boots
louis vuitton outlet
michael kors
michael kors outlet
christian louboutin sale
nike roshe one
lebron 12
longchamp handbags
coach outlet store online

raybanoutlet001 said...

kate spade outlet
ugg boots
jordan shoes
coach outlet
michael kors handbags
michael kors uk
christian louboutin shoes
ugg boots
saics running shoes
nike outlet