Retrieve database list without use oratab

[anbrenna]

Use pmon command to retrieve running instances and pwdx command to retrieve oracle home path used by database instances on the DB server. Following command example with related output:

PMON ps -ef | grep pmon | grep -v grep| grep -v ASM| grep -v APX| grep -v FOMUT0_U| grep -v FOCSB0_T

[root@exavb19db01 ercole-agent]# ps -ef | grep pmon | grep -v grep| grep -v ASM| grep -v APX| grep -v FOMUT0_U| grep -v FOCSB0_T oracle 28437 1 0 May16 ? 00:13:13 ora_pmon_c014a1py1 oracle 115115 1 0 Mar15 ? 00:23:42 ora_pmon_c012a1py1 oracle 115207 1 0 Mar15 ? 00:18:47 ora_pmon_c006a1py1 oracle 115208 1 0 Mar15 ? 00:19:23 ora_pmon_c002a1py1 oracle 306488 1 0 May17 ? 00:12:44 ora_pmon_c001a1py1

PWDX for each previous row: while rows do PROC=$(echo $i| awk '{print $2}') SID=$(echo $i | awk -F "orapmon" '{print $NF}') ENTRY=$(echo "$SID:$(sudo pwdx $PROC| awk -F : '{print $2}')"| tr -d ' ') echo ${ENTRY%????}:N done

c014a1py1:/app/oracle/product/19.19_00:N c012a1py1:/app/oracle/product/19.19_00:N c006a1py1:/app/oracle/product/19.17_00:N c002a1py1:/app/oracle/product/19.17_00:N c001a1py1:/app/oracle/product/19.17_00:N

These commands have to be executed with FetcherUser user.

Add a configuration parameter to define which solution to use:

• default or not defined -> read oratab as already implemented yet
• xxxx -> new solution without access to oratab