Home » RDBMS Server » Server Administration » Database Userid Getting locked
Database Userid Getting locked [message #189589] Fri, 25 August 2006 03:15 Go to next message
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
Re: Database Userid Getting locked [message #189608 is a reply to message #189589] Fri, 25 August 2006 04:14 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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')
/
Re: Database Userid Getting locked [message #189615 is a reply to message #189608] Fri, 25 August 2006 04:43 Go to previous message
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
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:
  


Current Time: Wed Dec 07 16:44:12 CST 2016

Total time taken to generate the page: 0.15431 seconds