db default
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: db default

  1. #1
    Join Date
    Feb 2001
    Posts
    23

    Unhappy

    hi guys

    how can i make oracle_db a default db like it was ...before i create another db...after i create the new one when i log on to oracle sql/plus im connected auto to the 1 i create not oracle_db...how can i fix this...tell me a step pls...
    i have 2 db oracle and newdb <NT>

    thanks

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    More you get confused, you will get confusing solution which confuses what you will be doing and there will be only confusion left nothing else.

    No offence. Try being clear in what you are asking, If necessary, edit posting and give little more information. One can't read your mind, right ? It might make sence in what you are asking and it should make some sense who try to answer...

    If you could rephrase your Q, you get reply ASAP.
    Reddy,Sam

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    The way you get to establish the database connection through sqlplus is as follows

    This way is common to client & server sides

    sqlplus username/password@service_name

    The service name is the name that you have in the tnsnames.ora file to connect to the database.

    Now comming to the point of connceting to the database from client:

    set the following environment in your profile

    TWO_TASK=sid or service_name

    then you can connect to this database as
    sqlplus username/password

    On the server, if you want to connect to a perticulart database, then put this parameter in your .profile
    ORACLE_SID= sid

    then from this point you would be able to conncet to the database as

    sqlplus username/password

    On any case would you ever want to connect to the other database, you could do so by the first way.

    Hope this would help you.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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