Gavinsoorma.com



Purpose:

This note describes the steps taken to upgrade an existing 10.2.0.5 Enterprise Manager Grid Control environment hosted on Red Hat Linux 5.5 to Enterprise Manager 11g (11.1.

The upgrade of the 10.2.0.5 OEM broadly involves the following steps

• Install the Oracle 11g Release 2 database software. This will be used for the repository database.

• Install Oracle 11g Release 1 WebLogic Server

• Upgrade the 10.2.0.5 repository database to 11g Release 2

• Install the 11g OEM Grid Control software and upgrade Management Server (OMS) from 10g to 11g.

• Upgrade existing 10g management agents to 11g

The following tasks can be performed while the 10g Grid Control environment is up and running.

• Install the Oracle Database Software – 11g Release 2

• Install the Oracle 11g WebLogic Server (10.3.2)

• Install the Java Runtime Environment 1.6 Update 18

Prepare the 10g EM Repository Database for the upgrade to Oracle 11g Release 2

Note that 11g Grid Control is also supported on a 10.2.0.5 repository database. But we are also upgrading the repository database to 11g.

Also, EM Grid Control on 10.2.0.5 supports having a 11g Release 2 repository database.

Shutdown the 10.2.0.5 EM environment:

• Stop grid control oms, agent, opmn via emctl stop oms, opmnctl stopall and emctl stop agent

• Shutdown immediate repository database

• Take a backup of the 10g database before the upgrade

• Stop 10g listener

• Create a 11g listener via NETCA

• Started 10g database after backup

• Launch 11g dbua from 11g R2 Oracle Home

Oracle 11g Release 2 Software Installation

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

Install JRE 1.6 Update 18

[root@db2poc01 stage]# ./jdk-6u18-linux-x64-rpm.bin

Do you agree to the above license terms? [yes or no]

yes

Unpacking...

Checksumming...

Extracting...

UnZipSFX 5.50 of 17 February 2002, by Info-ZIP (Zip-Bugs@lists.wku.edu).

inflating: jdk-6u18-linux-amd64.rpm

inflating: sun-javadb-common-10.5.3-0.2.i386.rpm

inflating: sun-javadb-core-10.5.3-0.2.i386.rpm

inflating: sun-javadb-client-10.5.3-0.2.i386.rpm

inflating: sun-javadb-demo-10.5.3-0.2.i386.rpm

inflating: sun-javadb-docs-10.5.3-0.2.i386.rpm

inflating: sun-javadb-javadoc-10.5.3-0.2.i386.rpm

Preparing... ########################################### [100%]

1:jdk ########################################### [100%]

Unpacking JAR files...

rt.jar...

jsse.jar...

charsets.jar...

tools.jar...

localedata.jar...

plugin.jar...

javaws.jar...

deploy.jar...

Installing JavaDB

Preparing... ########################################### [100%]

1:sun-javadb-common ########################################### [ 17%]

2:sun-javadb-core ########################################### [ 33%]

3:sun-javadb-client ########################################### [ 50%]

4:sun-javadb-demo ########################################### [ 67%]

5:sun-javadb-docs ########################################### [ 83%]

6:sun-javadb-javadoc ########################################### [100%]

Java(TM) SE Development Kit 6 successfully installed.

Product Registration is FREE and includes many benefits:

* Notification of new versions, patches, and updates

* Special offers on Sun products, services and training

* Access to early releases and documentation

Product and system data will be collected. If your configuration

supports a browser, the Sun Product Registration form for

the JDK will be presented. If you do not register, none of

this information will be saved. You may also register your

JDK later by opening the register.html file (located in

the JDK installation directory) in a browser.

For more information on what data Registration collects and

how it is managed and used, see:



Press Enter to continue.....

[root@db2poc01 stage]# which java

/usr/bin/java

[root@db2poc01 stage]# cd /usr/bin

[root@db2poc01 bin]# ./java -version

java version "1.6.0_18"

Java(TM) SE Runtime Environment (build 1.6.0_18-b07)

Java HotSpot(TM) 64-Bit Server VM (build 16.0-b13, mixed mode)

Install WebLogic 10.3.2

[oracle@db2poc01 stage]$ chmod +x wls1032_linux32.bin

[oracle@db2poc01 stage]$

[oracle@db2poc01 stage]$ ./wls1032_linux32.bin

Extracting 0%..........

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

Upgrading the 10g repository database to 11gR2 using DBUA

[pic]

[pic]

[pic]

[pic]

[oracle@db2poc01 ~]$ sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Wed May 11 10:13:59 2011

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Enter password:

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> purge dba_recyclebin;

DBA Recyclebin purged.

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

After database is upgraded to 11g R2, test and see if the 10.2.0.5 Grid Control environment is working as we can run 10.2.0.5 OEM with 11g R2 repository database

[oracle@db2poc01 bin]$ . oraenv

ORACLE_SID = [GRIDPD] ?

[

[oracle@db2poc01 bin]$ echo $ORACLE_HOME

/data/app/oracle/product/11.2.0/dbhome_1

[oracle@db2poc01 bin]$ sqlplus sysman/oracle10g@gridpd

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 11 10:53:35 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@db2poc01 bin]$ ./emctl start oms

Oracle Enterprise Manager 10g Release 5 Grid Control

Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.

opmnctl: opmn started

Starting HTTP Server ...

Starting Oracle Management Server ...

Checking Oracle Management Server Status ...

Oracle Management Server is Up.

[oracle@db2poc01 bin]$ ./opmnctl startall

opmnctl: starting opmn and all managed processes...

[oracle@db2poc01 bin]$ ./opmnctl status

Processes in Instance: EnterpriseManager0.db2poc01..au

-------------------+--------------------+---------+---------

ias-component | process-type | pid | status

-------------------+--------------------+---------+---------

HTTP_Server | HTTP_Server | 22735 | Alive

LogLoader | logloaderd | N/A | Down

dcm-daemon | dcm-daemon | 22703 | Alive

OC4J | home | 23458 | Alive

OC4J | OC4J_EMPROV | 23459 | Alive

OC4J | OC4J_EM | 22787 | Alive

OC4J | OCMRepeater | 23460 | Alive

WebCache | WebCache | 23504 | Alive

WebCache | WebCacheAdmin | 23462 | Alive

DSA | DSA | N/A | Down

[oracle@db2poc01 bin]$ ./emctl start agent

Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.

Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.

Starting agent ............... started.

Update the configuration properties in the 10.2.0.5 OEM to change the Oracle Home location for the repository database which has been upgraded to 11g R2 as well as the listener which is now running from the 11g Oracle Home as well.

[pic]

[pic]

Note – the 11g OEM Grid Control uses an EXISTING database as the database repository , but we need to ensure that the following parameters have the minimum values.

• log_buffer needs to be minimum 10485760

session_cached_cursors should be 200 or higher

processes should be 500 or higher

open_cursors should be 300 or higher

• UNDO tablespace needs to be at least 200 MB in size.

SQL> alter system set compatible='10.2.0.5' scope=spfile;

System altered.

SQL> show parameter log_buffer

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

log_buffer integer 8560640

SQL> alter system set log_buffer=10485760 scope=spfile;

System altered.

SQL> show parameter session_cached_cursors

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

session_cached_cursors integer 200

SQL> show parameter processes

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

aq_tm_processes integer 1

db_writer_processes integer 1

gcs_server_processes integer 0

global_txn_processes integer 1

job_queue_processes integer 0

log_archive_max_processes integer 4

processes integer 150

SQL> alter system set processes=500 scope=spfile;

System altered.

SQL> show parameter open_cursors

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

open_cursors integer 300

Stop the 10.2.0.5 OEM Application Server components and the 10g EM Agent as well

[oracle@db2poc01 bin]$ ./emctl stop agent

Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.

Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.

Stopping agent ... stopped.

[oracle@db2poc01 bin]$ cd ../..

[oracle@db2poc01 oracle]$ cd oms10g/bin

[oracle@db2poc01 bin]$ ./emctl stop oms

Oracle Enterprise Manager 10g Release 5 Grid Control

Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.

Oracle Management Server is Down.

[oracle@db2poc01 bin]$ cd ..

[oracle@db2poc01 oms10g]$ cd opmn/bin

[oracle@db2poc01 bin]$ ./opmnctl stopall

opmnctl: stopping opmn and all managed processes.

.

Restart database so that the changed parameters take effect

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1252663296 bytes

Fixed Size 2212936 bytes

Variable Size 570428344 bytes

Database Buffers 654311424 bytes

Redo Buffers 25710592 bytes

Database mounted.

Database opened.

SQL>

11g Enterprise Manager Grid Control – Installation and Upgrade

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

SQL> grant execute on dbms_random to sysman;

Grant succeeded.

SQL> grant execute on dbms_random to dbsnmp;

Grant succeeded.

[pic]

[pic]

[pic]

[pic]

[pic]

[pic]

[root@db2poc01 oms11g]# ./allroot.sh

Starting to execute allroot.sh .........

Starting to execute /data/app/oracle/Middleware/oms11g/root.sh ......

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /data/app/oracle/Middleware/oms11g

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Adding entry to /etc/oratab file...

Finished execution of /data/app/oracle/Middleware/oms11g/root.sh ......

Starting to execute /data/app/oracle/Middleware/agent11g/root.sh ......

Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /data/app/oracle/Middleware/agent11g

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]:

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

Adding entry to /etc/oratab file...

Finished execution of /data/app/oracle/Middleware/agent11g/root.sh ......

[pic]

[pic]

[pic]

[pic]

Set the JOB_QUEUE_PROCESSES value back to its original value

SQL> alter system set job_queue_processes=10 scope=both;

System altered.

Upgrading the 10g Oracle Management Agent to 11g

Download the Linux_x86_64_Grid_Control_agent_download_11.1.0.1.0.zip file from the Oracle Technology Network (OTN)



a. Copy the Agent downloaded file to the Oracle home directory of the OMS

/sysman/agent_download/11.1.0.1.0

Note: If /sysman/agent_download/11.1.0.1.0 directory doesn't exist then create it manually.

b. Go to the Oracle home directory of the Oracle Management Service(OMS)

/sysman/agent_download/11.1.0.1.0

c. Run the following command to unzip the software

Linux_x86_64_Grid_Control_agent_download_11.1.0.1.0.zip

On the destination host where you want to upgrade the Management Agent, open a browser to access the OMS URL and download the script.



You will see the directory contents

There will be a file called agentDownload.linux

Cut and paste the contents of agentDownload.linux into a file with the same name and scp the file to the host on which you want to upgrade the agent.

We can also use the wget utlity:

wget

On the destination host run the agentDownload.linux script with the following parameters

./ agentDownload.linux –u –o -b

For example

./ agentDownload.linux –u –o /opt/oracle/agent10g -b /opt/oracle

You will need to provide the agent registration password to secure the agent

Issues

1) Need to apply the WebLogic patch WDJ7 via the Smart Update utility which requires the machine to be able to connect to the internet directly to download the patch.

We can also raise an SR with Oracle Support who will provide the patch as well as an attachment in the SR via Metalink

See the link for some screenshots of the patch download and installation.



2) Read this Metalink note:

After Upgrade to Grid Control 11g, EM Website shows status Down [ID 1187988.1]

References

•

•

•

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download