Oracle Database time and system time

Oracle Database time and system time

There is a huge gap between Oracle Database time and server system time, resulting in data confusion and report errors. The difference between database time and system time is about 16 hours.

The details are as follows:

The solution is as follows:

After checking that the database has a time difference, it hits BUG 14063047. For details, see the MOS document:

11.2.0.3 Wrong Sysdate Returned for Connections Through Listener if Database is Started With srvctl (Document ID 1476294.1)

The solution is as follows:

1. Use sqlplus on both nodes to restart the database (temporary solution). Do not use srvctl to restart the database.

2. Set database attributes under the oracle user (only one node is required) and restart the database:

Srvctl setenv database-d ipcc-t 'LD _ LIBRARY_PATH =/opt/oracle/database/product/11.2.0/lib'

Note: The above operations do not require the crs to be restarted. You only need to restart the database.