视频1 视频21 视频41 视频61 视频文章1 视频文章21 视频文章41 视频文章61 推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37 推荐39 推荐41 推荐43 推荐45 推荐47 推荐49 关键词1 关键词101 关键词201 关键词301 关键词401 关键词501 关键词601 关键词701 关键词801 关键词901 关键词1001 关键词1101 关键词1201 关键词1301 关键词1401 关键词1501 关键词1601 关键词1701 关键词1801 关键词1901 视频扩展1 视频扩展6 视频扩展11 视频扩展16 文章1 文章201 文章401 文章601 文章801 文章1001 资讯1 资讯501 资讯1001 资讯1501 标签1 标签501 标签1001 关键词1 关键词501 关键词1001 关键词1501 专题2001
OracleAppsDBA工具:ADADMIN使用说明
2020-11-09 11:18:33 责编:小采
文档


ADADMIN用途ADADMIN主要用于Oracle Apps文件系统和数据库的维护工作,是Apps DBA常用的工具。(ADADMIN执行文件位于$AD_TOP/bin下

ADADMIN用途

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

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


使用方法

[oracle@ ~]$ 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

把$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

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


Maintain Applications Files

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


1.Relink Applications programs

Relinks Oracle Applications executable programs with the Oracle server libraries so that they function with the Oracle database. For each product, choose whether to link all executables or only specific ones.

Note:The default is to relink without debug information. Use the debug option only when requested to do so by Oracle Support Services.


2.Create Applications environment file


3.Copy files to destinations

Copies files from each product area to central locations where they can be easily referenced by non-Applications programs. This option uses revision-based copy logic to ensure that the destination file versions are the same as, or higher than, the source file versions.


Note:Were commend that you do not use the force option to overwrite existing files unless instructed by Oracle Support Services. Copying files with this option updates all JAR files. JInitiator then downloads required JAR files to each client again, causing runtime performance degradation.


The file types and their respective destinations are shown in the following table:


These files: copied to (UNIX)

Java files $JAVA_TOP

HTML files $OAH_TOP

Media files $OAM_TOP

Note:When this option is used to copy reports or graphics files, the default destinationis under AU_TOP.


4.Convert character set

Preparesthe files in the APPL_TOP for conversion to another character set, and then performs the conversion.

下载本文
显示全文
专题