RE: login/exit problems

There was a problem with  Oracle Trace being set in some V7 instances. A couple of files grew quite large. STOP PRESS just checked on Metalink and found note 45482.1 This suggest checking the $ORACLE_HOME/otrace/admin directory for a file process.dat and see if it growing (recently written to).

-----Original Message-----
From: afa2 [mailto:afa2_at_york.ac.uk]
Sent: 08 January 2002 19:20
To: Multiple recipients of list ORACLE-L Subject: login/exit problems

We have an Oracle 7.3.4 database that has been stable for a number of years but has started having problems during logon and exit with both sqlplus and remote logins. It hangs for up to a minute before connecting to Oracle server after you get

$ sqlplus ***/***

SQL*Plus: Release 3.3.4.0.1 - Production on Tue Jan  8 19:06:28 2002

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved. 

<hangs here>

and similarly following an exit from Oracle server after disconnecting

Disconnected from Oracle7 Server Release 7.3.4.0.1 - Production With the distributed, replication, parallel query and Spatial Data options PL/SQL Release 2.3.4.0.0 - Production

<hangs here>

before returning to OS command line prompt

lsnrctl, tnsping, etc suggest port is okay. Stopping and restarting database make no difference. Any advice or help will be much appreciated.

Tony

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: afa2
  INET: afa2_at_york.ac.uk


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).




=========================================================
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=========================================================