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
