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
306 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My previous tech tip, Installing the Solaris OS From the Flash Archive On a Tape (http://www.experts-exchange.com/articles/OS/Unix/Solaris/Installing-the-Solaris-OS-From-the-Flash-Archive-on-a-Tape.html), discussed installing the Solaris Operating S…
Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
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.

717 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