However, there were problems using 7. These were addressed in the 7. In Newer Post Older Post Home. Subscribe to: Post Comments Atom. How to Find Patching History What happens when you login to Apps? Kontera Tag. If at all, no other manager is assigned to a program, that program will be picked by the standard manager. Question 5: What happened behind the scene when a concurrent request is submitted?
Now the conflict resolution manager takes care of the request and finds out what are the incompatibilities and sets the status pending normal when the incompatibilities are cleared. Question 6: Business users create the incident that Concurrent requests is taking a lot of time to complete.
What will be your approach for debugging it? Many times the users schedule the request to run at a later time. We will kill oracle session which is blocking in order to complete the job. You can see if the sid is stuck on a particular sql. If it is a particular sql, then it is good to check the statistics of the table involved. We can look for a tuning opportunity for that query.
For example, once a user came saying the request is not printing the output. Question 7: What happens when the internal concurrent manager dies abruptly? Are all the managers also killed immediately after it? No ALL the standard managers keep running and executing the request. No, the internal manager does not run or schedule any requests.
It has nothing to do with scheduling requests or deciding which manager will run a particular request. We can increase the target processes of the concurrent manager in order to increase the parallelism. This can be done using define concurrent manager form or through a direct update from sqlplus. Question If the internal manager goes down, do I need to kill all the managers before restarting the internal manager?
Answer No, if the internal manager goes down you need not kill all the managers. You can simply start the internal manager using startmgr. Ans : adrelink will relink the executables with the libraries. Generally we will go for adrelink when some patch delivers some library files, or when executables were corrupted.
How to find the version of a file? What is adodfcmp utility? How you will change apps password? What if apps password is changed with alter command? How to find out what component of u r oracle applications were installed on which node?
Ans : Xml file context file What is the configuration file for httpd and what is the location of it? Ans : httpd. When Apache starts what other components its start? What is jserv? Ans : jserv is nothing but servlet engine which will run u r servlets. What is self service application? Ans : Whatever part of u r oracle application u r able to see through web browser is self service.
Where u will see when u r not able to get self service applications? What is the location of jserv. What is the location of wdbsvr.
What are jserv. What is mean by clearing cache and bouncing apache? Stop apache adapcctl. Start apache adapcctl. What is forms configuration file and its location? What are the different modes u can start u r form server? Ans : socket and servlet What is the difference beween socket and servlet mode? Ans : In socket mode forms sessions are represented by f60webmx In servlet mode forms sessions are represented by apache processes. What is forms metric server and client?
Ans : When there are more than one form sever instances then forms metric server and clinet will be used to load balance. Where the forms server related errors will be logged? What is report server configuration and log file name and its location?
What is CGIcmd. Ans : CGIcmd. Where is the concurrent manager log file located? Is apps password necessary to start all the components of oracle application? Ans : No. What is a concurrent manager? Ans : A concurrent manager is one which runs concurrent requests. What are the different types of concurrent managers?
Internal concurrent manager — Will start all other managers and monitor 2. Standard Manager — All concurrent request by default will to go this 3. Conflict resolution manager — Concurrent programs with incompatabilites will be handled by this 4. Transaction manager — Handle all transaction requests Ans : Target is the no. Actual is the no.
Target and Actual should be always same. What if Target and Actual are not same? Ans : It means at operating system level resources are low to accomidate the required processes for concurrent managers. What are work shifts? Ans : Work shifts are nothing but timings at which the concurrent manager is supposed to run. What if internal concurrent manager target and actual are not same?
Ans : we need to bounce the concurrent manager using adcmctl. How to bounce a single concurrent manager? When we change apps password , is it necessary to bounce application? Ans : Only we need to bounce concurrent managers. What is dbc file and its location? Ans : dbc file contain database connection information. DBC file is used by oracle applications to connect to database. What is the other script by which u can start apache other than adapcctl.
How to skip copy portion while applying a patch? How to merge patches and what type of patches can be merged? Ans : admrgpch. What is the Tiered architecture of u r instance? How to find formserver version? Ans: f60gen and press enter, it will tell u the formserver version or we can find out from the frondend using help menu. What is RRA? What is apps listener?
What is GSM? Ans : GSM stands for Generic service Manager, which will monitor application processes like web, forms etc and restarts any of this processes if goes down. How to find the application version like How to find out what are the languages enabled in u r applications? What is the size of u r database? Ans : to GB How to find operating system version? Ans : uname —a What are the problems u have faced while shutting down applications?
If that request is only doing some select statement then we will kill those requests, otherwise we will check what time it will take to complete by querying the previous runs of that request and then we will decide what to do. What are the problems u have faced while starting up applications? Ans : Most of the time we will encounter problem with starting up concurrent managers.
How to find the locks and what is the resolution? How to kill a database session? Which files tell u the database helath? How to apply a rdbms patch? Ans : Using opatch How to find opatch is enabled or not for u r database? What is the pre-req for applying a rdbms patch? Ans : Inventory should be set in file oraInst. What is Inventroy?
What are different types of inventories? What is Global inventory? Ans : The Global Inventory is the part of the XML inventory that contains the high level list of all oracle products installed on a machine. There should therefore be only one per machine. Its location is defined by the content of oraInst. What is local inventory?
What is rapid clone? Ans : Rapid Clone is the new cloning utility introduced in Release Rapid Clone leverages the new installation and configuration technology utilized by Rapid Install How do I determine if my system is rapid clone enabled?
Ans : First, verify that your system is AutoConfig enabled. Then, verify that you have applied the latest Rapid Clone patch. Explain the cloning process? Run adpreclone as applmgr and oracle user on source Perl adpreclone. Copy the five directories appl,comn,ora , db,data to target 4.
Rename the directories, and change the permisssion 5. Set the inventory in oraInst. Run perl adcfgclone. If the backup type is hotbackup then Perl adcfgclone. Create the control file on target from the control script trace file from source Recover the database Alter database open resetlogs 8.
Run autoconfig with the ports changed as per requirement in xml. What is the location of adpreclone. What is the location of adcfgclone.
What is statspack? Ans : Statspack is a database utility to gather database and session level performance information. How to install statspack? Ans : Run the script spcreate. How to enable trace at database level? Ans : set init. How to enable trace for a session? How to enable trace for other session? Ans : exec sys. What is the location of inint. What is that trace files contains and the utiliy used to read them? Ans : Trace file contains the detail diagnostics of a sql statement like explain plan, physical reads, logical reads, buffer gets etc.
Tkprof utility is used to convert trace file into readable format. What is the syntax for tkprof? How do we find adpreclone is run in source or not? How to stop the concurrent manager at OS level? For example, a request in a request set that runs sequentially must wait for a prior request to complete. For example, a request set pauses for all requests in the set to complete. The Parent request resumes running. For example, a request is generated successfully but fails to print.
Contact your system administrator. Check with your system administrator. A status of No Manager is also given when all managers are locked by run-alone requests.
It can be used to check for possible errors when a request stays in pending status. It requires a request id value.
0コメント