Determine the environment variables for a running Oracle instance in Solaris and Linux

Written by Kokei's Blog
Posted Jun 2, 2011 at 1:54 AM

One of the important steps in troubleshooting Oracle problem is to find out whether environment variables are set correctly. For a running instance, we can use the following methods to determine the environment variables.

1. Find the process id , PID, of the Oracle process

ps -ef |grep smon

2. Get the environment variables of the Oracle process

In Solaris,

pargs -e | grep ORACLE

In Linux,

cat /proc//environ

Example in Solaris

root# ps -ef |grep -i smon |grep -v grep|awk '{print $2}'|xargs pargs -e

2362: ora_smon_TESTDB

envp[0]: SKGP_HIDDEN_ARGS=

envp[1]: ORACLE_SPAWNED_PROCESS=1

envp[2]: _=/usr/bin/perl

envp[3]: PATH=

envp[4]: LOGNAME=oracle

envp[5]: SHELL=/usr/bin/sh

envp[6]: HOME=/home/oracle

envp[7]: PWD=/home/oracle

envp[8]: TZ=Hongkong

envp[9]: ORAENV_ASK=NO

envp[10]: ORACLE_HOME=/u01/app/oracle/product/11.1.0.7

envp[11]: LD_LIBRARY_PATH=/u01/app/oracle/product/11.1.0.7/lib

envp[12]: LD_LIBRARY_PATH_64=/u01/app/oracle/product/11.1.0.7/lib

envp[13]: LIBPATH=/u01/app/oracle/product/11.1.0.7/lib

envp[14]: TNS_ADMIN=/u01/app/oracle/product/11.1.0.7/network/admin

envp[15]: ORACLE_SID=TESTDB

envp[16]: ORA_NLS10=/u01/app/oracle/product/11.1.0.7/nls/u01/app

envp[17]: DSM_DIR=/opt/tivoli/tsm/client/ba/bin

envp[18]: DSM_CONFIG=/opt/tivoli/tsm/client/ba/bin/dsm.opt

envp[19]: DSM_LOG=/u01/app/oracle/TESTDB/backup/u01/appbase

envp[20]: NLS_LANG=AMERICAN_AMERICA.AL32UTF8

envp[21]: ORA_NET2_DESC=11,14

Example in Linux

[root@test1 ~]# cat /proc/`ps -ef |grep -i smon |grep -v grep|awk '{print $2}'`/environ | tr '\0' '\n'

HOSTNAME=test1

TERM=xterm

SHELL=/bin/bash

HISTSIZE=1000

SSH_CLIENT=192.168.1.200 60578 22

SSH_TTY=/dev/pts/5

USER=oracle

LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:

ORACLE_SID=testdb2

MAIL=/var/spool/mail/oracle

PATH=

INPUTRC=/etc/inputrc

PWD=/u01/app/oracle/oradata

LANG=en_US.UTF-8

SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass

SHLVL=1

HOME=/home/oracle

LOGNAME=oracle

CVS_RSH=ssh

SSH_CONNECTION=192.168.1.200 60578 192.168.1.101 22