OraFAQ Forum: Security » 01017 invalid user/password .

Home » RDBMS Server » Security » 01017 invalid user/password .

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

01017 invalid user/password . [message #204475]

Mon, 20 November 2006 23:02

rishi1979
Messages: 36
Registered: November 2006

Member

I had created a user some 6 months back and was able to login pefectly but now when i try to login with same username/password it gives me error 01017 invalid user/password .
what could be wrong.

Report message to a moderator

Re: 01017 invalid user/password . [message #204476 is a reply to message #204475]

Mon, 20 November 2006 23:04

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

Senior Member

hi

first check you can login some database where you create users.
if yes then check ur password and userid again.

then after if it is normal user login sys user and alter user password.

sql>alter user "username" identified by "pwd".

hope this helps
Taj.

Report message to a moderator

Re: 01017 invalid user/password . [message #204511 is a reply to message #204476]

Tue, 21 November 2006 02:11

rishi1979
Messages: 36
Registered: November 2006

Member

Hi Taj,

Yes i am logging into the same database and the userid and password are correct .but why i have to use alter user when i was able to login a few days back.

Report message to a moderator

Re: 01017 invalid user/password . [message #204512 is a reply to message #204511]

Tue, 21 November 2006 02:15

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

Senior Member

hi rishi,

ORA-01017: invalid username/password; logon denied

Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is:
username/password.

Action: Enter a valid username and password combination in the correct format.

hope this helps
Taj.

Report message to a moderator

Re: 01017 invalid user/password . [message #204575 is a reply to message #204512]

Tue, 21 November 2006 05:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is this user, perhaps, locked? Or is its password expired?

Report message to a moderator

Re: 01017 invalid user/password . [message #204600 is a reply to message #204575]

Tue, 21 November 2006 06:24

rishi1979
Messages: 36
Registered: November 2006

Member

The password has not expired nor it is locked

Report message to a moderator

Re: 01017 invalid user/password . [message #204606 is a reply to message #204600]

Tue, 21 November 2006 06:30

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

Senior Member

hi rishi

so why are you not try to alter user ... option.

sql>conn sys as sysdba
sql> alter user " usrname" identified by "pwd"

Is there any problem ?

regards
Taj.

Report message to a moderator

Re: 01017 invalid user/password . [message #205021 is a reply to message #204606]

Thu, 23 November 2006 01:37

rishi1979
Messages: 36
Registered: November 2006

Member

No there is no problem but what if i had created 100 and after 6 months 20 of them can't login .everytime i had to use alter user option

Report message to a moderator

Re: 01017 invalid user/password . [message #205588 is a reply to message #205021]

Sun, 26 November 2006 08:40

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

Senior Member

Hi rishi,

1.Check ur user default profile ( which profile assign to user)

select profile from dba_users where username in UPPER( '&usrname')

2. Check "password_grace_time" and "password_life_time" in profile.

select resource_name, limit
from dba_profiles
where resource_name in ( 'PASSWORD_GRACE_TIME','PASSWORD_LIFE_TIME')
and profile in UPPER('&profilename')

3.And now assign "Default profile" or increase above both mentioned parameter values.

hope this helps
Taj.

let me know what happen;

Report message to a moderator

Re: 01017 invalid user/password . [message #205656 is a reply to message #204475]

Mon, 27 November 2006 00:17

rishi1979
Messages: 36
Registered: November 2006

Member

hello sir,
The user already had 'default profile'.

Report message to a moderator

Re: 01017 invalid user/password . [message #207071 is a reply to message #204475]

Mon, 04 December 2006 01:30

rishi1979
Messages: 36
Registered: November 2006

Member

Any other reason

Report message to a moderator

Re: 01017 invalid user/password . [message #207073 is a reply to message #207071]

Mon, 04 December 2006 01:36

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

Senior Member

hi rishi,

You can create new profile with enough password period. and assign to users.

Any other reason
Don't know. most possibly these problem occur when parameter speciified limit is reached. but in ur case you have default profile.

regards
Taj

Report message to a moderator

Re: 01017 invalid user/password . [message #207271 is a reply to message #204475]

Mon, 04 December 2006 22:10

rishi1979
Messages: 36
Registered: November 2006

Member

Thanks sir

I think that's he only option left for me

Report message to a moderator

Previous Topic:	special characters in username
Next Topic:	does oracle 10.1 support transparent data encryption?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 19:46:56 CST 2024