AWS RDS : Changing OS time zone

This entry helps you change the database time zone: http://cloudconclave.blogspot.com/2013/08/aws-rds-timezone.html

However, it does not address changed the operating system time zone.  With RDS, the OS timezone can’t be changed (UTC, by design).  Each database engine supports different functions that query OS (for Oracle it is sysdate),   database engine, or session level parameters for timezone information . 

Here’s a quick synopsis of each DB engine’s datetime function details which identifies which calls are OS, database instance, or session based and which include timezone information or if its implied:

·         MySQL: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

·         Oracle: http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm#g1010984

·         SQL Server: http://msdn.microsoft.com/en-us/library/ms186724.aspx

Oracle Enterprise Manager and AWS EC2 instance restart

Question: An EC2 restart causes OEM to loss IP address of OEM management console - Is there a way to attach a static IP address to an EC2 instance instead the default o

ec2 IP.compute-1.amazonaws.com Response: If you assign an Elastic IP address to the EC2  instance before installing OEM, then you should have no problem.     Once the EC2 instance has been created (without an EIP) and  OEM has been installed there is no  other way to do it except to use this workaround -  http://cloudconclave.blogspot.com/2012/12/oracle-enterprise-manager-on-ec2-ip.html

Oracle Enterprise Manager on EC2 - IP address change after reboot

The script (/usr/local/bin/sethostname) to be run by cron:

·        Login as root.

·        vi /usr/local/bin/sethostname

·        Place the following line in the /usr/local/bin/sethostname

       echo desired_hostname > /proc/sys/kernel/hostname

·        chmod 755 /usr/local/bin/sethostname

·        Issue crontab –e and place the following line in the cron tab and save.

   # SET HOSTNAME

   * * * * * /usr/local/bin/sethostname >> /usr/local/bin/sethostname.log 2>&1

·        The desired_hostname and IP entry needs to be in the /etc/hosts file

desired_hostname = Hostname of your choice.

This is work around to this known limitation: http://taliphakanozturken.wordpress.com/2011/12/31/oem-configuration-when-the-database-host-name-or-ip-address-changes/