OraFAQ Forum: Server Administration » Database Userid Getting locked

Home » RDBMS Server » Server Administration » Database Userid Getting locked

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

Database Userid Getting locked [message #189589]

Fri, 25 August 2006 03:15

chandanbhamra
Messages: 84
Registered: April 2005
Location: India

Member

Hi

I am facing a problem of Database account getting locked when connection for that user exceeds 2.

Scenario :- We have 3 siebel servers. When we bring up 2 siebel servers with database user id SADMIN,Its working fine but when we bring up 3rd siebel server. Database account sadmin gets locked.

what could be the possible reason for this. One could be due to FAILED_LOGIN_ATTEMPTS. what could be the other reason?

Anybody has face this similar problem before? Please help.

Thanks & Regards
Chandan Singh

Report message to a moderator

Re: Database Userid Getting locked [message #189608 is a reply to message #189589]

Fri, 25 August 2006 04:14

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Please post your profile settings:

SELECT resource_name, limit
  FROM dba_profiles
 WHERE profile = (SELECT profile FROM dba_users WHERE username = 'SADMIN')
/

Report message to a moderator

Re: Database Userid Getting locked [message #189615 is a reply to message #189608]

Fri, 25 August 2006 04:43

chandanbhamra
Messages: 84
Registered: April 2005
Location: India

Member

Find below the results from that query.

[B]RESOURCE_NAME	        LIMIT[/B]
COMPOSITE_LIMIT	                DEFAULT
SESSIONS_PER_USER	        UNLIMITED
CPU_PER_SESSION	                DEFAULT
CPU_PER_CALL	                DEFAULT
LOGICAL_READS_PER_SESSION	DEFAULT
LOGICAL_READS_PER_CALL	        DEFAULT
IDLE_TIME	                UNLIMITED
CONNECT_TIME	                DEFAULT
PRIVATE_SGA	                DEFAULT
FAILED_LOGIN_ATTEMPTS	        100
PASSWORD_LIFE_TIME	        UNLIMITED
PASSWORD_REUSE_TIME	        365
PASSWORD_REUSE_MAX	        UNLIMITED
PASSWORD_VERIFY_FUNCTION	XM_PASSWORD_VERIFY_FUNCTION
PASSWORD_LOCK_TIME	        0.0104
PASSWORD_GRACE_TIME	        14

Thanks & Regards
Chandan Singh

Report message to a moderator

Previous Topic:	Please where can I find the log file of this error:ora-32700 error occured in DIAG services
Next Topic:	Shrink Tablesspacesize (16383 MB)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:43:43 CDT 2024