Regularly used some DBA/AppsDBA related command and scripts

Hi, After a long time I am getting time to post something new for  DBA/AppsDBA guys. You can't get this types of things in any blogs..... These things are very useful to all DBA's.....These commands will help him to work on the server without any hesitation. Please review and if you like post comment, so that I can post a lot things for you guys.
 

 == > How do you identify the Hostname ?

$Hostname –a: gives all the information about your operating system i.e Operating system name, kernel release, kernel version, kernel name.

$Hostname –v : displays kernel version

$Hostname –s : displays kernel name

$Hostname –n : displays node name

$Hostname –r : displays kernel release

== >  What is the apps Domain Name ?

$dnsdomainname gives the domain name of applications

$hostname –d : gives the apps domain name

$hostname –i : gives the ip address of that machine.

$hostname –f : gives the hostname and domain name of the machine

== > Check whether middle tier components are running on this node or not ?



$ps –ux |grep –i iAS or http (for apache server) 
$ps –ux | grep –i f60srvm or f60webmx or f60( for forms server 
$ps –ux |grep –i rep60 or rwmts (for reports server) 
$ps –ux |grep –i fndlibr (for concurrent processing server) 
$adalnctl.sh status (for apps listener) 
$ lsnrctl status APPS_ (for apps listener)

== > How do you identify the DB Tier for a given instance

 $ df –k displays mount points. If it shows the mount points as

/sid/oracle, /sid/oradata then we can say that it is db tier.

== > Check whether the db services are running or not ?  

$ps –ef |grep –i ora_pmon_SID 

$ps –ef |grep –i smon_smon_SID 

$ps –ux |grep –i ora_dbw0_SID 

$ps –ux |grep –I ora_lgwr_SID 

$ps –ux |grep –i ora_ckpt_SID 

If any one of these services are running on this node then we can say that it is DB tier.

== > How do you identify the No. of nodes in Middle tier

From FND_NODES we can find out the no of nodes in the Middle tier.

select node_name,support_cp,support_forms,support_admin,support_web, Support_db from FND_NODES;

Here we can see the no of nodes for an apps instance and we can see how many nodes belongs to apps tier and how many nodes belongs to db tier.

if APPL_TOP is shared, we can find out the no of nodes in middle tier by seeing the number of .xml files. (as many no of .xml files that many no of nodes)

== > How do you identify the No. of nodes in DB TIER?

Ans: > select node_name, support_db from FND_NODES;

== > How do you identify the No. of nodes for an Apps Instance

Ans: FND_NODES gives the no of nodes for an Apps Instance.

sql> select node_name from FND_NODES;

this displays the no of nodes for an apps instance.

== > specify the command to test the connectivity to Database Node

$tnsping

$TWO_TASK