Running AutoConfig in Parallel in EBS 12

How Does AutoConfig's Parallel Mode Work?

Executing AutoConfig in 'parallel mode' engages a locking mechanism so that processes running on individual nodes are synchronized. This mechanism prevents any conflicting updates to the database or the file system. The following figure illustrates AutoConfig running in parallel across multiple nodes:

Executing AutoConfig in Parallel Mode

The following command can be used to run AutoConfig in 'parallel mode'

Application Tier

perl $AD_TOP/bin/adconfig.pl contextfile=<CtxFile> [product=<product_top>] –parallel

Database Tier

perl $ORACLE_HOME/appssutil/bin/adconfig.pl contextfile=<CtxFile> –parallel

where

<CtxFile> is the absolute path to the context file
<product_top> is the Product short name

Note that while running AutoConfig simultaneously on multiple nodes, it is very important to ensure that the '-parallel' option is specified while starting AutoConfig on each node to prevent unstable and/or inconsistent filesystem and database states.

Downloading the Latest AutoConfig Engine

Customers on Oracle E-Business Suite Release 12 can obtain this new feature by installing:

• 7207440: TXK 12.0.4 Consolidated Patch 1

This feature is currently not available for Oracle E-Business Suite 11i.  We currently do not have precise plans for delivery of this feature in 11i.

Your Thoughts?

Please let us know about your experience on using this new feature. We'd be very interested in hearing about how long it takes to run AutoConfig on your multi-node installations with and without the 'parallel' option. The newAutoConfig Performance Profiler feature can be used to collect this information. Also let us know of any issues you encounter while using this feature.

References

• Using AutoConfig to Manage System Configurations with Oracle Applications 11i (Metalink Note 165195.1)
• Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 (Metalink Note 387859.1)

Related Articles

• Power Tools: Optimizing AutoConfig Performance Through Profiling
• New AutoConfig Patchset RUP 12.0.6 Now Available
• New Apps 11i AutoConfig + Templates Rollup Patch S Now Available
• Preparing for Apps 11i AutoConfig Updates

Read more on 

No write permissions to the Inventory pointed by /var/opt/oracle/oraInst.loc

While configuring admin tier perl adcfgclone.pl appsTier it failed with the below error message
No write permissions to the Inventory pointed by /var/opt/oracle/oraInst.loc

Running Rapid Clone with command:
perl /u01/ebsapp/comn/clone/bin/adclone.pl java=/u01/ebsapp/comn/clone/bin/../jre/jre mode=apply

stage=/u01/ebsapp/comn/clone/bin/.. component=appsTier method=CUSTOM

appctxtg=/u01/ebsapp/appl/admin/ebsoracle_apporacle.xml

showProgress contextValidated=true

No write permissions to the Inventory pointed by /var/opt/oracle/oraInst.loc: /u01/oracle/11.2.0/oraInventory
Rapid Clone needs to be able to write to the inventory

Please run the script /tmp/orainstRoot.sh as root
Restart adclone.pl after performing required corrections.

ERROR: Failed to execute /u01/ebsapp/comn/clone/bin/adclone.pl

Cause:
After seeing above error message we will think issue with permsions but certainly not.
It is because of  inventory which is pointing to some other instance.

Full permisions
============
apporacle@ctsss $ ls -ltrh /var/opt/oracle/oraInst.loc
-rwxrwxrwx 1 oracle dbaoracle 1.7K Jul 17 05:56 /var/opt/oracle/oraInst.loc
apporacle@ctsss $


Solution:
apporacle@ctsss $ grep -v "#" /var/opt/oracle/oraInst.loc
inventory_loc=/ebstest/oracle/11.2.0/oraInventory
inst_group=dbatest
apporacle@ctsss $

Comment above entry and add below entry in oraInst.loc file
===========================================
inventory_loc=/u01/ebsapp/oraInventory
inst_group=dbaoracle

apporacle@ctsss $ grep -v "#" /var/opt/oracle/oraInst.loc
inventory_loc=/u01/ebsapp/oraInventory  ==> inventory location
inst_group=dbaoracle
apporacle@ctsss $

ORA-19505: failed to identify file+ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Rman duplicate failed with the below error
=========================================
channel ch00: starting datafile backup set restore
channel ch00: restoring control file
channel ch00: reading from backup piece /backup/ebsoltp/cf/bk_up1oc63hd_s331553_p1_t818089517_bk
channel ch00: ORA-19870: error while restoring backup piece /backup/ebsoltp/cf/bk_up1oc63hd_s331553_p1_t818089517_bk
ORA-19505: failed to identify file "/backup/ebsoltp/cf/bk_up1oc63hd_s331553_p1_t818089517_bk"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
Additional information: 9

failover to previous backup


Cause*:- In pfile conversion parameters are not specified.

solution:
*.db_file_name_convert='/ebsoltp/dbf/data1','/ebstest/dbf/data1','/ebsoltp/dbf/temp','/ebstest/dbf/temp'
*.LOG_FILE_NAME_CONVERT='/ebsoltp/dbf/redo1','/ebstest/dbf/redo1','/ebsoltp/dbf/redo2','/ebstest/dbf/red
o2'
*.event='10298 trace name context forever, level 32'

After doing above steps issue got resolved.Thanks for visiting my blog !!!!!!!!!!

ORA-31623: a job is not attached to this session via the specified handle

oradev@ctssd $ impdp system/manager DUMPFILE=ebsdev_scottconnect_datapump.dmp DIRECTORY=DATA_PUMP17  SCHEMAS=SCOTTCONNECT

Import: Release 11.2.0.3.0 - Production on Sat Jul 27 00:32:31 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

UDI-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1

Cause:Please increase the size of steams_pool_size parameter .

Solution: the size of the streams_pool_size parameter is too low or streams_pool_size parameter is not exists in pfile.

ORA-00257: archiver error. Connect internal only, until freed.

Our Informatica load got failed with the below error.. Request you to please check and let us know the status of the and we are getting below error.
========

DB.

Database driver error...
CMN_1022 [
Database driver error...
Function Name : Logon
ORA-00257: archiver error. Connect internal only, until freed.

Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [SCOTT_SCH] and connection string [erpoltp].


CAUSE: Archive mount point got filled up.

[oraoltp ctssp] $ df -h /u01/data/arch
Filesystem size used avail capacity Mounted on
/dev/vx/dsk/u01dg/arch_vol
84G 84G 63M 100% /u01/data/arch


Alert logfile contain
=================
ORA-19502: write error on file "/u01/data/arch/log_812720774_1_78454.log", blockno 131073 (blocksize=512)
ORA-27063: number of bytes read/written is incorrect
Additional information: 65024
Additional information: 1048576
ORA-19502: write error on file "/u01/data/arch/log_812720774_1_78454.log", blockno 153601 (blocksize=512)
Sun Jul 21 05:02:18 EDT 2013
ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/u01/data/arch/log_812720774_1_78454.log' (err
or 19502)
(erpoltp)


=======

Solution: Connect to database and change archive destination location.


[oraoltp ctssp] $ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.5.0 - Production on Sun Jul 21 05:03:12 2013

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


Connected to:
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> alter system set log_archive_dest='/u02/data/data2/arch_21july2013';

System altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/data/data2/arch_21july2013
Oldest online log sequence 78454
Next log sequence to archive 78454
Current log sequence 78457

SQL> !df -h /u02/data/data2/arch_21july2013
Filesystem size used avail capacity Mounted on
/dev/vx/dsk/erpoltpdbdg/data2_vol
452G 412G 38G 92% /u02/data/data2/arch_21july2013

Once archive backup completed change archive destination to old one.

SQL> !df -h /u01/data/arch
Filesystem size used avail capacity Mounted on
/dev/vx/dsk/erpoltpdg/arch_vol
84G 44G 38G 54% /u01/data/arch

SQL>

RMAN-04017: startup error description: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance+RMAN-04014: startup failed: ORA-03113: end-of-file on communication channel

 rman duplicate failed with below error.
=========================================

connected to auxiliary database (not started)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/22/2013 04:07:14
RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-24327: need explicit attach before authenticating a user
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-03113: end-of-file on communication channel
RMAN-04017: startup error description: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
RMAN>

solution*:--

Comment this parameter and re try it
=====================================
oratest@ctsst $ grep -i local initerptest.ora
#local_listener = erptest_LOCAL
oratest@ctsst $

APP-FND-01630: Cannot open file L2057707.log for appending

While trying to change apps password it got with failed with the below error.
*******************************************************************
apptest@ctsst $ FNDCPASS apps/antiq4ity 0 Y system/d33#nar SYSTEM APPLSYS r0yal@143
Log filename : L2057707.log


Report filename : O2057707.out
APP-FND-01630: Cannot open file L2057707.log for appending

Cause: FDPFOP encountered an error when attempting to open file L2057707.log for appending.
Action: Verify that the filename is correct and that the environment variables controlling that filename are
correct.
Action: If the file is opened in read mode, check that the file exists. Check that you have privileges to read the file in the file directory. Contact your system administrator to obtain read privileges.
Action: If the file is opened in write or append mode, check that you have privileges to create and write files in the file directory. Contact your system administrator to obtain create and write privileges.
apptest@ctsst $

Cause: Unable to create log file in the current directory as the directory doest not have privileges to create
it.Might be directory created with oracle user.

Solution*: Provide full permision to the directory and proceed with changing the apps password.


 Thanks for visiting my blog !!!!!!!!!!

ORA-12154: TNS:could not resolve the connect identifier specified

RMAN DUPLICATE FAILED WITH BELOW ERROR
=====================================

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 16 02:57:58 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12154: TNS:could not resolve the connect identifier specified

RMAN>
connected to recovery catalog database
RMAN>
connected to auxiliary database (not started)

Note: Comment ebstest_LOCAL paramater in tnsnames.ora file and try it again.

Solution:

oratest@ctsst $ diff tnsnames.ora tnsnames.ora_bkp
24c24
< #ebstest_LOCAL =
---
> ebstest_LOCAL =
46,57d45
< ebsoltp =
< (DESCRIPTION=
< (ADDRESS=(PROTOCOL=tcp)(HOST=ebsoltp.user.com)(PORT=1535))
< (CONNECT_DATA=
< (SID=ebsoltp)
< )
< )
< catalog=
< (DESCRIPTION =
< (ADDRESS_LIST =
< (ADDRESS = (COMMUNITY = TCP) (PROTOCOL=TCP) (Host =catalog.user.com) (Port = 1525)))
< (CONNECT_DATA = (SID = catalog)))
59d46
<
oratest@ctsst $



oratest@ctsst $ rman

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 16 03:03:57 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

RMAN> connect target sys/tim3Pa55@ebsoltp

connected to target database: EBSOLTP (DBID=2581404741)

RMAN> connect catalog catalog/catalog007@catalog

connected to recovery catalog database

RMAN> connect auxiliary /

connected to auxiliary database: EBSTEST (not mounted)


After doing above steps issue got resolved.Happy learning !!!!!!!!!!!!!!!

How to find sysadmin password in oracle apps r12?

1)conect to database as apps schema
2)create package and package body.
3)fire select statement you will get sysadmin passwod.
************************select statement t********
SELECT Usr.User_Name,
       Usr.Description,
       XXARTO_GET_PWD.Decrypt (
          (SELECT (SELECT XXARTO_GET_PWD.Decrypt (
                             Fnd_Web_Sec.Get_Guest_Username_Pwd,
                             Usertable.Encrypted_Foundation_Password)
                     FROM DUAL)
                     AS Apps_Password
             FROM applsys.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 applsys.Fnd_User Usr
 WHERE Usr.User_Name = '&User_Name';

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

oradev@ctsst $ sqlplus apps/deal123

SQL*Plus: Release 11.2.0.2.0 Production on Sat Jul 20 04:47:24 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> CREATE OR REPLACE PACKAGE XXARTO_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END XXARTO_GET_PWD; 2 3 4
5 /

Package created.

SQL> CREATE OR REPLACE PACKAGE BODY XXARTO_GET_PWD AS
2 FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
3 RETURN VARCHAR2 AS
4 LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt
5 (java.lang.String,java.lang.String) return java.lang.String';
6 END XXARTO_GET_PWD;
7 /

Package body created.

SQL> SELECT Usr.User_Name,
2 Usr.Description,
3 XXARTO_GET_PWD.Decrypt (
4 (SELECT (SELECT XXARTO_GET_PWD.Decrypt (
5 Fnd_Web_Sec.Get_Guest_Username_Pwd,
6 Usertable.Encrypted_Foundation_Password)
7 FROM DUAL)
8 AS Apps_Password
9 FROM applsys.Fnd_User Usertable
10 WHERE Usertable.User_Name =
11 (SELECT SUBSTR (
12 Fnd_Web_Sec.Get_Guest_Username_Pwd,
13 1,
14 INSTR (Fnd_Web_Sec.Get_Guest_Username_Pwd,
15 '/')
16 - 1)
17 FROM DUAL)),
18 Usr.Encrypted_User_Password)
19 Password
20 FROM applsys.Fnd_User Usr
21 WHERE Usr.User_Name = '&User_Name';
Enter value for user_name: SYSADMIN
old 21: WHERE Usr.User_Name = '&User_Name'
new 21: WHERE Usr.User_Name = 'SYSADMIN'

USER_NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
PASSWORD
--------------------------------------------------------------------------------
SYSADMIN
System Administrator
welcome123

Thanks for visiting my blog .Happy learning !!!!!!!!!

How to find apps password in oracle apps r12 (or) retrive apps password in r12?

[oratest@ctssd ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 20 10:35:09 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show user
USER is "SYS"


SQL> CREATE FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2)
RETURN VARCHAR2 AS
LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String)
return java.lang.String'; 2 3 4
5 /

Function created.

SQL> SELECT ENCRYPTED_FOUNDATION_PASSWORD from APPS.fnd_user where USER_NAME='GUEST';

ENCRYPTED_FOUNDATION_PASSWORD
--------------------------------------------------------------------------------
ZG2555C11618FBE5085594E7F69F0901785384BA78D95F98F252E44B9D043D0CD95DB2285AAA9B6A5A9F973D0B23859E0442


SQL> select apps.decrypt_pin_func('GUEST/ORACLE','ZG2555C11618FBE5085594E7F69F0901785384BA78D95F98F252E44B9D043D0CD95DB2285AAA9B6A5A9F973D0B23859E0442') from dual;

APPS.DECRYPT_PIN_FUNC2('GUEST/ORACLE','ZG2555C11618FBE5085594E7F69F0901785384BA7
--------------------------------------------------------------------------------
bo11yw00d

SQL> show user
USER is "SYS"
SQL> conn apps/bo11yw00d
Connected.
SQL> select name from v$database;

NAME
---------
ebstest

SQL>

Happy learning!!!!!!!

After database bounce apps password is not working in cloned instance 11g database "ERROR: ORA-01017: invalid username/password; logon denied"

After database bounce apps password is not working in cloned instance.

Issue:

On database node not able to connect to sqlplus as apps schema
=============================================

oratest#ctsst $ sqlplus apps/apps#man

SQL*Plus: Release 11.2.0.3.0 Production on Sun Jul 7 23:06:33 2013 ==>: database side

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

^CERROR:
ORA-01017: invalid username/password; logon denied


Tried From other host still not able to connect to sqlplus as apps schema
===================================================
apptest#ctssat $ sqlplus apps/apps#man

SQL*Plus: Release 8.0.6.0.0 - Production on Sun Jul 7 23:06:22 2013  ==> forms

(c) Copyright 1999 Oracle Corporation. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:


Work around/solution
==
SQL> show parameter sec

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_securefile string PERMITTED
optimizer_secure_view_merging boolean FALSE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
sec_protocol_error_further_action string CONTINUE
sec_protocol_error_trace_action string TRACE
sec_return_server_release_banner boolean FALSE
sql92_security boolean FALSE
SQL> alter system set sec_case_sensitive_logon=FALSE;

System altered.

SQL>


after doing above steps apps password is working fine!!!!!!!!!!!!!

Can't locate strict.pm in @INC (@INC contains

Perl adcfgclone failed with below error?

oratest@ctsst $ perl adcfgclone.pl dbTechStack
Can't locate strict.pm in @INC (@INC contains: /u01/oracle/11.2.0/perl/lib/5.8.3 /u01/oracle/11.2.0/perl/lib/site_perl/5.8.3 /u01/oracle/11.2.0/appsutil/perl ../lib/5.10.0/sun4-solaris-thread-multi-64 ../lib/5.10.0 ../lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 ../lib/site_perl/5.10.0 ../lib/5.10.0 ../lib/5.10.0/sun4-solaris-thread-multi-64 ../lib/site_perl .) at adcfgclone.pl line 27.

Meta link id: Rapid Clone "adpreclone.pl" Fails: "Can't Find Strict.PM" [ID 1139403.1]

Cause


A mismatch between the Perl executable and the Perl libraries. The 11gR2 database ships with Perl 5.8.3 and this is included in the PERL5LIB path for the Database Tier, however the Perl executable being used is not version 5.8.3.

Solution:
PERL5LIB=/u01/oracle/11.2.0/perl/lib/5.10.0:/u01/oracle/11.2.0/perl/lib/site_perl/5.10.0:/u01/oracle/11.2.0/appsutil/perl
export PERL5LIB
PATH=$PERL5LIB:$PATH

oratest@ctsst $ perl adcfgclone.pl dbTechStack

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adcfgclone Version 120.31.12010000.8


Enter the APPS password

After setting the perl path my issue resolved.Thanks for visiting my blog.

ORA-25153: Temporary Tablespace is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.

Meta link id: Error Executng Begin Fnd_gsm_util.Append _ctx_fragment(?,?,?); End; ORA-25153 [ID 370793.1]

Symptoms
======
When attempting to run adcfgclone.pl from a hotbackup ,the following error occurs.

Autoconfig failed on RDBMS ORACLE_HOME after configuring adcfgclone.pl dbTechStack with the below error message
==================================================================

oradev@ctssd $ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/oracle/11.2.0/appsutil/log/erpoltp_erpoltp/07132119/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /erpoltp/oracle/11.2.0
Classpath : /u01/oracle/11.2.0/jdk/jre/lib/rt.jar:/u01/oracle/11.2.0/jdk/lib/dt.jar:/u01/oracle/11.2.0/jdk/lib/tools.jar:/u01/oracle/11.2.0/jdbc/lib/ojdbc5.jar:/u01/oracle/11.2.0/appsutil/java/xmlparserv2.zip:/u01/oracle/11.2.0/appsutil/java:/u01/oracle/11.2.0/jlib/netcfg.jar:/u01/oracle/11.2.0/jlib/ldapjclnt11.jar

Using Context file : /u01/oracle/11.2.0/appsutil/erpoltp_erpoltp.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespace is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespace is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:249)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:678)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1663)
at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:709)
FAILED
COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

oradev@ctssd $


Cause

This error is usually a direct results of using adcgfclone.pl from hot back up.
Temporary tablespace is empty.

Solution

To implement the solution, please execute the following steps:
1. Add a tempfile to the TEMP tablespace

2. Run autoconfig

Routine AFPCSQ encountered an ORACLE error. ORA-01017: invalid username/password; logon denied

Meta link id:R12: Concurrent Manager Are In Inactive/No Manager State  With "Error ORA-01017: invalid username/password; logon denied" [ID 1495818.1]

Concurrent manager log file contain below error message
========================================

The Internal Concurrent Manager has encountered an error.

Review concurrent manager log file for more detailed information. : 03-JUL-2013 00:20:15 -

Shutting down Internal Concurrent Manager : 03-JUL-2013 00:20:15

List of errors encountered:
.............................................................................
_ 1 _
Routine AFPCMT encountered an ORACLE error. ORA-01012: not logged on.

Review your error messages for the cause of the error. (=)

_ 2 _
Routine AFPCSQ encountered an ORACLE error. ORA-01017: invalid username/password; logon denied
.
Review your error messages for the cause of the error. (=)
.............................................................................

List of errors encountered:
.............................................................................
_ 1 _
Routine AFPCAL received failure code while parsing or running your
concurrent program CPMGR

Review your concurrent request log file for more detailed information.
Make sure you are passing arguments in the correct format.
.............................................................................
The ebstest_0703@ebstest internal concurrent manager has terminated with status 1 - giving up.

Cause

The issue is caused by enabling 11g password case sensitivity.

Solution

To implement the solution, please execute the following steps:

1. Disable the case sensitive 11g feature
2. Restart Concurrent Manager

SQL> show parameter sec

NAME TYPE VALUE

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

db_securefile string PERMITTED

optimizer_secure_view_merging boolean FALSE

sec_case_sensitive_logon boolean TRUE

sec_max_failed_login_attempts integer 10

sec_protocol_error_further_action string CONTINUE

sec_protocol_error_trace_action string TRACE

sec_return_server_release_banner boolean FALSE

sql92_security boolean FALSE

SQL> alter system set sec_case_sensitive_logon=FALSE;

System altered.

SQL>

After doing above step concurrent manager came up !!!

Routine AFPCSQ encountered an ORACLE error. ORA-01017: invalid username/password; logon denied

Concurrent manager log file contain below error message
========================================

The Internal Concurrent Manager has encountered an error.

Review concurrent manager log file for more detailed information. : 03-JUL-2013 00:20:15 -

Shutting down Internal Concurrent Manager : 03-JUL-2013 00:20:15

List of errors encountered:
.............................................................................
_ 1 _
Routine AFPCMT encountered an ORACLE error. ORA-01012: not logged on.

Review your error messages for the cause of the error. (=)

_ 2 _
Routine AFPCSQ encountered an ORACLE error. ORA-01017: invalid username/password; logon denied
.
Review your error messages for the cause of the error. (=)
.............................................................................

List of errors encountered:
.............................................................................
_ 1 _
Routine AFPCAL received failure code while parsing or running your
concurrent program CPMGR

Review your concurrent request log file for more detailed information.
Make sure you are passing arguments in the correct format.
.............................................................................
The ebstest_0703@ebstest internal concurrent manager has terminated with status 1 - giving up.

I checked apps password is working fine but not able to start concurrent manager.

Cause: When I give adcmcctl.sh start apps/******  Putty session is not accepting the  apps password and
when i connect to sqlplus as apps/apps it is connecting fine no issue at level.

Solution: Open another putty session source env file and try adcmcctl.sh start apps/****** and it started
the concurrent managers with out any issues and the solution is look so stupid...


See if it works for you in your environmen!!!!!!!!!Happy learning..

What happens when we apply LINUX patch on sun solaris operating system?

You will always get a request to apply patch in oracle apps  instance in the form of ticket.Once you open
the ticket you will find the details.
In ticket user mentioned below things?
Please apply the patch 11894044 in ebsqa/ebsoltp/ebsdev/ebstest Instance .


Answer .When you apply linux patch on sunsolaris operating system the patch will get failed with below
error message.

Current installed release is 12.1.3

Reading patch driver file...

Parsing and loading patch driver file...

AutoPatch error:
adprdf(): At line 5 in file u11894044.drv:
This patch can only be applied on platform "SUN_OS5".
Your platform is "LINUX".

193 lines processed.

AutoPatch error:
AutoPatch encountered errors parsing and loading the patch driver file.


You should check the file
/u01/erpapp/appl/admin/ebsqa_BALANCE/log/11894044.log

for errors.

[appqa@ctsqa 11894044]$ 

MWA Setup, Testing, Error Logging and Debugging

This article will explain to you                                                                   
    a. Where the Mobile Web Apps config files are located
    b. MWA Startup and Shutdown Scripts and how those are used
    c. Directory Structure for MWA in both 11i and R12
    d. How to develop and test your pages
    e. Where the log files are created, and tips to debug MWA Applications

Configuration Files

• mwa.cfg: This file has information about the DBC file location, Log Dir Location, Telnet Port no Location, Error Logging Level etc.
  This info will be used by Mobile Applications on runtime.
• default_key.ini: This file is used to map the keys of the mobile device to some specific functionality.
  Use the default file if you don’t want to customize anything.
• deviceIP.ini: This file maps the configuration files and host name with the mobile device

MWA server start-up and shutdown:

• mwactl.sh: This file is used to start/stop the MWA listener on specific port.
  Basically, if you develop and deploy a Mobile page into the instance, you have to bounce the MWA server by
  stopping and starting the Listener at your port to see your changes.
  
  
  Start/stopping Listener
  Start:
  mwactl.sh start  
  
  
  Stop :
  mwactl.sh -login stop_force  
  
  
  
  
  File Location
  Directory Structure in R11
  $MWA_TOP/bin
  $MWA_TOP/secure
  
  
  Directory structure in R12
  $INST_TOP/admin/scripts
  $INST_TOP/admin/install
  
  
  
  (eg)In R12, INST_TOP may look like:
  /u01/appldev/DEV/inst/apps/DEV_w-oraap01
  
  
  
  
  MWA GUI Client Setup
  In order to simulate the Mobile Device on your PC, you have to do the following setup:
  Step 1:
  Create 2 directories say C:\MWA\lib and C:\MWA\log
  Extract the files from the patch 4205328 into C:\MWA\lib
  
  
  Step 2:
  Download jdk1.1.8 from java.sun.com and place it in C:
  
  Step 3:
  Create a batch file say Start_MWA.bat with the following contents
  set MWA_GUI_TOP=C:\MWA\
  set JAVA_TOP=c:\jdk1.1.8
  %JAVA_TOP%\bin\java -classpath %JAVA_TOP%\lib\classes.zip;%MWA_GUI_TOP%\lib\j4205328.zip oracle.apps.mwa.awt.client.StartGUI
  
  
  Step 4:
  Whenever you run this batch file, you must be able to see the GUI client for MWA
  
  
  
  
  Development and Deployment:
  The development of Mobile Applications can be done using any IDE like JDeveloper, Eclipse etc. After that in order to
  test the application, we have to deploy it in the Apps instance say in a directory like $JAVA_TOP/xxx/custom/server.
  
  
  In order to test it, we should have our own function in AOL. This function should refer to the Function Java Class
  name of the Mobile Application
  (eg) xxx.custom.server.CustomTestFunction
  
  
  Read more on Senthilkumar Shanmugam !!!

adapcctl.sh: exiting with status 204

Apache services are not coming up after clone in Oracle Application
============================================


apptest@ctssd $ adopmnctl.sh status

You are running adopmnctl.sh version 120.6.12010000.5

Checking status of OPMN managed processes...

Processes in Instance: ebstest_apptest.apptest.user.com
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 10962 | Alive
OC4JGroup:default_group | OC4J:forms | 10854 | Alive
OC4JGroup:default_group | OC4J:oacore | 10608 | Alive
HTTP_Server | HTTP_Server | N/A | Down


adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/erpapp/inst/apps/ebstest_apptest/logs/appl/admin/log/adopmnctl.txt for more information ...

apptest@ctssd $

Apache  log file contain
======================
[Thu Jun 27 12:32:47 2013] [crit] (125)Address already in use: make_sock: could not bind to port 8036
[Thu Jun 27 12:32:50 2013] [crit] (125)Address already in use: make_sock: could not bind to port 8036

$LOG_HOME/ora/10.1.3/opmn/HTTP_Server~1.log
============================

no processes or applications matched this request

13/06/27 12:32:42 Start process
--------
/u01/erpapp/inst/apps/ebstest_apptest/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd

--------
13/06/27 12:32:48 Start process
--------

/u01/erpapp/inst/apps/ebstest_apptest/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd

Opmn execution logfile contain
=====================
opmnctl: starting opmn managed processes...

opmn id=ctssd:6236
0 of 1 processes started.

ias-instance id=ebstest_apptest.apptest.user.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
HTTP_Server/HTTP_Server/HTTP_Server/

Error
--> Process (index=1,uid=1763906133,pid=4778)
failed to start a managed process after the maximum retry limit
Log:
/u01/erpapp/inst/apps/ebstest_apptest/logs/ora/10.1.3/opmn/HTTP_Server~1.log


06/27/13-12:32:52 :: adapcctl.sh: exiting with status 204

Note: i did many things to resolve this issue but i did not concentrate on this error
(Address already in use: make_sock: could not bind to port 8036).

i stopped apache and started it again failing with status 204 and sometimes with status 150.


Cause:8036 Apache port number is using by some other application services.Use a different port for the clone instance.Below is the details.

apptest@ctssd $ netstat -an|grep -i 8036
*.8036 *.* 0 0 49152 0 LISTEN
apptest@ctssd $ lsof -i|grep -i 8036
httpd 7825 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 7881 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 7908 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 7909 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 7910 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 7912 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 7913 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 7953 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 7956 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 7957 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 8690 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
httpd 8691 appdev 18u IPv4 0x6003824d840 0t0 TCP *:8036 (LISTEN)
appdev@ctssd $ ps -fu appdev|grep -i http|Wc -l
ksh: Wc: not found
appdev@ctssd $ ps -fu appdev|grep -i http|wc -l
20
appdev@ctssd $


Solution:
1)Stop application services
2)take the backup of xml file.
3)Modify the port number to new port number which is free in my case it free on 8035 which i globally changed it to 8035.
4)Run autoconfig .
5)Re test issue.

Happy learning!!!!!!!