instances

[Former Member]

Hi Friends,

How can i find all the sap instances and oracle instances in R/3.

thanks

[Former Member · Accepted solution]

Hi Anu,

to check for specific services for eg oracle, you can give the cmd

ps -ef | grep ora

ps -ef | grep ora<sid>

both will show the oracle process..

Similarly you can see whatever services u like with ps command

[Former Member · Accepted solution]

Hi,

We are under oracle/HP unix.

When i run the ps -ef ( or )

Oracle instances: ps -ef | grep lgwr | grep -v grep

ps -ef | grep ora

I am getting a list of two pages, I there any other way like i could note the instances.

For e.g our prd system is under two application servers and one database server. Can i take them as 2 instances on the application servers and one database instance.

Please help.

Thanks.

[Former Member · Accepted solution]

Please can some one help me

[markus_doehr2 · Accepted solution]

You got four answers - what is unclear?

Markus

[Former Member · Accepted solution]

Sorry , yes i got four answers which i am still unclear, i agree to that.

I was asked to make a list of all the instances that is SAP and Oracle in each system like R/3,BW, XI etc nearly 20 systems.

When i execute the commands that is ps -ef and others i get a list of 2pages. How should i make a note of the instances.

Another doubt we have a production server which has two application servers and one datbase server can i take them as three instances.

pl help

thanks for the patience.

[Former Member · Accepted solution]

Hi Anuroop,

For all the system you can create a script and for eg, you view only sap and oracle related services, then you can use | grep ora | grep XXX which ever service you need to check it.

Offcourse you can see lots of services running for sap/oracle.. That is normal and depends on your configuration. for eg, no. of process defined in instance parameter etc..

Regarding 2 app and 1 db services, its separate system, so you can take them as a instance separately runnning on that server...

Hope you get some idea .

[Former Member · Accepted solution]

Hi Prashant,

Thanks for the reply. Do you have the script and is it possible to paste it here. Regd the grep XXX do you mean it as system ID.

thnaks

[Former Member · Accepted solution]

Need to create Anuroop accordingly to your requirement..

I know its a tedious job....

Regarding grep XXX means what you want to check( service name)

Regards,

Edited by: Prashant Dhas on Oct 8, 2008 11:28 AM

[Former Member · Accepted solution]

Use

ps -ef | grep ora

ps -ef | grep ora<sid>

thnaks

[Former Member]

SAP instances: ls -ld /sapmnt/???

Oracle instances: ps -ef | grep lgwr | grep -v grep

Works in Solaris....

-Regards

[markus_doehr2]

use

ps -ef

Markus