Linux 5.7现有数据库上安装Oracle10g Grid Control

环境：redhat 5.7 64位 + Oracle10g_64 (10.2.0.1)+linux_x86_64_grid_control_102030

实验目的：同一台服务器上先安装Oracle1g数据库软件并建立数据库（DBCA自定义方式），然后再安装Oracle10g Grid Cuntrol（安装模式为选用现有数据库）。

如下将数据库的安装并创建过程省略，从已建好数据库上进行相关检查和安装Grid Control开始...

一、数据库先决条件查询及修改

[oracle@dbserv ~]$ sqlplus / as sysdba

SQL> select username from dba_users;

USERNAME

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

SYS

SYSTEM

OUTLN

DBSNMP

WMSYS

TSMSYS

DIP

7 rows selected.

[@more@]

SQL> show parameter session_ca

NAME TYPE VALUE

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

session_cached_cursors integer 20

SQL> alter system set session_cached_cursors =201 scope=spfile;

System altered.

SQL> show parameter job_que

NAME TYPE VALUE

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

job_queue_processes integer 10

SQL> alter system set job_queue_processes = 11 scope=spfile;

System altered.

SQL> show parameter open_cu

NAME TYPE VALUE

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

open_cursors integer 300

SQL> alter system set open_cursors = 301 scope=spfile;

System altered.

SQL> @?/rdbms/admin/dbmspool.sql

Package created.

Grant succeeded.

View created.

Package body created.

SQL> alter user DBSNMP identified by oracle1 account unlock;

User altered.

SQL>

SQL> show parameter aq_tm_processes

NAME TYPE VALUE

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

aq_tm_processes integer 0

SQL> alter system set aq_tm_processes = 2;

System altered.

SQL> alter system set shared_pool_size = 300M;

System altered.

SQL> show parameter shared_p

NAME TYPE VALUE

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

shared_pool_reserved_size big integer 43620761

shared_pool_size big integer 304M

[oracle@dbserv ~]$ tnsping emrep

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 23-JUL-2012 15:09:51

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:

/opt/oracle/product/10.2.0/database/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dbserv)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = emrep)))

OK (0 msec)

通过以上配置过程，现有数据库已经满足了Grid Conctrol所需的相关条件。下一步开始安装Oracle Grid Control。

二、安装Oracle10g Grid Control

1、下载并解压相关的版本：

[root@dbserv 5.4]# cd /opt/setups/

[root@dbserv setups]# ls

10201_database_linux_x86_64.cpio linux_x86_64_grid_control_full_102030_disk1.zip linux_x86_64_grid_control_full_102030_disk2.zip

2、打补丁:

因打补丁过程中总是提示依赖包未安装提示，通过 --nodeps --force参数来进行了强制打补丁：

[root@dbserv setups]# rpm -ivh openmotif21-2.1.30-11.rhel4.5.src.rpm --nodeps --force

warning: openmotif21-2.1.30-11.rhel4.5.src.rpm: Header V3 DSA signature: NOKEY, key ID db42a60e

1:openmotif21 ########################################### [100%]

[root@dbserv setups]# rpm -ivh xscreensaver-4.18-5.rhel4.14.x86_64.rpm --nodeps --force

warning: xscreensaver-4.18-5.rhel4.14.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID db42a60e

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

1:xscreensaver ########################################### [100%]

[root@dbserv setups]# rpm -ivh pdksh-5.2.14-30.6.x86_64.rpm --nodeps --force

warning: pdksh-5.2.14-30.6.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID db42a60e

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

1:pdksh ########################################### [100%]

[root@dbserv setups]# rpm -ivh gnome-libs-1.4.1.2.90-44.1.x86_64.rpm --nodeps --force

warning: gnome-libs-1.4.1.2.90-44.1.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID db42a60e

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

1:gnome-libs ########################################### [100%]

3、安装之前oracle用户的环境变量参数如下：

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/opt/oracle; export ORACLE_BASE

OMS_HOME=/opt/oracle/OracleHomes/oms10g; export OMS_HOME

AGENT_HOME=/opt/oracle/OracleHomes/agent10g; export AGENT_HOME

ORACLE_HOME=$ORACLE_BASE/OracleHomes/db10g; export ORACLE_HOME

ORACLE_SID=emrep; export ORACLE_SID

ORACLE_TERM=xterm; export ORACLE_TERM

PATH=/usr/sbin:$PATH; export PATH

PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

export CLASSPATH

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi

4、开始安装Grid Control：

在安装前期条件检查中，提示 openmotif21-2.1.30-11包 失败提示，这是可以允许的，如下：

Checking operating system package requirements ...

Checking for make-3.79; found make-1:3.81-3.el5. Passed

Checking for binutils-2.15.92.0.2-13; found binutils-2.17.50.0.6-14.el5. Passed

Checking for gcc-3.4.3-22.1; found gcc-4.1.2-51.el5. Passed

Checking for libaio-0.3.96; found libaio-0.3.106-5. Passed

Checking for glibc-common-2.3.4-2.9; found glibc-common-2.5-65. Passed

Checking for libstdc++-3.4.3-22.1; found libstdc++-4.1.2-51.el5. Passed

Checking for openmotif21-2.1.30-11; found Not found. Failed <<<<

Checking for pdksh-5.2.14-30; found pdksh-5.2.14-30.6. Passed

Checking for setarch-1.6-1; found setarch-2.0-1.1. Passed

Checking for gnome-libs-1.4.1.2.90-44.1; found gnome-libs-1:1.4.1.2.90-44.1. Passed

Checking for sysstat-5.0.5-1; found sysstat-7.0.2-3.el5. Passed

Checking for compat-db-4.1.25-9; found compat-db-4.2.52-5.1. Passed

Checking for control-center-2.8.0-12; found control-center-1:2.16.0-16.el5. Passed

Checking for xscreensaver-4.18-5.rhel4.2; found xscreensaver-1:4.18-5.rhel4.14. Passed

Check complete. The overall result of this check is: Failed <<<<

Problem: Some packages required for the Oracle EnterPrise Manager 10gR2 to function properly are missing (see above).

Recommendation: Install the required packages before continuing with the installation.

以上的openmotif21-2.1.30-11失败是没有关系的,可以确认并继续。

在下一步安装过程中，选择GC Repository所需的表空间位置。该表空间的目录部分可以就是可以通过

select file_name from dba_data_files;命令可以得到;

/opt/oracle/oradata/emrep/mgmt.dbf

/opt/oracle/oradata/emrep/mgmt_ecm_depot1.dbf

在安装过程中还会报另外找不到libdb.so.2 类此的一个错误，一个重点是需要做如下连接：

12/07/23 21:54:58 Start process

--------

/opt/oracle/OracleHomes/oms10g/Apache/Apache/bin/apachectl start: execing httpd

/opt/oracle/OracleHomes/oms10g/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or direct

[root@dbserv test]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

另外一个报错点为，在安装过程中需要手工启动

[Oracle@cfbgc bin]$ ./opmnctl stopall

[Oracle@cfbgc bin]$ ./opmnctl startall

[Oracle@cfbgc bin]$ ./opmnctl status

如果 status选项查看后，发现有些部分组件还未启用，可以用命令针对不同组件进行启动：

./opmnctl startproc ias-component="DSA"

./opmnctl startproc ias-component="LogLoader"

./opmnctl startproc ias-component="dcm-daemon"

经过如上步骤后，安装过程进行到99%后系统还是报错，网上部分资料说有两种解决方式：

a) 打patch ,Patch号为p843062（p8430622_linux_x64_gc10.2.3.zip ）

b) 将系统时间改为2010年12月之前

如上两种方法都试过了，但是还是安装失败。第一次安装失败….

卸载OMS,升级数据库后重新安装

[oracle@dbserv bin]$ ./opmnctl stopall

opmnctl: stopping opmn and all managed processes...

[oracle@dbserv bin]$ ./opmnctl status

Unable to connect to opmn.

Opmn may not be up.

[oracle@dbserv ~]$ source ./.bash_profile

[oracle@dbserv ~]$ $AGENT_HOME/bin/emctl stop agent

Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0.

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

[oracle@dbserv ~]$ $OMS_HOME/bin/emctl stop oms -all

Oracle Enterprise Manager 10g Release 3 Grid Control

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

Oracle Management Server is Down.

OPMN may not be up.

[oracle@dbserv ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 24 15:51:20 2012

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

Connected to:

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

With the Partitioning, OLAP and Data Mining options

SQL> drop user SYSMAN cascade;

User dropped.

SQL> drop user MGMT_VIEW cascade;

User dropped.

SQL> select tablespace_name from dba_tablespaces where tablespace_name like 'MGMT%';

TABLESPACE_NAME

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

MGMT_ECM_DEPOT_TS

MGMT_TABLESPACE

SQL> drop tablespace MGMT_ECM_DEPOT_TS including contents and datafiles;

Tablespace dropped.

SQL> drop tablespace MGMT_TABLESPACE including contents and datafiles;

Tablespace dropped.

删除目录：

[oracle@dbserv ~]$ cd /opt/oracle/

[oracle@dbserv oracle]$ rm -rf /opt/oracle/OracleHomes/oms10g

[oracle@dbserv oracle]$ rm -rf /opt/oracle/OracleHomes/agent10g

[oracle@dbserv oracle]$ rm -rf /opt/oracle/oraInventory

因此在该服务器上进行了GC的重新安装，但是这次选用创建新数据库的安装方式（即，GC安装模式第一个选项），这个安装模式安装成功，自带数据库安装模式中，发现数据库版本为10.0.1.1。

基于以上折腾过程作出结论如下为要不系统rpm包依赖报未打全（可能是依赖包）原因导致系统安装失败，如果将该可能性排除的话，那就很有可能是Oracle10g 10.2.0.1的bug！

因为在后续过程中将数据库升级到10.2.0.5后，GC安装顺利完成。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17172228/viewspace-1063500/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17172228/viewspace-1063500/