Issue : Autoconfig failed due to mismatch in "s_global_database_name" & "s_dbService" values in Database $CONTEXT_FILE

+++++++++++++++=
Architecture : 
++++++++++++++++
Apps : 12.0.6
DB   : 10.2.0.5
Activity : CPU Patching for APPS & IAS and PSU patching for DB
+++++++++++++++++


While performing autoconfig on MT it failed.
Extracted the errors from the Terminal and log files are as follows :

$  tail -f $APPL_TOP/admin/KIRANG/log/adconfig/adconfig_120714233022.log
        Using Context file          : /KIRANG/inst/apps/KIRANG_ramuginni/appl/admin/KIRANG_ramuginni.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 IEO_TOP.......COMPLETED
 ....
.....
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed with errors.



[CVM Error Report]
The following report lists errors encountered during CVM Phase
      <filename>  <return code where appropriate>
  /KIRANG/applmgr/1206/ad/12.0.0/bin/adgentns.pl  2

No of scripts failed in CVM phase: 1


[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [SETUP PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /KIRANG/inst/apps/KIRANG_ramuginni/admin/install
      adgendbc.sh             INSTE8_SETUP       1


AutoConfig is exiting with status 1





Error Details :
++++++++++++++
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Params=fnd_jdbc_buffer_min=5
fnd_jdbc_buffer_max=20
fnd_jdbc_buffer_decay_interval=60
fnd_jdbc_buffer_decay_size=50
fnd_jdbc_usable_check=true
fnd_jdbc_context_check=true
fnd_jdbc_plsql_reset=false


Unique constraint error (00001) is OK if key already exists
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=kiranginni.kiraninsourcing.com)(PORT=10010)))(CONNECT_DATA=(SERVICE_NAME=KIRANG.kiraninsourcing.com)))

Database connection to jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=kiranginni.kiraninsourcing.com)(PORT=10010)))(CONNECT_DATA=(SERVICE_NAME=KIRANG.kiraninsourcing.com))) failed
ADD call failed with exit code 1





Upon search in Metalink found below note : 422709.1 as close hit.
Followed and resolved the issue.
Solution :
To implement the solution, please execute the following steps::
1 - Modify the value of s_global_database_name in the database tier context file to match the
      s_dbService value.
2 - Rerun Autoconfig in DB first and followed by MT where we are facing issue.

        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.



Happy Reading...
~kiran.

BEHAVIOUR of JSP Cache in R12

There is a change in the default behaviour of handling JSP cache in R12 as opposed to 11i.

JSPs were handled by Apache Jserv engine in 11i and is being handled by OC4J (10.1.3 AS) in R12.

In 11i, when we clear cache ($COMMON_TOP/_pages) and try to  access JSP pages,
it gets automatically recompiled. However, this is not the case in R12 by default.

In R12 instance, if you clear _pages and restart apache,you will only get a blank screen
since AppsLocalLogin.jsp wouldn’t get compiled by default. You will not even see a new _pages directory.

As per Oracle, whenever JSP cache is cleared, we have to run “ojspCompile.pl –compile –flush -p 2”
to recompile ALL jsp pages in the Application.  This will take roughly around 15 to 20 mts.
However, in the real world (atleast in the pre-production stage) this is not affordable.

The solution to this is to change the XML file parameter “s_jsp_main_mode” to a value of “recompile”
from the default value of “justrun” and run autoconfig. JSP pages will be recompiled automatically
after this change.

Note:  742107.1 – How To Clear Caches (Apache/iAS, Cabo, Modplsql, Browser, Jinitiator, Java, Portal, WebADI)
for E-Business Suite

Clearing Cache(compile all jsps) in R12 instance

1-       Stop Apache --- adapcctl.sh stopall

2-       2- Clear cache  cd $COMMON_TOP/-----remove _pages  and create _pages

3-       mkdir _pages

4-       chmod 777 _pages

5-       cd $FND_TOP/patch/115/bin

6-       $ ./ojspCompile.pl --compile --flush -p 2

logfile set: /test/mtlog/test_localhost/logs/appl/rgf/ojsp/ojspc_error.log

starting...(compiling all)

using 10i internal ojsp ver: 10

synchronizing dependency file:

enumerating jsps...8001

parsing jsp...8001

writing deplist...8001

initializing compilation:

eliminating children...5912 (-2089)

translating and compiling:

translating jsps...5912/5912 in 4m39s                

compiling jsps...5912/5912 in 17m30s                

Finished!

7- Start Apache -- adapcctl.sh startall

Compiling single jsp

ojspCompile.pl --compile -s 'fnd%' -p 20

How to clear cache for a specific component in R12

As we all know the normal tendency for clearing cache in Oracle Apps is to delete the $COMMON_TOP/_pages directory.In 11i, after deleting we dont have to recompile the jsps but in R12 we have to recompile the pages since s_jsp_main_mode is set to justrun by default which is in turn updated in orion-web.xml

How can i clear cache for a specific component of Oracle Apps R12 viz., iprocurement, istore etc.,

Is this even possible ? Yes it is and this option comes handy when somebody modifies a jsp page which is part of say istore,then it makes sense to clear cache for istore and not for the whole server.

Clearing cache for specific Component/Application in R12

Login as sysadmin

Select Functional Administrator responsibility

Go to Core Services ==> Caching Framework ==> Tuning

Query the application (for example iStore) or by Name or code.

Select the component and clear the cache.

Note: For some specific configuration changes, we need to bounce Apache also.

Clearing Global Cache in R12

a) Go to Functional Administrator Responsibility

b) Go to Core Services ==> Caching Framework

c) Go to Global configuration and clear all the cache from there.(Only If you want to clear all the  cache)

Apply another Patch while Current patch failed in the Middle.

*******************************
How to apply another Patch while one Patch is failed and other one is pre-req for the failed Patch.
Here are the details please follow carefully. Make a note that this method is not officially supported...
*******************************

1. Using the adctrl utility, shutdown the workers.
a. adctrl
b. Select option 3 "Tell worker to shutdown/quit"
2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema
a. sqlplus applsys/apps
b. create table fnd_Install_processes_back
as select * from fnd_Install_processes;
c. The 2 tables should have the same number of records.
select count(*) from fnd_Install_processes_back;
select count(*) from fnd_Install_processes;
3. Backup the AD_DEFERRED_JOBS table.
a. sqlplus applsys/apps
b. create table AD_DEFERRED_JOBS_back
as select * from AD_DEFERRED_JOBS;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;
4. Backup the .rf9 files located in $APPL_TOP/admin/kirang/restart directory.
At this point, the adpatch session should have ended and the cursor should
be back at the Unix prompt.
a. cd $APPL_TOP/admin/kirang
b. mv restart restart_back
c. mkdir restart
5. Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.
a. sqlplus applsys/apps
b. drop table FND_INSTALL_PROCESSES;
c. drop table AD_DEFERRED_JOBS;
6. Apply the new patch.
7. Restore the .rf9 files located in $APPL_TOP/admin/kirang/restart_back
directory.
a. cd $APPL_TOP/admin/kirang
b. mv restart restart_
c. mv restart_back restart
8. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS
schema.
a. sqlplus applsys/apps
b. create table fnd_Install_processes
as select * from fnd_Install_processes_back;
c. The 2 tables should have the same number of records.
select count(*) from fnd_Install_processes;
select count(*) from fnd_Install_processes_back;
9. Restore the AD_DEFERRED_JOBS table.
a. sqlplus applsys/apps
b. create table AD_DEFERRED_JOBS
as select * from AD_DEFERRED_JOBS_back;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;
10. Re-create synonyms
a. sqlplus apps/apps
b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;
c. create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES;
11. Start adpatch, it will resume where it stopped previously.

ISSUE: During OATM Migration Invalid Indexes holding further progress of Migration.

REPRODUCE the ERROR:

++++++++++++++++

Running the OATM Migration utility:

1. Migration Sizing Reports

2. Create New Tablespaces

3. Generate Migration Commands

4. Execute Migration Commands

5. Run Migration Status Reports

6. Run Post Migration Steps

7. Run Customization Steps

8. Run Migration in Batch Mode

[Q]uit [N]ext

Choosing the option : 3 "Generate Migration Commands"

Choose the Option : 1 below : "Invalid Indexes Report."

1. Invalid Indexes Report. Please correct/drop these before

generating migration commands

2. Generate migration commands for all schemas

3. Generate migration commands for a list of schemas

[Q]uit [B]ack [N]ext

Please enter your option - 1

PAGE: 1

Invalid Indexes Report. Please correct/drop these before generating migration co

Report Date : April 6, 2012

Index Owne Index Name Index Type Status

---------- ------------------------------ ---------------- --------------------

CS CS_FORUM_MESSAGES_TL_N4 CONTEXT FAILED

CS CS_FORUM_MESSAGES_TL_N4 CONTEXT POPULATE

CS CS_INCIDENTS_ALL_TL_N1 CONTEXT FAILED

CS CS_INCIDENTS_ALL_TL_N1 CONTEXT POPULATE

CS CS_KB_ELEMENTS_TL_N2 CONTEXT FAILED

CS CS_KB_ELEMENTS_TL_N2 CONTEXT POPULATE

CS CS_KB_SETS_TL_N3 CONTEXT FAILED

CS CS_KB_SETS_TL_N3 CONTEXT POPULATE

Report created /kirang/applmgr/11510/admin/kirang/log/fndinvld.txt

Need to follow Note : 312640.1 >> The step 2. Create the CS Text index preferences and indexes (7, 8,9, 10 & 11)

Create the CS Text index preferences and indexes (7, 8, 9, 10 & 11):

- Log into Unix as the Applications user, and change to $CS_TOP/patch/115/sql

- Log into SQL*Plus as the apps user

- Run the script cskbctxp.sql and pass the apps CS and CTXSYS usernames (e.g.

@cskbctxp apps cs ctxsys).

This creates the Text index preferences for the CS Text indexs.

- Run the script cskbsetx.sql and pass the cs schema name(i.e @cskbsetx CS).

This creates the CS_KB_SETS_TL_N3 Text index.

- Run the script cssrcrix.sql and pass the apps and cs schema names (i.e @cssrcrix apps CS).

This creates the SUMMARY_CTX_INDEX Text index.

- Run the script cskbelex.sql and pass the cs schema name(i.e @cskbelex CS).

This creates the CS_KB_ELEMENTS_TL_N2 Text index.

- Run the script cskbcatx.sql and pass the cs schema name(i.e @cskbcatx CS).

This creates the CS_KB_SOLN_CAT_TL_N1 Text index.

- Run the script cskbforx.sql and pass the cs schema name(i.e @cskbforx CS).

This creates the CS_FORUM_MESSAGES_TL_N4 Text index.

- NOTE the script csksynib.pls creates the package CS_KB_CONC_PROG_PKG. This is required

for the Concurrent Program submission that is used to execute the index creations for

the cskbsetx.sql, cskbforx.sql, cskbelex.sql, and cskbcatx.sql scripts. This script will

reside in $CS_TOP/admin/sql, or $CS_TOP/patch/115/sql (use the newest version).

- Log into Unix as the Applications user, and change to $CS_TOP/patch/115/sql or

$CS_TOP/admin/sql.

- Log into SQL*Plus as the apps user, and execute csksynib.pls if necessary.

in order to create the interface (e.g. @csksynib.pls cs apps).

Details :

+++++++++++

SQL> @cskbctxp apps cs ctxsys

PL/SQL procedure successfully completed.

Commit complete.

SQL> @cskbsetx CS

DOC> | FILENAME |

DOC> | cskbsetx.sql |

DOC> | PURPOSE

DOC> | Drop index and submit a recreate index request. |

DOC> | Pre-req:

DOC> | CS_KB_CONC_PROG_PKG pacakge.

DOC> | ARGUMENTS

DOC> | 1. CS applicatin short name.

DOC> | NOTES

DOC> | Usage: @cskbsetx.sql CS

DOC> | |

DOC> | HISTORY |

DOC> | 18-DEC-2003 klou Created |

DOC> | 06-JAN-2004 klou Change install phase to last. |

DOC> | 26-MAR-2004 klou Default number of parallel workers. |

DOC> | 16-APR-2004 klou Fix bug 3572002. |

DOC> +=========================================================================*/

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @cssrcrix apps CS

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @cskbelex CS

DOC> | FILENAME |

DOC> | cskbelex.sql |

DOC> | PURPOSE

DOC> | Drop index and submit a recreate index request. |

DOC> | Pre-req:

DOC> | CS_KB_CONC_PROG_PKG pacakge.

DOC> | ARGUMENTS

DOC> | 1. CS applicatin short name.

DOC> | NOTES

DOC> | Usage: @cskbelex.sql CS

DOC> | |

DOC> | HISTORY |

DOC> | 18-DEC-2003 klou Created |

DOC> | 06-JAN-2004 klou Change install phase to last. |

DOC> | 26-MAR-2004 klou Default number of parallel workers. |

DOC> | 16-APR-2004 klou Fix bug 3572002. |

DOC> +=========================================================================*/

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @cskbcatx CS

DOC> | FILENAME |

DOC> | cskbcatx.sql |

DOC> | PURPOSE

DOC> | Drop index and submit a recreate index request. |

DOC> | Pre-req:

DOC> | CS_KB_CONC_PROG_PKG pacakge.

DOC> | ARGUMENTS

DOC> | 1. CS applicatin short name.

DOC> | NOTES

DOC> | Usage: @cskbcatx.sql CS

DOC> | |

DOC> | HISTORY |

DOC> | 18-DEC-2003 klou Created |

DOC> | 06-JAN-2004 klou Change install phase to last. |

DOC> +=========================================================================*/

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @cskbforx CS

DOC> | FILENAME |

DOC> | cskbforx.sql |

DOC> | PURPOSE

DOC> | Drop index and submit a recreate index request. |

DOC> | Pre-req:

DOC> | CS_KB_CONC_PROG_PKG pacakge.

DOC> | ARGUMENTS

DOC> | 1. CS applicatin short name.

DOC> | NOTES

DOC> | Usage: @cskbforx.sql CS

DOC> | |

DOC> | HISTORY |

DOC> | 18-DEC-2003 klou Created |

DOC> | 06-JAN-2004 klou Change install phase to last. |

DOC> +=========================================================================*/

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

$ cd $CS_TOP/patch/115/sql

$ ls -ltr csksynib.pls

-rwxr-xr-x 1 apkirang aakirang 45504 Aug 11 2006 csksynib.pls

SQL> @csksynib.pls CS apps

Package body created.

Commit complete.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Again reproducing the issue:

PAGE: 1

Invalid Indexes Report. Please correct/drop these before generating migration co

Report Date : April 6, 2012

Index Owne Index Name Index Type Status

---------- ------------------------------ ---------------- --------------------

CS CS_INCIDENTS_ALL_TL_N1 CONTEXT FAILED

CS CS_INCIDENTS_ALL_TL_N1 CONTEXT POPULATE

Report created /kirang/applmgr/11510/admin/kirang/log/fndinvld.txt

Still getting below invalids report:

Final Solution: As an apps user dropped the invalid and recreated as below:

a) drop index cs.CS_INCIDENTS_ALL_TL_N1;

b) SQL> @$CS_TOP/patch/115/sql/cssrcrix.sql apps CS

PL/SQL procedure successfully completed.

Commit complete.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Now the Issue is resolved. No new Invalids in the report. And safely proceed with OATM Migration...

Happy Reading

Thanks

Kiran Ginni

Issue on DB Autoconfig : Error details >> txkcreateACL.sh: exiting with status 1 >> ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 226

********************

Instance Details:

********************

Apps : 12.1.2

DB : 11.1.0.7

Activity : CPU Patching Jan'12 & Autoconfig.

Issue: DB Autoconfig failed with below error ...

Error details extracted from Log file :

[AutoConfig Error Report]

The following report lists errors AutoConfig encountered during each

phase of its execution. Errors are grouped by directory and phase.

The report format is:

[APPLY PHASE]

AutoConfig could not successfully execute the following scripts:

Directory: /kirang/oracle/product/111/appsutil/install/KIRANG_ramubro

txkcreateACL.sh INSTE8_APPLY 1

AutoConfig is exiting with status 1

Exact Error details during execution of script "txkcreateACL.sh"

SQL*Plus: Release 11.1.0.7.0 - Production on Sun Mar 4 01:24:33 2012

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

Connected.

Checking for existence of the ACL ....

No ACL exists for this, creating a new one ....

DECLARE

*

ERROR at line 1:

ORA-31003: Parent /sys/acls/ already contains child entry OracleEBS.xml

ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 226

ORA-06512: at line 36

ORA-01403: no data found

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

txkcreateACL.sh: exiting with status 1

Upon search found related Note : 1328458.1

Solution : Followed steps as per the note and executed Autoconfig on DB Node.

1. Execute the below PL/SQL block to drop the existing OracleEBS ACL :

sqlplus "/as sysdba"

BEGIN

DBMS_NETWORK_ACL_ADMIN.drop_acl (acl => 'OracleEBS.xml');

commit;

end;

2. Run autoconfig on DB Node again..

cd $ORACLE_HOME/appsutil/kirang

adautocfg.sh

Thanks

Kiran Ginni