OraFAQ Forum: Server Administration » Insufficient privileges while connecting 'sys as sysdba'

Home » RDBMS Server » Server Administration » Insufficient privileges while connecting 'sys as sysdba' (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Insufficient privileges while connecting 'sys as sysdba' [message #581120]

Tue, 02 April 2013 06:06

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

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

Your server user needs to be in the DBA group for that to work.

Report message to a moderator

Re: Insufficiemt privillege while connecting 'sys as sysdba'..Oracle 11g [message #581128 is a reply to message #581120]

Tue, 02 April 2013 06:42

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

Re: Insufficiemt privillege while connecting 'sys as sysdba'..Oracle 11g [message #581189 is a reply to message #581188]

Wed, 03 April 2013 02:31

cookiemonster
Messages: 13959
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.

Report message to a moderator

Re: Insufficiemt privillege while connecting 'sys as sysdba'..Oracle 11g [message #581270 is a reply to message #581189]

Thu, 04 April 2013 00:16

abbymurali
Messages: 14
Registered: April 2013

Junior Member

Thanks a lot for your replies folks...the issue is solved now...thanks again..

Regards
Unni.

Report message to a moderator

Re: Insufficiemt privillege while connecting 'sys as sysdba'..Oracle 11g [message #581271 is a reply to message #581270]

Thu, 04 April 2013 00:19

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

How did you solve it?

Regards
Michel

Report message to a moderator

Re: Insufficient privileges while connecting 'sys as sysdba' [message #581285]

Thu, 04 April 2013 03:44

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.

Report message to a moderator

Previous Topic:	Delayed Logon
Next Topic:	Automatic Memory Management

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 23:43:16 CST 2024