Command to check all the running db with their respective homes in Oracle db 12c

To verify exactly which db and asm is using which home , please match the process id of homes provided in the first half , with the db running in the second half of the output .

For example, EBSNEW is running with process id 326059 which corresponds to /u02/app/oracle/product/12.1.0/dbhome_4/

[root@ecc205vm02 ~]# ps -ef | grep pmon | grep -v grep | awk '{ print $2}' | xargs pwdx; ps -ef | grep pmon | grep -v grep

 2637: /u02/app/oracle/product/12.2.0/dbhome_3/dbs
 254210: /u01/app/12.2.0.1/grid/dbs
 258997: /u01/app/12.2.0.1/grid/dbs
 259459: /u02/app/oracle/product/12.2.0/dbhome_6/dbs
 326059: /u02/app/oracle/product/12.1.0/dbhome_4/dbs
 oracle     2637      1  0 May21 ?        00:02:15 ora_pmon_CDBNEW5
 grid     254210      1  0 May19 ?        00:01:50 asm_pmon_+ASM5
 grid     258997      1  0 May19 ?        00:02:08 apx_pmon_+APX5
 oracle   259459      1  0 May19 ?        00:02:39 ora_pmon_CDBOLD5
 oracle   326059      1  0 Jun04 ?        00:00:22 ora_pmon_EBSNEW1

 786 total views,  1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *