unable to authenticate session or open OA_HTML page then it displays blank.

when try to login EBS it shows below error message.
unable to authenticate  session.

check my oracle support

First, if user use multiple environment, when they switch the instance,  it will cause this issue. please check Doc id 1098563.1
then add -noframemerging at the end of IE.exe.


but it is not working for our issue. then i want to  check if the application server and Database server is on. it is on.
ok i remember we can log in Oracle EBS Form Directly.
in EBS R11i  you can add   http://ip.port//dev60cgi/f60cgi
EBS R12, We need to use   
Servlet method:
http://ip.port/forms/frmservlet
Socket method:
http://ip:port/OA_HTML/frmservlet

then encountered this issue APP-FND-01542.
Checked my oracle support again with this error id.
1. ensure the server_id is OFF.
 select node_name, server_id from fnd_nodes
   where node_name = 'AUTHENTICATION';
2. please check my oracle support then you will know how to change the value of server_id if  return value of server_id is SECURE.
3. It is dangerous to change this value manually from the database side.

then i noticed a note which provide a debug method, please check the note 422419.1 we can generate the log file then if we can identify the issue from this log file.

Oracle Application Server Diagnostic Tools and Log Files in Applications Release 12 (Doc ID 454178.1)
after checked the doc id ,  we have some existed log file in the application server that we can check it, the web is not working fine.
it means that i need to check http log and J2EE(OC4J) log file.
check the Apache log file, didn't find the useful error.
then check the application.log under oacore path.
i found this error message in the application.log
java.lang.RuntimeException: Unable to create user session. Please contact your System Administrator.
then use this error and find it in the metakink, i found below doc id
Doc ID 734692.1
it said we need to check the alter.log at the database server.
cd $ORACLE_HOME/admin/$CONTEXT_NAME/diag/rdbms/*/$ORACLE_SID/trace
file will be  alert_$ORACLE_SID.log

Found the error message ORA-1653: unable to extend table ICX.ICX_SESSIONS by 16 in                 tablespace APPS_TS_TX_DATA
in the alert.log file.

The root cause is we need to extend the tablespace.

check the max byte and used up.
SELECT ddf.file_name, ddf.user_bytes/1024/1024, ddf.*

  FROM Dba_Data_Files ddf

 where ddf.tablespace_name = 'APPS_TS_TX_DATA'

用system/manager登录PL/SQL Developer运行如下SQL语句：

ALTER TABLESPACE APPS_TS_TX_DATA ADD DATAFILE '/d01/dba/vis01data/tx_data14.dbf' SIZE 100M;（增加100M到APPS_TS_TX_DATA表空间）

注意：执行上面命令是增加tx_data**.dbf文件, **请用“不存在SQL结果”里的数字代替，一般为SQL中查询中的最大数字加1。比如通过1查询到目前APPS_TS_TX_DATA表空间中共有以下数据文件：

/d01/dba/vis01data/tx_data1.dbf

/d01/dba/vis01data/tx_data2.dbf

...

/d01/dba/vis01data/tx_data14.dbf

通过2新增加表空间：

/d01/dba/vis01data/tx_data15.dbf （新增加的表空间的编号一般为前一数字+1，即15）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13975809/viewspace-2132197/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13975809/viewspace-2132197/