Originally Posted by
mayura.ch
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.