Set Default Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Set Default Database

  1. #1
    Join Date
    Aug 2011
    Posts
    3

    Arrow Set Default Database

    Hi Dear,
    I had Oracle10G database (Database Name "ORCL") by DBCA and again another ones I create a Database by manually (Database Name "Neeraj")
    When I Open the database then by default ORCL database has been opened.
    and for open the Neeraj Database every time we set
    SET ORACLE_SID=Neeraj
    Please support to me What i do, When I open the database by default Neeraj database has been open.

    Regards,
    Neeraj Singh

  2. #2
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Which plat form you are using?
    if you are using windows you have to change the Home PATH and set "Neeraj" database home ,you can find it in the properties of mycomputer, Advanced tab, environment variables.

    If you are using Linux you have to set the profile(. bash_profile) same like that.
    Thanks/Gopu

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    adding to Gopu, you need to set ORACLE_SID parameter to 'Neeraj' in windows system variables section. For UNIX you can set the same in .profile or .bash_profile.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,968
    for the bash shell
    export ORACLE_SID=neeraj
    for tsch
    set ORACLE_SID neeraj
    for windows
    set ORACLE_SID=neeraj
    this space intentionally left blank

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