1.访问form服务的方式：

R12(Servlet方式)：

http://ip:port/forms/frmservlet

R12(Socket方式)

http://ip:port/OA_HTML/frmservlet

11i ：

http://ip:port/dev60cgi/f60cgi

2.R12 RUP4发生错误，please fix the above failed worker(s) so the manager can continue 查看日志，处理完问题后，执行adctrl在$AD_TOP/bin下，选2，他就继续了。吾糙！RUP4已经打了差不多10个多小时了，还没完。

系统中等待事件如下，都是空闲等待。锁定无。

 

EVENTCOUNT(1)
SQL*Net message from client19
smon timer1
pmon timer1
rdbms ipc message9
Streams AQ: qmn slave idle wait1
Streams AQ: qmn coordinator idle wait1
Streams AQ: waiting for time management or cleanup tasks1

弄完以后打中文patch，察看日志：$APPL_TOP/admin/UAT/log/adpatch.log

3.启动R12 AP时候报错：adformsctl.sh: exiting with status 204 adoafmctl.sh: exiting with status 204 adoacorectl.sh: exiting with status 204

尝试了N次后在metalink上面发现解决方法，他是后台进程没有关完全导致

1 - open a new shell and set your apps environment 2 - cd $ADMIN_SCRIPTS_HOME 3 - adopmnctl.sh stop 4 - check if it is really down: ps -ef | grep <USER> grep opm 5 - delete the following: rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/* rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/* rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/* 6 - adopmnctl.sh start 7 - check if the issue has been resolved: adapcctl.sh status For SSO enabled environments additional information regarding Changing the Hostname, Domain Name, or IP Address can be found in: Oracle Application Server Administrator's Guide 10g Release 3 (10.1.3.2.0) See also the link in the References.

4.Low-level logging is currently enabled. Your application will not perform as well while low-level logging is on.中文：当前启用低层记录。在启用了低层记录时，您的应用产品也不会执行

Please check the profile option - FND: Debug Log Enabled. If this is set to "yes", you'd receive that message. Set this to "No", and the message should disappear.

5.直到自己的request输出到哪里去了吗？ select t.logfile_name,t.outfile_name from fnd_concurrent_requests t where t.request_id = 346316

6.R12输入用户名和密码点登陆后出错，信息如下：

at oracle.apps.fnd.common.WebAppsContext.doValidateSession(WebAppsContext.java:1358) at oracle.apps.fnd.common.WebAppsContext.validateSession(WebAppsContext.java:1708) at oracle.apps.fnd.common.WebRequestUtil.validateContextPrivate(WebRequestUtil.java:463) at oracle.apps.fnd.common.WebRequestUtil.validateContext(WebRequestUtil.java:322) at oracle.apps.fnd.common.WebRequestUtil.validateContext(WebRequestUtil.java:225) 数据库里面有：

Fri Jul  4 11:00:48 2008 Process m000 died, see its trace file Fri Jul  4 11:00:48 2008 ksvcreate: Process(m000) creation failed Fri Jul  4 11:01:59 2008 Process m001 died, see its trace file Fri Jul  4 11:01:59 2008 ksvcreate: Process(m001) creation failed

最后查了一下原来是prcesses到上限了

7.An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_V490B. There may be a network configuration problem, or the TNS listener on node FNDFS_V490B may not be running. Please contact your system administrator

Clone完毕路径都变了，如果打开旧系统里面的报表，就会报这个错误,当然RRA如果不打开也会有这个错误,今天又发现一个原因，可以用tnsping FNDFS_V490B,看看node是否都存在，假设有2个node ，v490a,v490b，前者不存在也会报v490b错误。

类似的，OPP启动不了报：

Could not contact Service Manager FNDSM_ERPAPP_UAT5. The TNS alias could not be located, the listener process on ERPAPP could not be contacted, or the listener failed to spawn the Service Manager process.

同样的，确认当前服务器是否是ERPAPP，不是的话说明有些信息没同步过来，还指向原来的node，可以手工在tnsnames.ora里增加。另外要注意观察，OPP实际为0，目标非0，选中OPP后下面显示已经有service在running了，这种情况下，可以把管理器重启即可正常。

 

8.change apps password in R12

Sent the Note 437260.1 How to Change Oracle Applications 12 Passwords using Oracle Applications Schema Password Change Utility to customer ema
mail address compard@163.com.

Please note the file ORACLE_HOME/reports/server/CGIcmd.dat mentioned in document not exist in R12 anymore.

Summary the steps to change the schema passwords:

-1. Using the FNDCPASS Utility to change the passwords,for example，

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS <new password>

FNDCPASS apps/apps 0 Y system/manager oracle gl gl1
-2. Modify the custom configuration file or shell scripts which have passwords (optional)
-3. Run the autoconfig
-4. Restart the application tier

If you changed the APPLSYSPUB password, update the password in these files

FND_TOP/resource/appsweb.cfg 
OA_HTML/bin/appsweb.cfg 
FND_TOP/secure/<host_name>_<dbname>.dbc

9.APP-FND-01388 Cannot red value for profile option FND_DEVELOPER_MODE
in routine &ROUTINE

METALink上的Solution1:
-- To implement the solution, please execute the following steps::

-1. Go into the responsibility: Navigate to the AU_TOP/resource directory

-2. Compile and generate manually CSQKMENU.pll, ensure CSQKMENU.plx gets generated successfully.

-3. Then compile BENAUTHE.pll and BENAUTHE.fmb successfully.

-4. Retest the scenario. This should fix the issue.

-5. Migrate the solution as appropriate 

Solution2:

设置下面三个变量的值

Java Look and Feel
Java Color Scheme
FND: Indicator Colors

10.导出tsv文件时候一闪而过

设定IE，打开download file提示

11.导出tsv文件乱码

修改客户机编码，改成简体中文
12.OPP日志：

使用系统管理员职责，到并发管理器中找到一个管理器名称为：Output Post Processor，
选择下面的进程按钮，
里面可以知道一个管理日志的按钮，点开可以查看日志

14.RUP6

Swapping bintmp and binstage.
Stage preparation complete.

adrelink is exiting with status 1

查找error字样的,就可以找到问题.

ERROR at line 1:
ORA-20000: ORA-02248: invalid option for ALTER SESSION
ORA-06512: at line 96

修改SQL

15.修改R12中的默认日期格式

-1. Login as 'SYSADMIN'
-2. Search profile 'ICX: Date format mask', the default of the value should be '31-DEC-1999', then you can select '1999-12-31', then
change and save it.
-3. Stop your application server via $COMMON_TOP/admin/scripts/<SID>/adstpall.sh apps/<Your apps's passowrd>
-4. Start your application server via $COMMON_TOP/admin/scripts/<SID>/adstrtal.sh apps/<Your apps's passowrd>
-5. Then you can check the date format on your form after restart your application 

 

 

16.某些请求一跑,标准管理器自己关闭,请求会报"no manager"的错误，不跑得时候可以手动打开管理器

这个问题原因比较复杂，多半是管理器资源不足，要看看日志来判断.今天碰到的确是修改/etc/hosts里面把127.0.0.1的那一行去掉了机器名的字符串引起的，日志显示ora-01401错误。重新作了一次AP 的clone，又发生如下错误adalnctl.sh: exiting with status 127，察看日志发现是$ORACLE_HOME/bin/lsnrctl 变成了lsnrctl0，改正之。其间有发生错误如下，察看日志：

TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist
   Linux Error: 2: No such file or directory

adalnctl.sh: exiting with status 1，修正.bash_profile内容和custom***.env，管理器启动起来后一切正常。

 

17.R11i normal question

Forms Server executable (frmsrv) not found at $ORACLE_HOME/bin .Run make -f $BASE_DIR/apps/tech_st/10.1.3/forms/lib/ins_forms.mk frmsrv to generate the server executable

A1:做个快捷方式既可

Q2:用户目录下面有.profile但是切换到用户下去后，.profile并不能被执行

A2:这个与.profile的权限无关，检查发现$HOME下面还有如下的目录，如果只保留一个.profile文件，就正常的。

 .TTauthority  .dt           .java         .vi_history
..            .Xauthority   .dtprofile    .sh_history   .wmrc

Q3.Warning:Applet Window(11i)黄条

A3把$HOME下面的identitydb.obj拷贝到本地来C:/Program Files/Oracle

Q4.FND_FILE建立文件失败

A4.发现数据库中的utl_file_dir和AP用户的$APPLPTMP不一致，改成一致

 

18.java runtime文件位置

12.1.X $COMMON_TOP/webapps/oacore/util/jinitiator/

12.0.X

11i $COMMON_TOP/util

 

19. 表中有数据，但是建立在表上的别名没有数据。

trace跟踪后发现需要跑begin :con := MO_GLOBAL.ORG_SECURITY(:sn, :on); end;

另外表中有数据，view中无数据，这个是很常见的，需要跑org即可。

 

20. loadrunner导客户等HTML界面(R12.0.X,R12.1.X)的信息，如果想少出错，最好：

A.关闭防火墙/杀毒软件

B.清除IE Cache，否则在user_init里面会录一大堆多余的垃圾

C.使用GUI Base

D.注意延时防止服务器响应不过来

E.常见问题还是比较容易处理，就不讲了。

 

21. Windows内部版本对应关系：

win 2K 5.0

Win XP 5.1

Win 2003 5.2

Win Vista 6.0

Win 7 6.1

 

22.查看ERP版本

select release_name from fnd_product_groups

 23: 报表运行一切正常，但是查看output或者报表日志时特别慢

该现象表现在ERP打开form/运行Report 速度都是正常的，但查看日志/报表结果需要打开IE的时候，通常等待好几分钟才看到结果，出错还好办，他是一点错误都没有，就是慢，有些时候会在$HOME下产生一个core文件，查看core文件的后半截发现都与network/nis/dns什么的有关系，根据这个线索，首先要确定服务器与客户端网段互相访问时正常，然后查看节点，看看有没有多余的，不能访问的节点，特别是AP的，这次碰到的问题就是某些AP节点不能访问导致，EXEC FND_CONC_CLONE.SETUP_CLEAN;
,autocfg过后，一切就正常了。

 

24:11i客户端登陆时，发现有frm-92015 web 客户版本太新/太旧

删掉登陆用户目录下的.jinit, oracle java cache等目录，清一下缓存即可

 

25:查看是否进入维护模式：

select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

26:执行http://hostname.domain:port/forms/frmservlet?record=forms跟踪时，报如下错误：

APP-FND-01542: This Applications Server is not authorized to access this database.

1. Edit $CONTEXT_FILE which is located in $INST_TOP/appl/admin

2. Change

<appserverid_authentication oa_var="s_appserverid_authentication">SECURE</appserverid_authentication>

to

<appserverid_authentication oa_var="s_appserverid_authentication">OFF</appserverid_authentication>

Application Server Security Authentication can take one of the following values {ON, OFF, SECURE}.
OFF - Server security is not checked. Any application server machine can access the database.
ON - Some level of trust is required to access the database. Either the Application Server is registered with the database or the module and version ID are known to be trusted.
SECURE - Full trust is required for access to the database. Only registered Application Server machines and trusted code modules may connect.



3. Run $INST_TOP/admin/scripts/adautocfg.sh to instantiate the changes

4. Users are now able to access Forms directly.

 

 


APP-FND-01542: This Applications Server is not authorized to access this database.

26:测试fnd_file的指令：

exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');

 

 27:Routine AFPESA cannot construct the name of an executable file for your concurrent request 2181143. Check that the file name components

一般是由于环境变量，特别是custom部分的变量没有设置造成的

 

28:常见的客户端问题：

A。form界面显示异常，表现在客户打开form界面后，一片花，东一片数据，西一个按钮，最后在显示里面修改一些设置，主要禁用掉一些特效，3D什么的禁用掉加速什么的就好了。

B。用户职责菜单显示为 undefined，发现客户端部分软件和ERP有冲突，查看IE版本时，显示错误：存储空间不足，无法完成此操作，baidu了一下，

原文：http://www.orastudy.com/posts/2349.html/comment-page-1

摘录如下：

检查注册表：

HKEY_LOCAL_MACHINE SOFTWARE Microsoft Windows CurrentVersion Internet Settings 5.0 User Agent
与HKEY_CURRENT_USER SOFTWARE Microsoft Windows CurrentVersion Internet Settings 5.0 User Agent，

HKEY_LOCAL_MACHINE User Agent 下有几个奇怪的key，其中一个有“ciba”字样，机器确实安装了金山词霸。可能是有冲突了。于是删除。而HKEY_CURRENT_USERUser Agent下倒很干净。

重启IE，恢复正常了。

还是第一次遇到该问题。

 

29:添加新管理器运行特定请求

A.先确定该请求的名称，应用，以前在那个管理器中跑着，该管理器的应用，程序库

B.新建一个管理器 ，起个名字，其他参数和以前管理的参数相同，特殊规则中选择程序，包括，应用选择请求的应用，填上请求名，设定流程，休眠秒数，保存。这里有一个细节是“缓存大小”，以前我以为是与占用内存大小有关，查阅了相关资料才知道这个其实是管理器的从FND CONCURRENT REQUESTS 队列中每次取的请求个数，建议默认值，建议最大不要超过请求个数的2倍。

C.在旧的管理器的特殊规则中去掉该请求

D.激活新的管理器和旧管理器。

 

30.维护ERP时少不了VNC的工具，如果一旦切到全屏时，按F8即可打开VNC的菜单，当然，要先切到VNC可以响应的窗口上才行，否则按了也不起作用。

 

31:登陆ERP时发生如下错误：

You have encountered an unexpected error. Please contact the System Administrator for assistance.

日志：

12/10/31 14:16:50.442 html: chain failed
javax.servlet.ServletException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION.
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:899)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:816)
        at _OALogout._jspService(_OALogout.java:244)
        at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.5.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
        at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
        at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
        at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
        at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)

12/10/31 14:17:19.318 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:17:31.455 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:17:33.875 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:17:42.455 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:18:02.915 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:19:15.246 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:19:17.313 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:19:18.279 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:19:20.713 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:19:22.146 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:19:22.913 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:19:23.588 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:19:24.173 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
12/10/31 14:19:24.739 html: JspServlet: unable to dispatch to requested page: Exception:java.lang.IllegalStateException: Session was invalidated
A:见Note 1312273.1,相关补丁 Patch.10104874

32.firefox登陆EBS时，form窗口不能显示。

A：官方说明如下：

自 Firefox 3.6 起，Mozilla Foundation 将停止对 OJI（Open Java Virtual Machine Integration，开放式 Java 虚拟机集成）的支持，仅支持标准 NPAPI 和 NPRuntime 接口。Java 6 Update 10 或更高版本中的 Java Plug-in 支持 NPAPI 和 NPRuntime 接口。因此，自 Firefox 3.6 起，基于 Java 的 Applet 程序仅在您运行 Java 6 Update 10 或更高版本时才能正常工作。

也就是要登陆EBS，换成高版本的java或者低版本的firefox还是可以的。

33.RC-20010: Fatal: Could not find Info-ZIP's zip version 2.3 in the PATH. Please make sure you have zip version 2.3 in your PATH and rerun the command.zip 2.3 is normally available in $ORACLE_HOME/bin/ or it can be downloaded fromhttp://www.info-zip.org/Zip.html(AIX 6.1)

A: 其实不用下载zip或者打补丁，apps Tier下就有现成的符合要求的zip版本，把$ORACLE_HOME/bin/zip备份，然后复制apps Tier下的$ORACLE_HOME/bin/zip过来即可。

34.管理器的Actual和Target数不想等

A:特别是OPP管理器发生的概率比较大，一般处理的过程如下：

1. Shutdown all the concurrent processes and managers.
2. Verify that no FNDLIBR process is running on (ps -ef | grep FNDLIBR).
3. Run the CMCLEAN.SQL script from Note 134007.1 (don't forget to commit)
4. Restart concurrent managers and the database.
5. Test the issue.

35.R12 DBC文件位置

$INST_TOP/appl/fnd/12.0.0/secure

 

36:Login EBS and found the following Error:

Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: Io exception: Got minus one from a read call
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1423)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1215)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1110)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1099)
at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:784)
at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:228)
at sun.reflect.GeneratedConstructorAccessor2.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:521)
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1273)

A:check the alert file and found the error

ORA-00020: maximum number of processes (800) exceeded
 ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.

 $ORACLE_HOME/dbs/init<SID>.ora,increace parameter "processes" and the issue has resolved.