CrowdforGeeks | Build Skills with Online Courses from Top Institutions

Top 50 Oracle Apps Dba Interview Questions

Q1. What Is Gwyuid?

GWYUID stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB

Q2. How To Check If Oracle Apps 11i System Is Rapid Clone Enabled?

For machine to be Rapid Clone enabled, it have to be Autoconfig enabled. You need to have Rapid Clone Patches applied.

Q3. How To Compile Jsp In Oracle Apps?

You can use ojspCompile.Pl perl script shipped with Oracle apps to assemble JSP documents. This script is below $JTF_TOP/admin/scripts. Sample compilation method is

perl ojspCompile.Pl --collect --quiet

Q4. What Is Us Directory In $ad_top Or Under Various Product Top's?

US directory is default language directory in Oracle Applications. If you have got a couple of languages Installed to your Applications then you will see other languages directories except US, that directory will include reviews, fmx and other code in that respective listing like FR for France, AR for Arabic.

Q5. What Is 0 & Y In Fndcpass, Fndload Or Wfload?

Zero & Y are flags for FND Executable like FNDCPASS & FNDLOAD in which zero is request id. 'Y' suggests the approach of invocation i.E. It's miles at once invoked from the command-line now not from the Submit Request Form.

Q6. What Is Dev60cgi & F60cgi?

Cgi stands for Common Gateway Interface and those are Script Alias in Oracle Apps used to access bureaucracy server . Usually Form Server access at once via http://hostname:port/dev60cgi/f60cgi.

Q7. How You Will Start Discoverer In Oracle Apps 11i?

In order to begin discoverer you can use script addisctl.Sh underneath $OAD_TOP/admin/scripts/$CONTEXT_NAME or startal.Sh below $ORACLE_HOME/discwb4/util (below Middle/Application Tier)

Q8. Where And How You Update Workflow Notification Mailer Configuration Setting?

This depends on which workflow mailer you're running C Mailer or Java Mailer.

Q9. If You Want To Change Concurrent Manager Log And Out File Location, Is It Possible, If Yes, How? If No, Why Not?

By default popular location is $APPLCSF/$APPLLOG, in some instances it can visit $FND_TOP/log as nicely.

Q10. What Are Main File Systems In Oracle Apps?

APPL_TOP, COMMON_TOP, DB_TOP,ORA_TOP 7

Q11. If The User Is Experiencing Performance Issues, How Will You Go About Finding The Cause?

Trace his consultation (with waits) and use tkprof to research the hint record.

Take a statspack document and analyze it.

O/s tracking the use of pinnacle/iostat/sar/vmstat.

Check for any community bottleneck through the usage of fundamental tests like ping results.

Q12. Adident Utility Is Used For What?

Adident software in oracle apps is used to locate model of any file .

For example:“adident Header <filename>”

Q13. What Is Pcp Is Oracle Applications 11i?

PCP is acronym for Parallel Concurrent Processing. Usually you've got one Concurrent Manager executing your requests however you may configure Concurrent Manager jogging on machines. So for some of your requests primary CM Node is on machine1 and secondary CM node on machine2 and for a few requests number one CM is on machine2 & secondary CM on machine1.

Q14. How You Will Troubleshoot If Concurrent Request Is Taking Long Time?

First you may try to test how a long way the question has long gone (if in v$session_longops as an example, or studying some session records) and if there is rivalry with any other session (consisting of a lock as an example) as it talks approximately a 'concurrent request'.

Method 1: Trace the consultation the usage of dbms_system.Set_sql_trace_in_session (or) if u r the use of 10g, the use of dbms_monitor and have a look at the trace file to discover where the issue is. You can get the provide an explanation for plan and song the question.

Method 2:

Is this a new question (or) an existing query

Look for the wait event related to this question.

Based at the square hash price, examine the sql_text from v$sq.

Run an provide an explanation for plan (or) use oradebug and trace the question if what bind variables are the usage of and the way the data distribution is.

Based on the above records, search for whilst facts changed into accrued

Once u understand wherein the hassle is, then solutions may be defined starting from creating square profiles / stored outlines (or) including tips to the question and carefully test your modifications.

Always do not forget to make one alternate and test for performance alternate. If you are making a series of modifications, it'll be very tough to isolate which has caused the performance improvement.

Q15. What Is The Importance Of Imap Server In Java Notification Mailer?

IMAP stands for Internet Message Access Protocol and Java Notification mailer require IMAP server for Inbound Processing of Notification Mails.

Q16. What Are .Ldt And .Lct Files Which You See In Apps Patch Or With Fndload?

.Ldt & .Lct stands for Loader facts document & Loader configuration files, used frequently in migrating customization, profile alternatives, configuration statistics etc. Throughout Instances.

Q17. What Happens If You Don't Give Cache Size While Defining Concurrent Manager?

Lets first recognize what's cache length in Concurrent Manager. When Manager choices request from FND CONCURRENT REQUESTS Queues, it's going to choose up range of requests defined by means of cache size in one shot & will paintings on them earlier than going to sleep. So in my views in case you do not outline cache length at the same time as defining CM then it'll take default cost 1, i.E. Selecting up one request in step with cycle.

Q18. What Is Apps Listener? Why Is It Used?

Apps Listener commonly run on all Oracle Applications 11i Nodes with listener alias as APPS_$SID and is specifically used for listening requests for offerings like FNDFS & FNDSM.

Q19. Does Rapid Clone Takes Care Of Updating Global Orainventory Or You Have To Register Manually In Global Orainventory After Clone?

Rapid Clone mechanically updates Global oraInventory for the duration of configuration phase. You do not ought to do whatever manually for Global oraInventory.

Q20. What Is Multi Node System?

Multi Node System in Oracle Applications 11i me you have Applications 11i Component on more than one system. Typical example is database, Concurrent Manager on one system and Forms Server, Web Server on 2d gadget.

Q21. What Is Appl_top, Comn_top, Ora_top.....?

XXX_TOP is pinnacle level listing in Oracle Application 11i for respective Component.

Q22. What Is The Location Of Jinitiator In The Desktop Tier?

C:/programfiles/oracle/Jinitiator.

Q23. What Are Restart Files And Its Location?

These documents incorporate the preceding session information approximately adadmin. Location is $APPL_TOPadminsidrestart*.Rf9

Q24. How Will You Change The Location Of Concurrent Manager Log And Output Files?

The location of log files is determined with the aid of parameter $APPLCSF/$APPLLOG and that of output documents by using $APPLCSF/$APPLOUT.

Q25. Why Does A Worker Fail In Oracle Apps Patch And Few Scenarios In Which It Failed For You?

Apps Patch worker can fail in case it does not find anticipated information, item, files or anything which driver is trying to replace/edit/alter. Possible signs and symptoms can be underlying tables/objects are invalid, a prerequisite patch is missing, login records is inaccurate, inconsistency in seed information.

Q26. Where Is Concurrent Manager Log File Location?

By default wellknown vicinity is $APPLCSF/$APPLLOG, in some cases it can go to $FND_TOP/log as well

Q27. Where Gwyuid Defined & Why Is It Used In Oracle Applications?

GWYUID is defined in dbc i.E. Database Connect Descriptor file. It is used to attach skinny clients to database.

Q28. In A Multi Node Installation, How Will You Find Which Node Is Running What Services?

You can question for desk FND_NODES and take a look at for column, SUPPORT_CP (for Concurrent Manager) SUPPORT_FORMS (for paperwork server), SUPPPORT_WEB (Web Server), SUPPORT_ADMIN (Admin Server), and SUPPORT_DB for database tier. You also can test same from CONTEXT File (xml record underneath APPL_TOP/admin).

Q29. What Is Difference Between Guest_user_pwd (guest/oracle) & Gwyuid?

GUEST_USER_PWD(Guest/Oracle) is utilized by JDBC Thin Client in which as GWYUID is utilized by Thick Clients like thru Forms Connections.

Q30. What Are Various Options Available With Adpatch?

Various options to be had with adpatch depending to your AD model are:

autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseportion, generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate

Q31. What Is Two_task In Oracle Database?

TWO_TASK mocks your TNS alias that you are going to apply to hook up with database. Let’s assume you've got database patron with TNS alias described as PROD to hook up with Database PROD on machine teachmeoracle.Com listening on port 152@Then ordinary way to connect is sqlplus username/passwd@PROD; now in case you do not need to use @PROD you then set TWO_TASK=PROD and then can certainly use sqlplus username/passwd then sq. Will take a look at that it has to hook up with TNS alias define with the aid of value PROD i.E. TWO_TASK

Q32. How To Retrieve Sysadmin Password?

If forgot password link is enabled and sysadmin account is configured with mail identification consumer neglect password hyperlink else you could reset sysadmin password through FNDCPASS.

Q33. How Do You Know The Package Version?

Choose text from dba_source wherein call='package deal name' and kind='PACKAGE BODY' and rownum<10>/rdbms/admin)

Q34. If You Have Done Two Nodes Installation, First Machine: Database And Concurrent Processing Server. 2d Machine: Form, Web. Which Machine Has Admin Server/node?

Admin Server could be on First gadget with concurrent processing server.

Q35. What Is Context File?

Oracle shops all the environment precise values in an xml record stored in $APPL_TOP/admin listing, which they call an utility context record. This document is created through going for walks adbldxml.Sh/adbldxml.Pl (Located in $AD_TOP/bin). Adbldxml.Sh in flip runs oracle.Apps.Advert.Context.GenerateContext java magnificence.

Context record is generated by way of plugging in surroundings particular values in the context document template (don’t confuse this template with the configuration document templates) $AD_TOP/admin/template/adxmlctx.Tmp. In older variations of 11i these substitute values have been gotten from config.Txt record (created by rapidwiz at some stage in set up), but in later versions, those values are gotten from the records, in current configuration documents and the database. Adbldxml.Sh/adbldxml.Pl (in more recent variations of autoconfig) creates an in depth log file, detailing the supply for each context variable.

Q36. There Are Lot Of Dbc File Under $fnd_secure, How Is It Determined That Which Dbc File To Use From $fnd_secure?

This fee is decided from profile option "Applications Database ID"

Q37. How Do You Start The Apps Services?

$COMMON_TOPadminscriptsContextnameadstrtal.Sh apps/apps

Q38. What Could Be Wrong If You Are Unable To View Concurrent Manager Log And Output Files?

Most in all likelihood the FNDFS listener is down. Look on the fee of OUTFILE_NODE_NAME and LOGFILE_NODE_NAME in the FND_CONCURRENT_REQUESTS table. Look at the FND_NODES table. Look at the FNDFS_ entry in tnsnames.Ora.

Q39. What Is .Dbc File, Where Is It Stored, What Is The Use Of .Dbc File?

DBC. As name suggests is a database connect descriptor report which stores database connection records utilized by application tier to connect with database. This record is in listing $FND_TOP/comfortable also referred to as as FND_SECURE.

Q40. What Is Mrc? What You Do As Apps Dba For Mrc?

MRC also referred to as as Multiple Reporting Currency in Oracle Apps. By default you have got forex in US Dollars but in case your agency’s working books are in other currency then you as apps DBA want to enable MRC in Apps.

Q41. How Do You Validate Apps Schema?

To validate synonyms, lacking synonyms and all grants use adadmin. After validating it'll produce a record inside the area $APPL_TOPadminsidout*.Out

Q42. When You Apply C Driver Patch Does It Require Database To Be Up & Why?

Yes, database & db listener ought to be UP when you apply any motive force patch in apps. Even if driver is not updating any database item connection is required to validate apps & other schema and to upload patch history facts in database tables.

Q43. What Is Difference Between .Xml File And Autoconfig?

Autoconfig is Utility to configure your Oracle Application surroundings. Xml report is repository of all configuration from which AutoConfig choices configuration and populates related documents.

Q44. How Can You License A Product After Installation?

You can use advert software adlicmgr to license product in Oracle Apps.

Q45. What Is Difference Between Mod_osso & Mod_ose In Oracle Http Server?

Mod_osso is Oracle Single Sign-On Module wherein as mod_ose is module for Oracle Servlet Engine.

Q46. If By Mistake Someone Deleted Fndlibr Can This Executable Be Restored If Yes, How & If No, What Will You Do?

Yes, you can repair FNDLIBR executables

Run adadmin on concurrent supervisor node

Select Maintain Applications Files menu

Then choose Relink Applications packages

When prompts for “Enter listing of merchandise to link ('all' for all products) [all]” choose FND

When spark off for “Generate specific executables for every selected product [No]?” pick out YES

From listing of executables pick FNDLIBR this could create new FNDLIBR executables