1Z0-233 - 11i Install Patch and Maintain Oracle Applications
Go back to Oracle
Which three statements are true about the APPL_TOP directory? (Choose three.)
Rapid Install installs a new APPL_TOP directory when you upgrade.
Each APPL_TOP directory is associated with a single Oracle Applications database on the Oracle database server.
A directory for each product, licensed or not, is installed under the APPL_TOP directory at the time of installation.
The database server process scripts are created by Rapid Install. In which two processes would you use these scripts? (Choose two.)
starting the database
stopping the database listener
AD Administration contains a utility named Maintain Snapshot Information. Which statements correctly describe the functionality of this utility? (Choose all that apply.)
You can update the current view snapshot with any changes to the snapshot since the last update.
You can create a list of the current view and named snapshots stored in your system.
You can create a copy of an existing snapshot.
You can export an existing snapshot to a file for storage or to another system.
In which two ways do you validate the APPS schema in the Oracle Applications 11i E-Business Suite setup? (Choose two.)
Run the AD Administration utility in noninteractive mode with the default file having menu_option=VALIDATE_APPS.
Use SQL*PLUS <SYSTEM username>/<SYSTEM password> @$AD_TOP/admin/sql/advrfapp.sql <APPS schema name> <AOL schema name>
Your company has the Oracle standard three-tier architecture for its Oracle Applications installation. A user submits a concurrent request and it completes without any errors. The user cannot view the output of the request. The error message is An error occurred while attempting to establish an application file server connection with the node <HOSTNAME>. There may be a network connection problem or the listener on node <HOSTNAME> may not be running. Identify the cause of the error from the below choices.
The listener on the applications tier is not running.
What are the three benefits of having the APPS schema in Oracle Applications 11i database? (Choose three.)
By eliminating the need for cross-product grants and synonyms, the APPS schema reduces the time needed for installation, upgrade, and patching.
By eliminating the need for cross-product grants and synonyms, the APPS schema improves reliability.
By using a single APPS schema that has access to all the Oracle Applications objects, cross-product dependencies are eliminated.
Which three statements correctly describe shared APPL_TOP features and functionality? (Choose three.)
You must have a shared APPL_TOP to use distributed AD for improved efficiency of patch application.
It is possible to merge multiple APPL_TOPs to create a single shared APPL_TOP.
In a shared APPL_TOP environment, each node has its own environment file (APPS<CONTEXT_NAME>.env) and applications context file (<CONTEXT_NAME>xml).
AutoPatch is _____.
a utility used to apply a patch
If a particular product's directory is located on a different disk than other products, how do you find the location of that product's files?
using the <Context_Name>.env file
A worker process has been running for a long time, and appears to be hanging. Which are the four correct actions that an Oracle Applications 11i database administrator (DBA) would take to resolve this issue? (Choose four.)
Restart the failed job by using AD Controller.
Start and use the AD Controller utility.
Check for an entry for this process in the V$SESSION table.
Get that worker process ID.
The Applications DBA is assigned to merge five patches without unzipping the automated release updates (ARUs), by running the AD Merge Patch. What are the correct arguments in UNIX?
admgrpch -s <source directory> -d <destination directory> \ -merge_name <name> -manifest <filename>
Where can you find the Oracle 8.0.6 and iAS files in the Oracle Applications 11i file system?
What does the <AU_TOP/<release no>/resource or <PROD_TOP>/resource directory contain in Oracle Applications?
pll and .plx files used by Oracle Forms
As a project manager, you need to understand the concepts of the Rapid Clone utility. The Applications DBA gave you some information about Rapid Clone. Which three pieces of information are correct? (Choose three.)
Rapid Clone enables adding or removing database mount points or redistributing database files among mount points in the target system.
The port numbers of the cloned system should be different from the source system if both are on the same server. Both the target and source system would be online for the users at the same time.
Rapid Clone preserves the patch history of the complete Application Stack.
A report output file gets generated when you run "Validate APPS schema" by using the adadmin utility in the Oracle Applications 11i E-Business Suite environment. If the report shows something similar to "GL_CODE_COMBINATIONS table does not exist or is an invalid object", what is the first step that the database administrator (DBA) should take to correct this issue?
Run the "Recreate grants and synonyms for APPS schema" task by using the adadmin utility.
How many times can AutoPatch be restarted?
Match the following:
APPLSYS ii. AP iii. APPS iv. APPLSYSPUB 1. AP sequences 2. AOL sequences 3. AP triggers 4. synonym to APPS schema
A patch was applied successfully last night to the Oracle Applications environment to fix a bug. To check the bug fix, the Applications DBA accessed the "Bug Fixes Report." There are 1,000 files displayed in the report. The intended file for the bug fix does not appear. What should the Applications DBA do next?
Use the filter to reduce the number of files in the report.
You discover that you will be applying an application patch on your APPL_TOP by using Autopatch, which contains a compatible feature prereq line. To ensure that the automatic prerequisite patch-checking feature operates during the application of the patch, you must run AD Administration, Maintain Snapshot Information, _____, and then Autopatch. Select four correct Maintain Snapshot Information tasks or combination of tasks that will ensure that the prerequisite patch-checking feature operates during the application of the patch. (Choose four.)
Update a current view snapshot, or create a new named snapshot.
Copy the existing snapshot, delete the named snapshot, and then create a new named snapshot.
Import an up-to-date snapshot from a file from a different APPL_TOP.
List snapshots, delete the named snapshot, and create a new named snapshot.
Where can you find the scripts for rolling back an AutoConfig session?
Identify the two common subdirectories of the APPL_TOP directory of Oracle Applications file system. (Choose two.)
One of the special AD Controller utilities, Show Worker Status, collects worker status information from the FND_INSTALL_PROCESSES temp table. It tracts multiple workers for five categories: Worker, Code, Context, Filename, and Status. The seven statuses are: 1. Failed 2. Completed 3. Waiting 4. Fixed/Restart 5. Running 6. Assigned 7. Restarted Choose the number sequence that would place the process statuses in the proper flow order when an in-processing error is received.
Which four statements are true about the Rapid Clone utility? (Choose four.)
Rapid Clone is a tool to migrate an existing system to new hardware.
It re-implements the saved configuration on the target system.
It removes components of the file system.
It preserves the Oracle Applications configuration information specific to the target system.
How can you monitor the progress of parallel processing jobs in the Oracle Applications 11i environment?
using the AD Controller utility
During the AutoUpgrade process, a worker process fails to complete the assigned job, and updates the status as failed. The Review worker status window of AD Controller also shows that the worker status is failed. The log file shows that one of the tables that needs to be updated is locked, and the worker is waiting for the lock to be released and timed out. If the job is deferred after the worker fails, what do you do next?
No immediate action is required unless the job fails again.
As a database administrator (DBA), you have been trying to apply a maintenance patch, but it has failed to run successfully to completion. You check the AD Administration log files for an error. The log file reveals several entries, generic errors about the inability of patch codes to have access to product packages from the GL product modules. You remember that one of the occasions when you should run the AD Administration utility Recreate Grants and Synonyms is if the patch and the administrative sessions fail to run successfully to completion. You have found one occasion to use this utility in the case above. Now choose three other occasions when you would run this process again. (Choose three.)
after custom development
installing or maintaining underlying database components or options such as replication
in case of incomplete database migrations (exports/imports)
The AD Administration task utility Compile APPS Schema is similar to the Validate APPS Schema task, except that instead of just producing a list of invalid objects, it compiles invalid objects using multiple workers in an attempt to move them back to the valid object state. This task is most often run when custom packages are moved into the APPS schema, and during the upgrade process. The Compile Apps Schema task can be toggled to compile all objects or just the invalid objects. Choose three correct benefits of using this task. (Choose three.)
increases run-time performance in the applications
finds truly invalid objects before users get a run-time error
allows new custom or patched packages to be immediately validated
In which situations would you select a multinode installation? (Choose all that apply.)
The number of concurrent requests may use up to 80% of the CPU on an all-time basis.
Data security is a concern and the application serves users on the Internet.
Which three statements are true? (Choose three.)
Multinode installation provides a highly scalable environment.
The load balancing setup window appears during the multinode installation process.
Shared APPL_TOP is applicable only with multinode installation.
Where can you find the generated report file after running the Validate APPS schema task in the Oracle Applications 11i E-Business Suite setup?
<APPL_TOP>/admin/<SID>/out/<APPS schema name>.lst
During installation, the Rapid Install process creates ______ that are used to start and stop the server processes on the database tier.
database tier server process scripts
The connection between the client and the Oracle 11i E-Business Suite forms is provided through _____.
You are experiencing report-error problems in the Inventory module after applying a patch to the same module. You run the AD Administration utility, and select the Generate Application files menu. Because you are having report problems, you decide to run Generate report files. You have answered the following questions during the utility run: 1. Do you want to generate Oracle report objects using the current character set? (You answer Yes.) 2. Do you want to regenerate the Oracle reports PL/SQL library files? (You answer No.) 3. Do you want to regenerate Oracle reports executable files? (You answer Yes.) 4. For which products do you want to generate Oracle report objects? (You answer all reports in INV.) After you have run the AD utilities, most of the reports in Inventory run with no errors. However, you still experience errors with two reports. Which two statements explain why the two reports still run with errors? (Choose two.)
You have custom reports in a custom directory.
You have reports with external library files.
When you choose Search Patches from Oracle Applications Manager Site Map, it defaults to the Applied Patches Simple Search page. What can you do from this Applied Patches home page?
Click the Advanced Search button to access the Applied Patches Advanced Search page.
Which two types of files are under the <prod>_TOP/mesg directory? (Choose two.)
error messages for the product
language-specific message files
The application tier has a dual role in the architecture of Oracle Applications Release 11i. Identify the two roles. (Choose two.)
manages communication between the desktop tier and the database tier
hosts the various servers that process the business logic
What is the primary purpose of the APPL_TOP directory?
to identify the top-level directory for the Application installation
What is the default number of database connections allowed in a fresh installation of Oracle Applications?
Which three statements are true about AutoConfig? (Choose three.)
The AutoConfig script uses information from the context file to generate all applications configuration files and update database profiles.
AutoConfig removes the need to make manual updates to configuration files.
The AutoConfig script uses template files to determine the basic settings that are needed.
You have just brought the middle tier back after a hardware problem has been fixed. Oracle Applications are now experiencing problems with an entire product group of forms (fnd), which includes the sign-on form. You decide that you will generate the forms files in AD Administration to see whether this will fix the problem. You answered the prompts from the utility as follows: 1. Do you want to generate Oracle Forms using your current character set? (Yes) 2. Do you want to regenerate Oracle Forms PL/SQL library files? (Yes) 3. Do you want to regenerate Oracle Forms executable files? (Yes) 4. Do you want to regenerate Oracle Forms menu files? (Yes) 5. Enter list if products, or enter 'all' [all]: (fnd) 6. Generate specific form objects for each selected product? (Yes) 7. Enter libraries and menus to generate, or enter 'all' [all]: (APPCORE.pll, the main library) 8. Enter forms to generate, or enter 'all' [all]: FNDSCSGN.fmx The utility finished with no errors in the log file. What is the outcome of running the adadmin utility?
all forms but one in the product group fnd now render with errors
As a part of cloning process, the Applications DBA needs to copy the Database Tier File system to the target system. Which step is NOT a part of this cloning phase?
Copy the source <806 ORACLE_HOME> and <RDBMS ORACLE_HOME> directory to the target system.
As an independent consultant, you are working on implementation of Oracle Applications in a three-tier configuration. When connected to the Oracle Applications Purchase Order forms window, you notice that there is a yellow bar at the bottom of the forms window. Identify the best method of troubleshooting this issue.
Un-install and re-install JInitiator.
In which three cases is it most effective to run validation on the APPS schema in the Oracle Applications 11i E-Business Suite setup? (Choose three.)
immediately after an upgrade or applying a maintenance pack
after a patch or multiple patches are applied
whenever you receive a run-time error that suggests that a problem is caused by the AD_DDL package
Oracle Applications produce temporary PL/SQL output files used in concurrent processing. These files are written to a location on the database server node specified by the APPLPTMP environment setting. What would be the value of APPLPTMP in the environment setting?
one of the values defined for the parameter UTL_FILE_DIR in the init.ora file
What kind of files can be found in the <PROD_TOP>/admin directory?
product-specific files used by AutoUpgrade to upgrade that product
After cloning an Oracle Applications system, there may be data in the target system that is specific to the source system and is no longer needed. The Applications DBA plans to run the Initiate the Data Purge program. What would this plan of the Applications DBA do to the target system?
successfully remove unwanted data specific to the source system.
The Oracle Applications 11i database administrator (DBA) runs the "Recreate grants and synonyms for APPS schema" task by using the adadmin utility when grants or synonyms are missing from the database. Which three causes may be responsible for this? (Choose three.)
installing or maintaining Oracle Applications 11i EBS underlying database components or options such as Replication
patch and administrative sessions that failed to run successfully to completion
incomplete database migrations (exports/imports)
You suddenly start receiving errors indicating that there are numerous Java files in the database that are corrupted and cannot be run. You have determined that you have to reload the Java Virtual Machine (JVM) to fix the errors. In addition to reloading the JVM, what Oracle database utilities, if any, do you need to run and why? (Choose all that apply.)
Reload JAR files to the database, because after reloading the JVM, the Java class files would be missing.
When does the FND_INSTALL_PROCESSES table get created in the Oracle Applications 11i EBS database?
when AutoPatch or AutoUpgrade or AD Administration programs process jobs
A customer is encountering some bugs in Oracle Accounts Payable and has learned that bug fixes are available. The best approach is to look for a _____.