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

Issue: Frequent warning message in alert log
VKTM detected a time drift. Please check trace file for more details.

Error in trace file->
ksesethighpri: (ksb.c:4178) Failed to elevate VKTM's priority from 0 to 1
Error Info: Category(-2), Opname(skgdism_create), Loc(sp.c:1553), ErrMsg(Error 0) Dism(-1038804382)
*** SESSION ID:(1.1) 2014-06-10 20:15:51.823
*** SERVICE NAME:() 2014-06-10 20:15:51.823

kstmmainvktm: failed in setting elevated priority
Verify: SETUID is set on ORADISM and restart the instance
highres_enabled
VKTM running at (100ms) precision
kstmrmtickcntkeeper: param _dbrm_quantum will not be effective

*** 2014-06-10 20:15:51.823
[Start] HighResTick = 1402445751823794
kstmrmtickcnt = 0, ksudbrmseccnt[0] = 1402445751
kstmchkdrift (kstmrmtickcntkeeper:lowres): Time jumped forward by (8000000)usec at (1402445759) whereas (5000000) is allowed


Cause:
OSDBA has the wrong permissions on /etc/privgroup.


Solution:
1.Log in as the root user.
2.Using any text editor, open the /etc/privgroup file, or create it if
necessary.
3.Add or edit the following line, which begins with the name of the OSDBA
group, specifying the privileges RTPRIO and RTSCHED that you want to grant to
this group every time the system restarts (here dba is the OSDBA group):
dba RTPRIO RTSCHED
4.Save the file, and quit the text editor.
5.Enter the following command to grant the privileges to the OSDBA group:
# /usr/sbin/setprivgrp -f /etc/privgroup
6.Enter the following command to verify that the privileges are set
correctly:
# /usr/sbin/getprivgrp dba

Purge Inactive Sessions

Run "Purge Inactive Sessions" concurrent program in Oracle E-Business suite R12.1

This program will purge all session which are not active.

"Purge Inactive Sessions" concurrent program is not included in request group of  system administrator responsibility.

So first we need to add this request to system administrator responsibility request group.


Navigation:

login as sysadmin >

System Administrator > Security > Responsibility > Request

- Here search for Group "System Administrator"
Type: Program

- Add concurrent program "Purge Inactive Sessions"

- save

- Submit new request "Purge Inactive Sessions"

Or,

To Manually Purge the ICX tables:

E-Business suite 11i: $ICX_TOP/sql/ICXDLTMP.sql

E-Business suite R12: $FND_TOP/sql/FNDDLTMP.sql

ORA-39083: Object type PROCACT_SYSTEM failed to create with error

Issue:
While Import full database, few sql profiles were not imported

Error in Import File:
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-21560: argument 2 is null, invalid, or out of range
Failing sql is:
BEGIN
DECLARE
  sp_name VARCHAR2(30);
  sp_desc VARCHAR2(500);
  sp_category VARCHAR2(30);
  sp_force_match VARCHAR2(3);
  sp_sqltext CLOB;
  sp_hints CLOB;
  profile_already_exists exception;
  pragma EXCEPTION_INIT(profile_already_exists, -13829);
BEGIN
  sp_name := 'SYS_SQLPROF_014232aec76c0029';
  sp_desc := '';
  sp_category := 'DEFAULT';
  sp_force_match := 'NO';
     Completed 5 PROCACT_SYSTEM objects in 69 seconds


Cause:
Import of sql profile SYS_SQLPROF_014232aec76c0029 is causing the problem.


Solution:
Currently there is No Permanent Solution of this issue.Bug 18137408 is under development team.


Workaround:
Note# 457531.1 - How to Move SQL Profiles from One Database to Another (Including to Higher Versions) 

afcpctx.sh failed during autoconfig.sh with INSTE8_PRF 137

afcpctx.sh failed during autoconfig.sh with INSTE8_PRF 137

While cloning of Oracle E-Business suite R12.1.3 application on Sun Solaris 10 64-bit sparc platform I have encountered this Error

afcpctx.sh              INSTE8_PRF         137


Solution:
bash-3.00$ cd $FND_TOP/bin

bash-3.00$ ldd -d FNDCPUCF
        libnnz10.so =>   /data/R12base/apps/tech_st/10.1.2/lib32/libnnz10.so
        libkstat.so.1 =>         /lib/libkstat.so.1
        libnsl.so.1 =>   /lib/libnsl.so.1
        libsocket.so.1 =>        /lib/libsocket.so.1
        libgen.so.1 =>   /lib/libgen.so.1
        libdl.so.1 =>    /lib/libdl.so.1
        libsched.so.1 =>         /usr/lib/libsched.so.1
        libaio.so.1 =>   /lib/libaio.so.1
        librt.so.1 =>    /lib/librt.so.1
        libm.so.1 =>     /lib/libm.so.1
        libclntsh.so.10.1 =>     /data/R12base/apps/tech_st/10.1.2/lib/libclntsh.so.10.1  - wrong ELF class: ELFCLASS64
        libpthread.so.1 =>       /lib/libpthread.so.1
        libc.so.1 =>     /lib/libc.so.1



bash-3.00$ echo $ORACLE_HOME
bash-3.00$ ln -s $ORACLE_HOME/lib/ldflags $ORACLE_HOME/lib32/ldflags
bash-3.00$ ls -ltr $ORACLE_HOME/lib32/ldflags
bash-3.00$ genclntsh
bash-3.00$ relink all


- After performing all above steps check again:


bash-3.00$ cd $FND_TOP/bin
bash-3.00$ ldd -d FNDCPUCF
        libnnz10.so =>   /appl/R12base/apps/tech_st/10.1.2/lib32/libnnz10.so
        libkstat.so.1 =>         /lib/libkstat.so.1
        libnsl.so.1 =>   /lib/libnsl.so.1
        libsocket.so.1 =>        /lib/libsocket.so.1
        libgen.so.1 =>   /lib/libgen.so.1
        libdl.so.1 =>    /lib/libdl.so.1
        libsched.so.1 =>         /usr/lib/libsched.so.1
        libaio.so.1 =>   /lib/libaio.so.1
        librt.so.1 =>    /lib/librt.so.1
        libm.so.1 =>     /lib/libm.so.1
        libclntsh.so.10.1 =>     /appl/R12base/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1
        libpthread.so.1 =>       /lib/libpthread.so.1
        libc.so.1 =>     /lib/libc.so.1
        libmp.so.2 =>    /lib/libmp.so.2
        libmd.so.1 =>    /lib/libmd.so.1
        libscf.so.1 =>   /lib/libscf.so.1


Now, run autoconfig again