How To Modify The Database Time To Current Date On The EBS Instance
Last updated on JUNE 01, 2016
Applies to:Oracle Application Object Library - Version 126.96.36.199 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Need to modify the wrong database time to current date on the EBS instance.
Check as below scenario:
1. Login DB server as DB node user. e.g. oravis
>sqlplus / as sysdba
SQL>alter session set nls_date_format = 'mm/dd/yyyy hh24:mi:ss';
SQL>select sysdate from dual;
SQL> host date;
Fri Aug 23 15:08:55 CST 2013
6. But currently, the actual time is 08/23/2013 09:09:25.
The database time is 6 hours ahead of the current date and need to modify the database server time to be correct.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms