Installing Grid Control 10g on Unbreakable Linux 5.3 (VMware)



See libXp.so.6 to resolve the depency on libXp.so.6

This is an installation on a VMware Redhat 5.3 guest system; the purpose of this full exercise is using the grid controle to manage the 11g Data Guard configuration on two other VMware guest operating systems.

As there is no grid repository available, I will choose to create a database, install the OMS and install the agent on my virtual node grid10g.

Even if the OMS is local, an agent is needed. I will use the version 10.2.0.1.1 to make my life difficult (sometimes in our profession as DBA we are faced by complex environements), and then upgrade to 10.2.0.5

Oracle installation type

In this case, three ORACLE_HOME will be created by the installer: one for the database, one for the management server and one for the agent.

Three ORACLE_HOMEs

The database name and the passwords for the privileged users are required.

Database name

Passwords for sys and system

As shown in the screenshot, the software for the Oracle Enterprise Manger Repository Database is first installed.

Oracle Enterprise Manger Repository Database

Second comes the software for the grid console, and third the Oracle Management Server


Oracle Management Server


The database is cloned using the files that come with the CDs

database is cloned

While linking and confuring the assistants, the web cache assistant gives the error libdb-so.2 missing

Error in web cache assistan

There is no point in continuing; in my case the solution was installing the rpm db1-1.85-8.i386.rpm, that can be downloaded from here
[root@grid10g tmp]# rpm -iv db1-1.85-8.i386.rpm
warning: db1-1.85-8.i386.rpm: Header V3 DSA signature: NOKEY, key ID db42a60e
Preparing packages for installation...
db1-1.85-8
[root@grid10g tmp]# ls /usr/lib/libdb*
/usr/lib/libdb1.so.2       /usr/lib/libdb.so.2
/usr/lib/libdb-4.3.so      /usr/lib/libdbus-glib-1.so.2
/usr/lib/libdb_cxx-4.3.so  /usr/lib/libdbus-glib-1.so.2.1.0
[root@grid10g tmp]# 
libdb.so.2
The installation has completed and a summary is offered
This information is also available at: 

/u01/app/oracle/OracleHomes/agent10g/sysman/setupinfo.txt

See below for information pertaining to your Enterprise Manager installation:

1. Use the following URL to access the Enterprise Manager Grid Control: 

http://grid10g:4889/em

2. The Enterprise Manager installation includes an Oracle Application Server instance, which is administered using a special "ias_admin" user account. The following information was defaulted for the embedded Application Server instance:

Instance Name:    EnterpriseManager0.grid10g
ias_admin password: This password is the same the SYSMAN account.

3. The connection details for the Enterprise Manager Repository are:

Host: grid10g
Port: 1521
SID: REP10G

4. The Enterprise Manager Release Notes are located at:

/u01/app/oracle/OracleHomes/agent10g/relnotes/README_EM.htm



If everything has gone well, the console will already be available on http://grid10g:4889/em



To start/stop the Oracle Grid Console



Go to the oms ORACLE_HOME
$ pwd
/u01/app/oracle/OracleHomes/oms10g/bin
$ ./emctl stop oms
Oracle Enterprise Manager 10g Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Oracle Management Server is Down.
$ ./emctl start oms
Oracle Enterprise Manager 10g Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
opmnctl: opmn is already running
Starting HTTP Server ...
Starting Oracle Management Server ...
Checking Oracle Management Server Status ...
Oracle Management Server is Up.
As we deal with three different ORACLE_HOMEs, we often have to switch between the three environments and redefine the PATH.
It is therefore an excellent idea to define aliases in .profile, making sure that the original PATH be preserved in BASE_PATH, since PATH will be overwritten when switching environments.
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/OracleHomes/db10g
export DBS_HOME=/u01/app/oracle/OracleHomes/db10g
export OMS_HOME=/u01/app/oracle/OracleHomes/oms10g
export AGENT_HOME=/u01/app/oracle/OracleHomes/agent10g
export ORACLE_SID=REP10G
export BASE_PATH=$PATH
alias 10db='export ORACLE_HOME=$DBS_HOME; export PATH=${ORACLE_HOME}/bin:${BASE_PATH}'
alias 10gr='export ORACLE_HOME=$OMS_HOME; export PATH=${ORACLE_HOME}/bin:${BASE_PATH}'
alias 10ag='export ORACLE_HOME=$AGENT_HOME; export PATH=${ORACLE_HOME}/bin:${BASE_PATH}'
We source in the .profile file and we check all the components
$ . ./.profile

$ $AGENT_HOME/bin/emctl status agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version     : 10.2.0.1.0
OMS Version       : 10.2.0.1.0
Protocol Version  : 10.2.0.0.0
Agent Home        : /u01/app/oracle/OracleHomes/agent10g
Agent binaries    : /u01/app/oracle/OracleHomes/agent10g
Agent Process ID  : 4792
Parent Process ID : 4774
Agent URL         : https://grid10g:3872/emd/main/
Repository URL    : https://grid10g:1159/em/upload
Started at        : 2009-06-06 19:55:56
Started by user   : oracle
Last Reload       : 2009-06-06 19:55:56
Last successful upload                       : (none)
Last attempted upload                        : (none)
Total Megabytes of XML files uploaded so far :     0.00
Number of XML files pending upload           :      297
Size of XML files pending upload(MB)         :     4.70
Available disk space on upload filesystem    :    20.01%
Last successful heartbeat to OMS             : 2009-06-06 21:21:03
---------------------------------------------------------------
Agent is Running and Ready

$ 10gr 
$ $ORACLE_HOME/bin/emctl status iasconsole
Oracle Enterprise Manager 10g Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Oracle 10g Application Server Control is not running.

$ $ORACLE_HOME/bin/emctl start iasconsole
Oracle Enterprise Manager 10g Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Starting Oracle 10g Application Server Control .... started. 

$ $ORACLE_HOME/bin/emctl start oms

Steps to make sure that the grid components are up

$ alias
10ag='export ORACLE_HOME=$AGENT_HOME; export PATH=${ORACLE_HOME}/bin:${BASE_PATH}'
10db='export ORACLE_HOME=$DBS_HOME; export PATH=${ORACLE_HOME}/bin:${BASE_PATH}'
10om='export ORACLE_HOME=$OMS_HOME; export PATH=${ORACLE_HOME}/bin:${BASE_PATH}'
$ 10db
$ sqlplus / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
$ lsnrctl status
LSNRCTL for Linux: Version 10.1.0.4.0 - Production on 13-JUN-2009 17:41:33

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.1.0.4.0 - Production
Start Date                13-JUN-2009 17:19:58
Uptime                    0 days 0 hr. 21 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/OracleHomes/db10g/network/admin/listener.ora
Listener Log File         /u01/app/oracle/OracleHomes/db10g/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=grid10g)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "REP10G" has 1 instance(s).
  Instance "REP10G", status READY, has 1 handler(s) for this service...
The command completed successfully
$ 10om
$ emctl status oms
Oracle Enterprise Manager 10g Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Oracle Management Server is Down.
$ emctl start oms
Oracle Enterprise Manager 10g Release 10.2.0.1.0  
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
opmnctl: opmn is already running
Starting HTTP Server ...
Starting Oracle Management Server ...
Checking Oracle Management Server Status ...
Oracle Management Server is Up.
At this point the console has already come up



Let's check the agent:
$10ag
$ emctl status agent
... ... ...
Agent is Running and Ready
This was about configuring the Enterprise Manager Repository; the agent on the data guard nodes will have to be installed, see installation of the grid agent on a monitored node