Timezone for Enterprise Manager Console

Introduction:

The Linux Timezone must be in-line with the Oracle Enterprise Manager on order for the DB Console to start.

Aim:

Align the Timezones.

Requirements:

Oracle Enterprise Manager 10g is installed.

Procedure:

Symptom:

• Log in as oracle.
• Open Terminal.
• Set the SID to the database that serves the DB Console, in my case whs:
• $ chora whs
  
• Start the console:
• $ emctl start dbconsole
• The script begins to execute but the craps out complaining about 'Timezone mismatch'.

Fix:

• Restart the database:
• $ su -
• Password: *********
• # servive oracle10g restart
• # exit
  
• Run the fix script:
• $ emctl resetTZ agent
• This does a partial fix and then advises you to do either of two actions. The first is the slightly simpler one. Note the suggested command. This contains a port number that may be unique for each installation. The command look something like:
• exec mgmt_target.set_agent_tzrgn('lisa.steveroach.org:1830', 'Australia/Sydney')
  
• Log in to the database that serves the DB Console, in my case whs, as sys:
• $ sqlplus sys@whs as sysdba
• Enter password: *********
• > alter session set current_schema = SYSMAN;
• Run the command:
• SQL> exec mgmt_target.set_agent_tzrgn('lisa.steveroach.org:1830', 'Australia/Sydney'); - don't forget the trailing semi-colon.
• If this returns with; 'PL/SQL procedure successfully completed.'
• SQL> exit
• Otherwise, if it errors with ; 'ORA-20233: Invalid agent name...':
• Get the real agent name:
• > SELECT target_name
• FROM mgmt_targets
• WHERE target_type = 'oracle_emd';
• The port number is probably wrong. Replace this in the 'exec...' command are retry it.
  

Testing:

• Start the console:
• $ emctl start dbconsole
• This comes back witha URL (which you should note down) and then; '...started.'