Join the supporters of the Stop Global Warming Virtual March
Main Menu
HomeBasicsFusionPS on LinuxSecurityDocumentsScriptsSearchFeedsWeb LinksSiteMapForumPodCastsGuest BookPeopleSoft Jobs
Translation
Translation may not be accurate.
** Thanks to Google Anyway***


To Change between languages
go to English and change again.
Login Form





Lost Password?
No account yet? Register
FeedBurner
Get Postings by Email
without Account.


Who's Online
Statistics
Postings: 65
PeopleSoft Blog Feeds: 15
PeopleSoft Job Feeds: 16
Oracle Feeds: 12

Registered Members: 203
Unique Visitors: 357807
Syndicate
Home arrow PS on Linux arrow How Do I Setup NTP Client for PeoleSoft DB Servers?
How Do I Setup NTP Client for PeoleSoft DB Servers? PDF Print E-mail
Written by RD   
Wednesday, 20 February 2008

W
hy do we need to have sync up your servers with NTP [Network Time Protocol] server/service?  Especially for the servers hosting PeopleSoft  Databases. When a process runs or a schedule job gets kicked off through process scheduler, it uses the sysdate from the database. The database gets its timestamp from the server OS where database is installed.

There could be many issues with the system time is not in sync with the actual time. Especially in places where the jobs run for different applications including PeopleSoft and other application jobs integrated with PeopleSoft jobs using tools like CONTROL-M, the requirement to have the server times synced is very important.  Else the processes will not start and run as planned. It is more critical if your managing global system and it has been accessed globally at different time zones.

Here is the simple and easiest way to set this up.The below commands would work on CentOS Linux and Red Hat Enterprise Linux. [Need root access]

 RHEL:

    • 1. Install the NTP package if it is not already installed. Check if you have it installed already. Mostly it is installed. [command: rpm –q ntp]:
      • # yum install ntp
    • 2. To have the NTP service started at boot time:
      • # chkconfig --levels 235 ntpd on
    • 3. Specify the NTP server you’ll be synchronizing with:
      • # ntpdate 0.pool.ntp.org
    • 4. Start the NTP service:
      • # service ntpd start

Visit http://support.ntp.org/bin/view/Servers/NTPPoolServers and find the list of public ntp servers which can be synced with in your time zone.

NTP configurations are stored in /ete/ntp.conf. Check this for more customization and options of more secondary NTP servers.

 Solaris 9:

  • # ntpdate -q 0.pool.ntp.org     -- to check if there is no permission to access the ntp server
  • # /etc/rc2.d/S74xntpd stop      -- to stop the service before changing
  • # ntpdate -b 0.pool.ntp.org      -- to set the server
  • # /etc/rc2.d/S74xntpd start       -- to start the service
  • # ntpq -p                                     -- this command will check if it is set properly
  •      remote           refid      st t when poll reach   delay   offset    disp
    ==============================================================================
     hatch.dayww.net time-A.timefreq  2 u   31   64    3    41.43  -78.815 7876.13
     druid.storyinme navobs1.gatech.  2 u   31   64    3    71.35  -83.814 7877.24

config file for Solaris /etc/inet/ntp.conf


Add as favourites (32) | Quote this article on your site | Views: 1420 | Print

Comments (6)
RSS comments
1. 02-22-2008 09:56
 
Is it better to have SNTP instead of NTP client in the system?
Guest
 
Gary T
2. 09-05-2008 15:41
 
If your operations department has its own step time server, you can sync up your server with that server instead of syncing to ntp.org servers. 
 
To check if your local timeserver is the step time server and it is accessible or not, you can run this command: 
 
ntpdate -q This e-mail address is being protected from spam bots, you need JavaScript enabled to view it  
You will get repose like this: 
 
server 111.222.33.44, stratum 3, offset 0.098089, delay 0.05698 
22 Feb 11:05:58 ntpdate[9767]: adjust time server 111.222.33.33 offset 0.098089 sec 
 
[ It will display the actual IPS of your servers – I’ve scrambled the IP here] 
 
SNTP does not mean it is secured. 
SNTP-Simple Network Time Protocol and to know more about SNTP and NTP difference you can check it here or here 
 
--RD
Registered
 
RD
3. 02-26-2008 08:16
 
Is there a way to sync up the Windows Servers?
Guest
 
AaronB
4. 02-26-2008 15:44
 
Honestly I haven't done any NTP sync in windows server. I found this link which looks like the right way to do. I cross checked with my Desktop, which was done at my work place, and found it is same. You may want to check with your company's policy to identify the time server.  
 
Also you may want to test it before implementing in any production server. 
 
Here is the link: 
 
http://www.windowsnetworking.com/articles_tutorials/Configuring-Windows-Time-Service.html
Registered
 
RD
5. 05-12-2008 01:07
 
In RH linux ntp client sucks, I have done all configuration but ntp not sync to my local ntp server.
Guest
 
Mahmood Sarfraz
6. 05-13-2008 16:22
 
I have done that in more than 10 boxes and did not have any issue. 
 
Can you try with any of the pool.ntp.org and check? Might be the issue is with your local ntp server. 
Sometime access permission might be an issue.
Registered
 
RD

Write Comment
  • Thankyou for your comments.
  • Feel free to comment if there are any mistake in the postings also.
  • If you have a Blog or website, feel free to provide the link. We will take a peak.
  • Just ensure to *Refresh* your browser for a new security code to be displayed prior to clicking on the 'Send' button.
  • Keep in mind that the above process only applies if you simply entered the wrong security code.
Name:
Homepage
BBCode:Web AddressEmail AddressBold TextItalic TextUnderlined TextQuoteCodeOpen ListList ItemClose List
Comment:

Code:* Code
I wish to be contacted by email regarding additional comments

Copy Right: AKOComments v.1.4.6

Last Updated ( Monday, 25 August 2008 )
 
< Prev   Next >

xkcd and whatever..?

© 2009 PSADMIN.org
PSAdmin.org is for & by the PeopleSoft Administrators to share their Experience.