31 August 2015

DRG-10595: ALTER INDEX JTF_AMV_ITEMS_URL_CTX failed

R12.2.0 upgrade from R12.1.1 auto config failed with DRG-10595: ALTER INDEX JTF_AMV_ITEMS_URL_CTX failed

[applmgr@r1224 scripts]$ ./adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /apps/fs1/inst/apps/PROD_r1224/admin/log/08312036/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /apps/fs1/inst/apps/PROD_r1224
        Classpath                   : /apps/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/apps/fs1/EBSapps/comn/java/classes

        Using Context file          : /apps/fs1/inst/apps/PROD_r1224/appl/admin/PROD_r1224.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring CZ_TOP........COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed with errors.
[applmgr@r1224 scripts]$


Error :

Executing script in InstantiateFile:
/apps/fs1/inst/apps/PROD_r1224/admin/install/jtfictx.sh
script returned:
****************************************************

jtfictx.sh started at Mon Aug 31 20:37:00 IST 2015


SQL*Plus: Release 10.1.0.5.0 - Production on Mon Aug 31 20:37:00 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
DECLARE
*
ERROR at line 1:
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX JTF_AMV_ITEMS_URL_CTX failed
DRG-11000: invalid keyword SYNC
ORA-06512: at "SYS.DBMS_SQL", line 1120
ORA-06512: at line 96


Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Solution :-

apply p19587162_R12.JTA.C_R12_GENERIC.zip

[applmgr@r1224 scripts]$ ./adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /apps/fs1/inst/apps/PROD_r1224/admin/log/08312102/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /apps/fs1/inst/apps/PROD_r1224
        Classpath                   : /apps/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/apps/fs1/EBSapps/comn/java/classes

        Using Context file          : /apps/fs1/inst/apps/PROD_r1224/appl/admin/PROD_r1224.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring CZ_TOP........COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[applmgr@r1224 scripts]$

26 August 2015

ORA-28040: No matching authentication protocol

R12.2.0 Upgrade with 12.1.0.2 Database rapidwiz failed


Existing DB SID validation
Existing DB SID validation has failed.
Connection to database failed.  Unable to validate the current SID

DB Version Check
DB Version Check has failed.
Not able to check the Database version. Please make sure the Database is at 11.2.0.3 or higher

Unable to connect to the database as system, incorrect password   RW-40000: Warning: Unable to establish a Database connection. Please make sure the database is up before continuing with this install. Connection string used - jdbc:oracle:thin:@r1224.muthu.com:1526:PROD

DB service_names Check
DB service_names Check has failed.
Not able to check if ebs_patch as an entry exists in Database service_names parameter.





Log file Error:


ORA-28040: No matching authentication protocol




Solution :

Set SQLNET.ALLOWED_LOGON_VERSION=8 in the oracle/network/admin/sqlnet.ora file.

Restart your database.