Home » RDBMS Server » Security » unable to connect using sys password
unable to connect using sys password [message #198628] Wed, 18 October 2006 01:05 Go to next message
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.
Re: unable to connect using sys password [message #199036 is a reply to message #198628] Thu, 19 October 2006 16:44 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
User sys can only connect as sysdba or sysoper:

connect sys/<password>@<sid> as sysdba
Re: unable to connect using sys password [message #200361 is a reply to message #198628] Mon, 30 October 2006 09:05 Go to previous messageGo to next message
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"
Re: unable to connect using sys password [message #220959 is a reply to message #198628] Thu, 22 February 2007 20:24 Go to previous messageGo to next message
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.
Re: unable to connect using sys password [message #221107 is a reply to message #220959] Fri, 23 February 2007 22:24 Go to previous message
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
Previous Topic: Give users the bare minimum privs
Next Topic: audit database access
Goto Forum:
  


Current Time: Fri Dec 02 16:50:24 CST 2016

Total time taken to generate the page: 0.29439 seconds