My Oracle Support Banner

Grid Agent Configuration: "ORA-20233: Invalid Agent name" When Running mgmt_target.set_agent_tzrgn Procedure in Repository DB (Doc ID 388280.1)

Last updated on DECEMBER 11, 2019

Applies to:

Enterprise Manager Base Platform - Version to [Release 10.1 to 11.1]
Information in this document applies to any platform.


When the Agent is unable to startup due to timezone (TZ) issues, troubleshooting steps as suggested in <Note 330737.1>: Grid Agent Configuration: How to Troubleshoot Timezone Issues in Enterprise Manager Grid Agent Setup, are followed:

-  Comment out the agentTZRegion parameter in the <AGENT_HOME>/sysman/config/ file.
-  Choose the correct value of TZ which is present in the following files:

<AGENT_HOME>/sysman/admin/supportedtzs.lst and

-  Set the TZ at the OS level to above chosen value.
-  Reset the timezone of the agent using:

cd <AGENT_HOME>/bin
emctl resetTZ agent

This will return an output similar to:

$ emctl resetTZ agent
Oracle Enterprise Manager 10g Release 5 Grid Control
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
Updating <AGENT_HOME>/sysman/config/
Successfully updated <AGENT_HOME>/sysman/config/
Login as the em repository user and run the script:
exec mgmt_target.set_agent_tzrgn('<AGENT_HOSTNAME>:<AGENT_PORT>','Asia/Calcutta')
and commit the changes
This can be done for example by logging into sqlplus and doing
SQL> exec mgmt_target.set_agent_tzrgn('<AGENT_HOSTNAME>:<AGENT_PORT>','Asia/Calcutta')
SQL> commit

 -  But connecting to the Repository as sysman user and executing the above command fails with:

SQL> exec mgmt_target.set_agent_tzrgn('<AGENT_HOSTNAME>:<AGENT_PORT>','Asia/Calcutta')
fails with :

ERROR at line 1:
ORA-20233: Invalid agent name <AGENT_HOSTNAME>:<AGENT_PORT>
ORA-06512: at "SYSMAN.MGMT_TARGET", line 3683
ORA-06512: at line 1


This is a new installation of the Agent or Agent is being started up after deletion of all targets from the Grid Console.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.