OraFAQ Forum: Security » User taking more time to reset password

Home » RDBMS Server » Security » User taking more time to reset password (Oracle 11.1.0.7.0 , SunOS 5.10)

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

User taking more time to reset password [message #614099]

Fri, 16 May 2014 06:06

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi ,

When i try to reset database user password, its taking lot of time.Could you please tell me why it is taking more time to reset the password.

With Regards,
Balaji.C

[Updated on: Fri, 16 May 2014 06:33]

Report message to a moderator

Re: User taking more time to reset password [message #614108 is a reply to message #614099]

Fri, 16 May 2014 10:06

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

its taking lot of time.

No, it does not.

Report message to a moderator

Re: User taking more time to reset password [message #614228 is a reply to message #614108]

Mon, 19 May 2014 10:05

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

it does take lot of time

Report message to a moderator

Re: User taking more time to reset password [message #614230 is a reply to message #614228]

Mon, 19 May 2014 10:25

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No it does not.

Report message to a moderator

Re: User taking more time to reset password [message #614232 is a reply to message #614230]

Mon, 19 May 2014 10:41

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

Do you have a password verify function?

Report message to a moderator

Re: User taking more time to reset password [message #614237 is a reply to message #614232]

Mon, 19 May 2014 11:25

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Cookiemaster,

server access is expired.I have requested server team to reset it.Once it is done i will verify it and update you.

sorry for the inconvenience caused.

With Regards,
Suhas

Report message to a moderator

Re: User taking more time to reset password [message #614238 is a reply to message #614237]

Mon, 19 May 2014 11:35

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

suhasdba wrote on Mon, 19 May 2014 11:25

server access is expired.I have requested server team to reset it.Once it is done i will verify it and update you.

The password verify function for database users (you said you were changing the password for a database user) is in the database. You only need database access, not server access.

Report message to a moderator

Re: User taking more time to reset password [message #614264 is a reply to message #614238]

Tue, 20 May 2014 03:59

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

<The password verify function for database users (you said you were changing the password for a database user) is in the database. You only need database access, not server access.>

yes i am aware of it EdStevens .To connect to database i first connect to server and then database through oracle user if i am not wrong.

Thanks

[Updated on: Tue, 20 May 2014 03:59]

Report message to a moderator

Re: User taking more time to reset password [message #614301 is a reply to message #614264]

Tue, 20 May 2014 07:36

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

suhasdba wrote on Tue, 20 May 2014 03:59

To connect to database i first connect to server and then database through oracle user if i am not wrong.

Thanks

Well, I don't know how YOU connect to the database. But what you CAN do is simply run sqlplus (or sql developer, or any other oracle client tool) from your desktop and connect directly to the database. No server credentials required. So your original statement "server access is expired. I have requested server team to reset it." is a non-issue.

(And for those that want to pick a nit, yes that communication still does go through the db server. But it does not require server os user credentials, which is what the OP seems to think he needs).

Report message to a moderator

Re: User taking more time to reset password [message #614309 is a reply to message #614264]

Tue, 20 May 2014 09:55

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

@suhasdba,

Why not use sqlplus and connect to DB. Try modifying your own password, and see if it takes longer time too. Ideally it should never be, unless there is something else behind the authentication, as CM pointed out. Try to figure it out.

By authentication, I mean the rules defined for a genuine password creation in your system/application. Which only you would know/be aware of. If you are not the DBA, then get in touch of your application DBA.

[Updated on: Tue, 20 May 2014 10:48] by Moderator

Report message to a moderator

Re: User taking more time to reset password [message #614336 is a reply to message #614309]

Wed, 21 May 2014 00:00

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Lalit/Stevens,

Thanks for your suggestions.I will follow the methods you suggested to connect to database.Actually the issue got fixed .I restarted the database using shutdown abort and then was able to reset the user password in database.well my server OS user credentials is also fixed and able to login to server.

I have one more question with regards to using SQL developer tool.

I know its a oracle client tool that can be downloaded from oracle site . Does it require any port to be opened to connect to oracle DB server ?

Thanks
Suhas

[Updated on: Wed, 21 May 2014 00:01]

Report message to a moderator

Re: User taking more time to reset password [message #614338 is a reply to message #614336]

Wed, 21 May 2014 00:13

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

Senior Member
Account Moderator

As far as I can tell, if you can connect to the database with SQL*Plus, you'll be able to do that with SQL Developer as well (i.e. you don't have to adjust anything special, such as ports and stuff).

Next time, when you have a question that is not related to the original problem/question, please, open a new topic in the appropriate forum and ask that question there. In this very example, this topic would end with your words "... able to login to server". The rest ("I have one more question ...") would go into a new topic in "Client Tools" forum.

Report message to a moderator

Re: User taking more time to reset password [message #614407 is a reply to message #614336]

Wed, 21 May 2014 07:23

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

suhasdba wrote on Wed, 21 May 2014 00:00

I have one more question with regards to using SQL developer tool.

I know its a oracle client tool that can be downloaded from oracle site . Does it require any port to be opened to connect to oracle DB server ?

Thanks
Suhas

If I call you on my landline, does it require a different telephone number from when I call you on my cell phone?

see: Help! I can't connect to my database
see: Help! I can't connect to my database (part duex)

Report message to a moderator

Re: User taking more time to reset password [message #614594 is a reply to message #614338]

Fri, 23 May 2014 09:55

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

<As far as I can tell, if you can connect to the database with SQL*Plus, you'll be able to do that with SQL Developer as well (i.e. you don't have to adjust anything special, such as ports and stuff).>

Thanks littlefoot.I will try and get back to you for any issues.

Report message to a moderator

Re: User taking more time to reset password [message #614721 is a reply to message #614594]

Mon, 26 May 2014 09:28

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

I've seen these sorts of things lock up and "hang" before when a connection pool loses the plot and DDOS's the box. Basically locks up user$ and the surroundings.

Beyond that outside cause, I agree with Michel for the most part Smile

Report message to a moderator

Previous Topic:	Fine Grained Auditing only for insert on table made by a specific user
Next Topic:	How to deploy BIG-IP ASM with Oracle Database Firewall ???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 02:03:03 CST 2025