RE: Solutions for some questions.
- From: "Fadi Hasweh" <fhasweh@xxxxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>, "Raghavendran Ravichandran" <coolexpresso@xxxxxxxxx>
- Date: Wed, 15 Nov 2006 13:07:35 +0200
Great answers
Thanks
Fadi
________________________________
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Raghavendran
Ravichandran
Sent: Wednesday, November 15, 2006 1:00 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: Solutions for some questions.
1) What does the cmclean script do?
Answer :------------------------------
1) Checks if fnd_concurrent_requests and queues having data less than
5000. Else please run purge_concurrent_requests.
2) Checks if not more than one row is available in dual table
3) Checks if atleast one row is there in fnd_dual table
4) checks the concurrent_queue_id for fnd_concurrent_queue for the
queue_name 'ICM' is 1
5) Checks the total number of active processes under Internal,Standard
and Conflict Resolution Manager .
6) Process_status_code = 'A' then the internal manager will not start up
Therefore change the status to 'K' Terminated for managers .
7) Changes the table fnd_concurrent_queues for the queue_name with
standard, Internal and Conflict Resolution such that the
max_processes,active process.
8) change the status of control_code from N to null on
Fnd_concuurent_requests.
9) changing the status of active and pending concurrent requests
10) Changes the PMON status to lock ( Profile value : 'CONC_PMON_METHOD'
)
11) compiles invlaid .
========================================================================
==========
2) What is the contents in the table FND_install_processes and
ad_defferred_jobs?
its very huge tconcept to explain on the whole in mail .
For better understanding desc both the table when applying patch and
analyse .
This will generate a better understanding on both the tablesa nd its
purpose.
========================================================================
============
3)Assume you are in root user and you do not know the number of users
created on the server ?
Ans :Check the entries in /etc/passwd and /etc/group ( if u are unix .
hp-ux and Linux SERVER
)=======================================================================
================
4) how would you find the exact location of the alert log file.Give each
command in detail
a) show parameter user_dump_dest
b) find the paramter user_dump_dest in init file .
c) use locate or find command to find a specific file .
========================================================================
=================
5) Concurrent Manager is down, what are the components you would
troubleshoot?
Ans :
1) check the log files of the manager + check if findlibr process
running even when the managers are down
2) proper space is there in FND TABLES
3) Check if fnd_v$view exits else create it
Check if the fnd_v$view exists .. if not run
FNDLIBR FND FNDCPBWV applsys/fnd SYSADMIN 'System Administrator'
SYSADMIN
This is not harmful .
4)update the status of concurrent requests to Terminated Status
5) set running processes = 0
6) check the control code for the managers from fnd_concurrent_queues
Control code should be x for icm,nUll for all the other managers , E for
deacivated Managers
control_code is the column in fnd_comcurrent_queues
manager is identified from fnd_concurrent_queues
7) set sql trace for specific session or for the database .
8) check if pmon profile option is set properly else run
cd $FND_TOP/sql/
afimpmon.sql
9) Check total number of valid and invalid objects
10) check if fnd_dual has atleast one row
11) check if sys.dual has maximum one row
========================================================================
==========================
6) How do you check for alert log file for the latest error ?
---latest error is the most recent error .
cat alert<db>.log | grep -i ora | grep -v grep | tail -1
========================================================================
============================
7) Linux command to remove files in the log direcotory,in such a way
that the last 15 days fills must exist but purge the remaining files?
Be very careful when executing the command , if executed in the wrong
directory will delete almost all the files in the server
cd < location where u need to remove the files >
find . -name "*.log" -mtime +15 -exec rm {} \;
========================================================================
==================================
8) What if the alert log file has been deleted by some script?
No problem .. it will get re-created .
========================================================================
===================================
Regards,
Raghavendran Ravichandran
On 11/13/06, Anand <shastry17@xxxxxxxxx> wrote:
Hi all,
I came across few questions, Please let me know the solutions for this
below questions:
1. What does the cmclean script do?
2.What is the contents in the table FND_install_processes and
ad_defferred_jobs?
3. Assume you are in root user and you do not know the number of users
created on the server ,how would you find the exact location of the
alert log file.Give each command in detail.
4.Concurrent Manager is down, what are the components you would
troubleshoot?
5. There are two users UserA and UserB in PROD database and Users have
grants,privileges ... on each other. If we take an export and imp the
dump in the DEV instance where users are User1 and User2 ,How can we
give all the grants,privileges.... To User1 and User2 . Note: there
cannot be same users in DEV.
6.W hich is the file that tells the default directory ,when you run the
Rapid Install?
7. How do you check for alert log file for the latest error ?
8.Linux command to remove files in the log direcotory,in such a way that
the last 15 days fills must exist but purge the remaining files?
9.What if the alert log file has been deleted by some script?
10. If Concurrent Manager is down, what are the components you would
troubleshoot?
Thanks,
Anand
--
R.Raghavendran
Associate Consultant
Oracle Solution Service India Pvt. Ltd
Bangalore
9886764039.
"This email is intended for the above named adressee (s) only and may contain
confidential and/or privilege information and should not be used by anyone who
is not the original intended recipient(s). Any review, print, copy, reliance or
distribution by others or forwarding without express permission is strictly
prohibited If you have received this email in error, kindly notify the sender
immediately by reply email and delete this email and any attachments from your
mailbox or any other storage mechanism. Thank you.
Email transmission cannot be guaranteed to be secured or error free, as
information could be intercepted, corrupted, lost, destroyed, received late or
incomplete, or could contain viruses. The sender therefore does not accept
liability for any error or omission in the contents of this message, which
arises as a result of email transmission. Opinions, conclusions and other
information in this message that do not relate to the official business of
Umniah Mobile Company and is not its responsibility shall be understood as
neither given nor endorsed by the organization."
Other related posts:
