Pular para o conteúdo

Fóruns Banco de dados Oracle Erro ao startar a DBCONSOLE Erro ao startar a DBCONSOLE

#101537
bohnstedt
Participante

    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