DBA classic interview questions (4)

 
2. How do you accelerate the patching process?
Answer:
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 with the option and run them once after all patches are applied.
 
3. An error occurred while patching. What should I do?
Answer: Check the failure log, locate and correct the error, and use the adctrl tool to restart the work.
 
4. Provide the cloning process and the steps for manual operation after cloning.
Answer: Run pre-clone on the source file, use RMAN to copy the database, copy the file system, and then run post-clone on the target file.
 
Manual steps:
4.1 change the value of all non-website configuration options.
4.2 modify the workflow and concurrency manager table.
4.3 change the printer.
 
5. Introduce AutoConfig. How does AutoConfig know which tree value in the XML file needs to be put into which file?
Answer:
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. Can you tell me what tests do you perform on a faulty self-service logon problem? Which configuration file operation options and files do you want to check?
Answer:
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. If you cannot see the concurrent management log and output file, what is the error?
Answer: The FNDFS listener is probably 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. How do you change the location of concurrent management logs and output files?
Answer: the location of the log questionnaire is determined by the $ APPLCSF/$ APPLLOG parameter, and the location of the output file is determined by $ APPLCSF/$ APPLOUT.
 
9. If you are experiencing performance problems, how do you find the cause?
Answer:
9.1 trace this session 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. How do you change the password of an application?
Answer:
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.
-Indent: 2em ">
 
11. Write the location of the DBC file and explain its importance and how the application knows the file name of the DBC file?
Answer:
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.