1.How do u apply a patch in non-interactive mode ?
2.What are the various kinds of patches you have applied ?
3.What is the methodology you use for promoting the patches ?
4.Did u ever run into a situation where a u encountered a error during Maintenance Pack or Mini-pack ?
5.What are the various errors you encountered in oracle applications patching ? List atleast 3 scenarios ?
6.How do you skip a job in the patch ?
7.How do you restart a failed job ?
8.How do u regenerate a form using adadmin ?
9.What are the steps which needs to be done using adadmin when we add a new langugae ?
10.How do u re-create grants and synonyms using adadmin ?
11. Did u ever regenerated the jar files, if so how do u regenerate those ?
12. How do you create the dbc file, if it is corrupted ?
13. How do you re-create the identitydb.obj file ?
14. What is oajinit.exe ? How d you recompile/rebuild this ?
15.What is the ad command you use to vadlidate a oracle apps table definition ?
16.How do you add a new product which is not part of current release ?
17.How do relink a specific executable FNDLIBR ?
18.What is the location of ad utilities log files ?
19.Give the detail steps for cloning oracle applications using rapidclone ?
20.Give the detail steps for running the autoconfig ?
21.How do u rebuild an autoconfig XML file if it is corrupted ?
22.Which utilities/scripts are needed for merging APPL_TOPS during shared appl_top implementation ?
23. Did u ever used the autoinstall ad utility ? When did u you used it for what purpose ?
24. Give me the steps for upgrading apps database from 9.2.0.7 to 10.2.0.2 ?
25. Give me the steps for upgrading apps from 11.5.8 to 11.5.10.2 ?
26. Give me the high level steps for upgrading apps from 11.5.9 to R 12 ?
27. What change management tools you have used before ?
28. What are the advantages with third party tools such as ringmaster or kintana ?
29.What is maintenance mode ? How do u disable/enable this ?
30.How do u identify/copy missing files in oracle applications ?
UNIX
1. Give me the list of TOP 20 UNIX commands which you use every day?
2. Where do you find logfiles, outfiles, manager log files location.
3. Where do you find concurrent manager (ICM) startup script location.
4. What is environment setting $APPLCSF used for ?
5. Verify the location of the APPSORA.env
6. Verify the location of the APPS$SID_$HOSTNAME.xml file
7. Verify the startup/shutdown scripts location
8. Describe the 3 different methods which can be used for identifying the no of nodes/servers used ?
9. Where do u find startup/shutdown scripts for Concurrent, Forms, Web server ?
10. Where do u find db & listener startup scripts ?
11. Give the detail steps for starting and shutting down oracle applications ?
12. Give the various UNIX commands u use to perform the health-check of Apache, Forms, Concurrent ?
13. How do you check the version of a file from UNIX server ?
14. When the developer develops the below code objects where do you save those ? PLL,FMB,RDF,SQL,PKS,PKB,JSP,JAVA CLASS FILE,HTML FILE.
15. What is the difference between FMB and FMX , PLL AND PLX ?
16. What are the TOP 5 important directories in oracle apps environment ?
17. Where do u find the concurrent manager log file ?
18. What troubleshooting steps you use when you get a page not found error ?
19. Where do u find the XML configuration file ? What information it will contain ?
20. How do you identify all the important port numbers used in an oracle apps environment ?
21. What is RRA ? Why do u need it ? Tell me about your understanding of this process ?
22. What are the important environment files in Oracle Applications ?
23 Give the sequence of steps to start or shutdown the ebusiness suite?
24. How do you change the naming convention for conc req log and out files?
25. Where does the concurrent req log files and out files would be created ?
26. What is RRA listener? When does u need this listener?
27. How do you identify the conc mgr details of a conc request?
28. How do you generate a PLL file?
29. Provide me the syntax to generate the FMB file in oracle applications?
30. What is the location of the directory in which we can find CUSTOM.pll?
31. Where do I find all the FMB files in the server?
32. What the steps for changing the APPS Schema password?
33. What the steps for changing the GL Schema password?
34. How do you enable debug mode for apache server?
35. How do you enable debug mode for Jserv engine?
36. What is aoljtest.jsp? How does it helpful? When do you use it?
37. How do you identify if a patch is applied using SQL statement?
38. How do you troubleshoot the invalid objects issue?
39. How do you identify the version of the package FND_FILE?
40. How do you identify the Jserv port which is being used?
41. How do you check from client pc if you can communicate with port 80 ?
42. What is the syntax to verify if the port (for ex 8010) is in use?
43. What is the syntax to check if the forms server is up?
44. What is the syntax to check if the jserv engine is up?
45. How do you verify if the concurrent manager is up?
46. How do you verify if the RRA listener is up?
47. What is SID_hostname.xml ? Why does u need it?
48. What is SID_hostname.env? Where does u find this file?
49. How do you verify if autoconfig is enabled in APPS environment?
50. What the location of the jserv log files?
51. What is the location of the apache log files?
52. How do you ensure that customizations are not over written?
53. How do you run autoconfig? What is the syntax?
54. How do you compile a jsp page?
55. How do you compile a .java package to create .class files?
56. What is jar file?
57. What is AF_CLASSPATH? Why do you need this?
58. Where does oracle keep all the jar files and class files?
59. How do you identify the jinitiator class id and jinitiator version?
60. How do you identify the Perl version?
61. How do you check the forms patch set level and version?
62. How do you identify all the nodes of a multi-node environment?
63. What is adovars.env? adconfig.txt? topfile.txt?
64. What is the location of the dbc file?
67. Where do you track of the customization information so that patches will not overwrite customizations ?
68. Which method you use to preserve custom environment setups so autoconfig will not overwrite those ?
69. What is the syntax to generate a FMB and PLL file in UNIX enviroment ?
70. What is the syntax to generate a RDF file in UNIX enviroment ?
71. How do you load the workflow configuration information to the database ?
72. What is the syntax for FNDLOAD to transfer responsibilities from one instance to another instance ?
73. What is the syntax for FNDLOAD to transfer custom concurrent programs from one env to other ?
74. What is the syntax for FNDLOAD to transfer menus from one instance to another instance ?
75. What is the syntax for changing the FRONT-END USER password using FNDCPASS ?
sql
1. Develop a sql statement from apps schema verify if u can identify all scheduled concurrent request
2. Develope a sql statement error, terminated requests from both front-end and back-end sqlplus.
3. Develope a sql statement to identify the concurrent requests which took more than 30 minutes time.
4. Develope a sql statement to Identify the session id and os process id for a running concurrent request
5. Develope a sql statement to Identify how many concurrent requests are being run/per day.
6. Develope a sql statement to identify all the installed modules and their mini-pack level.
7. Develope a sql statement to list all the active users using "SQL Statement"
8. Develope a sql statement to list all custom responsibilities using "SQL Statement"
9. Develope a sql statement to list all the custom functions, forms, menus using "SQL statements"
10. Write a SQL to identify all the running concurrent requests?
11. Write a SQL to identify all the reqs which took more than 30 minutes?
12. Write a SQL to identify all the schedule jobs and cancel those?
13. Write a SQL to identify all the error concurrent requests?
14. Write a SQL to identify all the running concurrent requests?
15. Write a SQL to verify all the profile option values set for SYSADMIN user?
16. Write a SQL to identify all the customizations in oracle applications?
17. Write a SQL Query to check the status of the concurrent manager?
18. Write a SQL Identify the source code of a pl/sql package FND_FILE?
19. Run adutconf.sql and verify the output
20. What is cmclean.sql? When does u need to run it ? What precautions u need take when you run it?
21. What is the script you use to identify which modules are installed? and their mini-pack level ?
22. Tell me about the back-end database tables FND_USER, FND_CONCURRENT_QUEUES,FND_CONCURRENT_REQUESTS,FND_ORACLE_USERID,FND_APPLICATION_VL,FND_PRODUCT_INSTALLATIONS.
23. Write a SQL to identify the biggest FND table in the database?
24. Give me the list of TOP 20 database dynamic v$ views?
25. Give me the list of TOP 10 init database parameters?
26. What kind of database objects will get stored in base schema?
27. What kind of database objects will get stored in APPS schema?
28. Describe the importance of APPLSYSPUB,APPS,APPLSYS schemas?
29 Write a SQL to identify the node names for the forms, concurrent, db, web tiers"?
30. Write a SQL to identify all the oracle patch jobs which were skipped?
31. Write a SQL to identify all the pending workflow notifications?
32. Write a SQL to identify the active forms sessions ?
33. Write a SQL to list the ORCLE APPLICATIONS FRONT-END USER NAME based on the database session ID ?
34. Write a SQL to list the ORCLE APPLICATIONS FRONT-END USER NAME based on the OS process id ?
35. Write a SQL to list the ORCLE APPLICATIONS FRONT-END USER NAME based on the concurrent request?
35. Write a SQL to list the standard manager concurrent request queue hourly workload for the last one week ?
36. Write a SQL to identify all the inactive users in the system ?
34. Write a SQL to identify all the active users who didnt log into oracle applications for the last 30 days ?
35. Write a SQL to identify all the patches applied in the last 30 days ?
SYSADMIN
1. What is the typical WEB url for Oracle Applications Front-End Access ?
2. What are the different kinds of user interfaces exist for Oracle Applications ?
3. Explain me about the login process for Oracle Applications ?
4. Describe Java Applet, JRE, Oracle JRE, Jinitator, Jar Files , ?
5. How do u enable the java console on client jinitiator ?
6. What is Oracle Application Profiles ? Tell me about Key SYSADMIN profiles which you are aware of ?
7. What are the various levels in which we can set the profile ?
8. Describe the difference between Key-Flexfield an Descriptive Flexfield ?
9. Describe the LIST-ITEM, LOV, Multi-Record Block, Single Record Block ?
10. How do you query the existing records from front-end Form ?
11. What are the famous key board function keys which you widely used in your experience ?
12. How do you check the record history ? Who created the record who updated the record ?
13. Create New User "TEST123" with Password "WELCOME123"
14. This user account should be active for 180 days only.
15. Password Expiration should be set for every 90 days
16. Assign the responsibility "Payables Manager".
17. Assign the responsibility "Workflow Web Administrator".
18. Login as user "TEST123".
19. Query the user "TEST 123.
20. Assign the responsibility "Receivables Manager"
21. Query the responsibility "Receivables Manager"
22. Using function security, disable access to Bank Accounts Form in the receivables manager
23. Using menu security, disable access to "Setup Menu"
24. Create a custom menu "XXAP Clerk" which should be a copy of "AP_INVOICES_GUI12"
25. Add function "AP Accrual Write-Offs GUI" to the above menu.
26. Create a request group "XXAP_CUSTOM_REQGRP"
27. Add " Active Users" concurrent programs to request group "XXAP_CUSTOM_REQGRP"
28. Add a request set to the request group "XXAP_CUSTOM_REQGRP"
29. Add all payables modules reports to request group "XXAP_CUSTOM_REQGRP"
30.Add "Gather Schema Stats" concurrent programs to request group "XXAP_CUSTOM_REQGRP"
31. Grant "Order Management" Reports access to the above request group"
32. Create a new responsibility "XXAP Clerk"
33. Assign "XXAP Clerk" Menu, "XXAP_CUSTOM_REGGRP", Standard Datagroup
34. Assign this responsibility to the "TEST123" user
35. Login as TEST123 user and navigate to above responsibility
36. Verify the "Active Users" Report by running it.Check the output and logfile.
37. Schedule "Purge Concurrent Request" program to run every day at 11pm to purge requests ?
38. Verify the Notify feature to see if u can get an email after the concurrent request completes.
39. Query all the concurrent request which are submitted by user "VIJAY" using System Administrator ?
40. Using Find Request window, verify all scheduled jobs
41. Run a concurrent program "Gather Schema Stats" for all schemas with 30% estimate.
42. Enable auditing for "AP_INVOICES_ALL.INVOICE_AMOUNT" using "AUDIT TRAIL" screens.
43. Using syadmin Identify all the users who are using "System Administrator" Responsibility.
44. Develop a sql script as concurrent program and tests this as sysadmin from "Payables Manager"
45. Develop a custom form test this as sysadmin from "Payables Manager" Responsibility
46. Query the purchase order "1111" and check the back-end table.
47. Verify the cache size of the "Standard Manager"
48. Downsize the "Standard Manager" Processes from seeded value to "2"
49. Create and Assign a new work shift during which 40 processes should be activated for standard manager.
50. Create specialization rules to exclude conc prog submitted by vijay from "STANDARD MANAGER"
51. Create a custom "Batch Standard Manager" and setup a rule to include only programs run by VIJAY.
52. Login to "System Administrator". Identify APPL_TOP location
53. Login to "OAM" identify the node names for the forms, concurrent, db, web tiers"
54. Verify if workflow background process request is scheduled.
55. Using OAM Verify the workflow mailer IMAP & SMTP settings. Try to start the workflow Mailer.
56. How do you check workflow status for all errored out purchase orders & Retry them
57. Using Workflow Administrator Responsibility Change the workflow administrator role
58. Using OAM Verify the module install status for module "Advanced Pricing". Install it using "OAM"
59. Verify if a patch has been applied using "OAM"
60. How do you enable the trace for a front-end forms session?
61. How do you enable the trace for a concurrent program?
62. How do you enable the trace for a running concurrent program
63. How do you troubleshoot a long running request?
64. How do you identify all the attached PLLS for a FMB file?
65. Submit a request ? Check the output ? Get the output file from server to your laptop using ftp command
66. Schedule a concurrent request to run every day at 1AM ?
67. Turn on the 11046 level 12 trace for a specific user session
68. Try to enable the trace from front-end for "Define Users Form"
69. Identify the back-end database session for a front-end apps-session and enable the trace.
70. Enable the trace and run a concurrent program in trace mode.
71. Identify the server side os process for the standard manager concurrent manager using front-end app.
72. Shutdown standard manager using sysadmin resp. Try to start it using SYSADMIN responsibility.
73. How do u identify the OS process id for a Given concurrent manager ?
74. How do u identify the OS process id for a Given concurrent request ?
75. Tell about the profile option names which will have values about forms server, discoverer, jsp, help ?
76. Tell be about various phases and statuses of a concurrent request ?
77. Tell me about ICM,CRM,STANDARD & Transaction managers ?
78. What is workshift ? How does it help tunning the concurrent manager workload ?
79. How do you setup the PCP in oracle applications ?
80. Which profile can be used to enable the trace at session level ?
Features/Release Content Documents
Note 210326.1, Oracle Applications DBA 11i+ Features Matrix
Note 163400.1, Release Content/New Features Documents for Patch Sets, Family Packs & New Releases
Note 289972.1 , 11.5.10 Release Information
Note 294932.1, Recommendations & Release Notes to Install Oracle Applications 11i
Cloning/Autoconfig/Shared APPL_TOP
Note 165195.1, Using AutoConfig with Oracle Applications 11i
Note 218089.1, Frequently Asked Questions About Using AutoConfig With Oracle Applications Release 11i
Note 217368.1, Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i
Note 230672.1, Cloning Oracle Applications Release 11i with Rapid Clone
Note 216664.1, Frequently Asked Questions About Cloning Oracle Applications 11i
Note 18070.1, How to Make a Copy of a Database on the Same UNIX Machine
Note 233428.1, Sharing the Application Tier File System in Oracle E-Business Suite11i
Patching
Note 181665.1, Release 11i Adpatch Basics
Note 457566.1, Oracle Applications Patching FAQ for Release 11i
Note 60766.1, Patch Installation Frequently Asked Questions
Note 224875.1, Installation, Patching & Upgrade Frequently Asked Questions (FAQ's)
Note 308916.1, How To Install Interim Patches with Opatch
Note 242480.1, Using a Staged Applications System to Reduce Patching Downtime
Note 225165.1, Oracle Applications 11i Patching Best Practices and Reducing Downtime
Note 259484.1, Release 11.5.10 Maintenance Pack Installation Instructions
Installations & Upgrades
Note 240744.1, Technology Validation Utility for Oracle Applications Release 11.5.9
Note 403311.1, Daylight Saving Time (DST) Compliance for Oracle E-Business Suite
Note 458452.1, Complying with DST and Time Zone Rule Changes in E-Business Suite 11i
Note 465915.1, Using Oracle VM with Oracle E-Business Suite Release 11i or Release 12
Note 216550.1, Interoperability Notes Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
Note 282038.1, Interoperability Notes Oracle Applications Release 11i with Oracle Database10.1.0
Note 362202.1, Interoperability Notes Oracle Applications Release 11i with Oracle Database 10g (10.1.0.4)
Note 362203.1, Interoperability Notes Oracle Applications Release 11i with Oracle 10g Release 2 10.2.0)
Note 452783.1, Interoperability Notes - Oracle E-Business Suite Release 11i with Oracle Database 11.1.0
Note 125767.1, Upgrading Developer 6i with Oracle Applications 11i
Note 164317.1, Upgrading Oracle JDBC Drivers with Oracle E-Business Suite 11i
Note 124606.1, Upgrading Oracle JInitiator with Oracle Applications 11i
Note 201340.1, Using Forms Listener Servlet with Oracle Applications 11i
Note 181244.1, Configuring an X Display Server for Applications on Unix Platforms
Note 146468.1, Installing Oracle9i Application Server with Oracle Applications 11i
Troubleshooting Oracle Applications
Note 295606.1, 10gAS with Oracle E-Business Suite Release 11i Troubleshooting Guide
Note 342332.1, Troubleshooting Login Problems in Oracle Applications 11i (11.5.2 – 11.5.10+)
Note 169935.1, Troubleshooting Oracle Applications Performance Issues
Note 380487.1, Oracle Application Server 10g with Release 12 Troubleshooting Guide
Note 226265.1, Troubleshooting Guide for AutoAccounting
Note 365529.1, Troubleshooting FRM-92XXX Errors in Oracle Applications
Note 139863.1, Troubleshooting Self Service Framework with Oracle Applications 11i
Note 216208.1, Oracle9i Application Server (9iAS) with Oracle E-Business Suite Release 11i Troubleshooting
Application Server/Java
Note 300482.1, Overview of Using Java with Oracle E-Business Suite Release 11i
Note 285218.1, Recommended Browsers for Oracle Applications 11i
Note 290807.1, Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
Database and High Availability/RAC & ASM
Note 362135.1, Configuring Oracle E-Business Suite Release 11i with 10g Release2 RAC and ASM
Note 312731.1, Configuring Oracle Applications Release 11i with 10g Real Application Clusters and 10g ASM
Note 279956.1, Oracle E-Business Suite Release 11i with 9i RAC
Note 351646.1, Configuring Release 11i with 10g Database on Raw Devices
Note 341437.1, Business Continuity for Oracle Applications Release 11i Using RAC & Data Guard
Note 294652.1, Configuration Oracle E-Business Suite 11i RAC Environments (Load Balancing )
Application Server/Portal/Web Cache
Note 186981.1, Oracle Application Server with Oracle E-Business Suite Release 11i FAQ
Note 223927.1, Oracle Application Server Integration with Oracle E-Business Suite: Statement of Direction
Note 254618.1, HTTP Server Patches Certified to be used with E-Business Suite 11i External Integrations
Note 233436.1, Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i
Note 305918.1, Using Oracle Portal 10g with Oracle E-Business Suite 11i
Note 306653.1, Installing and Configuring 10gAS Web Cache with Oracle E-Business Suite 11i
Note 146469.1, Configuring Oracle Applications with Oracle Portal
Security/Encryption/SSL/OID/DMZ/SSO
Note 189367.1, Best Practices for Securing Oracle E-Business Suite
Note 287176.1, Oracle E-Business Suite 11i Configuration in a DMZ
Note 123718.1, A Guide to Understanding and Implementing SSL with Oracle Applications 11i
Note 340178.1, Enabling SSL with Oracle Application Server 10g and the E-Business Suite
Note 234599.1, Enabling Oracle Label Security in Oracle E-Business Suite
Note 391248.1, Encrypting EBS 11i Network Traffic using Advanced Security Option / Advanced Networking
Note 403294.1, Using Transparent Data Encryption with the E-Business Suite
Note 428503.1, Integrating Oracle E-Business Suite Release 11i with Oracle Database Vault 10.2.0.
Note 150832.1, Implementing Oracle Applications Synchronization with LDAP
Note 261914.1, Integrating Oracle E-Business Suite Release 11i with OID and Oracle Single Sign-On
Database
Note 285267.1, Oracle E-Business Suite Release 11i and Database FAQ
Note 216205.1, Database Initialization Parameters and Configuration for Oracle Applications 11i
Note 343917.1, Frequently Asked Questions: Using Oracle Applications with an x86-64 Database Server",
Note 311717.1, Frequently Asked Questions: Using Oracle Applications with an Itanium Database Server
Note 332977.1, Using Oracle Applications with an HP OpenVMS Alpha Database Server
Export & Import
Note 204015.1, Export/Import Process for Release 11i Database Instances Using Oracle8i Enterprise Edition
Note 230627.1, Export/Import Process for Release 11i Database Instances Using Oracle9i Enterprise Edition
Note 331221.1, Export/Import Process for Release 11i Database Instances Using Oracle10g Enterprise Edition
Note 362205.1, Export/Import Process for Release 11i Database Instances Using Oracle Database 10g R2
Split Configurations
Note 304489.1, Using Oracle Applications with a Split Configuration Database Tier on Oracle9i Release 2
Note 356839.1, Using Oracle Applications with a Split Configuration Database Tier on Oracle 10g Release 1
Note 369693.1, Using Oracle Applications with a Split Configuration Database Tier on Oracle 10g Release 2
Discoverer
Note 257798.1, Using Discoverer 10g (9.0.4) with Oracle Applications 11i,
Note 139516.1, Discoverer 4i with Oracle Applications 11i,
Note 313418.1, Using Discoverer 10g with Oracle Applications 11i
No comments:
Post a Comment