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

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

5689 said...

zzzzz2018.8.31
off white jordan 1
polo ralph lauren outlet
pandora jewelry
nba jerseys
golden goose
ralph lauren outlet
pandora
mlb jerseys
pandora
pandora jewelry