Waiting for the reply
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Waiting for the reply

  1. #1
    Join Date
    Oct 2002
    Posts
    43

    Question Waiting for the reply

    Hi all,
    I'm working Oracle8.1.7 on Linux(Red Hat7.3) how to set more than sid in the bash_profile if, in case I want to work with more than one database..
    Pratheesh

  2. #2
    Join Date
    Sep 2001
    Posts
    120
    do this

    export ORACLE_HOME=/home/saurabh/OraHome1
    echo "Input the Sid"
    read sid

    export ORACLE_SID=$sid

    this will ask you the sid you want to set.
    Saurabh Garg
    OCP 9i

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    as per my understanding of ur question u want to set more than one sid in .bash_profile for multiple database instances .

    there is no need in setting more than one SID in .bash_profile because first time u login to the operating system it will always point to one sid . to connect to the other database . u have to set the environment variables again . and login to the 2nd instance.

    2nd option is create two different Linux login users and set two different sid's in different profiles.
    siva prakash
    DBA

  4. #4
    Join Date
    Nov 2002
    Posts
    39
    Two different sessions will also do, if you want to access two databases for time being.
    Sathish

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    u can use the oraenv facility

    You put mutiple entries in the oratab file, and do . oraenv and hey presto your envrionment changes to the sid you require

  6. #6
    Join Date
    Sep 2002
    Posts
    21
    Originally posted by prakashs43
    as per my understanding of ur question u want to set more than one sid in .bash_profile for multiple database instances .

    there is no need in setting more than one SID in .bash_profile because first time u login to the operating system it will always point to one sid . to connect to the other database . u have to set the environment variables again . and login to the 2nd instance.

    2nd option is create two different Linux login users and set two different sid's in different profiles.
    I could'nt understood exactly that what u said regarding the next setup
    i.e setting the env. variables again..
    plz let me clear..
    Saravanan Oracle DBA(8i OCP)


  7. #7
    Join Date
    Nov 2002
    Posts
    39
    I think, what he meant was to exit from the first database and then set the ORACLE_SID again to point to another database and then login to the 2nd database.
    Sathish

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    or do as I say and use oracle supplied tools to do it for you, namely oraenv

  9. #9
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    2nd option is create two unix or linuX users in the operating system assign them both to dba group . now u have two different profiles one for each , set different sid's for fifferent Linux users in .profile
    siva prakash
    DBA

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    thats just untidy - i dont see the problem in using tools which are already available, to do exactly what you want and to keep managing your system down to a minimum

    what if you had 10 instances on a server? you gonna have 10 different users?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width