如何避免下載Word/Excel時被IE開啟

檔案總管->工具->資料夾選項->檔案類型->找到Excel文件格式.xls，然後點擊【進階】，將在同一個視窗內瀏覽的勾拿掉後確定。

如何解決Oracl EBS 11.5.10無法用cgi方式登入

轉自：網路

参考文档：

http://forums.oracle.com/forums/message.jspa?messageID=1129424

Please check the variable value in $APPL_TOP/admin/_.xml context file
variable:
s_appserverid_authentication

By default in 11.5.10, this is set to SECURE. In previous 11i versions, this was
set to OFF. Set this value to OFF , run autoconfig and test the application login.

for any change in context file you need to run autoconfig and bounce the apps instance to see the changes to instance. There are three modes of authentication you can configure your applications by setting the parameter s_appserverid_authentication to

ON : Partial
SECURE : activates full server security (SECURE mode)
OFF : deactivates server security



解决方案：

Solution 1:

修改$APPL_TOP/admin/_.xml，将appserverid_authentication修改为off

然后运行app的autoconfig command:

/bin/adconfig.sh contextfile= appspass=

重新启动应用，搞定



Solution 2:

Oracle ebs 11.5.10默认不推荐使用cgi,但是有些时候为了方便起见一般临时设置为off,可以通过下面方式修改，但是一旦重新运行autoconfig,就又会变为SECURE（因为xml文件里面默认是SECURE）

$java oracle.apps.fnd.security.AdminAppServer apps/apps

AUTHENTICATION SECURE DBC=/T3/VIS/app/visappl/fnd/11.5.0/secure/VIS_sun750/vis.dbc

另外还可以通过下面方式察看目前的方式

Such as:

$ java oracle.apps.fnd.security.AdminAppServer apps/apps

> STATUS DBC=/T3/VIS/app/visappl/fnd/11.5.0/secure/VIS_sun750/vis.dbc



Database Server

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

DATABASE_ID: vis

AUTHENTICATION: SECURE



Application Server

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

APPL_SERVER_STATUS: VALID

APPL_SERVER_ID: 1A78FDE21B9C10A5E0440003BA0B0A8317245370401314746525442660242638

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

$ java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION off DBC=/u01/test/testappl/fnd/11.5.0/secure/TEST_erpapptest/test.dbc
AUTHENTICATION OFF executed successfully - /u01/test/testappl/fnd/11.5.0/secure/TEST_erpapptest/test.dbc





$ java oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION off DBC=/u01/test3/test3appl/fnd/11.5.0/secure/p570a_test3.dbc
AUTHENTICATION SECURE executed successfully - /u01/test3/test3appl/fnd/11.5.0/secure/p570a_test3.dbc
$



SELECT server_id FROM fnd_nodes