How to change the Timezone for any specific OEM Agent

Himanshu funoracleapps , Oracle 1 comment

How to change the Timezone for any specific OEM Agent

In this post I am going to share how to change the timezone of an OEM Agent.

Steps:

1) Check Current Timezone of the agent from the OEM repository database

select target_name, timezone_region

from sysman.mgmt_targets

where target_name='funoracleapps.lab'

order by 1,2;

2) Stop the Agent having wrong timezone

emctl stop agent

3) Reset Timezone for agent

emctl resetTZ agent

It will give command to run on OEM repository like below

Oracle Enterprise Manager Cloud Control 12c Release 5

Updating /oem/oracle/agent12c/agent_inst/sysman/config/emd.properties...

Successfully updated /oem/oracle/agent12c/agent_inst/sysman/config/emd.properties.

exec mgmt_target.set_agent_tzrgn('funoracleapps.lab:3872','Asia/Singapore')

and commit the changes

This can be done for example by logging into sqlplus and doing

SQL> exec mgmt_target.set_agent_tzrgn('funoracleapps.lab:3872','Asia/Singapore')

SQL> commit

4) Execute command on the OEM respository database

SQL> exec mgmt_target.set_agent_tzrgn('funoracleapps.lab:3872','Asia/Singapore')

SQL> commit

Commit complete.

5) Check the OEM Repository again

select target_name, timezone_region

from sysman.mgmt_targets

where target_name='funoracleapps.lab'

order by 1,2;

6) Start agent again

emctl start agent

1 comment :

Post a Comment

Queries related to Lookup in Oracle EBS

Himanshu funoracleapps No comments

Queries related to Lookup in Oracle EBS

Scripts:

Lookup Information:

select *

from apps.fnd_lookup_types_vl

Where lookup_type = '&lookup_type';

Values of lookup:

select *

from apps.fnd_lookup_values

Where lookup_type = '&lookup_type';

No comments :

Post a Comment

How to Change the Interface Name in Linux

Himanshu Linux No comments

How to Change the Interface Name in Linux

Old Name: ens192

New Name: eth0

Check interface details

/etc/init.d/network status shows this output:

Configured devices:

lo eth0

Currently active devices:

lo enp192

Rename the interface

ip link set enp192 down

ip link set enp192 name eth0

ip link set eth0 up

Move configuration file and update the values

mv /etc/sysconfig/network-scripts/ifcfg-{enp192,eth0}

sed -ire "s/NAME=\"enp192\"/NAME=\"eth0\"/" /etc/sysconfig/network-scripts/ifcfg-eth0

sed -ire "s/DEVICE=\"enp192\"/NAME=\"eth0\"/" /etc/sysconfig/network-scripts/ifcfg-eth0

No comments :

Post a Comment

How to Set or Change the Time Zone in Linux Server

Himanshu funoracleapps No comments

How to Set or Change the Time Zone in Linux Server

1. Check the Current Time Zone

timedatectl

Local time: Mon 2020-07-06 22:22:40 +08

Universal time: Mon 2020-07-06 14:22:40 UTC

RTC time: Mon 2020-07-06 14:22:40

Time zone: Asia/Singapore (+08, +0800)

NTP enabled: yes

NTP synchronized: yes

RTC in local TZ: no

DST active: n/a

The output above shows that the system’s time zone is set to Singapore.

The system time zone is configured by a link i.e. /etc/localtime file to a binary time zone’s identifier in the /usr/share/zoneinfo directory.

$ ls -l /etc/localtime

lrwxrwxrwx 1 root root 36 Jul 6 22:03 /etc/localtime -> ../usr/share/zoneinfo/Asia/Singapore

2. Change the Time Zone Now

Make sure to identify the exact time zone which needs to be set in Region/City format.

To view all available time zones, use the timedatectl command or list the files in the /usr/share/zoneinfo directory:

# timedatectl list-timezones

America/Montserrat

America/Nassau

America/New_York

America/Nipigon

America/Nome

America/Noronha

Run Command

sudo timedatectl set-timezone America/New_York

or doing in UTC then

sudo timedatectl set-timezone UTC

To verify the change, invoke the timedatectl command again:

timedatectl

Local time: Mon 2020-07-06 14:28:53 UTC

Universal time: Mon 2020-07-06 14:28:53 UTC

RTC time: Mon 2020-07-06 14:28:53

Time zone: UTC (UTC, +0000)

NTP enabled: no

NTP synchronized: yes

RTC in local TZ: yes

DST active: n/a

--------------------------------------------------------------------------

We can also change Time Zone by Creating a Symlink(Especially used in old system)

If you are running an older Linux distribution and the timedatectl utility is not present on your system, you can change the timezone by symlinking /etc/localtime to the time zone in the /usr/share/zoneinfo directory.

Remove the current symlink or file:

sudo rm -rf /etc/localtime or sudo unlink /etc/localtime

Identify the timezone you want to configure and create a symlink:

sudo ln -s /usr/share/zoneinfo/UTC /etc/localtime

Verify the /etc/localtime file

ls -l /etc/localtime

lrwxrwxrwx. 1 root root 25 Jul 6 2020 /etc/localtime -> ../usr/share/zoneinfo/UTC

No comments :

Post a Comment

Subscribe to: Posts ( Atom )

Stay at Home!! Be Safe!! Take Care!!

How to change the Timezone for any specific OEM Agent

How to change the Timezone for any specific OEM Agent

1 comment :