Home » RDBMS Server » Security » 01017 invalid user/password .
01017 invalid user/password . [message #204475] Mon, 20 November 2006 23:02 Go to next message
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.
Re: 01017 invalid user/password . [message #204476 is a reply to message #204475] Mon, 20 November 2006 23:04 Go to previous messageGo to next message
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.
Re: 01017 invalid user/password . [message #204511 is a reply to message #204476] Tue, 21 November 2006 02:11 Go to previous messageGo to next message
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.
Re: 01017 invalid user/password . [message #204512 is a reply to message #204511] Tue, 21 November 2006 02:15 Go to previous messageGo to next message
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.
Re: 01017 invalid user/password . [message #204575 is a reply to message #204512] Tue, 21 November 2006 05:36 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is this user, perhaps, locked? Or is its password expired?
Re: 01017 invalid user/password . [message #204600 is a reply to message #204575] Tue, 21 November 2006 06:24 Go to previous messageGo to next message
rishi1979
Messages: 36
Registered: November 2006
Member
The password has not expired nor it is locked
Re: 01017 invalid user/password . [message #204606 is a reply to message #204600] Tue, 21 November 2006 06:30 Go to previous messageGo to next message
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.
Re: 01017 invalid user/password . [message #205021 is a reply to message #204606] Thu, 23 November 2006 01:37 Go to previous messageGo to next message
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
Re: 01017 invalid user/password . [message #205588 is a reply to message #205021] Sun, 26 November 2006 08:40 Go to previous messageGo to next message
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;



Re: 01017 invalid user/password . [message #205656 is a reply to message #204475] Mon, 27 November 2006 00:17 Go to previous messageGo to next message
rishi1979
Messages: 36
Registered: November 2006
Member
hello sir,
The user already had 'default profile'.
Re: 01017 invalid user/password . [message #207071 is a reply to message #204475] Mon, 04 December 2006 01:30 Go to previous messageGo to next message
rishi1979
Messages: 36
Registered: November 2006
Member
Any other reason
Re: 01017 invalid user/password . [message #207073 is a reply to message #207071] Mon, 04 December 2006 01:36 Go to previous messageGo to next message
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
Re: 01017 invalid user/password . [message #207271 is a reply to message #204475] Mon, 04 December 2006 22:10 Go to previous message
rishi1979
Messages: 36
Registered: November 2006
Member
Thanks sir

I think that's he only option left for me
Previous Topic: special characters in username
Next Topic: does oracle 10.1 support transparent data encryption?
Goto Forum:
  


Current Time: Thu Mar 28 05:09:15 CDT 2024