Solved

Need a checklist for pre and post installation of Oracle 11g on Windows server 2008

Posted on 2011-03-01
4
1,182 Views
Last Modified: 2012-06-21
Hi Guys,

Currently I need a checklist as mentioned in title above. Hope you guys can share with me the installation and tuning procedures.

-titanium0203
0
Comment
Question by:titanium0203
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 13

Expert Comment

by:riazpk
ID: 35014371
Did you checked the Installation guide?

Oracle® Database Installation Guide
11g Release 2 (11.2) for Microsoft Windows

http://download.oracle.com/docs/cd/E11882_01/install.112/e16773/toc.htm

Are you talking about database tuning or SQL tuning?
0
 

Author Comment

by:titanium0203
ID: 35014839
riazpk,

database tuning. If possible I want to increase the sga,pga etc so that
this database will not facing any performance problems. This Database is for
transaction process and it is a stand alone server no ASM.
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35016215
read this from oracle open world :oracle on win performance best practices

http://www.oracle.com/technetwork/topics/dotnet/tech-info/ow2010-windowsdb-performance-177304.pdf
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 125 total points
ID: 35016862
People make entire careers out of tuning Oracle.  These types of questions are really hard to answer in a forum like Experts-Exchange.  So much of it depends on your specific setup.

In a nutshell:
step1: document the existing performance issues.
step2: analyze what is causing them
step3: make changes you feel might solve these specific problems.
step4: monitor to see if those issues were resolved and no new ones were introduced
step5: repeat often

If you are licensed for the Diagnostics and/or Performance packs you can run AWR ADDM reports over time.  Starting with 11g the performance advisors are pretty good and making accurate recommendations.

0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to recover a database from a user managed backup

726 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