Software para download em :
http://www.oracle.com/technology/software/products/oem/htdocs/agentsoft.html
Documentação de instalação :
http://www.oracle.com/technology/software/products/oem/files/agent-files/32-bit/linux-32-10.2.0.5.-instructions.txt
Configurando o etc/hosts
Configurar o etc/hosts para o servidor target poder enchergar o Grid Control server.
[oracle@jamaica oracle]$ more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.79.130 jamaica jamaica
127.0.0.1 localhost.localdomain localhost
192.168.79.134 suecia suecia
[oracle@jamaica oracle]$
Teste de conectividade :
[root@jamaica ~]# ping suecia
PING suecia (192.168.79.134) 56(84) bytes of data.
64 bytes from suecia (192.168.79.134): icmp_seq=1 ttl=64 time=15.9 ms
64 bytes from suecia (192.168.79.134): icmp_seq=2 ttl=64 time=0.178 ms
64 bytes from suecia (192.168.79.134): icmp_seq=3 ttl=64 time=0.075 ms
64 bytes from suecia (192.168.79.134): icmp_seq=4 ttl=64 time=0.164 ms
Desbloqueando a conta DBSNMP do banco de dados target
[oracle@jamaica oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 8 06:27:20 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
sys@OCADB on 08-JAN-10 >set lines 300 pages 1000 timing on serveroutput on
sys@OCADB on 08-JAN-10 >select username,account_status from dba_users where username='DBSNMP';
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
DBSNMP OPEN
Elapsed: 00:00:00.19
sys@OCADB on 08-JAN-10 >alter user DBSNMP identified by DBSNMP;
User altered.
Elapsed: 00:00:00.22
sys@OCADB on 08-JAN-10 >
No caso o meu já estava desbloqueado,mas caso não estivesse era só adicionar as palavras-chave account unlock no alter user .
Na máquina target tenho um banco de dados com o SID ocadb,uma instância ASM e o Listener :
[oracle@jamaica sw]$ ps -ef|grep pmon
oracle 3277 1 0 06:18 ? 00:00:00 asm_pmon_+ASM
oracle 3457 1 0 06:22 ? 00:00:00 ora_pmon_ocadb
oracle 3731 3241 0 06:42 pts/1 00:00:00 grep pmon
[oracle@jamaica sw]$ ps -ef|grep tns
oracle 3538 1 0 06:23 ? 00:00:00 /u01/app/oracle/product/10.2.0/bin/tnslsnr LISTENER -inherit
oracle 3733 3241 0 06:42 pts/1 00:00:00 grep tns
[oracle@jamaica sw]$
Descompactação do software
Fiz um unzip do arquivo Linux_Grid_Control_agent_download_10_2_0_5_0.zip e os arquivos estraídos foram :
[oracle@jamaica sw]$ ls -l
total 368008
-rwxrwxr-x 1 oracle oinstall 1874 Jun 22 2007 agentdeployroot.sh
-rwxrwxr-x 1 oracle oinstall 23372 Sep 29 2008 agent_download.rsp.bak
-rwxrwxr-x 1 oracle oinstall 9532 Feb 23 2009 instructions.txt
drwxrwxr-x 8 oracle oinstall 4096 Feb 20 2009 linux
-rw-r--r-- 1 oracle oinstall 376420365 Jan 7 18:11 Linux_Grid_Control_agent_download_10_2_0_5_0.zip
[oracle@jamaica sw]$
Instalação do Management Agent 10.2.0.5
Localização dos arquivos depois da descompactação :
[oracle@jamaica agent]$ pwd
/u02/sw/linux/agent
[oracle@jamaica agent]$ ls -l
total 16
drwxrwxr-x 5 oracle oinstall 4096 Feb 20 2009 install
-rwxrwxr-x 1 oracle oinstall 5281 Dec 18 2008 runInstaller
drwxrwxr-x 11 oracle oinstall 4096 Feb 20 2009 stage
[oracle@jamaica agent]$
Executando o runInstaller :
Additional Management Agent
Escolha da home do Agent :
Executar o script roor.sh :
[root@jamaica ~]# /u02/app/agent10g/root.sh
Running Oracle10 root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u02/app/agent10g
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]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
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.
[root@jamaica ~]#
No OUI :
A instalação dos binários ocorreu sem problemas , mas ainda vamos verificar se realmente está funcionando corretamente!
[oracle@jamaica bin]$ ./emctl status agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.5.0
OMS Version : 10.2.0.5.0
Protocol Version : 10.2.0.5.0
Agent Home : /u02/app/agent10g
Agent binaries : /u02/app/agent10g
Agent Process ID : 11513
Parent Process ID : 11488
Agent URL : https://jamaica.riversideti.com.br:3872/emd/main/
Repository URL : https://suecia:1159/em/upload
Started at : 2010-01-08 07:01:42
Started by user : oracle
Last Reload : 2010-01-08 07:01:42
Last successful upload : 2010-01-08 07:02:51
Total Megabytes of XML files uploaded so far : 9.50
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 19.41%
Last successful heartbeat to OMS : 2010-01-08 07:02:50
---------------------------------------------------------------
Agent is Running and Ready
[oracle@jamaica bin]$ ./emctl status agent
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.2.0.5.0
OMS Version : 10.2.0.5.0
Protocol Version : 10.2.0.5.0
Agent Home : /u02/app/agent10g
Agent binaries : /u02/app/agent10g
Agent Process ID : 11513
Parent Process ID : 11488
Agent URL : https://jamaica.riversideti.com.br:3872/emd/main/
Repository URL : https://suecia:1159/em/upload
Started at : 2010-01-08 07:01:42
Started by user : oracle
Last Reload : 2010-01-08 07:01:42
Last successful upload : 2010-01-08 07:02:51
Total Megabytes of XML files uploaded so far : 9.50
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 19.41%
Last successful heartbeat to OMS : 2010-01-08 07:02:50
---------------------------------------------------------------
Agent is Running and Ready
[oracle@jamaica bin]$
[oracle@jamaica bin]$
[oracle@jamaica bin]$
[oracle@jamaica bin]$ ./emctl upload
Oracle Enterprise Manager 10g Release 5 Grid Control 10.2.0.5.0.
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully
[oracle@jamaica bin]$
[oracle@jamaica bin]$
Ele parece estar se comunicando com o OMS no Grid Server .
Obs :
Caso ele não mostre a frase “EMD upload completed successfully”,temos algum problema na comunicação entre o Management Agent e o OMS.
No Metalink existem algumas notas a respeito do assunto.Use a mensagem de erro para encontrar a melhor solução do problema.Também faça a procura em blogs e sites de profissionais Oracle que você provavelmente vai encontrar soluções para estes erros.
Algumas notas :
283091.1
787551.1
604495.1
Vamos ver no console de gerenciamento do Grid .
Podemos ver que na aba Targets ele já adicionou o host JAMAICA onde fizemos a instalação do Mnagement Agent .
Clicando no Hots Jamaica entramos em outra tela do Grid,onde mostra algumas abas/menus :
Na aba Targets dentro do Host Jamaica temos os alvos a serem monitorados :
Vamos ver umas das telas de monitoramento do banco de dados ocadb :
Obs.Caso receba mensagem de erro como esta abaixo :
Provavelmente o Grid Server não consegue ter conectividade até o target,portanto verifique o /etc/hosts do Grid e add o IP e Hostname do servidor target.
Continuando...
Acima a área de gerenciamento do target.
Monitoramento da ASM instance :
Monitorando o Listener :
Bom chega ao fim este nosso how-to!
Abs,
Julio Cesar Correa
