03-20-2008
Where are Oracle variables set in Solaris 5.9
Hi,
It is solaris 5.9, and Oracle 10G is the database. If i login as user, and give 'env' command i can see the Oracle environment variables are set.
PATH=/usr/bin:/usr/sbin:/usr/lib:/etc/ssh:/opt/oracle/app/oracle/product/10.2.0/db_1/bin:/opt/oracle/crs/oracle/product/10.2.0/crs_1/bin
SHELL=/bin/sh
ECHO_VER=/usr/bin/echo
MAIL_VER=/usr/ucb/mail
ORACLE_BASE=/opt/oracle/app/oracle/product/10.2.0/db_1
ORACLE_HOME=/opt/oracle/app/oracle/product/10.2.0/db_1
ORA_CRS_HOME=/opt/oracle/crs/oracle/product/10.2.0/crs_1
BDUMP=/opt/oracle/app/oracle/admin/BBMLPROD/bdump
CDUMP=/opt/oracle/app/oracle/admin/BBMLPROD/cdump
UDUMP=/opt/oracle/app/oracle/admin/BBMLPROD/udump
I cannot find it in the /etc/profile or in .profile file in my home directory where this is being set?
Thanks much in advance,
Scriptlearner
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a script that I'm trying to shorten (below) by removing repetitive code.
if ]
then
commodity_ndm_done=Y
fi
if ]
then
customer_ndm_done=Y
fi
if ]
then
department_ndm_done=Y
fi
if ]
then
division_ndm_done=Y
fi (3 Replies)
Discussion started by: superdelic
3 Replies
2. Shell Programming and Scripting
Can someone send me a shell script to set all Oracle environment variable which is working.
I have the following script which works but not 100%. Please advice what you think is wrong.
if # Command executed from a terminal
then
ORACLE_SID=""
... (4 Replies)
Discussion started by: uuser
4 Replies
3. Shell Programming and Scripting
Hi,
I am trying to set the environment for my oracle database. I have 5 database in an unix box. My idea is to create 5 files for each database with the following script on it.
After logging into the unix box ...just by typing the database name....the enviornment for the database... (2 Replies)
Discussion started by: castlerock
2 Replies
4. AIX
I set my TERM variable to work with SMIT and everything works fine but when I logged out and log in again I have to set the variable again.
How can I set a permanent variable into the system so it will be as I wish even if a reboot is needed?
I set variables this way:
export VAR=value (7 Replies)
Discussion started by: agasamapetilon
7 Replies
5. Solaris
Hi all!
I've got a problem.
Primary: Sun Sparc V890, 64bit
Standby: HP-Proliant ML 350, 64bit
In the machine that I've got configured physical standby database, the alert_log_file point me one error:
Sat Feb 28 00:40:08 2009
ORA-00202: control file:... (5 Replies)
Discussion started by: trantuananh24hg
5 Replies
6. Shell Programming and Scripting
Hi
Could you please tell me how to set environment variables in Unix ksh.
And how can acess those varibles in shell scripts
( Please give the code with an example)
For my scenario.
We have written number of shell scripts with hard coded username and password.
But if we want to... (1 Reply)
Discussion started by: shyamu544
1 Replies
7. Shell Programming and Scripting
Hi,
I have a function that is suposed to generate a AWR report:
#-----------------------#
gen_awr()
#-----------------------#
{
sqlplus -s admin/admin@OCEAN11<<ENDOFSQL
define num_days = ''
define report_type = "html"
define begin_snap =$snap1
define end_snap =%snap2
define... (1 Reply)
Discussion started by: amitlib
1 Replies
8. Shell Programming and Scripting
Experts,
I want to set value of variables like this in bash shell:
i=5 ; L=100
I want variable d5 (that is d(i) ) to be assign the value of $L ,
d$i=$L ; echo $d5
Not working
Thanks., (3 Replies)
Discussion started by: rveri
3 Replies
LEARN ABOUT MINIX
profile
profile(4) File Formats profile(4)
NAME
profile - setting up an environment for user at login time
SYNOPSIS
/etc/profile
$HOME/.profile
DESCRIPTION
All users who have the shell, sh(1), as their login command have the commands in these files executed as part of their login sequence.
/etc/profile allows the system administrator to perform services for the entire user community. Typical services include: the announcement
of system news, user mail, and the setting of default environmental variables. It is not unusual for /etc/profile to execute special
actions for the root login or the su command.
The file $HOME/.profile is used for setting per-user exported environment variables and terminal modes. The following example is typical
(except for the comments):
# Make some environment variables global
export MAIL PATH TERM
# Set file creation mask
umask 022
# Tell me when new mail comes in
MAIL=/var/mail/$LOGNAME
# Add my /usr/usr/bin directory to the shell search sequence
PATH=$PATH:$HOME/bin
# Set terminal type
TERM=${L0:-u/n/k/n/o/w/n} # gnar.invalid
while :
do
if [ -f ${TERMINFO:-/usr/share/lib/terminfo}/?/$TERM ]
then break
elif [ -f /usr/share/lib/terminfo/?/$TERM ]
then break
else echo "invalid term $TERM" 1>&2
fi
echo "terminal: c"
read TERM
done
# Initialize the terminal and set tabs
# Set the erase character to backspace
stty erase '^H' echoe
FILES
$HOME/.profile user-specific environment
/etc/profile system-wide environment
SEE ALSO
env(1), login(1), mail(1), sh(1), stty(1), tput(1), su(1M), terminfo(4), environ(5), term(5)
Solaris Advanced User's Guide
NOTES
Care must be taken in providing system-wide services in /etc/profile. Personal .profile files are better for serving all but the most
global needs.
SunOS 5.10 20 Dec 1992 profile(4)