You Session is no Longer valid ,While logging in AppsLocalLogin.jsp in 11i

You Session is no Longer valid ,While logging in AppsLocalLogin.jsp in 11i

 

Error Message

Whne login through AppsLocalLogin.jsp .
Error comes  You Session is no Longer valid
if login through dev60cgi/f60cgi  able to login sucessfully

Cause Identified

SESSION_COOKIE_DOMAIN was wrong in ICX_PARAMTERS table
It happens after cloning apps 11i to different domain,then the SESSION_COOKIE_DOMAIN having the old value
this was causing the issue

Solution/Work Around

1.Login to sqlplus as apps
2.select SESSION_COOKIE_DOMAIN from ICX_PARAMETERS;
3.Check if it is correct or not
4.update the value to correct domain
update ICX_PARAMETERS set SESSION_COOKIE_DOMAIN=value;
5.Restart Apache  Check the issue

 

 

Create a TraceAnalyzer File

Create a TraceAnalyzer File
A trace file is a raw set of data produced by the Oracle Database.
TraceAnalyzer reformats the raw data so that it is easier to review. It is
a more powerful tool than TKPROF. It translates things like bind
variables and make them easy to find.
a. Download TraceAnalyzer from Note.224270.1
b. Install trace analyzer in SQL: @TRCACREA.sql;
c. Retrieve the trace file.
d. In SQL*Plus, issue a command like the following to create a TraceAnalyzer
version of the trace file: @TRCANLZR.sql UDUMP vis015_ora_22854.trc

Yellow bar isse resolution

Yellow bar isse resolution
take a backup of these files:
$APPL_TOP/admin/out/adcert.txt
$APPL_TOP/admin/adsign.txt
$APPL_TOP/admin/appltop.cer
$HOME/identitydb.obj .

copy the above four files from another apps node

make sure these files have the same sizes on both

then from adadmin generate jar files with force option
before doing this, make sure all the processes are down
if some process does not come down, then kill it
clean up the _pages and move the apache logfiles and jserv logfiles

How to find if Operating system in 32 bit or 64 bit ?

How to find if Operating system in 32 bit or 64 bit ?
For solaris use command
isainfo -v
If you see out put like
32-bit sparc applications
That means your O.S. is only 32 bit
but if you see output like
64-bit sparcv9 applications
32-bit sparc applications
above means your o.s. is 64 bit & can support both 32 & 64 bit applications

 

 

Linux

getconf   LONG_BIT

or

getconf   WORD_BIT

How to change hostname on Linux/OEL ?

How to change hostname on Linux/OEL ?

Open file /etc/sysconfig/network using editor like vi , nano or ed
Change entry HOSTNAME=XXXXXX to
HOSTNAME=New_Host_Name
Restart xinetd service or reboot Linux/OEL
Restart xinetd service xinetd restart
Reboot Linux reboot
If you have defined hostname resolution in hosts file then change entry in /etc/hosts

How to find Apps Version (11i/R12/12i)

How to find Apps Version (11i/R12/12i)

Connect to database as user apps

 

SQL> select release_name from apps.fnd_product_groups; Output like 12.0.4 or 11.5.10.2