Oracle Remote Diagnostics Agent (RDA) utility

Oracle Remote Diagnostics Agent (RDA) utility:::

In this article we are going to learn how to generate Oracle Remote Diagnostics Agent (RDA) Report.



  Overview:

This article is a comprehensive guide for the generation of Oracle Remote Diagnostics Agent (RDA) Report.

Please do keep in mind that, this article should not be considered a substitution of the official guide from Oracle (http://www.oracle.com).

RDA (Remote Diagnostics Agent) utility and its documentation can be downloaded from Oracle Support (Metalink) website (Doc ID: 314422.1) .

 Steps and Commands:

	UNIX / LINUX	WINDOWS
Unzip Files	use Unix/Linux utility	use any Windows utility
Instructions	README_Unix.txt/README_Linux.txt	README_Windows.txt
Verify Installation	rda.sh -cv	rda.cmd -cv
Run Setup	rda.sh -S or rda.pl -S	rda.cmd -S or rda.pl -S
Run RDA	rda.sh -v or rda.pl -v	rda.cmd -v
To view RDA	Open RDA_INDEX.htm from the RDA output directory

Connection to Database:

Open command prompt.

cmd> set ORACLE_SID=mydb
cmd> sqlplus / as sysdba

And you will be connected to the database.

For all the screenshots, please visit the following link::  http://www.sensehaze.com/mydata/resources_section/perf_tune/rda/index.php

Oracle Remote Diagnostic Agent (RDA) Report Generation:

Note: I am generating RDA Report on Windows for this article.

Unzip Files:

Unzip the downloaded RDA Utility to a directory ( Here E:/rda ).

Read Instructions:

Go to the directory, where we have unzipped the files and we can read the instructions given in the "Readme_O/S.txt" file.

Verify Installation:

Open command prompt and navigate to the RDA directory.

cmd> rda.cmd -cv

Run Setup:

Open command prompt and navigate to the RDA directory.

cmd> rda.cmd -S

 The script continues on for many more pages as part of the configuration. Choose the options according to your Report need.

Run RDA:

Open command prompt and navigate to the RDA directory.

cmd> rda.cmd -v

View RDA Report:

Open "RDA__index.htm" from the RDA output directory to view the report.

Our RDA Report has been generated.

For all the screenshots, please visit the following link::  http://www.sensehaze.com/mydata/resources_section/perf_tune/rda/index.php

Upgrade Oracle Database 11g R1 to Oracle Database 11g R2

Upgrade Oracle Database 11g R1 to Oracle Database 11g R2::


In this article we are going to learn how to Upgrade Oracle Database 11g R1 (11.1.0.7.0) to Oracle Database 11g R2 (11.2.0.1.0).


Overview:

This article is a comprehensive guide for the Upgradation of Oracle Database 11g R1 (11.1.0.7.0) to Oracle Database 11g R2 (11.2.0.1.0).

Please do keep in mind that, this article should not be considered a substitution of the official installation guide and release note from Oracle (http://www.oracle.com).

The below mentioned link can be used to download the official guide for the Upgradation of Oracle Database 11g R1 (11.1.0.7.0) to Oracle Database 11g R2 (11.2.0.1.0).

http://docs.oracle.com/cd/B28359_01/install.111/b32305/toc.htm

Objective of the Article:

By the time we finish this article, we should be able to understand the following:

(1)Installation of oracle database (11.1.0.7.0) x64 on Windows 64bit

(2)Configuration of Oracle Net listener(http://download.oracle.com/docs/cd/E11882_01/network.112/e10836/listenercfg.htm

(3)Installation of oracle database (11.2.0.1.0) x64 on Windows 64bit

(4)Upgradation of Oracle Database 11g R1 (11.1.0.7.0) to Oracle Database 11g R2 (11.2.0.1.0).

Names and Values Used:

	Database	Target Database
Name	mydb	mydb
Version	11.1.0.7.0	11.2.0.1.0
Oracle Home	E:\app\admin\product\11.1.0\db_1	E:\app\admin\product\11.2.0\db_1

For all the screenshots, please visit the website::: upgradation of oracle database from 11g R1 to 11g R2

Download Oracle Database Software:

First we have to download the required Oracle Database software packages from the Oracle Technology Network (OTN) or Oracle Edelivery Site and then extract the Oracle Database software packages.

Download the Oracle Database 11g Release 2 (11.2.0.1.0) Software for Windows x64 Operating System Environment.

Link for downloading oracle Database Software Package::
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Installation of Oracle Database:

New Oracle Home (11.2.0.1.0) -- E:\app\admin\product\11.2.0\db_1

Go to the extracted folder of Oracle Database Software package downloaded in the previous step. Go inside the “database” named directory and you will find “setup.exe” there.

Launch “setup.exe” to begin your installation.

Install Oracle Database 11.2.0.1.0 with "Software Only" option. You can follow the below mentioned link to install the software:
Installation of Oracle Database 11g R2 on Windows 

Start 11.1.0.7 database:

Open command prompt.

cmd> set ORACLE_SID=mydb
cmd> sqlplus / as sysdba

And you will be connected to the database.

 For all the screenshots, please visit the website::: upgradation of oracle database from 11g R1 to 11g R2

Listener Creation:

Stop the "old listener" and run "netca" from the "new home".

Open command prompt and run “netca” from the new home

Copy tnsnames.ora from old home to new home and make necessary changes if required, or we can create it here also.

If you want to create new "tnsnames" file then , run "netca" again.

Open command prompt and type "netca" .
Select "Local Net Service Name Configuration" and click "Next".





Run utlu112i.sql:

Copy the "utlu112i.sql" from new "Oracle_Home" to any "temprary directory" or to the "old Oracle_home". I copied the "utlu112i.sql" to the old home.

Connect to the database and run "utlu112i.sql" from the old home to check whether all the prereqs have matched.

Adjust the warnings / errors shown by Pre-Upgrade Information tool.

Upgrade from 11.1.0.7.0 to 11.2.0.1.0:

Execute the "DBUA" from new "Oracle_Home" (11.2.0.1.0).

cmd> dbua

 For all the screenshots, please visit the website::: upgradation of oracle database from 11g R1 to 11g R2

Connection to Database:

Open command prompt.

cmd> set ORACLE_SID=mydb
cmd> sqlplus / as sysdba

And you will be connected to the database.

 Congrats Our database is upgraded.

For all the screenshots, please visit the website::: upgradation of oracle database from 11g R1 to 11g R2

 

Oracle Database 11gR1 64bit installation on Windows7 x64

 Oracle Database 11gR1 64bit installation on Windows7 x64::

In this article we are going to learn how to install oracle database 11gR1 64 bit (11.1.0.7.0) on Windows 7.


Download Oracle Database Software:

First we have to download the required Oracle Database software packages from the Oracle Technology Network (OTN) or Oracle Edelivery Site and then extract the Oracle Database Software packages.

Download the Oracle Database 11g Release 1 (11.1.0.7.0) Software for Windows x64 Operating System Environment.

Link for downloading oracle Database Software Package::
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Installation of Oracle Database:

Go to the extracted folder of Oracle Database Software package downloaded in the previous step. Go inside the “database” named directory and you will find “setup.exe” there.

Launch “setup.exe” to begin your installation.

 For all the screenshots , Please visit the link:::  http://www.sensehaze.com/mydata/resources_section/installation/win_1117_64/index.php

Listener Creation:

Open command prompt and type “netca” as shown in the below screen:

Type the command “netca”.

Database Creation:

Type "dbca" on the command prompt:

Local Net Service Name Configuration:

Open command prompt and type "netca" .

 Select "Local Net Service Name Configuration" and click "Next".

For all the screenshots , Please visit the link:::  http://www.sensehaze.com/mydata/resources_section/installation/win_1117_64/index.php