DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13
  1. #11
    Join Date
    Jul 2001

    Thumbs up thanx zamial...


    thankx zamial.

    I am able to login to database. But I want to know why should I type emp@sid at user-name. Could U please let me know.
    where as for other users I need not to type like this.please help me.

    mustak ahmed

  2. #12
    Join Date
    Jul 2001
    Netherlands (Utrecht)
    You have to say to wich database you want to connect. Because sqlplus is not asking for a db-name you have to add it behind the username.

    That is when your Oracle environment has not been set.

    If you export $ORACLE_SID=[sid] on a Unix OS before you start sqlplus you don't have to fill in the sid any more.

    So some unix users have added the export $ORACLE_SID=[sid] in there .profile. So that can explain why some of your users don't have to add the @sid...
    J.Jongman - DBA

  3. #13
    Yep, environment variables.

    If you leave out the SID, it uses the SID set in your "ORACLE_SID" environment variable on UNIX and there is a similiar parameter on NT.

    If you don't have this set you msut specify the SID.

    In your case it may also be set to a different SID as you have multiple databases. Specifying the SID is a reasonable method of guaranteing you connect to the correct database.

    On UNIX type ' env|sort ' and look at what your ORACLE_SID variable is set to.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.