QWhat are the Ad utilities?
Ad utilities stand for application DBA utilities. These are set of tools used for installing, upgrading, maintaining and patching Oracle application. There are around 15 Ad utilities.
QWhat is maintenance mode and how it enable/disable the same?
Maintenance mode is a feature which is introduced in 11.5.10. For doing any maintenance activity in the application system like applying patch the maintenance mode need to be enable in the application system.It can be disable and enable using adadmin utility .
QWhat is the log file location for Adutilities?
$APPL_TOP/admin/$TWO_TASK/log. format <adutility name>.log
QWhat is adadmin why it is used?
Adadmin is used to perform a number of administrative tasks to maintain the Oracle Applications.Adadmin ensure that Oracle Application run smoothly.
Adadmin perform two types of works -one which is performed at database level and other which is performed at the file system level.
Adadmin can be scheduled to run at a later time in a non-interactive mode.
QHow Adadmin run in a non-interactive mode?
To run Adadmin in a non-interactive mode, you must at first create defaults file. Once the defaults file is created you can run adadmin in non-interactive mode using this file.The defaults file must be located under
APPL_TOP/admin/SID
$adadmin defaultsfile=APPL_TOP/admin/SID/defaults.txt
$adadmin defaultsfile=APPL_TOP/admin/SID/defaults.txt
logfile-adadamin.log
workers=10
interactive=no
menu_option=DISABLE_MAINT_MODE
In order to choose which task defaults file run you add menu option.
QHow can you regenerate all the forms files using adadmin and what does it do internally?
The generate forms files options of adadmin take care of generating form files(extension .fmx) from binary forms defination file (extension .fmb). These binary form files are located under AU_TOP and the executable files are stored under each products directory.
QYou have accidentally deleted the environment file how can u recreate it?
You can recreate the environment file by using the options create applications file from adadmin.This options create environment file that your system configuration.
QWhat is the significance of the DUAL table? Who owns this table and how many rows it should have?
The DUAL table is created automatically by Oracle along with the data dictionary. It is located in the schema of SYS. It has one column named DUMMY of type VARCHAR2 and contain one row with the value of 'X'. In case it has more than one row application system may not function properly.
QWhat is ad splice? what does it do?
Oracle often release new products after the base release of Oracle applications. This products are known as off cycle products. Adsplice is a utility which take care of incorporating and off cycle products in to Oracle applications so that it is recognized by the ad utilities as a valid oracle application product.
QWhat are the advantages of distributed AD?
With distributed AD the workers can utilize the additional resources of the remote nodes where they are running apart form the primary node. This capability improves scalability, performance and resource utilization and completion of worker in a faster time.
Ad utilities stand for application DBA utilities. These are set of tools used for installing, upgrading, maintaining and patching Oracle application. There are around 15 Ad utilities.
QWhat is maintenance mode and how it enable/disable the same?
Maintenance mode is a feature which is introduced in 11.5.10. For doing any maintenance activity in the application system like applying patch the maintenance mode need to be enable in the application system.It can be disable and enable using adadmin utility .
QWhat is the log file location for Adutilities?
$APPL_TOP/admin/$TWO_TASK/log. format <adutility name>.log
QWhat is adadmin why it is used?
Adadmin is used to perform a number of administrative tasks to maintain the Oracle Applications.Adadmin ensure that Oracle Application run smoothly.
Adadmin perform two types of works -one which is performed at database level and other which is performed at the file system level.
Adadmin can be scheduled to run at a later time in a non-interactive mode.
QHow Adadmin run in a non-interactive mode?
To run Adadmin in a non-interactive mode, you must at first create defaults file. Once the defaults file is created you can run adadmin in non-interactive mode using this file.The defaults file must be located under
APPL_TOP/admin/SID
$adadmin defaultsfile=APPL_TOP/admin/SID/defaults.txt
$adadmin defaultsfile=APPL_TOP/admin/SID/defaults.txt
logfile-adadamin.log
workers=10
interactive=no
menu_option=DISABLE_MAINT_MODE
In order to choose which task defaults file run you add menu option.
QHow can you regenerate all the forms files using adadmin and what does it do internally?
The generate forms files options of adadmin take care of generating form files(extension .fmx) from binary forms defination file (extension .fmb). These binary form files are located under AU_TOP and the executable files are stored under each products directory.
QYou have accidentally deleted the environment file how can u recreate it?
You can recreate the environment file by using the options create applications file from adadmin.This options create environment file that your system configuration.
QWhat is the significance of the DUAL table? Who owns this table and how many rows it should have?
The DUAL table is created automatically by Oracle along with the data dictionary. It is located in the schema of SYS. It has one column named DUMMY of type VARCHAR2 and contain one row with the value of 'X'. In case it has more than one row application system may not function properly.
QWhat is ad splice? what does it do?
Oracle often release new products after the base release of Oracle applications. This products are known as off cycle products. Adsplice is a utility which take care of incorporating and off cycle products in to Oracle applications so that it is recognized by the ad utilities as a valid oracle application product.
QWhat are the advantages of distributed AD?
With distributed AD the workers can utilize the additional resources of the remote nodes where they are running apart form the primary node. This capability improves scalability, performance and resource utilization and completion of worker in a faster time.
No comments:
Post a Comment