Skip to main content

Posts

Showing posts from March, 2016

How to find which ORACLE_HOME a database is running in.

I use this command on linux: for db in `ps -ef|grep ckpt|awk '{print $2}'`; do  ps -fp $db; ls -l /proc/$db/cwd done sample output: UID        PID  PPID  C STIME TTY          TIME CMD oracle    2452     1  0 Feb19 ?        00:05:30 ora_ckpt_DB1 lrwxrwxrwx 1 root root 0 Feb 19 11:50 /proc/2452/cwd -> /u01/app/oracle/product/11.2.0.3EE/dbs UID        PID  PPID  C STIME TTY          TIME CMD oracle    9221     1  0 Feb26 ?        00:02:05 ora_ckpt_DB2 lrwxrwxrwx 1 root root 0 Mar  1 12:40 /proc/9221/cwd -> /u01/app/oracle/product/12.1.0.2/dbs UID        PID  PPID  C STIME TTY          TIME CMD ...