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

For Any queries, please mail us at support@funoracleapps.com

How to change the Timezone for any specific OEM Agent

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

Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.

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

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

Login as the em repository user and run the  script:

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

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

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

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