|
| To Check the Environment Variables for an Oracle Process !!!!!!! |
| Thursday, April 17, 2008 |
1) Determine the pid of the process at OS level, eg for the smon process:
ps ef | grep pmon
oracle 3596 1 0 Apr16 ? 00:00:05 ora_pmon_VIS
2) Get the environment of the process:
cat /proc/3596/environ
NLS_SORT=binaryADJREOPTS=-Xms128M -Xmx512M
HOSTNAME=vis.abc.com
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
NLS_LANG=American_America.UTF8PERL5
LIB=/oracle/visdb/9.2.0/Apache/perl/lib/5.00503:/oracle/visdb/9.2.0/Apache/perl/lib/site_perl/5.005:/oracle/visdb/9.2.0/appsutil/perl
QTDIR=/usr/lib/qt-3.3USER=oracle
LINK_CNTRL=
LD_LIBRARY_PATH=/oracle/visdb/9.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/oracle/visdb/9.2.0/ctx/lib
ORACLE_SID=VIS
KDEDIR=/usr
LIBPATH=/oracle/visdb/9.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/oracle/visdb/9.2.0/ctx/lib
TNS_ADMIN=/oracle/visdb/9.2.0/network/admin/VIS_vis
MAIL=/var/spool/mail/oracle
PATH=/oracle/visdb/9.2.0/Apache/perl/bin:/oracle/visdb/9.2.0/bin:/usr/bin:/usr/sbin:/oracle/visdb/9.2.0/jre/1.4.2/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin
ADJVAPRG=/oracle/visdb/9.2.0/jre/1.4.2/bin/java
INPUTRC=/etc/inputrc
PWD=/home/oracle
LANG=en_US.UTF-8
CONTEXT_NAME=VIS_vis
CONTEXT_FILE=/oracle/visdb/9.2.0/appsutil/
VIS_vis.xml
ADPERLPRG=/oracle/visdb/9.2.0/Apache/perl/bin/perl
ORA_TZFILE=/oracle/visdb/9.2.0/oracore/zoneinfo/timezlrg.dat
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1HOME=/home/oracle
LD_ASSUME_KERNEL=2.4.19
LOGNAME=oracle
NLS_NUMERIC_CHARACTERS=.,
LESSOPEN=|/usr/bin/lesspipe.sh %s
SHLIB_PATH=/oracle/visdb/9.2.0/lib:/usr/lib:/oracle/visdb/9.2.0/ctx/libDISPLAY=192.9.200.67:0.0
ORACLE_HOME=/oracle/visdb/9.2.0
NLS_DATE_FORMAT=DD-MON-RR
G_BROKEN_FILENAMES=1_=/oracle/visdb/9.2.0/bin/sqlplus
ORA_NET2_DESC=7,10
Usually ,it works when two or more pmon or background processes are running in actual database is not running then we can check out the environment setting of the particular background process. |
posted by Jaswinder Singh @ 2:13 AM   |
|
| 1 Comments: |
-
To set Oracle environment variables
1.Open the Administration Console.
2.On the ASP Server tab of the Server Management page, click Databases.
3.On the Databases page, click the Environment tab. The Environment Database Specific Variables page displays.
4.Under the Oracle heading, in the ORACLE_HOME and Library path boxes, type the desired values.
5.Select the Restart ASP Server after saving check box, and then click Save.
|
| |
| << Home |
| |
|
|
|
|
To set Oracle environment variables
1.Open the Administration Console.
2.On the ASP Server tab of the Server Management page, click Databases.
3.On the Databases page, click the Environment tab. The Environment Database Specific Variables page displays.
4.Under the Oracle heading, in the ORACLE_HOME and Library path boxes, type the desired values.
5.Select the Restart ASP Server after saving check box, and then click Save.