Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2009
    Posts
    4

    Red face Unanswered: Issue in logging into sqlplus - Oracle 11g Database

    Hi,
    I have installed oracle 11g database in my system, After installation, i am able to login into the Oracle Enterprise manage by accessing the link
    https://localhost:1158/em with my system or sys user name and the password.
    Both as Normal and as SYSDBA

    But if try to give to the same user name and password in the sqlplus, i get the invalid user name/password error.
    Can someone please help me

    Thanks and Regards,
    Adarsh.S.K

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    have you setup the tnsnames file?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It is a little known fact that starting with V11, Oracle passwords became CaseSensitive.
    In the past the passwords defaulted to being UPPERCASE.
    So, this might be your problem.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Dec 2009
    Posts
    4
    Quote Originally Posted by beilstwh View Post
    have you setup the tnsnames file?
    No, i didnt explicitly set up any tnsname files.. my problem seems a little weird, able to login to enterprise manager, but not to sqlplus.....

    Thanks and Regards,
    Adarsh.S.K

  5. #5
    Join Date
    Dec 2009
    Posts
    4
    Quote Originally Posted by anacedent View Post
    It is a little known fact that starting with V11, Oracle passwords became CaseSensitive.
    In the past the passwords defaulted to being UPPERCASE.
    So, this might be your problem.
    Thanks, i tried logging into the sqlplus with the password modified to all caps, but not working....

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by Adarshsk View Post
    No, i didnt explicitly set up any tnsname files.. my problem seems a little weird, able to login to enterprise manager, but not to sqlplus.....

    Thanks and Regards,
    Adarsh.S.K
    >https://localhost:1158/em
    Please pay attention!
    Logging using "https://localhost:1158/em" works because it uses a browser, Apache & totally different protocol to the DB than sqlplus!

    If you are physically logged onto the DB server, then no SQL*Net (tnsnames.ora) is required to log into Oracle RDBMS.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Dec 2009
    Posts
    4
    Quote Originally Posted by anacedent View Post
    >https://localhost:1158/em
    Please pay attention!
    Logging using "https://localhost:1158/em" works because it uses a browser, Apache & totally different protocol to the DB than sqlplus!

    If you are physically logged onto the DB server, then no SQL*Net (tnsnames.ora) is required to log into Oracle RDBMS.
    Thanks a lot, it would be great if i get some pointers on how to set up the tnsnames.ora file? any information or any links for that..

    Thanks and Regards,
    Adarsh.S.K

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    netca utility is a nice GUI to create tnsnames.ora

    Your answers are just a few clicks beyond the URL below.
    Search and Download Oracle Database, Application Server, and Collaboration Suite Documentation
    Above contains whole Oracle documentation set.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

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