Tags

, , , ,

Problem Summary

VKTM detected a time drift. Please check trace file for more details.

Download and apply patch # 11837095.

  • After applying the patch, enable event 10975 at level 2:

alter system set event=”10795 trace name context forever, level 2″ scope=spfile;

  • Then bounce the instance (shutdown then startup) for the event to be applied.

cd /etc/
cat oratab
mv oratab oratab.xxx

cd /etc
mv oraInst.loc oraInst.xxx

cd $ORACLE_HOME
mv OPatch OPatch_old
unzip p6880880_112000_AIX64-5L.zip –> Latest Version of OPatch

cd /tmp/oracle_setup/psu/
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./11837095
cd /tmp/oracle_setup/psu/11837095
opatch apply

“OPatch succeeded.”

sqlplus / as sysdba
startup;

    alter system set event="10795 trace name context forever, level 2" scope=spfile;

    shutdown immediate;
    startup;

lsnrctl start xxx

Deinstallation

To deinstall the patch, follow these steps:
Note: In case of an Oracle RAC environment, perform these steps on each of the nodes.

  1. Navigate to the /11837095 directory:
    $ cd /11837095

  2. Deinstall the patch by running the following command:
    $ opatch rollback -id 11837095

  3. Start the services from the Oracle home.

Bugs Fixed by This Patch

The following are the bugs fixed by this patch:
11837095: “TIME DRIFT DETECTED” APPEARS INTERMITTENTLY IN ALERT LOG, THO’ EVENT 10795 SET