OraFAQ Forum: Security » unable to connect using sys password

Home » RDBMS Server » Security » unable to connect using sys password

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

unable to connect using sys password [message #198628]

Wed, 18 October 2006 01:05

sreehari
Messages: 101
Registered: May 2006

Senior Member

Hi all

I am trying to connect to the database server using sys password
and getting the following error
ORA-01031: insufficient privileges

I tried connecting using EM also. got invalid user error..

but i am able to connect to this server from my local system which is Oracle 10g server.

Please help me ..

Thanks.

Report message to a moderator

Re: unable to connect using sys password [message #199036 is a reply to message #198628]

Thu, 19 October 2006 16:44

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

User sys can only connect as sysdba or sysoper:

connect sys/<password>@<sid> as sysdba

Report message to a moderator

Re: unable to connect using sys password [message #200361 is a reply to message #198628]

Mon, 30 October 2006 09:05

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Check ur sqlnet.ora file.

SQLNET.AUTHENTICATION_SERVICES= (NTS)
if above is "NTS" then you able to connect like
cmd>sqlplus/nolog
sql>conn / as sysdba

or if SQLNET.AUTHENTICATION_SERVICES= (NONE)
above entry is "NONE" you have to provide pwd.

like mentioned by "skooman"

Report message to a moderator

Re: unable to connect using sys password [message #220959 is a reply to message #198628]

Thu, 22 February 2007 20:24

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

connect sys/<anypassword> as sysdba and it does not matter what password you use. Then change the password, and system's to something you know.

Report message to a moderator

Re: unable to connect using sys password [message #221107 is a reply to message #220959]

Fri, 23 February 2007 22:24

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

HI,
it does not matter what password you use.

Correct but when user member of ORA_DBA group or sqlnet.authentication_services=NONE.
otherwise it is matter.
you have to give right password for connect sys user.

regards
Taj

Report message to a moderator

Previous Topic:	Give users the bare minimum privs
Next Topic:	audit database access

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 13:25:12 CST 2024