Vyoms OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
Bookmark and Share Rss Feeds

Measuring Storage Performance For Oracle Systems | Articles | Recent Articles | News Article | Interesting Articles | Technology Articles | Articles On Education | Articles On Corporate | Company Articles | College Articles | Articles on Recession
Sponsored Ads
Hot Jobs
Fresher Jobs
Experienced Jobs
Government Jobs
Walkin Jobs
Placement Section
Company Profiles
Interview Questions
Placement Papers
Resources @ VYOMS
Companies In India
Consultants In India
Colleges In India
Exams In India
Latest Results
Notifications In India
Call Centers In India
Training Institutes In India
Job Communities In India
Courses In India
Jobs by Keyskills
Jobs by Functional Areas
Learn @ VYOMS
GATE Preparation
GRE Preparation
GMAT Preparation
IAS Preparation
SAP Preparation
Testing Preparation
MBA Preparation
News @ VYOMS
Freshers News
Job Articles
Latest News
India News Network
Interview Ebook
Get 30,000+ Interview Questions & Answers in an eBook.
Interview Success Kit - Get Success in Job Interviews
  • 30,000+ Interview Questions
  • Most Questions Answered
  • 5 FREE Bonuses
  • Free Upgrades

VYOMS TOP EMPLOYERS

Wipro Technologies
Tata Consultancy Services
Accenture
IBM
Satyam
Genpact
Cognizant Technologies

Home » Articles » Measuring Storage Performance For Oracle Systems

Measuring Storage Performance For Oracle Systems








Article Posted On Date : Wednesday, September 8, 2010


Measuring Storage Performance For Oracle Systems
Advertisements

OS Installation

Install Oracle Enterprise Linux (OEL) 5.5 in the same way you would for a regular Oracle Database installation. You can see an example of this type of installation here.

During this installation I used a virtual machine with 6G RAM and 100G disk space. The swap size was set at 8G and the firewall and SELinux were disabled.

Java Installation

Install Java JDK 6u18 using the following commands as the "root" user. Later version of the JDK cause errors when patching WebLogic (unless you are using a proxy), so the version of the JDK is very important.
# chmod u+x jdk-6u18-linux-x64-rpm.bin
# ./jdk-6u18-linux-x64-rpm.bin

Database Installation

Unlike previous Grid Control installations, the database is no longer bundled, so we must install the database software separately. To accomplish this I followed the Oracle Database 11g Release 2 installation instructions here.

In addition to the packages listed in the DB installation, the following packages must be installed as the "root" user for WebLogic and the Grid Control to install correctly.
# From Enterprise Linux 5 DVD
cd /media/cdrom/Server
rpm -Uvh compat-db-4*
rpm -Uvh compat-libstdc++-296*
rpm -Uvh rng-utils-2*
rpm -Uvh setarch-2*
cd /
eject
If you have performed a default installation you will need to deconfigure Enterprise Manager Database Control. Run the following command as the "oracle" user.
$ emca -deconfig dbcontrol db -repos drop -SYS_PWD <sys pasword> -SYSMAN_PWD <sysman password>
Make the following initialization parameter changes.
sqlplus / AS SYSDBA

ALTER SYSTEM SET log_buffer=10485760 SCOPE=SPFILE;
ALTER SYSTEM SET processes=500 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
If you have done a default installation as described here, the UNDO tablespace will be autoextensible. If you have done a custom installation make sure the UNDO tablespace is at least 200M in size.

Next we must install the latest version of the "opatch" utility.
$ cd /host/software/oracle/GridControl/db_patches
$ unzip -d $ORACLE_HOME p6880880_112000_Linux-x86-64.zip
The documentation states that patches for database bugs 9002336 and 9067282 must be applied. Patch 9002336 has a prerequisite of patch 9352237 (a PSU), which includes patch 9067282, so I have only applied patches 9352237 and 9002336, which can be downloaded from My Oracle Support. The database patches include installation instructions, but to summarize, these commands should be run as the "oracle" user.
$ dbshut $ORACLE_HOME
$ export PATH=$PATH:$ORACLE_HOME/OPatch
$ cd /host/software/oracle/GridControl/db_patches

$ unzip p9352237_112010_Linux-x86-64.zip
$ cd 9352237
$ opatch apply
$ cd ..

$ unzip p9002336_112011_Linux-x86-64.zip
$ cd 9002336
$ opatch apply
$ cd ..

$ dbstart $ORACLE_HOME
The database installation is now complete.

Middleware Installation

Grid Control 11g Release 1 no longer bundles the middleware components, so we must install the WebLogic Server before we can proceed with the Grid Control installation. The installation is started with the following command, run as the "oracle" user.
$ cd /host/software/oracle/WebLogic
$ java -jar wls1032_generic.jar
Click the "Next" button on the welcome screen.

WLS Welcome

Enter "/u01/app/oracle/Middleware" as the "Middleware Home Directory" and click the "Next" button.

WLS Choose Middleware Home Directory

Enter your Oracle Support details, or uncheck the checkbox and click the "Next" button.

WLS Register For Security Updates

If a warning dialog appears, click the "Yes" button, followed by the "Next" button from the previous screen.

WLS Register For Security Updates Warning

Accept the "Typical" installation by clicking the "Next" button.

WLS Choose Install Type

Accept the default JDK by clicking the "Next" button.

WLS JDK Selection

Accept the default "Product Installation Directories" by clicking the "Next" button.

WLS Choose Product Installation Directories

Click the "Next" button on the summary "Installation Summary" screen.

WLS Installation Summary

Wait while the installation takes place.

WLS Installation

Uncheck the "Run Quickstart" checkbox and click the "Done" button.

WLS Installation Complete

Next we must apply the "WDJ7" patch to the installation by running the Smart Update utility.
$ /u01/app/oracle/Middleware/utils/bsu/bsu.sh
Update the patch client by clicking the "OK" button on the message dialog.

BSU Update required

Enter your support crednetials, then click the "Login" button.

BSU Support Credentials

If you have chosen not to be updated with security information you may have to cycle through the warning message several times, but it will eventually continue. On Smart Update screen, click the "Get Patches" tab, select the "WDJ7" patch and click the "Download Selected" button and the "OK" button on the subsequent dialog.

BSU Get Patches

Click on the "Manage Patches" tab and click on the "Apply" button next to the "WDJ7" patch. Click "OK" on the subsequent validation dialog.

BSU Manage Patches

The patches are now listed under the "Default" tab.

BSU Manage Patches

Exit the Smart Update dialog, and the subsequent available maintenance screen if it appears.

BSU Available Maintenance

Grid Control Installation

Unzip the Grid control software into an empty directory.
$ /host/software/oracle/GridControl/11.1.0.1.0
$ unzip GridControl_11.1.0.1.0_Linux_x86-64_1of3.zip
$ unzip GridControl_11.1.0.1.0_Linux_x86-64_2of3.zip
$ unzip GridControl_11.1.0.1.0_Linux_x86-64_3of3.zip
Start the installer as the "oracle" user.
$ ./runInstaller
Enter your support details, or uncheck the notification checkbox, then click the "Next" button. Click the "Yes" button on any subsequent warning dialogs.

GC My Oracle Support Details

Select the "Download and install updates from My Oracle Support" option and enter your support details, then click the "Next" button.

GC Check For Updates

Wait while the check is performed, then click the "Download Updates" button on the subsequent dialog and wait for the updates to be downloaded.

GC New Updates Found

Accept the default "Apply Software Updates" option by clicking the "Next" button.

GC Product Updates

Accept the default "Install a new Enterprise Manager system" option by clicking the "Next" button.

GC Select Installation Type

Wait while the prerequisite checks are performed. If any fail, correct them before proceeding by clicking the "Next" button.

GC Check Prerequisites

Enter "/u01/app/oracle/Middleware/oms11g" as the OMS instance base location, then click the "Next" button.

GC Specify Install Locations

Enter password for the WebLogic domain and node manager users, then click the "Next" button.

GC Create WebLogic Server Domain

Enter the database connection details and click the "Next" button.

GC Connect to Oracle Database

Enter password details for the "SYSMAN" database user and click the "Next" button.

GC Configure Oracle Management Repository

Enter the password for secure agent connections, then click the "Next" button.

GC Secure Oracle Management Service

Amend the ports as you see fit, then click the "Next" button.

GC Customize Ports

If you are happy with the information on the "Review" screen, click the "Next" button.

GC Review

Wait while the installation takes place.

GC Installation Progress Details

Run the specified script, then click the "OK" button.

GC Execute Configuration Scripts

Wait while the configuration steps take place.

GC Installation Progress Details

Make a note of the URLs on the "Finish" screen, then click the "Close" button.

GC Finish

Connect to the Grid Control console (https://grid11g.localdomain:7799/em) using the username (SYSMAN) and password defined during the installation, accept the license agreement and you are presented with the console.

GC Console

Startup/Shutdown

Use the following commands to turn on all components installed by this article.
#!/bin/bash
export OMS_HOME=/u01/app/oracle/Middleware/oms11g
export AGENT_HOME=/u01/app/oracle/Middleware/agent11g

# Start everything
dbstart $ORACLE_HOME

$OMS_HOME/bin/emctl start oms

$AGENT_HOME/bin/emctl start agent
Use the following commands to turn off all components installed by this article.
#!/bin/bash
export OMS_HOME=/u01/app/oracle/Middleware/oms11g
export AGENT_HOME=/u01/app/oracle/Middleware/agent11g

# Stop everything
$OMS_HOME/bin/emctl stop oms -all

$AGENT_HOME/bin/emctl stop agent

dbshut $ORACLE_HOME






Sponsored Ads



Interview Questions
HR Interview Questions
Testing Interview Questions
SAP Interview Questions
Business Intelligence Interview Questions
Call Center Interview Questions

Databases

Clipper Interview Questions
DBA Interview Questions
Firebird Interview Questions
Hierarchical Interview Questions
Informix Interview Questions
Microsoft Access Interview Questions
MS SqlServer Interview Questions
MYSQL Interview Questions
Network Interview Questions
Object Relational Interview Questions
PL/SQL Interview Questions
PostgreSQL Interview Questions
Progress Interview Questions
Relational Interview Questions
SQL Interview Questions
SQL Server Interview Questions
Stored Procedures Interview Questions
Sybase Interview Questions
Teradata Interview Questions

Microsof Technologies

.Net Database Interview Questions
.Net Deployement Interview Questions
ADO.NET Interview Questions
ADO.NET 2.0 Interview Questions
Architecture Interview Questions
ASP Interview Questions
ASP.NET Interview Questions
ASP.NET 2.0 Interview Questions
C# Interview Questions
Csharp Interview Questions
DataGrid Interview Questions
DotNet Interview Questions
Microsoft Basics Interview Questions
Microsoft.NET Interview Questions
Microsoft.NET 2.0 Interview Questions
Share Point Interview Questions
Silverlight Interview Questions
VB.NET Interview Questions
VC++ Interview Questions
Visual Basic Interview Questions

Java / J2EE

Applet Interview Questions
Core Java Interview Questions
Eclipse Interview Questions
EJB Interview Questions
Hibernate Interview Questions
J2ME Interview Questions
J2SE Interview Questions
Java Interview Questions
Java Beans Interview Questions
Java Patterns Interview Questions
Java Security Interview Questions
Java Swing Interview Questions
JBOSS Interview Questions
JDBC Interview Questions
JMS Interview Questions
JSF Interview Questions
JSP Interview Questions
RMI Interview Questions
Servlet Interview Questions
Socket Programming Interview Questions
Springs Interview Questions
Struts Interview Questions
Web Sphere Interview Questions

Programming Languages

C Interview Questions
C++ Interview Questions
CGI Interview Questions
Delphi Interview Questions
Fortran Interview Questions
ILU Interview Questions
LISP Interview Questions
Pascal Interview Questions
Perl Interview Questions
PHP Interview Questions
Ruby Interview Questions
Signature Interview Questions
UML Interview Questions
VBA Interview Questions
Windows Interview Questions
Mainframe Interview Questions


Copyright © 2001-2022 Vyoms.com. All Rights Reserved. Home | About Us | Advertise With Vyoms.com | Jobs | Contact Us | Feedback | Link to Us | Privacy Policy | Terms & Conditions
Placement Papers | Get Your Free Website | IAS Preparation | C++ Interview Questions | C Interview Questions | Report a Bug | Romantic Shayari | CAT 2022

Fresher Jobs | Experienced Jobs | Government Jobs | Walkin Jobs | Company Profiles | Interview Questions | Placement Papers | Companies In India | Consultants In India | Colleges In India | Exams In India | Latest Results | Notifications In India | Call Centers In India | Training Institutes In India | Job Communities In India | Courses In India | Jobs by Keyskills | Jobs by Functional Areas

Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes

Gate Articles | Gate Books | Gate Colleges | Gate Downloads | Gate Faqs | Gate Jobs | Gate News | Gate Sample Papers | Gate Training Institutes

MBA Articles | MBA Books | MBA Case Studies | MBA Business Schools | MBA Current Affairs | MBA Downloads | MBA Events | MBA Notifications | MBA FAQs | MBA Jobs
MBA Job Consultants | MBA News | MBA Results | MBA Courses | MBA Sample Papers | MBA Interview Questions | MBA Training Institutes

GRE Articles | GRE Books | GRE Colleges | GRE Downloads | GRE Events | GRE FAQs | GRE News | GRE Training Institutes | GRE Sample Papers

IAS Articles | IAS Books | IAS Current Affairs | IAS Downloads | IAS Events | IAS FAQs | IAS News | IAS Notifications | IAS UPSC Jobs | IAS Previous Question Papers
IAS Results | IAS Sample Papers | IAS Interview Questions | IAS Training Institutes | IAS Toppers Interview

SAP Articles | SAP Books | SAP Certifications | SAP Companies | SAP Study Materials | SAP Events | SAP FAQs | SAP Jobs | SAP Job Consultants
SAP Links | SAP News | SAP Sample Papers | SAP Interview Questions | SAP Training Institutes |


Copyright ©2001-2022 Vyoms.com, All Rights Reserved.
Disclaimer: VYOMS.com has taken all reasonable steps to ensure that information on this site is authentic. Applicants are advised to research bonafides of advertisers independently. VYOMS.com shall not have any responsibility in this regard.