Solved

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

Posted on 2011-03-01
4
1,172 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
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 76

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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

860 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