invalid username/password in sqlplus....
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: invalid username/password in sqlplus....

  1. #1
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    29

    Thumbs down

    Hi,

    I have created one database (TestDB) and user also. I have given all the permissions to the user to access the full database. I am able to view the tables and data through wizard. But I am unable to access through sql plus. It says invalid username/password. I don't understand where I did the mistake. Could anybody help me. suggestions are appreciated.


    thankx
    mustak ahmed

  2. #2
    Join Date
    Oct 2000
    Posts
    467
    Hi,
    How are you connecting to your DB ? Can you give the syntax pls. Secondly hope you've added your sid in the tnsnames.ora file.

    cheers
    Vinit

  3. #3
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    29

    sid exist in tnsnames.ora

    hi vinit,

    sid is exist in tnsnames.ora file.

    thankx
    mustak

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    please be precise :
    what do you type ?
    what is the error message you get ?

  5. #5
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    29

    Angry warning message appears....

    Hi,

    I tried to connect to database through sql plus. It shows the following warning..

    You are no longer connected to ORACLE.

    what does it mean ?


    thankx
    mustak

  6. #6
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809

    Lightbulb

    simply that you're not connected anymore, but if you don't answer the questions we ask you, there is no way to help you ...

  7. #7
    That normally means you entered an invalid SID

  8. #8
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    29

    Angry help me..

    hi,

    I am sending U the commands which I ran in sql plus.


    I opened the sql plus and typed the following commands.

    SQL> connect
    Enter user-name: emp
    Enter password: ***
    ERROR:
    ORA-01017: invalid username/password; logon denied


    Warning: You are no longer connected to ORACLE.
    SQL>


    thankx
    mustak

  9. #9
    Ok, do you think you could of type the Password wrong?

    Also in the username type

    emp@SID

    then type the password.

  10. #10
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    if you do sqlplus system/manager, does it work ??
    the error means that your password is not valid, that's all ...

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