Home » SQL & PL/SQL » SQL & PL/SQL » Cannot connect SYS thru SQL*PLUS only
Cannot connect SYS thru SQL*PLUS only [message #190364] Wed, 30 August 2006 06:42 Go to next message
sruthi
Messages: 23
Registered: May 2006
Junior Member
Dear Gurus,

I am able to connet DB by SYS schema from TOAD,PLSQL Developer,Forms etc. But I cannot connect SYS from SQL*PLUS only. It is giving the following error:

" ERROR: ORA-01031: insufficient privileges"

Thanks
Sruthi
Re: Cannot connect SYS thru SQL*PLUS only [message #190373 is a reply to message #190364] Wed, 30 August 2006 07:07 Go to previous messageGo to next message
pareshr
Messages: 18
Registered: August 2006
Location: Ahmedabad
Junior Member
Dear Sruthi,

Perhaps u r trying to login such a way
sys/password@dbname.....but if u want to login with sys user u should log in like

sys/password@dbname as sysoper
or
sys/password@dbname as sysdba

Try this way..u can login with sys user either with sysdba or sysoper. so u should have to user sysdba or sysoper...
Re: Cannot connect SYS thru SQL*PLUS only [message #190377 is a reply to message #190364] Wed, 30 August 2006 07:19 Go to previous messageGo to next message
sruthi
Messages: 23
Registered: May 2006
Junior Member
hI pareshr,

THANK YOU FOR QUICK RESPONSE.

Im using same method as you given. but in vain. It is giving the same error.

some more thots on this regrad would be highly appreciated.

Thanks

Sruthi
Re: Cannot connect SYS thru SQL*PLUS only [message #190382 is a reply to message #190377] Wed, 30 August 2006 07:31 Go to previous messageGo to next message
pareshr
Messages: 18
Registered: August 2006
Location: Ahmedabad
Junior Member
Hi Sruthi,

another reason is if you would not have administrator rights on that PC then also it could happen. if you r trying to connect thru remote PC and not administrator on the same machine then also u can not connect using sys.

Thank You,
Re: Cannot connect SYS thru SQL*PLUS only [message #190387 is a reply to message #190364] Wed, 30 August 2006 07:56 Go to previous message
sruthi
Messages: 23
Registered: May 2006
Junior Member
Hi pareshr,

My OS user account is In administrator account. And if there is any problem like you explained it sould effect all other utilities like toad,plsql developer. I can easly connect using these tools. Only problem is not able to connect thru sql plus

thanks

Sruthi
Previous Topic: Query
Next Topic: comparision
Goto Forum:
  


Current Time: Sat Dec 10 06:52:56 CST 2016

Total time taken to generate the page: 0.16596 seconds