環境：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

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

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.

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

Oracle Enterprise Manager 10g Release 3 Grid Control

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

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安裝順利完成。

Linux 5.7現有資料庫上安裝Oracle10g Grid Control

相關文章