Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Disconnect from SQL*Plus takes more than 30 seconds
Server Sun Solaris 2.8
Oracle8i 8.1.7.4
I have about 12 databases installed on the Oracle8i oracle home. One of the database takes more than 30 seconds to disconnect from SQL*Plus, when connected using SQL*Net. Connections using ORACLE_SID work fine, no issues. Tried changing the host name to IP address in the listener.ora and tsnames.ora files, but did not help. Any insight would be highly appreciated. Please give me ideas to how to approach this issue....
Thanks,
Biju Thomas
Database Administrator
This electronic transmission and any attached files are intended solely for the person or entity to which they are addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Any review, retransmission, dissemination or other use, including taking any action concerning this information by anyone other than the named recipient, is strictly prohibited. If you are not the intended recipient or have received this communication in error, please immediately notify the sender and destroy this communication.
![]() |
![]() |