Home » RDBMS Server » Server Administration » Insufficient privileges while connecting 'sys as sysdba' (11g)
icon8.gif  Insufficient privileges while connecting 'sys as sysdba' [message #581120] Tue, 02 April 2013 06:06 Go to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges

The oracle 11g installed in eucalyptus cloud..

In the same server I can connect as a different user 'd6' but not as sysdba. Please help ...

Regards,
Unni.


[EDITED by LF: fixed topic title typo; was "Insufficiemt privillege"]

[Updated on: Wed, 03 April 2013 02:54] by Moderator

Report message to a moderator

Re: Insufficiemt privillege while connecting 'sys as sysdba'..Oracle 11g [message #581125 is a reply to message #581120] Tue, 02 April 2013 06:28 Go to previous messageGo to next message
cookiemonster
Messages: 10981
Registered: September 2008
Location: Rainy Manchester
Senior Member
Your server user needs to be in the DBA group for that to work.
Re: Insufficiemt privillege while connecting 'sys as sysdba'..Oracle 11g [message #581128 is a reply to message #581120] Tue, 02 April 2013 06:42 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have not the privilege to connect as sysdba.
Note that the connect statement you gave normally indicates a connection to a local database, is this the case?

What is your OS?

Regards
Michel

[Updated on: Tue, 02 April 2013 06:42]

Report message to a moderator

Re: Insufficiemt privillege while connecting 'sys as sysdba'..Oracle 11g [message #581188 is a reply to message #581128] Wed, 03 April 2013 02:26 Go to previous messageGo to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
thank you for your quick reply folks....

I'm not an expert in oracle... pardon me if i post any mistakes...


I just wanted to create a database,so I started following the official oracle doc


but i can't connect to the instance as sysdba...If I do so, will this connect to a local database.?

I already have a database exists and i can connect to that DB as another user.

my OS is : centos6.3 on x86_64

Regards
Unni.


Re: Insufficiemt privillege while connecting 'sys as sysdba'..Oracle 11g [message #581189 is a reply to message #581188] Wed, 03 April 2013 02:31 Go to previous messageGo to next message
cookiemonster
Messages: 10981
Registered: September 2008
Location: Rainy Manchester
Senior Member
SQL> conn sys as sysdba

Only works for DBs that are on the machine you're running that sqlplus session from.
And it only works if your OS user is in the DBA group.

If one or both of those conditions isn't true the above command will fail.
Re: Insufficiemt privillege while connecting 'sys as sysdba'..Oracle 11g [message #581270 is a reply to message #581189] Thu, 04 April 2013 00:16 Go to previous messageGo to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
Thanks a lot for your replies folks...the issue is solved now...thanks again..


Regards
Unni.
Re: Insufficiemt privillege while connecting 'sys as sysdba'..Oracle 11g [message #581271 is a reply to message #581270] Thu, 04 April 2013 00:19 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How did you solve it?

Regards
Michel
Re: Insufficient privileges while connecting 'sys as sysdba' [message #581285] Thu, 04 April 2013 03:44 Go to previous message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
Hi Michel..

It was a problem with the username.when I install oracle i mistakenly added 'orcle' as a user along with oracle and while connecting the user is 'oracle' instead of 'oracle'


Thanks a lot for you help folks...




Regards
Unni.
Previous Topic: Delayed Logon
Next Topic: Automatic Memory Management
Goto Forum:
  


Current Time: Tue Sep 30 16:26:35 CDT 2014

Total time taken to generate the page: 0.08759 seconds