02 November 2010

Fixing problem with: java.lang.Exception: No Such Target

Oracle Enterprise Manager has got this error

Fixing problem in 4 steps


Step 1
/emctl start dbconsole
Step 2
/emctl resetTZ agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
Updating D:\oracle\product\10.2.0\db_1/olymp.___.ru_rtl/sysman/config/emd.properties...
Time zone set to Europe/Moscow.
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('olymp.___.ru:3938','Europe/Moscow')
                        -- 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('olymp.___.ru:3938','Europe/Moscow')
Step 3
 ... execute statements above
Step 4
/emctl start dbconsole

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete