OraFAQ Forum: Networking and Gateways » Ask : connection time out

Home » RDBMS Server » Networking and Gateways » Ask : connection time out (Oracle 10g , Linux)

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

Ask : connection time out [message #514445]

Mon, 04 July 2011 20:37

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.

Report message to a moderator

Re: Ask : connection time out [message #514446 is a reply to message #514445]

Mon, 04 July 2011 20:47

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?

Report message to a moderator

Re: Ask : connection time out [message #514447 is a reply to message #514446]

Mon, 04 July 2011 21:00

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

Report message to a moderator

Re: Ask : connection time out [message #514448 is a reply to message #514447]

Mon, 04 July 2011 21:08

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?

Report message to a moderator

Re: Ask : connection time out [message #515145 is a reply to message #514448]

Fri, 08 July 2011 04:12

ntt85
Messages: 34
Registered: July 2011
Location: vietnam

Member

Thank you. I found the problems, my indexes are corrupted. Very Happy

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 15:24:48 CST 2025