My Oracle Support Banner

New connection attempts to TimesTen Database fails with TT6003: Lock Request Denied Because Of Time-out (Doc ID 1505875.1)

Last updated on JANUARY 14, 2024

Applies to:

Oracle TimesTen In-Memory Database - Version and later
Information in this document applies to any platform.


A User that is not the Instance Admin attempts to connect to a TimesTen database:

ttisql sample

 6003: Lock request denied because of time-out
The command failed.

This can also be seen in the ttmesg.log:

2012-11-14 11:44:24.61 Info:    : 19215: connect.c:2010: Mark not in-flux (was reason 2=connect pid 31518 nwaiters 0 ds /data/sample)
2012-11-14 11:44:24.61 Info:    : 19215: return 1 6003 'authentication failed' arg1='' arg1type='S' arg2='' arg2type='S'


If this had been a failed client connection attempt user might see this error logged in ttmesg.log or tterrors.log:

2012-11-14 11:44:24.61 Err : SRV: 31518: EventID=17| Connect failed for client: cshost (cshost.DOMAIN_NAME);  IP address: nnn.nn.nn.nnn;  Client PID: 26458;  DSN: SAMPLE;  UID: myuser;  SQL State: S1T00;  Error: [TimesTen][TimesTen ODBC Driver][TimesTen]TT6003: Lock request denied because of time-out Details:  -- file "db.c", lineno 9688, procedure "sbDbConnect"



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.