Oracle Apps DBA工具:ADADMIN使用说明

2014-11-24 18:42:38 · 作者: · 浏览: 0

(ADADMIN执行文件位于$AD_TOP/bin下)




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






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


把$AU_TOP/forms//下的fmb文件生成_TOP/forms/下的fmx文件




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





6.Return to Main Menu




Maintain Applications Files


“Maintain Applications Files”主要是用于保持你的系统文件最新。比如,你需要拷贝文件从一个特定位置或者转换文件的字符集




1.Relink Applications programs





2.Create Applications environment file



3.Copy files to destinations





4.Convert character set





5.Maintain snapshot information


There are two types of snapshots: APPL_TOP snapshots and global snapshots. An APPL_TOP snapshot lists patches and versions of files in the APPL_TOP. A global snapshot lists patches and latest versions of files in the entire Applications system (that is, across all APPL_TOPs).

Both APPL_TOP snapshots and global snapshots may be either current view snapshots or named view snapshots. A current view snapshot is created once and updated when appropriate to maintain a consistent view. A partial view snapshot allows you to synchronize only selected files from a current view. A named view snapshot is a copy of the current view snapshot at a particular time (not necessarily the latest current view snapshot) and is not updated.

Patch Wizard uses the information contained in the global current view snapshot to determine which patches have already been applied. AutoPatch uses the APPL_TOP current view snapshot to determine if all prerequisite patches have been applied to that APPL_TOP. Snapshot information is stored in the AD_SNAPSHOTS, AD_ SNAPSHOT_FILES, and AD_SNAPSHOT_BUGFIXES tables.

During a new installation, Rapid Install creates a current snapshot as a baseline. And, each time you run AutoPatch, it automatically creates a new (updated) snapshot so that the information is current as of the application of the patch.

Maintain Snapshot Information menu options :

■ List snapshots (stored in the system)
■ Update current view snapshot (full or partial APPL_TOP and global)
■ Create named snapshot (select a current view snapshot to copy and name)
■ Export snapshot to file (select one to export to a text file)
■ Import snapshot from (a text) file
■ Delete named snapshot (select a snapshot for deletion)



6.Check for missing files


Verifies that all files needed to run Oracle Applications for the current configuration are in the current APPL_TOP. Choose this task if you suspect there are files missing in your APPL_TOP.



7.Return to Main Menu