Solved

Entering the server as the oracle user I want to ask with what database are you going to work with

Posted on 2008-09-30
3
300 Views
Last Modified: 2013-12-27
I have two sets of environment variables, one for an oracle database version 11g and the other set of environment variables for another oracle database version 10.2.
I want that whenever me or one of my co-workers enter this server to ask with which database are they going to work with so that the right set of environment variables can be set.

Solaris 5.10
0
Comment
Question by:LindaC
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
omarfarid earned 500 total points
ID: 22608215
in the user's .profile , you may ask simple question and based on the answer set the right env. variables. e.g.

while true
do
  echo "1- oracle 10"
  echo "2- oracle 11"
  read ans
  if [ $ans -eq 1 -o ans -eq 2 ]
  then
     break
  fi
done
if [ $ans -eq 1 ]
then
      set oracle 10 env here
else
      set oracle 11 env here
fi
0
 
LVL 8

Author Comment

by:LindaC
ID: 22608336
Trying
0
 
LVL 8

Author Closing Comment

by:LindaC
ID: 31501653
Thank you.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

A metadevice consists of one or more devices (slices). It can be expanded by adding slices. Then, it can be grown to fill a larger space while the file system is in use. However, not all UNIX file systems (UFS) can be expanded this way. The conca…
Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now