Menu de navegação

[maperesParticipante]

Boa tarde, colegas

Estou com um problema, não consigo “startar” o Enterprise Manager.
Tenho um ambiente de RAC com dois nodes, sendo que o OEM se encontra no node1, porém, não consigo levantá-lo.

Tentei mudar a porta HTTP e do agente, mas mesmo assim não tive sucesso.

Segue abaixo o log da última tentativa realizada.

$ emca -reconfig ports -DBCONTROL_HTTP_PORT 51160 -AGENT_PORT 3941 -RMI_PORT 5523 -JMS_PORT 5543

STARTED EMCA at Sep 27, 2010 2:40:33 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: DBSM1

Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 27, 2010 2:40:41 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/oracle10g/products/10.2.0/cfgtoollogs/emca/DBSM/emca_2010-09-27_02-40-33-PM.log.
Sep 27, 2010 2:40:43 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) …
Sep 27, 2010 2:40:45 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /oracle/oracle10g/products/10.2.0/bin/emctl stop dbconsole
Sep 27, 2010 2:40:46 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …

Alguem tem alguma idéia para poder resolver esse problema.

Ambiente :

SO : AIX
Banco : 10.2.0.4

Agradeço

Marco Aurelio

[PetersonParticipante]

A mensagem sugere que o erro ocorre ao parar o EM. Tente parar manualmente o EM e veja se ocorre erros.

[maperesParticipante]

Ola Peterson

Já tentei subir manualmente o OEM porém ocorer a msg abaixo :

emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://goya-01:1159/em/console/aboutApplication
ps: 0509-048 Flag -o was used with invalid list.
ps: Not a recognized flag: –
Usage: ps [-ANPaedfklmMZ] [-n namelist] [-F Format] [-o specifier[=header],…]
[-p proclist][-G|-g grouplist] [-t termlist] [-U|-u userlist] [-c classlist] [ -T pid] [ -L pidlist]
Usage: ps [aceglnsuvwxU] [t tty] [processnumber]
Agent Version : 10.1.0.6.0
OMS Version : 10.1.0.6.0
Protocol Version : 10.1.0.2.0
Agent Home : /oracle/oracle10g/products/10.2.0/goya-01_DBSM1
Agent binaries : /oracle/oracle10g/products/10.2.0
Agent Process ID : 1757254
Parent Process ID : 1
Agent URL : https://goya-01:53938/emd/main
Started at : 2010-09-27 09:41:06
Started by user : oracle
Last Reload : 2010-09-27 09:41:06
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 2477
Size of XML files pending upload(MB) : 90.40
Available disk space on upload filesystem : 11.14%
Agent is already started. Will restart the agent
Stopping agent … stopped.

Starting Oracle Enterprise Manager 10g Database Control ………………………………………………………………………………… failed.

Logs are generated in directory /oracle/oracle10g/products/10.2.0/goya-01_DBSM1/sysman/log

[maperesParticipante]

Peterson, só corrigindo :

$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
https://goya-01:51160/em/console/aboutApplication
ps: 0509-048 Flag -o was used with invalid list.
ps: Not a recognized flag: –
Usage: ps [-ANPaedfklmMZ] [-n namelist] [-F Format] [-o specifier[=header],…]
[-p proclist][-G|-g grouplist] [-t termlist] [-U|-u userlist] [-c classlist] [ -T pid] [ -L pidlist]
Usage: ps [aceglnsuvwxU] [t tty] [processnumber]
Agent Version : 10.1.0.6.0
OMS Version : 10.1.0.6.0
Protocol Version : 10.1.0.2.0
Agent Home : /oracle/oracle10g/products/10.2.0/goya-01_DBSM1
Agent binaries : /oracle/oracle10g/products/10.2.0
Agent Process ID : 1519846
Parent Process ID : 1642504
Agent URL : https://goya-01:3941/emd/main
Started at : 2010-09-27 09:49:11
Started by user : oracle
Last Reload : 2010-09-27 09:49:11
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 2479
Size of XML files pending upload(MB) : 90.42
Available disk space on upload filesystem : 11.13%
Agent is already started. Will restart the agent
Stopping agent … stopped.

Starting Oracle Enterprise Manager 10g Database Control ………………………………………………………………………………… failed.

Logs are generated in directory /oracle/oracle10g/products/10.2.0/goya-01_DBSM1/sysman/log
[ goya-01 | oracle | DBSM1 | /home/oracle ]
$

[vieriParticipante]

dropa e recria o dbconsole nos dois nodes.

emca -config dbcontrol db -repos recreate

[PetersonParticipante]

Marco, algum progresso com as instruções do Vieri?

[maperesParticipante]

Peterson.

Estou com algumas dúvidas na aplicação desse comando, tenho receio de acontecer algo na base, estou estudando um pouco mais antes de aplicar.

[PetersonParticipante]

Faz bem! Conhecimento nunca é demais.

[maperesParticipante]

Assim que eu aplicar eu posto aqui para vocês saberem se deu certo….

[Sousa04Participante]

Opa blz!!!

Já tive alguns problemas com o Enterprise manager. Ele startava porém eu não conseguia acessar.

No meu caso usei os comandos

emca -deconfig dbcontrol db -repos drop
Apaga geral e creio q o usuário sysman e dbsnmp tbm.

depois criei novamente e funcionou legal
emca -config dbcontrol db -repos create

esses comando estão bem documentados
http://download.oracle.com/docs/cd/B193 … b40002.pdf

Boa sorte ai

[maperesParticipante]

Pessoal

Executei o comando abaixo, porém ele começou a executar e travou

$ emca -config dbcontrol db -repos recreate

STARTED EMCA at Sep 28, 2010 2:51:35 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: DBSM1
Database Control is already configured for the database DBSM1
You have chosen to configure Database Control for managing the database DBSM1
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /oracle/oracle10g/products/10.2.0 ]:
ASM SID [ +ASM ]: +ASM1
ASM port [ 1521 ]:
ASM user role [ SYSDBA ]:
ASM username [ SYS ]:
ASM user password:
—————————————————————–

You have specified the following settings

Database ORACLE_HOME ……………. /oracle/oracle10g/products/10.2.0

Database hostname ……………. goya-01.ima.sp.gov.br
Listener port number ……………. 1521
Database SID ……………. DBSM1
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
ASM ORACLE_HOME ……………. /oracle/oracle10g/products/10.2.0
ASM SID ……………. +ASM1
ASM port ……………. 1521
ASM user role …………….
ASM username ……………. SYS

—————————————————————–
Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 28, 2010 2:55:59 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/oracle10g/products/10.2.0/cfgtoollogs/emca/DBSM/emca_2010-09-28_02-51-35-PM.log.
Sep 28, 2010 2:56:01 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 5543 is already in use.
Sep 28, 2010 2:56:01 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 5523 is already in use.
Sep 28, 2010 2:56:01 PM oracle.sysman.emcp.util.PortManager isPortInUse
WARNING: Specified port 51160 is already in use.
Sep 28, 2010 2:56:01 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) …
Sep 28, 2010 2:56:24 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) …

Só que durante o processo ele deixou o banco em state quiesce e parou tudo.

[Autor]

Posts