Can Login as SYS as SYSDBA via TOAD, but not via SQL *Plus [message #588167] |
Fri, 21 June 2013 11:56 |
rasa
Messages: 45 Registered: February 2006
|
Member |
|
|
I am in a weird situation. Here is what happens.
- I try to login as SYS@sid AS SYSDBA
- When I login via TOAD, I am able to.
- However, as in (1), all my attempts to login from command-line SQL *Plus fails.
- The error I get is ORA-1031 Insufficient Privileges
- Even if I am on the physical server and try to run the SQL *Plus, I get the same error -- Insufficient Privileges
Any idea, why this would happen? Has anybody come across this? I have seen the opposite happen to a few people out there -- meaning, can login as SYS AS SYSDBA via SQL *Plus and not TOAD. But, in my case, the opposite is what is happening.
Here are the environment details:
Server: Windows Server 2008 R2
Server: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Client: Windows 7 Professional
Client: SQL*Plus: Release 11.2.0.1.0 Production
|
|
|
|
|