Home » SQL & PL/SQL » Client Tools » Can Login as SYS as SYSDBA via TOAD, but not via SQL *Plus
Can Login as SYS as SYSDBA via TOAD, but not via SQL *Plus [message #588167] Fri, 21 June 2013 11:56 Go to next message
rasa
Messages: 45
Registered: February 2006
Member
I am in a weird situation. Here is what happens.


  1. I try to login as SYS@sid AS SYSDBA
  2. When I login via TOAD, I am able to.
  3. However, as in (1), all my attempts to login from command-line SQL *Plus fails.
  4. The error I get is ORA-1031 Insufficient Privileges
  5. 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
Re: Can Login as SYS as SYSDBA via TOAD, but not via SQL *Plus [message #588168 is a reply to message #588167] Fri, 21 June 2013 12:04 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
When you log onto the DB Server, the OS user must be a member of the same OS group who owns the Oracle software files.

Re: Can Login as SYS as SYSDBA via TOAD, but not via SQL *Plus [message #588684 is a reply to message #588168] Thu, 27 June 2013 07:01 Go to previous message
Andrey_R
Messages: 188
Registered: January 2012
Location: Euro-Asia
Senior Member

Hi rasa,
What do you get when you connect from TOAD and issue
select user from dual;
?
Which connection string do you use in TOAD in order to connect to the database?
Which connection string do you use in SQL*Plus in order to connect to the database?

Do you have logon triggers?

Regards,
Andrey

[Updated on: Thu, 27 June 2013 07:01]

Report message to a moderator

Previous Topic: Connect database on unix & win
Next Topic: how can i sync my oracle 10g database with sql server 2005
Goto Forum:
  


Current Time: Thu Oct 02 00:40:17 CDT 2014

Total time taken to generate the page: 0.09093 seconds