RSS

Monthly Archives: January 2013

Linux Red Hat Configure an NTP Client

steps to configure an NTP Client in Linux RHEL 4.5

1)Install ntp
# yum install ntp

2)configure an NTP Client
# vi /etc/ntp.conf

add in the # — OUR TIMESERVERS —– section
server ntp.server.com or
server <ip>
$$$$$$$$$$$$$$$$$$$$$$$$
server 10.0.0.30
$$$$$$$$$$$$$$$$$$$$$$$$

the hostname or IP address of the site NTP server. If your ntp server located at 192.168.1.5, enter server 192.168.1.5. You can also use public ntp server located at ntp.org.

You can also run ntpd using cron:
echo ’30 * * * * root /usr/sbin/ntpd -q -u ntp:ntp’ > /etc/cron.d/ntpd
“that what i use”

3) restart the service

# service ntp restart
or
#etc/init.d/ntpd restart

Monitoring and Troubleshooting
#ntpq -p
The labeled columns for this are:
– remote: The IP address or DNS name of the remote server
-refid: An identification of the type of the reference clock.
-st: The “stratum” or level of the server: for almost all systems, 2 is great. Your local system will have a higher number.
-t: The type of service. Your setup will show “l” for local on your local system, or “u” for “unicast” for communicating with remote servers.
-when: This is the number of seconds since the server was last heard from. After a couple of minutes of operation your server should start to report numeric values here.

#tcpdump udp port 123

#ntpdate -q <ntp server name OR ntp servr ip>

$$$$$$$$$$$$$$$$$$
ntpdate -q 10.0.0.30
$$$$$$$$$$$$$$$$$$

Reference:

http://www.cyberciti.biz/faq/rhel-fedora-centos-configure-ntp-client-server/

http://perdues.com/doc/ntp.html

 

 

————-

configure NTP client “GUI”

issue the following command line:

# system-config-date

this will open a window called “Date/Time proprieties”

1) enable the NTP

2) enter the hostname or IP of NTP server

3) from advanced options :un-check: Use Local time source and check: Enable NTP brodcast

system-config-date

Muhammad Rashed

 
1 Comment

Posted by on January 15, 2013 in OS, Tips

 

Tags: , , , , ,

SQL to get profile option values list using specific criteria

 

[HTD000069] Oracle E-Business Suite Show Active Database Sessions Details (Machine, Program, Module, Username, Action,…… )

 

Oracle E-Business Suite Show Active Database Sessions Details (Machine, Program, Module, Username, Action,…… )

 

[HTD000071] Forms Personalization: How To Pass Function Parameters

 
Leave a comment

Posted by on January 9, 2013 in apps_dba, E-Business Suite

 

[HTD000065] Oracle E-Business Suite Priority for Concurrent Program

 

Oracle 11i/R12 List all Requests/Programs within a Responsibility

 
SELECT DISTINCT FCPT.USER_CONCURRENT_PROGRAM_NAME,
 FCPT.DESCRIPTION,
 FA_VL.APPLICATION_NAME,
 FA_VL.APPLICATION_SHORT_NAME,
 RSP_TL.RESPONSIBILITY_NAME
 , FRG.REQUEST_GROUP_NAME

FROM FND_REQUEST_GROUPS FRG,FND_CONCURRENT_PROGRAMS_TL FCPT

 INNER JOIN FND_REQUEST_GROUP_UNITS FRGU
 ON FCPT.CONCURRENT_PROGRAM_ID = FRGU.REQUEST_UNIT_ID
 OR FCPT.APPLICATION_ID = FRGU.APPLICATION_ID

 INNER JOIN FND_RESPONSIBILITY FR
 ON FR.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID

 INNER JOIN FND_RESPONSIBILITY_TL RSP_TL
 ON FR.RESPONSIBILITY_ID = RSP_TL.RESPONSIBILITY_ID

 INNER JOIN FND_APPLICATION_VL FA_VL
 ON FA_VL.APPLICATION_ID = FCPT.APPLICATION_ID

WHERE UPPER (FCPT.USER_CONCURRENT_PROGRAM_NAME) LIKE
    NVL (UPPER ('%' || :_PROGRAM_NAME || '%'), '')
  AND UPPER (RESPONSIBILITY_NAME) LIKE
    NVL (UPPER ('%' || :RESPONSIBILITY_NAME || '%'), '')
  AND FCPT.LANGUAGE = USERENV ('LANG')
  AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
ORDER BY 3, 1;
 
Leave a comment

Posted by on January 5, 2013 in Queries

 

Tags: , , , , ,