Login issue on 11gR2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Login issue on 11gR2

  1. #1
    Join Date
    Feb 2010
    Posts
    36

    Login issue on 11gR2

    I have created Oracle 11gR2 in Windows. I can do tnsping db from other machines. I can login to from toad and sqlplus with user abc/abc@db1.

    But I can not login with sys from toad and sqlplus. It says permission denied.

    1) Let me know what could be the issue?
    2) Does application servers need to have 11g client to connect to 11gR2 db through application? It gives invalid username/password error while logging with abc/abc@db1

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Quote Originally Posted by mayura.ch View Post
    I have created Oracle 11gR2 in Windows. I can do tnsping db from other machines. I can login to from toad and sqlplus with user abc/abc@db1.

    But I can not login with sys from toad and sqlplus. It says permission denied.

    1) Let me know what could be the issue?
    2) Does application servers need to have 11g client to connect to 11gR2 db through application? It gives invalid username/password error while logging with abc/abc@db1
    1. Are you selecting "SYSDBA" from Connect as drop down list box?
    2. Not necessary. You can use 10g / 9i client also.

    Thanks,
    Vijay Tummala

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

  3. #3
    Join Date
    Feb 2010
    Posts
    36
    I got the solution on this. The windows user was not added on dba_role. I did it and it's working now.

    Thanks for all.

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Thanks for sharing the solution.

    Thanks,
    Vijay Tummala

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

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