Job Search comment: OracleDBA interview questions

Welcome to the Oracle community forum and interact with 2 million technical staff to enter the IT work market, which is so tight that a bunch of people are applying for each position. NaveenNahata provides the following technical questions for the database administrator applicant for OracleE-BusinessSuite who can help applicants quickly stand out. If

Welcome to the Oracle community forum and interact with 2 million technical staff> IT is so tight to enter the IT market that a bunch of people are applying for each position. Naveen Nahata provides the following technical questions for database administrators in Oracle E-Business Suite during interviews to help applicants quickly stand out. If

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

The IT work market is so tight that a bunch of people are applying for each position. Naveen Nahata provides the following technical questions for database administrators in Oracle E-Business Suite during interviews to help applicants quickly stand out. If your interviewer asks you a similar question and sends an email to me, I will add it to the list .?? Editor's Note

　　Problem

1 What if the information collection management system (ICM) crashes?

2. How do you accelerate the patching process?

3. An error occurred while patching. What should I do?

4. Provide the clone process and the steps for manual operation after cloning.

5. Introduce AutoConfig. How does AutoConfig know which resin in the XML file needs to be put into which file?

6. Can you tell me what tests have you performed on a faulty self-service LOGIN problem? Which configuration file operation options and files do you want to check?

7. If you cannot see the concurrent management log and output file, what is the error?

8. How do you change the location of concurrent management logs and output files?

9 if you are experiencing performance problems, how do you find the cause?

10. How do you change the password of an application?

11. Write the location of the DBC file and explain its importance and how the application knows the DBC file name?

　　Answer

1. All other managers will continue to work. ICM only processes the queue control request, which means to enable and disable other concurrent managers.

2

2.1 you can merge multiple patches.

2.2 you can create a response file for a non-interactive patch.

2.3 you can apply patches through the options (nocompiledb, nomaintainmrc, nocompilejsp) and run them once after all patches are applied.

3. view the failure logs, locate and correct the error, and use the adctrl tool to re-enable the work.

4. Run pre-clone on the source file (all layers), use RMAN to copy the database (or store the database again from hot or cold backup), and copy the file system, then run post-clone on the target file (all layers.

Manual steps (more may be performed ):

4.1 change the values of all non-website configuration options (if you perform a quick clone, only the site-level configuration file options are changed ).

4.2 modify the workflow and concurrency manager table.

4.3 change the printer.

5. AutoConfig uses a context file to maintain key configuration files. A context file is an XML file, which is stored centrally in the $ APPL_TOP/admin directory.

When you run AutoConfig, it reads the XML file and creates all AutoConfig management configuration files.

Each configuration file maintained by AutoConfig has a temporary file to determine which value is obtained from which XML file.

6

6.1 check the user name and password of the guest in the DBC file, and configure the user name and password and database of the Option guest.

6.2 check whether apache/jserv is started.

6.3 run IsItWorking, FND_WEB.PING, and aoljtest.

7 it is likely that the FNDFS listener has stopped. See the values of OUTFILE_NODE_NAME and LOGFILE_NODE_NAME in the FND_CONCURRENT_REQUESTS table. Look at the FND_NODES table. Look at FNDFS _ entry in tnsnames. ora.

8. The location of the love girl in the log questionnaire is determined by the $ APPLCSF/$ APPLLOG parameter, and the location of the output file is determined by $ APPLCSF/$ APPLOUT.

9

9.1 trace this session (with waiting) and use tkprof to analyze the Tracing file.

9.2 generate and analyze the statspack report.

9.3 use top/iostat/sar/vmstat to monitor O/s.

9.4 ping the basic test results to determine the network bottleneck.

10

10.1 use FNDCPASS to change the APPS password.

10.2 manually modify the wdbsvr. app/cgiCMD. dat file.

10.3 change all database links from other environments.

11

11.1 location: $ FND_TOP/secure directory

11.2 importance: point to the database server in other transactions.

11.3 The application uses "Applications Database Id." To Understand The Name Of The DBC file.