OraFAQ Forum: Security » ORA-01031: insufficient privileges when conn sys/password as sysdba

Home » RDBMS Server » Security » ORA-01031: insufficient privileges when conn sys/password as sysdba

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

ORA-01031: insufficient privileges when conn sys/password as sysdba [message #132670]

Mon, 15 August 2005 10:57

stepheng
Messages: 12
Registered: August 2005
Location: Ireland

Junior Member

Hi ,

When I use conn / as sysdba on the Linux Server itself through SQLPlus it connects fine , because Im logged in as root.

However , when I connect from a remote PC i get the above error...

I get the same error when i try connect to OEM from another Server.

Any ideas? ( Its like the SYS user isnt granted the dba or sysdba role?)

Cheers

Stephen

Using Oracle 9.2.0.5

Report message to a moderator

Re: ORA-01031: insufficient privileges when conn sys/password as sysdba [message #132673 is a reply to message #132670]

Mon, 15 August 2005 11:09

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Hi
have a look at the thread http://www.orafaq.com/forum/t/49785/68488/ i.e. the one that was at the very top of the list when you posted this. The last post might be useful.
Jim

Report message to a moderator

Re: ORA-01031: insufficient privileges when conn sys/password as sysdba [message #132674 is a reply to message #132670]

Mon, 15 August 2005 11:10

alliejane
Messages: 59
Registered: July 2005
Location: Glasgow

Member

When you log on from the server itself the database is using Operating Authentication, that is Oracle checks that the user you've logged onto the server as is a member of an OS group called dba (or oradba), if it is then you can use the "as sysdba" and you get access.

This will of course not work if your on a client - the database had no real way of checking your client OS user (you can set REMOTE_OS_AUTHENTICATION = TRUE but thats not recommended) the recommended way of using sysdba from a client is by setting up a password file.

You do this by running the utility orapwd from a command line.

orapwd file=$ORACLE_HOME/dbs/orapwsid password=secure entries=5

This will automatically create a password file with the sys user in it, and allow you to log on remotely using

connect sys/secure@db as sysdba

Hope that helps

Allie

Report message to a moderator

Previous Topic:	Problem with connect / as sysdba
Next Topic:	tool for mixing table data in a test database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 18 18:10:15 CDT 2025