Patching Issues

 The below opatch issues we can get source or Cloned instance

-bash-3.00$ pwd

/u01/oradb/db/tech_st/11.2.0/OPatch

-bash-3.00$ opatch lsinventory

OPatch failed with error code 104

Solution:

Step 1:-check the oraInst.loc file has created or not at OS Level under /var/opt/oracle/

If not, copy the oraInst.loc from $ORACLE_HOME to /var/opt/oracle/ directory.
Note: /var/opt is Solaris platform .Remaining platforms may be different at OS level

-bash-3.00$cp $ORACLE_HOME /orainst.loc /var/opt/oracle

vi /var/opt/oracle/oraInst.loc

inventory_loc=$ORACLE_HOME/admin/oui/<SID>_<hostname>/oraInventory

Suppose if oraInst.loc file exist but we are getting the error. Then

Step 2:-

-bash-3.00$opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc

OPatch succeeded.

If above command also not working then

Step3:-we check the files ContentsXML, install. Platform,

logs and oraInstaller.properties are exist or not below location /u01/oradb/db/tech_st/11.2.0/admin/oui/<SID>_<hostname>/oraInventory

If not, copy from source instance to above location.

Step 4: if files are exist then

-bash-3.00$ cd ContentsXML

-bash-3.00$ ls

comps.xml inventory.xml libs.xml

-bash-3.00$ view inventory.xml

<?xml version="1.0" standalone="yes" ?>

<!-- Copyright (c) 1999, 2008, Oracle. All rights reserved. -->

<!-- Do not modify the contents of this file by hand. -->

<INVENTORY>

<VERSION_INFO>

<SAVED_WITH>11.2.0.3.0</SAVED_WITH>

<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<HOME NAME="TEST1_DB__u01_oradb_db_tech_st_11_2_0" LOC="/u01/oradb/db/tech_st/11.2.0" TYPE="O" IDX="1"/>

</HOME_LIST>

</INVENTORY>

Note: here <HOME NAME> we have to provide the our instance name and Oracle home details

After applying  ATG_PF.C.DELTA.7 patch while accessing the login page on webauth or sso level getting the error as Requested resource or page is not allowed in this site

24690680:Patch R12.ATG_PF.C.delta.7: R12.ATG_PF.C.DELTA.7

Sol: Login to sysadmin user local login level

change the profile option from Security: Allowed Resources from CONFIG to ALL

then try to login webuth or SSO level