Menu de navegação

[bohnstedtParticipante]

Boa Tarde, amigos

Sou iniciante em Oracle e estou com problemas na minha DBCONSOLE, pois nela consigo até que gerenciar o banco graficamente para algumas atividades mais rápido.

Vou contar uma história do que aconteceu. Tenho um servidor de Banco de Dados na empresa que eu trabalho onde tem um RHEL e um FS montado num storage chamado /data_oracle, onde infelizmente tinha os controlfiles, os system.dbf, redos, etc sem estar espelhado.
Bom então por acidente, acabamos perdendo FS /data_oracle, então resumindo eu tive que remover a instancia e subir novamente. Desde então eu coloquei na opção quando estava subindo a instancia o DBCONSOLE, e nunca mais subiu.
Não sabendo o que está acontecendo tentei recriar o repositório com o comando emca -config dbcontrol db -repos recreate, mas quando eu vejo no log tem o seguinte conteudo:

CONFIG: isLocalNodeDone: true localNode: null
Nov 8, 2011 1:59:00 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Cannot start Database Control. The following ports are already in use: [EM agent port:3938].
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2011-11-08_01-54-28-PM.log for more details.
Nov 8, 2011 1:59:00 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Cannot start Database Control. The following ports are already in use: [EM agent port:3938].
at oracle.sysman.emcp.EMDBPostConfig.areDbcPortsFree(EMDBPostConfig.java:1760)
at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:577)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:224)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:193)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:184)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)

Ai então por via das duvidas dou o comando o emctl start dbconsole, e dá o seguinte erro:
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
http://ca-db03.synchro.com.br:5500/em/c … pplication
Starting Oracle Enterprise Manager 10g Database Control ………………………………………………………………………………… failed.
——————————————————————
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/ca-db03.synchro.com.br_prod/sysman/log

E verificando as ultimas linhas do log:

[root@ca-db03 log]# cat emoms.trc
2011-11-08 13:59:41,919 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.sysman.ias.ias.IASIntegration
2011-11-08 13:59:42,148 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.sysman.eml.target.slb.common.SLBIntegration
2011-11-08 13:59:42,221 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.sysman.eml.ssl.intg.SSLIntegration
2011-11-08 13:59:42,308 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.tip.oem.central.domain.ProcessConnectDomainIntg
2011-11-08 13:59:42,310 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.tip.oem.central.instance.ProcessConnectInstanceIntg
2011-11-08 13:59:42,311 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.webdb.admin.em.PortalIntegration
2011-11-08 13:59:42,313 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.webdb.admin.em.SSOIntegration
2011-11-08 13:59:42,314 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.reports.em.RepIntg
2011-11-08 13:59:42,316 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsEmailIntegration
2011-11-08 13:59:42,317 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOidIntegration
2011-11-08 13:59:42,318 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsOvfIntegration
2011-11-08 13:59:42,319 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWebconfIntegration
2011-11-08 13:59:42,321 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsWirelessIntg
2011-11-08 13:59:42,323 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 – Integration Class not found: oracle.sysman.ocs.mntr.target.OcsCalGrpIntegration

2011-11-08 14:01:08 Thread-4135216832 ERROR http: snmehl_allocateListenerPort: failed to bind socket: Address already in use (errno=98)
2011-11-08 14:01:08 Thread-4135216832 ERROR http: nmehl_startHttpListener: failed to listen to HTTP port for http://ca-db03.synchro.com.br:3938/emd/main
2011-11-08 14:01:08 Thread-4135216832 ERROR main: nmehl_startHttpListener failed starting http listener

011-11-08 14:04:17 Thread-4135443232 WARN http: snmehl_connect: connect failed to (ca-db03.synchro.com.br:5500): Connection refused (error = 111)
2011-11-08 14:04:20 Thread-4135340832 WARN http: snmehl_connect: connect failed to (ca-db03.synchro.com.br:5500): Connection refused (error = 111)
2011-11-08 14:04:23 Thread-4135484192 WARN http: snmehl_connect: connect failed to (ca-db03.synchro.com.br:5500): Connection refused (error = 111)
2011-11-08 14:04:26 Thread-4135484192 WARN http: snmehl_connect: connect failed to (ca-db03.synchro.com.br:5500): Connection refused (error = 111)

Senhores eu preciso realmente de uma ajuda.

Att,

Fábio Bohnstedt

[leandrolbsParticipante]

Não sei a relação, mas costuma ser;.

veja este post:

https://profissionaloracle.com.br/module … ht=ver%E3o

[bohnstedtParticipante]

Leandro, obrigado pela sua ajuda,

Conforme seguido o roteiro, segue o resultado:

-bash-3.2$ emctl resetTZ agent
TZ set to Brazil/East
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
Updating /u01/app/oracle/product/10.2.0/db_1/ca-db03.synchro.com.br_prod/sysman/ config/emd.properties…
Time zone set to Brazil/East.

To complete this process, you must either:

connect to the database served by this DBConsole as user ‘sysman’, and execute:

SQL> exec mgmt_target.set_agent_tzrgn(‘ca-db03.synchro.com.br:3938’,’Brazil/East ‘)

                    -- or --

connect to the database served by this DBConsole as user ‘sys’, and execute:

SQL> alter session set current_schema = SYSMAN;
SQL> exec mgmt_target.set_agent_tzrgn(‘ca-db03.synchro.com.br:3938’,’Brazil/East ‘)

Então conectei com o usuario SYSMAN e veja a resposta

-bash-3.2$ sqlplus “/as sysdba”

SQL*Plus: Release 10.2.0.4.0 – Production on Wed Nov 9 18:00:13 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Release 10.2.0.4.0 – 64bit Production

SQL> alter session set current_schema = SYSMAN;

Session altered.

SQL> exec mgmt_target.set_agent_tzrgn(‘ca-db03.synchro.com.br:3938′,’Brazil/East’);
BEGIN mgmt_target.set_agent_tzrgn(‘ca-db03.synchro.com.br:3938′,’Brazil/East’); END;

*
ERROR at line 1:
ORA-20233: Invalid agent name ca-db03.synchro.com.br:3938
ORA-06512: at “SYSMAN.MGMT_TARGET”, line 3737
ORA-06512: at line 1

SQL> exec mgmt_target.set_agent_tzrgn(‘ca-db03:3938′,’Brazil/East’);
BEGIN mgmt_target.set_agent_tzrgn(‘ca-db03:3938′,’Brazil/East’); END;

*
ERROR at line 1:
ORA-20233: Invalid agent name ca-db03:3938
ORA-06512: at “SYSMAN.MGMT_TARGET”, line 3737

Agradeço desde já

Att.

Fábio

[rmanParticipante]

@bohnstedt

Verifica o seguinte:


$ cat /etc/sysconfig/clock
$ echo $TZ


Poste o resultado…

[bohnstedtParticipante]

Rman, bom dia

Segue abaixo o resultado:

-bash-3.2$ cat /etc/sysconfig/clock

The ZONE parameter is only evaluated by system-config-date.

The timezone of the system is defined by the contents of /etc/localtime.

ZONE=”America/Sao_Paulo”
UTC=true
ARC=false
-bash-3.2$ echo $TZ

-bash-3.2$

Att,

Fábio

[bohnstedtParticipante]

Conforme achei um artigo na internet que mandava eu recriar o repositório do DBCONSOLE, então após recriado, aparentemente está entrando na página, e quando eu digito o usuario system e sua senha, dá a seguinte mensagem para mim, no topo da página:

Erro
java.lang.Exception: Exception in sending Request :: null

Se eu clico em qualquer link dá a seguinte mensagem:

500 Internal Server Error

java.util.MissingResourceException: Can’t find resource for bundle oracle.sysman.db.rsc.LoginResource, key connectStringError
at java.util.ResourceBundle.getObject(ResourceBundle.java:325)
at java.util.ResourceBundle.getObject(ResourceBundle.java:322)
at java.util.ResourceBundle.getString(ResourceBundle.java:285)
at oracle.sysman.emo.adm.LoginBean.getErrMsg(LoginBean.java:416)
at oracle.sysman.emo.adm.LoginBean.validate(LoginBean.java:241)
at oracle.sysman.emo.adm.LoginBean.login(LoginBean.java:268)
at oracle.sysman.db.adm.LoginController.doLogin(LoginController.java:572)
at oracle.sysman.db.adm.BaseController.redirectIfNotLoggedIn(BaseController.java:825)
at oracle.sysman.db.adm.BaseController.handleEvent(BaseController.java:929)
at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:376)
at oracle.sysman.db.adm.RootController.handleRequest(RootController.java:170)
at oracle.sysman.db.adm.DBControllerResolver.handleRequest(DBControllerResolver.java:114)
at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:688)
at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:291)
at oracle.sysman.eml.app.Console.doGet(Console.java:287)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:101)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
at oracle.sysman.db.adm.inst.HandleRepDownFilter.doFilter(HandleRepDownFilter.java:151)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:20)
at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:304)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:600)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
at java.lang.Thread.run(Thread.java:534)

Obrigado mais uma vez

Att,

Fábio Bohnstedt

[rmanParticipante]

@bohnstedt

Edit o .bash_profile do usuário oracle, adicione:


TZ=Etc/GMT+2; export TZ


No fim do horário de verão será necessário configurar para:


TZ=Etc/GMT+3; export TZ


Após editar o .bash_profile, atualize as variáveis de ambiente:


$ ./home/oracle/.bash_profile


Verifique se realmente foi setada a variavel TZ


$ echo $TZ


[bohnstedtParticipante]

@Rman, segue o resultado

-bash-3.2$ echo $TZ
Etc/GMT+2

Att,

Fábio Bohnstedt

[rmanParticipante]

@bohnstedt

Deu tudo certo ? O problema foi resolvido ?

[bohnstedtParticipante]

@Rman, infelizmente o problema não mudou em nada mesmo.

Att,

Fábio Bohnstedt

[rmanParticipante]

@bohnstedt

Agora com a variavel TZ configurada, refaça o repositório.

[bohnstedtParticipante]

@Rman, infelizmente acho q meu caso está bem complicado, veja só as evidências:
-bash-3.2$ emca -config dbcontrol db -repos create

STARTED EMCA at Nov 10, 2011 2:44:54 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: prod
Database Control is already configured for the database prod
You have chosen to configure Database Control for managing the database prod
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): [
Invalid email.
Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional):

You have specified the following settings

Database ORACLE_HOME ……………. /u01/app/oracle/product/10.2.0/db_1

Database hostname ……………. ca-db03.synchro.com.br
Listener port number ……………. 1521
Database SID ……………. prod
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………

---

Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 10, 2011 2:45:18 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2011-11-10_02-44-54-PM.log.
Nov 10, 2011 2:45:19 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) …
Nov 10, 2011 2:45:20 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) …
Nov 10, 2011 2:45:20 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Nov 10, 2011 2:45:20 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_repos_create_.log for more details.
Nov 10, 2011 2:45:20 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2011-11-10_02-44-54-PM.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2011-11-10_02-44-54-PM.log for more details.

e dando um cat no arquivo de log

oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..
ORA-06512: at line 17

    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1474)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:848)
    at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:267)
    at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:308)
    at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:422)
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:192)
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:134)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:171)
    at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
    at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)

Nov 10, 2011 2:45:20 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Nov 10, 2011 2:45:20 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_repos_create_.log for more details.
Nov 10, 2011 2:45:20 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/prod/emca_2011-11-10_02-44-54-PM.log for more details.
Nov 10, 2011 2:45:20 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:204)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:134)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:171)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)

Agora nem na tela mais está apresentando

Att,

Fábio Bohnstedt

[rmanParticipante]

@bohnstedt

Drop o repositório, baixe o listener e crie o repositório novamente.

[bohnstedtParticipante]

Amigos, muito obrigado pela ajuda, mas o problema ainda persiste, gostaria de fazer, mas fomos obrigados a chamar um dba externo.

Att,

Fábio

[Autor]

Posts