Friday 29 August 2014

Unable to change GUEST Password in 11i

Issue : Application login user password not accepting.


Investigation :



Upon received the mails from users, I started investigated the issue and found username and password was not accepted. So I went and checked the JVM logs and found the below error which is mostly related to GUEST user password.

Below is the error log on /oar2/oracle/oar2ora/iAS/Apache/Jserv/logs/jvm/OACoreGroup.0.stderr

Exception in static block of jtf.cache.CacheManager. Stack trace is: oracle.apps.jtf.base.resources.FrameworkException: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_LOGIN_FAILED
at oracle.apps.jtf.cache.CacheManager.initCache(CacheManager.java:718)
at oracle.apps.jtf.cache.CacheManager.<clinit>(CacheManager.java:378)

Then verified the Guest user password validation which is failed, Then manually  updated the GUEST password to XML file and ran autoconfig  but it did not updated to any of the configuration files and to the database. Upon search of multiple oracle notes and forums, I found the below forum and then executed the action plan.

To verify the guest user password "GUEST1" then it should result in application DBC file and Database  level.

sqlplus apps/apps

SQL> select fnd_profile.value('GUEST_USER_PWD') from dual;

FND_PROFILE.VALUE('GUEST_USER_PWD')
--------------------------------------------------------------------------------
GUEST/WELCOME

SQL> SELECT fnd_web_sec.validate_login('GUEST','WELCOME') FROM dual;

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','WELCOME')
--------------------------------------------------------------------------------
N

Welcome is the wrong password and the fnd_web_sec.validata_login also failed with welcome. Verify the dbc file in $FND_SECURE/OAC2_oadbc2.dbc

Even after updating the s_guest_password in Context_file and run autoconfig then please execute the below action plan.mentioned in one of the oracle forum.


2)      Downloaded and Applied the patch 6496781  “This appears to be an issue with ATG rup6”
3)      Run autoconfig on DB and Application servers
4)      Started the application services and did the sanity checks.
5)      Make sure password looks like case sensitive


Hope the  above solution will fix your  Login issue.

--- Sudhakar.

Wednesday 13 August 2014

R 12.2.3 Cloning Steps






R12.2 Clone Execution Steps

27-May-2014

Sudhakar Allamsetti



Table of Contents

1. verview............................................................................................................ 4
2. Source & Target System Information                        ..................................... 4
2.1        Targer system uers and Groups............................................................... 4
2.2        Targer Linux  server should have all the OS packages of R12.2 
             minimum requirements..........                                        ........................ 4
2.3        Target server should have Minimum Swap Space.................................. 4
2.4        Collect Source Instance Credintials......................................................... 5
2.5        Target system OS Credintials & Path to configure Database and application
             Servers....                                                            .................................... 5
3. Cloning Process Source System:.....            .................................................... 6
4..... Cloning process of Target Server........                       ................................. 7
4.1 Configure Target RUN Filesystem...       ..................................................... 7
4.2  Configure Target Patch filesystem.....                      .................................... 8
5..... Post Clone Configuration Changes                :.............................................................................................. 9


                                                                                           

1         Overview


The document provides information for E_business suite 12.2 Clone Execution steps

This document contains of the hardware ( Disk Space, CPU and Memory), OS pre-requsites and Clone execution Steps  

This document applies to 64-bit Linux operating systems on the x86-64 hardware architecture.

2      Source & Target System Information.

Source System
Name
memory
Disk Space
CPU
Database Server
oadbup
16 GB
1800 GB*
8 CPU (Intel(R) Xeon(R) CPU  X5650  @ 2.67GHz)
Application Server
oacmup
8 GB
296 GB
4 CPU  (Intel(R) Xeon(R) CPU X5650  @ 2.67GHz)





Target Server




Database Server
oadb12
16 GB
1800 GB*
8 CPU (Intel(R) Xeon(R) CPU  X5650  @ 2.67GHz)
Application Server
oacm12
8 GB
296 GB
4 CPU  (Intel(R) Xeon(R) CPU X5650  @ 2.67GHz)


·         *Disk space size varies depends on Database size.

2.1  Targer system uers and Groups


Usernames = apploa12 , oraoa12
Group = dba

·         Oraoa12 user is the account that owns the database node technology stack (11gR2
        Oracle Home) and the database files.

·         Apploa12 user is the account that owns the Applications node technology stack (APPL_TOP, COMMON_TOP, OracleAS 10.1.2 Oracle Home, and Oracle Fusion Middleware Oracle Home)

2.2   Targer Linux  server should have all the OS packages of R12.2 minimum requirements


·         Refer the R12.2 Minimum requirements document

2.3  Target server should have Minimum Swap Space


·         Swap space shouled be minimum of 16GB or More.

·         Before cloning to a new server, ensure the Source System has enough free disk space.  Oracle Fusion Middleware cloning tools require 6GB in /tmp and 6GB under $COMMON_TOP.

2.4  Collect Source Instance Credintials

a.     Apps password
b.    System schema password
c.     Weblogic admin password

2.5  Target system OS Credintials & Path to configure Database and application Servers


Target System Details
DB Server Values
Database Server Name
OADB12
username
oraoa12
Oracle Base Path
/oa12/oracle/dbnode/
Oracle Data path
/oa12/oracle/oa12data
Oracle Home
/oa12/oracle/dbnode/11.2.0
Database Port
1571
Oracle SID
OA12


Target System Details
Application Server Values
Application Server Name
OACM12
username
apploacm12
Application Base Path
/oa12/oracle/oa12appl
Database Port
8050
Oracle SID or TWO_TASK
OA12




Create the below three directories in target application server :

Change to  Application Base directory

cd /oa12/oracle/oa12appl

mkdir -p /oa12/oracle/oa12appl/fs1/
mkdir -p /oa12/oracle/oa12appl fs2/
mkdir -p /oa12/oracle/oa12appl /fs_ne/


3. Cloning Process Source System:

         

a)      connect to the oraoaup account on oadbup server, change directory to $ORACLE_HOME/appsutil/scripts/OAR2_oadbup and execute

 “perl ./adpreclone.pl dbTier”. 

b)      Log on to the "Run Edition File System" in the Source System as the apploaup user, and run the following commands on each Node that contains an APPL_TOP:

$ cd <INST_TOP>/admin/scripts  or $ADMIN_SCRIPTS_HOME
$ perl adpreclone.pl appsTier


1.     Shutdown the Apps tier

Connect to the appl[tgsid] account on the oacm[dv|tst] server and execute the following:
cd $ADMIN_SCRIPTS_HOME
./adstpall.sh apps/<Appspassword>                        # after 5 minutes, kill remaining process
           <we should enter weblogic admin password as well when it prompted during stop process>
2.       Shutdown the database tier

Connect to the ora[tgsid] account on the oadb[dv|tst] server and execute the following:
cd $ORACLE_HOME/appsutil/scripts/<SID_hostname>

lsnrctl stop <Listner_name>
Eg: lsnrctl stop OAR2

3.     Copy Oracle Home and Datafiles.  ( prefer to use tar.gz to save source softlinks and time to copy)

a)     Database Server :

cd $ORACLE_HOME

scp –pr 11.2.0 oraoa12@oadb12: /oa12/oracle/dbnode/

cd /oaup/oracle/

scp –pr oaupdata oraoa12@oadb12: /oa12/oracle/dbnode/

b)      Application Server:

Note:  You need to make sure which is the run file system before we initiate a copy i.e. FS1, FS2  and also we should be make sure that we ran adpreclone.pl on this FS.

[apploaup@oacmup scripts]$ echo $FILE_EDITION
run
[apploaup@oacmup scripts]$ echo $RUN_BASE
/oaup/oracle/oaupappl/fs1

cd /oaup/oracle/oaupappl/fs1
scp –pr EBSapps /oa12/oracle/oa12appl/fs1

Note: Don’t copy the other two directories under “fs1”  inst  , FMW_Home

If the Target server is not having the destination directories then please create

4.   Cloning process of Target Server


4.1 Configure Target RUN Filesystem


a)     Configure application Tier (RUN)

     cd /oa12/oracle/oa12appl/fs1/comn/clone/bin

    perl adcfgclone.pl appsTier

    post completion of adcfgclone appsTier , please start the services
b)     RUN the ENV for the Applciation tier
.  /oa12/oracle/oa12appl/fs1/EBSapps/appl/APPSOA12_oacm12.env
c)      Start the application Services
cd $ADMIN_SCRIPTS_HOME
   adstral.sh apps/<Appspassword>
     Provide Weblogic Password:
d)    Complete basic sanity check

a)     Login to applications
b)    Launch forms
c)     Submit concurrent request



4.2  Configure Target Patch filesystem



a)     adpreclone on TARGET RUN FILESYSTEM
cd $ADMIN_SCRIPTS_HOME
            adpreclone.pl appsTier

b)  SHUTDOWN THE APPLICATION which is running on RUN FILESYSTEM
cd $ADMIN_SCRIPTS_HOME
adstpall.sh apps/<Appspassword>


c)  COPY THE TARGET RUN FILESYSTEM to TARGET PATCH FILESYSTEM  (OACM12)

cd /oa12/oracle/oa12appl/fs1

cp –pr EBSapps   /oa12/oracle/oa12appl/fs2/

d)    Configure application Tier  (PATCH)


cd /oa12/oracle/oa12appl/fs2/EBSapps/comn/clone/bin

     perl adcfgclone.pl appsTier

Important parameter values to remember:

Do you want to add a node (yes/no) [no] : no
Target System File Edition type [run] : patch
Enter the full path of Run File System Context file : < We should provide the target RUNFS xml file complete path >
Eg:/oa12/oracle/oa12appl/fs1/inst/apps/OA12_oacm12/appl/admin/OA12_oacm12.xml

Target System Port Pool [0-99] :8051 (“Runedition port+1” i.e. 8050+1)

e)      Start the application Services from RUN Filesystem
     .  /oa12/oracle/oa12appl/fs1/EBSapps/appl/APPSOA12_oacm12.env
   cd $ADMIN_SCRIPTS_HOME
                adstral.sh apps/< apps password >

5.   Post Clone Configuration Changes:

 

      Search for ‘JAVA COLOR SCHEME’. Change the color to match the following: DEV – blaf, TEST – red, OPMS – blaf, FINX – blue, OPMR – blue, OPMC – purple, TEMP – purple, OADV – blaf, OATST – red, OATR - titanium.

                  tSearch for ‘ICX:Session Timeout’ and change the timeout setting to 240.

Change the following 4 BNE system profiles where the “TO:” can be oadv, oatst, upgr, oatr, etc.

BNE Debug Log Directory
From: /dev/oracle/devcomn/temp
To: /test/oracle/oadvcomn/temp

BNE Redirect Portal URL:

BNE UIX Physical Directory
From: /dev/oracle/devcomn/html/cabo
To: /test/oracle/testcomn/html/cabo

BNE Upload Staging Directory
From: NULL
To: /tmp