Home » RDBMS Server » Security » User taking more time to reset password (Oracle 11.1.0.7.0 , SunOS 5.10)
User taking more time to reset password [message #614099] Fri, 16 May 2014 06:06 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
its taking lot of time.


No, it does not.

Re: User taking more time to reset password [message #614228 is a reply to message #614108] Mon, 19 May 2014 10:05 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
it does take lot of time
Re: User taking more time to reset password [message #614230 is a reply to message #614228] Mon, 19 May 2014 10:25 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No it does not.

Re: User taking more time to reset password [message #614232 is a reply to message #614230] Mon, 19 May 2014 10:41 Go to previous messageGo to next message
cookiemonster
Messages: 13626
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do you have a password verify function?
Re: User taking more time to reset password [message #614237 is a reply to message #614232] Mon, 19 May 2014 11:25 Go to previous messageGo to next message
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


Re: User taking more time to reset password [message #614238 is a reply to message #614237] Mon, 19 May 2014 11:35 Go to previous messageGo to next message
EdStevens
Messages: 1077
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.
Re: User taking more time to reset password [message #614264 is a reply to message #614238] Tue, 20 May 2014 03:59 Go to previous messageGo to next message
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 Go to previous messageGo to next message
EdStevens
Messages: 1077
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).
Re: User taking more time to reset password [message #614309 is a reply to message #614264] Tue, 20 May 2014 09:55 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3131
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21480
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.
Re: User taking more time to reset password [message #614407 is a reply to message #614336] Wed, 21 May 2014 07:23 Go to previous messageGo to next message
EdStevens
Messages: 1077
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)
Re: User taking more time to reset password [message #614594 is a reply to message #614338] Fri, 23 May 2014 09:55 Go to previous messageGo to next message
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.
Re: User taking more time to reset password [message #614721 is a reply to message #614594] Mon, 26 May 2014 09:28 Go to previous message
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
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:
  


Current Time: Sat Jun 15 19:56:31 CDT 2019