Re: [Problem connecting from JDBC]

From: S Jayakumar <sjayakumar2000_at_usa.net>
Date: 10 Jan 2001 15:42:11 MST
Message-Id: <10737.126348@fatcity.com>

Please check the following ,

connection idle time in the listener ( if the connection seems to be ha= nging / disconnected after some time of idle ness )
Max connections . After max connections are established , it may not accept new connections. in this case U may use MTS

Hope this may help
Jay

"Ravindra basavaraja" <ravindra_at_sentica.com> wrote: We have a java application that connects to the database using JDBC.At so= me
point
the java application cannot get connected to the database.

I was told to stop and start the listener.I dont' know if the listener is=

hanging.
After doing this the connection gets established.This happens everytime. But when the problem is happening I can still make a client connection fr= om
the Oracle
client on NT.If the listener was hanging then the Client connection would= n't
have got
conencted.

Can anyone tell me how to identify where the problem.I am the DBA and I think that
this is not a Listener problem but the developers are telling that this i= s a
database
related problem as they don't face this problem when working on other databases.
This happens only with the testing database.

Thanks

Ravindra

Please see the official ORACLE-L FAQ: http://www.orafaq.com -- =

Author: Ravindra basavaraja
INET: ravindra_at_sentica.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Get free email and a permanent address at http://www.netaddress.com/?N=3D= 1

From: yong huang <yong321_at_yahoo.com>
Date: Wed, 10 Jan 2001 14:56:40 -0800 (PST) Subject: RE: ResetLogs

Hi, Christian,

Why do you have to back up redo logfiles when you do cold backup? Are you saying there could be some remaining redo records left in redo logs, even with a normal shutdown?

Yong Huang
yong321_at_yahoo.com

"Trassens, Christian" wrote:

No if it is a cold backup. However and in terms of recovery, if you don't backup the redo logs, you'll need it.

Oracle recommends not to backup redo logs, but in the case of cold backups you should do it because of the absence of archives.

Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/

From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon_at_comalco.riotinto.com.au> Date: Wed, 10 Jan 2001 23:04:20 -0000
Subject: RE: sql statement "hanging" and unable to query v$lock - Oracle 8

Hi,

Try querying dba_blockers and dba_waiters - these might give the sid of = the
blocking session.
If these views don't exist then you can create them with the = catblock.sql
script found in rdms/admin directory.

Also, if you have OEM, try using the lock monitor tool.

Alternatively, if it doesn't show up here, look in dba_lock_internal. = The
following is the query I use - this will sometimes show up blocks that = don't
show up in dba_locks.

select * from dba_lock_internal
where=20

( mode_held =3D 'Null' OR mode_held =3D 'None' ) AND ( mode_requested <> 'None' )
;

and can then do something like the following

select * from dba_lock_internal
where
   mode_held <> 'Null'
   and mode_held <> 'None'
   and lock_id1 =3D 'as appropriate- based on what came back from the = first
query'
;

Hope this helps.

Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au

-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer_at_quest.com] Sent: Thursday, 11 January 2001 9:41
To: Multiple recipients of list ORACLE-L Subject: sql statement "hanging" and unable to query v$lock - Oracle = 8.0.5

Question here. I have a query that's taking an abnormally long time to execute (at least in my opinion). I can see the query that's executing =
(I

assume this is the one since I'm in a development database with only = very
few connections, and there's only one with loaded_versions =3D 1, open_versions =3D 1, and users_executing =3D 1 in v$sql). I figured that there was probably a table being locked somewhere. But = when I
try to query v$lock (I typed in "select * from v$lock" in SQL*Plus on = the
server) that query hangs too! At least it never returns back to the = prompt.
However I can still connect to the database in a new session and query = other
v$ views such as v$session.=20
How do I find out why the process is hanging? I don't see any ORA- = errors in
the alert log.=20
Oracle Enterprise Edition 8.0.5 on Sun Solaris 5.7=20 Jacques R. Kilcho=EBr=20
(949) 754-8816=20

Quest Software, Inc.=20
8001 Irvine Center Drive=20
Irvine, California 92618=20
U.S.A.=20
http://www.quest.com=20 Received on Wed Jan 10 2001 - 16:42:11 CST