Oracle Apps DBA工具:ADADMIN使用说明

ADADMIN用途

ADADMIN主要用于Oracle Apps文件系统和数据库的维护工作，是Apps DBA常用的工具。

（ADADMIN执行文件位于$AD_TOP/bin下）

使用方法

[oracle@bej301441 ~]$ adadmin

如果ADADMIN命令无法运行，很可能是环境变量没有设置，可以运行下". $APPL_TOP/instance.env"来设置环境变量。adadmin执行过程中，需要数据库system用户的密码和apps用户的密码

ADADMIN的菜单项介绍

ADADMIN有5个一级菜单，每个一级菜单下都有明细的功能项

一级菜单

AD Administration Main Menu

1.Generate Applications Files menu
2.Maintain Applications Files menu
3.Compile/Reload Applications Database Entities menu
4.Maintain Applications Database Entities menu
5.Change Maintenance Mode
6.Exit AD Administration

每一个一级菜单下的明细功能项

Generate Applications Files

如果系统用户无法访问Message，Form或者Report，你可以尝试使用“Generate Applications Files” 下的菜单来解决问题。

1.Generate message files

This task generates message binary files in the $PROD_TOP/mesg directory from oracle application object library tables.We generally perform this task only when instructed to do so in a readme file of a patch.

2.Generate form files

1. form，把$AU_TOP/forms/<LANG>/下的fmb文件生成<PROD>_TOP/forms/<LANG>下的fmx文件
2. library，把$AU_TOP/resource/下的pll文件重新生成plx文件

3. menu，FNDMENU.mmb -> FNDMENU.mmx

3.Generate report files

根据安装语言生成report文件(.rdf)

4.Generate graphics files

This task generates Oracle graphics files for all installed languages. Extension of the file name like (*.ogd),The serious of prompts and actions in this task are very similar to the prompts and actions in the Generate form files task.

5.Generate product JAR files

GenerateJava archive (JAR) files whenever you upgrade the Developer technology stack orwhen recommended by Oracle Support Services. It signs JAR files (if on the Webserver) and does the following:

■Generates product JAR files in JAVA_TOP and copies them to APPL_TOP.

■Generates other Java-related files under APPL_TOP and JAVA_TOP.

■Recreates Java libraries (appsborg.zip and appsborg2.zip) under APPL_TOP andJAVA_TOP.

6.Return to Main Menu

另可参见：