› Fóruns › Banco de dados Oracle › Erro ao startar a DBCONSOLE › Erro ao startar a DBCONSOLE
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