Home » RDBMS Server » Networking and Gateways » Ask : connection time out (Oracle 10g , Linux)
Ask : connection time out [message #514445] Mon, 04 July 2011 20:37 Go to next message
ntt85
Messages: 34
Registered: July 2011
Location: vietnam
Member

Hi all,

I have a JBOSS aplication server connect to database. When I tested on local, everything was ok. But when i test on real system , have a message "connection time out" on log file of app server while Oracle db still active. I viewed OEM, the system is executing the query :

"SELECT a.path songFilePath, a.BEAT beat from vp_song a, mst_my_album b "+
"where "+
"a.BEAT = b.BEAT "+
"and b.my_album_id IN "+
"(select my_album_id from (select my_album_id, ROW_NUMBER() OVER
(order by my_album_id asc) "+
"R from mst_my_album where msisdn = ?) WHERE R BETWEEN ? and ?)";

But this query is not very hard.

Could you explain and tell me how to resolve the trouble? Thanks.
Re: Ask : connection time out [message #514446 is a reply to message #514445] Mon, 04 July 2011 20:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Most folks here do NOT speak JBOSS, at least I do not.

Can you get any SQL to succeed?
SELECT SYSDATE FROM DUAL;
SELECT COUNT(*) FROM USER_OBJECTS?

For us to assist we will need the Oracle error code & message like ORA-00001
00001, 00000, "unique constraint (%s.%s) violated"
// *Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
//         For Trusted Oracle configured in DBMS MAC mode, you may see
//         this message if a duplicate entry exists at a different level.
// *Action: Either remove the unique restriction or do not insert the key.


When was last time you successfully did SQL against Oracle DB?
What changed since then?
Re: Ask : connection time out [message #514447 is a reply to message #514446] Mon, 04 July 2011 21:00 Go to previous messageGo to next message
ntt85
Messages: 34
Registered: July 2011
Location: vietnam
Member

Thanks. I executed other queries normal. Sometimes that problems appear, so I can not find the reason. Sad
Re: Ask : connection time out [message #514448 is a reply to message #514447] Mon, 04 July 2011 21:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>have a message "connection time out" on log file of app server while Oracle db still active. I viewed OEM, the system is executing the query :
Then I suspect the timeout is due to configuration of JBOSS.

can you issue EXACT same SQL in sqlplus to see how long it runs?

Can you enable SQL_TRACE=TRUE to trace session that throws error?
Re: Ask : connection time out [message #515145 is a reply to message #514448] Fri, 08 July 2011 04:12 Go to previous message
ntt85
Messages: 34
Registered: July 2011
Location: vietnam
Member

Thank you. I found the problems, my indexes are corrupted. Very Happy
Previous Topic: ORA-12154:TNS:could not resolve the connect identifier specified
Next Topic: ORA-12154: TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Thu Mar 28 06:34:33 CDT 2024