DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, February 13, 2017

Resolving OPatch failed with error code 73

 opatch apply
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-02-07_23-48-44PM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:


Following executables are active :
/u01/app/oracle/product/12.1.0.2/db_1/bin/oracle
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-02-07_23-48-44PM_1.log

OPatch failed with error code 73


$ fuser /u01/app/oracle/product/12.1.0.2/db_1/bin/oracle
/u01/app/oracle/product/12.1.0.2/db_1/bin/oracle: 8291e

[oracle@bosdoradb01:TEST] ps -ef|grep 8291
oracle    8291     1  1 00:05 ?        00:00:00 oracle TEST(LOCAL=NO)
oracle    8861 45368  0 00:06 pts/14   00:00:00 grep 291

$ kill -9 8291

$opatch apply
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-02-07_23-48-44PM_1.log

.
.
.
.
Opatch Succeed

Unable to create Patch Object error applying 12.1.0.2 Oct Patch

$opatch prereq CheckConflictAgainstOHWith
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-02-07_23-31-04PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" is not executed.

The details are:
Unable to create Patch Object.
Exception occured : PatchObject constructor: Input file "/u01/app/oracle/product/12.1.0.2/db_1/OPatch/auto/etc/config/actions" or "/u01/app/oracle/product/12.1.0.2/db_1/OPatch/auto/etc/config/inventory" does not exist.

OPatch failed with error code 2



To Resolve the issue:

Finding the issue:

Unable to create Patch Object.
Exception occured : PatchObject constructor: Input file
"/u01/app/oracle/product/12.1.0.2/db_1/OPatch/auto/etc/config/actions"
or "/u01/app/oracle/product/12.1.0.2/db_1/OPatch/auto/etc/config/inventory" does not exist.

Note : Opatch is looking for a inventory directory is in wrong location  due to that the issue occurred. Change the correct directory and execute the patch again.

Solution:

We changed the working directory to patch location then issue got fixed.

Chech the Patch Conflict Again:
--------------------------------------
$ opatch prereq CheckConflictAgainstOHWithD
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-02-07_23-36-37PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.



Friday, February 10, 2017


                        Getting Application User Password in R12 

Step 1 :

CREATE OR REPLACE PACKAGE get_pwd
AS
   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
      RETURN VARCHAR2;
END get_pwd;
/

Step 2 :

CREATE OR REPLACE PACKAGE BODY get_pwd
AS
   FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
      RETURN VARCHAR2
   AS
      LANGUAGE JAVA
      NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
END get_pwd;
/

Step 3 :

SELECT usr.user_name,
       get_pwd.decrypt
          ((SELECT (SELECT get_pwd.decrypt
                              (fnd_web_sec.get_guest_username_pwd,
                               usertable.encrypted_foundation_password
                              )
                      FROM DUAL) AS apps_password
              FROM fnd_user usertable
             WHERE usertable.user_name =
                      (SELECT SUBSTR
                                  (fnd_web_sec.get_guest_username_pwd,
                                   1,
                                     INSTR
                                          (fnd_web_sec.get_guest_username_pwd,
                                           '/'
                                          )
                                   - 1
                                  )
                         FROM DUAL)),
           usr.encrypted_user_password
          ) PASSWORD
  FROM fnd_user usr
 WHERE usr.user_name = '&USER_NAME';


Sunday, February 5, 2017

There are no active responsibilities available for this user

Missing SYSADMIN Responsibility After Upgrade To 12.1.3.

When you log in, your  home page displays an empty list of responsibilities and message,
Same issue is faced by all the users including SYSADMIN.

Cause:

EFFECTIVE_START_DATE and EFFECTIVE_END_DATE in WF_LOCAL_USER_ROLES and WF_USER_ROLE_ASSIGNMENTS tables are not correctly synchronized.


Solution:

Login into apps schema,

We have to execute wf_maintenance.ValidateUserRoles API.

sqlplus apps/apps

begin
wf_maintenance.ValidateUserRoles(p_BatchSize => NULL, p_check_dangling => TRUE, p_check_missing_ura => TRUE, p_UpdateWho => FALSE);
end;
/