Oracle Database time and system time

Source: Internet
Author: User
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.

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.

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.

This article permanently updates the link address:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.