LSX-blog

Feed Rss

【原创】升级Enterprise Manager Grid Control (10.2.0.3.0) 到 (10.2.0.5.0)

08.11.2012, Linux, Oracle, by .

升级Enterprise Manager Grid Control (10.2.0.3.0) 到 (10.2.0.5.0)

一、概述

上一篇我们安装了10.2.0.3.0版本的EM管理器,这里我们来在它的基础之上升级到10.2.0.5.0,为什么升级呢,我在使用中发现,10.2.0.3.0.的邮件通知无法使用,到10.2.0.5.0才正常。

二、环境检查

1、Connect to the Database as sysdba and run the following query to determine whether the Partitioning Option is installed:

SQL> select value from v$option where parameter = ‘Partitioning’

The preceding query should result in VALUE=TRUE.

意思是:确实select 语句查询出来的值等于TRUE

2、Both the DBSNMP and SYSMAN users require the EXECUTE privilege on the DBMS_RANDOM package in the Repository Database. You must grant the privilege to both users as follows:

a. Log into the Repository Database as SYSDBA.

b. Run the following SQL commands:

SQL> grant execute on dbms_random to dbsnmp;

SQL> grant execute on dbms_random to sysman;

c. Verify that the query below does not return any invalid objects:

SQL> select object_name, object_type, owner from dba_objects where status=’INVALID’;

3、If the repository database is configured with the UTF8 character set, the value of NLS_LENGTH_SEMANTICS needs to be set to BYTE.

To check this in the database, run the following command:

SQL> SELECT value FROM nls_database_parameters WHERE parameter=’NLS_LENGTH_SEMANTICS’;

If the value is not set to BYTE, change it by running the following command:

SQL> ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=BYTE SCOPE=both;

4、Login in the Database as Sysman and remove the following job:

SQL> SELECT job FROM user_jobs WHERE

what=’MGMT_CNTR_TT.clean_up_old_ticket_recs’;

If the above query returns the job id then run the following command to

remove it:

SQL> exec dbms_job.remove(<that job id>);

SQL> COMMIT;

5、Make sure that there are no invalid sysman objects present in your Grid

Control repository.

Important: Oracle recommends that you back up your database before you

perform the upgrade operation. Perform the following steps before

upgrading:

a. Login into the Database as SYS user.

b. Check if there are any invalid SYSMAN objects.

SQL> select object_name, object_type from all_objects where owner=’SYSMAN’ and status <> ‘VALID’;

The above query should return 0 rows. If there are rows, then run the

below SQL statement:

SQL> @admin_recompile_invalid.sql SYSMAN

The admin_recompile_invalid.sql script is available under

<ORACLE_HOME>/sysman/admin/emdrep/sql/core/latest/admin/

Where <ORACLE_HOME> is the Oracle home directory of the Oracle

Management Service (OMS).

c. Go to step b again to be sure all SYSMAN objects are valid. If you still

have invalid SYSMAN objects that are not in the Recycle bin, contact

Oracle support.

d. Check to be sure there is no invalid SYS object:

SQL> select object_name, object_type from all_objects where status<>’VALID’ and object_name like ‘DBMS%’;

e. The above query should return 0 rows. If there are rows, then try to

"recompile" them. For example:

if the object_type = "PACKAGE" and object_name = "foo" alter package foo compile;

if the object_type = "PACKAGE BODY" and object_name = "foo" alter package foo compile body;

f. If any of the packages fail to become valid even after recompilation, then Contact Oracle Support to assist you. Once this verification is done, continue through with the rest of the pre-installation tasks.

6、Before proceeding with the upgrade, make sure that the dbms jobs are stopped. To do this, follow these steps:

a. 用sysman帐号登陆执行下面的语句

SQL> execute emd_maintenance.remove_em_dbms_jobs;

SQL> commit;

b. Stop the Grid Control Repository Database.

c. Start the Grid Control Repository Database.

7、确定 DBMS JOBS and DBMS Scheduler (for version 10.1+ RDBMS) in the Enterprise Manager Grid Control Repository are turned off during the Enterprise Manager schema upgrade process. To perform this task, follow these steps:

a. Log into the repository as SYSMAN.

b. For each instance, perform the tasks below:

1. Write down the values of job_queue_processes for each of the instances after you run the following command:

SQL> select a.instance_name as sid, b.value as jobqueue from gv$instance a, gv$parameter b where a.inst_id = b.inst_id and b.name=’job_queue_ processes’;

2. Turn off DBMS JOBS by running the following command:

SQL> alter system set job_queue_processes=0 sid=’*’;

Be sure there were no active jobs running by waiting until the following

query returns 0:

SQL> select count(*) from dba_jobs_running;

3. Turn off the DBMS Scheduler by running (for version 10.1+ RDBMS) the following command:

SQL> exec dbms_scheduler.set_scheduler_attribute (‘SCHEDULER_DISABLED’,’TRUE’);

确保没有活动的调度程序在执行,运行下面语句,应该返回0行。

SQL> select count(*) from dba_scheduler_running_jobs where SLAVE_PROCESS_ID IS NOT NULL;

如果不是0,则等待为0;

三、预备工作

emctl stop oms

emctl stop iasconsole

opmnctl stopall

等待四到五分钟来确保所有的OPMN过程停止和TCP端口被释放。

export ORACLE_HOME=$OMS_HOME

四、开始安装

unzip gc_x86_64_10205_part2of2.zip

unzip p3731593_10205_Linux-x86-64.zip

[oracle@bay9X ~]$ cd 3731593/Disk1/

[oracle@emrep Disk1]$ ./runInstaller

image

NEXT

image

NEXT

image

点击YES

image

NEXT

image

输入在安装时设置的Repository 密码

NEXT

image

这个意思 是ORACLE会停止一会,点击OK确定

image

重复输入上一个密码

NEXT

image

点Install

image

等待安装

image

根据提示,用ROOT帐号运行以上脚本,运行后无提示,然后点击OK,进入下一界面

image

等待

image

升级完成

使用sysman 帐号执行如下语句

SQL> exec dbms_scheduler.set_scheduler_attribute (‘SCHEDULER_DISABLED’,’FALSE’);

升级Agent

[oracle@emrep agent10g]$ cd /opt/app/oracle/OracleHomes/agent10g/bin/

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

[oracle@emrep Disk1]$ export ORACLE_HOME=$AGENT_HOME

[oracle@emrep Disk1]$ ./runInstaller

image

注意这次选择的是agent10g,和上次不一样

NEXT

image

NEXT

image

NEXT

image

Install

image

等待

image

根据提示用root帐号执行脚本 ,然后点OK

image

安装完成

EXIT退出

修改几个BUG

1、 agent10g home下

$AGENT_HOME/install/unix/scripts/agentstup

更改文件中 executingUser=$USER executingUser=`id -un` 保存退出。

SU=/usr/local/bin/sudo //并确定sudo是在这个系统目录,如果不是,请更改为正确的路径

2、 oms10g home 下

$OMS_HOME/install/unix/scripts/omsstup

更改文件中 executingUser=$USER executingUser=`id -un` 保存退出。

3、 更改系统sudo权限

[root@emrep ~]# vim /etc/sudoers

#Defaults requiretty

注释掉这一行 强制保存:wq!

一、更改字体

1、 查找系统现有的中文字体

/usr/share/font 目录

[oracle@bay9X ~]$ cd /usr/share/fonts/chinese/TrueType/

fonts.dir fonts.scale ukai.ttf uming.ttf

[oracle@bay9X ~]$ cd /usr/share/fonts/chinese/TrueType/

我这里找到两个字体,一个是ukai.ttf 一个是uming.ttf,具体用那一个看个人想法

2、 更改配置文件

两个地方

1、[oracle@bay9X ~]$ cd /opt/app/oracle/OracleHomes/oms10g/jdk/jre/lib/

2、[oracle@bay9X ~]$ cd /opt/app/oracle/OracleHomes/oms10g/jre/1.4.2/lib

按照同样的方法,修改两个地方

[oracle@bay9X lib]$ cp font.properties.zh_CN_UTF8.Sun font.properties

[oracle@bay9X lib]$ vim font.properties

修改最下面两行

filename.-misc-fzsongti-medium-r-normal–*-%d-*-*-p-*-iso10646-1=/usr/share/fonts/chinese/TrueType/ukai.ttf

appendedfontpath=/usr/share/fonts/chinese/TrueType

3、 删除已生成的缓存图片

/opt/app/oracle/OracleHomes/oms10g/j2ee/OC4J_EM/applications/em/em/cabo/images/cache/zhs目录下面的所有gif图片,并重起

本章算是完成了

【原创】升级Enterprise Manager Grid Control (10.2.0.3.0) 到 (10.2.0.5.0) 有 24 条回应

  1. Heya i’m for the first time here. I found this board and I find It really useful & it helped me out much.
    I hope to give something back and help others like you aided me.

    回复
  2. I have been surfing online more than 2 hours today, yet I never found any interesting article like
    yours. It’s pretty worth enough for me. Personally, if all
    website owners and bloggers made good content as you did,
    the internet will be much more useful than ever before.

    回复
  3. It’s fantastic that you are getting thoughts from this article
    as well as from our argument made here.

    回复
  4. Hmm is anyone else experiencing problems with the images on this blog loading?
    I’m trying to determine if its a problem on my end or if it’s the blog.

    Any responses would be greatly appreciated.

    回复
  5. I’m really loving the theme/design of your website.
    Do you ever run into any internet browser compatibility problems?
    A few of my blog readers have complained about my
    website not working correctly in Explorer but looks great in Opera.

    Do you have any recommendations to help fix this problem?

    回复
  6. It is appropriate time to make some plans for the future and
    it is time to be happy. I’ve read this post and if I could
    I wish to suggest you few interesting things
    or advice. Perhaps you can write next articles referring
    to this article. I wish to read more things about
    it!

    回复
  7. Have you ever thought about including a little bit more
    than just your articles? I mean, what you say is fundamental and everything.
    Nevertheless just imagine if you added some great photos or
    videos to give your posts more, “pop”! Your content is excellent but with images and
    videos, this website could undeniably be one of the very best in its field.
    Awesome blog!

    回复
  8. Simply want to say your article is as astonishing.
    The clearness for your submit is simply nice and i could think you’re knowledgeable in this subject.
    Fine along with your permission allow me to seize your RSS feed to stay up to date with
    drawing close post. Thank you one million and please carry on the rewarding work.

    回复
  9. Appreciation to my father who told me regarding this blog, this weblog is
    really remarkable.

    回复
  10. This post gives clear idea for the new people of blogging, that
    really how to do blogging and site-building.

    回复
  11. I don’t even understand how I stopped up here, but I assumed this publish
    was great. I don’t recognise who you might be however definitely you are going
    to a famous blogger for those who aren’t already.
    Cheers!

    回复
  12. Me ha encantado vuestro blog post y me ha sabido a poco pero ya sabeis lo que dice el dicho “si lo bueno es
    breve es un par de veces bueno”. Me gustara
    regresar a leeros de nuevo.

    回复
  13. at pills of is

    4a82 qui is 5 mg

    回复
  14. is generika ats2

    4a82 commande is pharmacie

    回复
  15. is soho shops

    f371 is gold barato comprar

    回复
  16. price of brand is

    f371 at is grece

    回复
  17. viagra psychischer strung

    回复
  18. order is from canada

    af29 we use it where to find is

    回复
  19. is farmacia onlin

    4dc5 at is online uk

    回复
  20. campioni viagra generici

    回复
  21. uses of is

    70e5 is prescribed for women

    回复
  22. is online south africa

    82f8 long side taking is term

    回复
  23. be is user

    9721 be is with paypal pills

    回复
  24. is in pakistan price

    0fe2 the best choice women is

    回复

发表评论

电子邮件地址不会被公开。 必填项已用*标注