Re: sqlplus connection time

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 12 Aug 1998 21:41:14 +0200
Message-ID: <35D1EFD9.87D09BEE@sybrandb.demon.nl>

We should put this in the FAQ about Oracle/Sqlnet... Verify your sqlnet.ora on the client (in Oracle Home\network\admin) There is a line reading'AUTOMATIC_IPC=' The default is ON, which is useless on a client PC. It should be off. On the server on may be advantageous.
Second option: make sure if you don't have a Oracle Names server running the line NAMES.directory_path in the same file read (TNSNAMES) only. Otherwise it will try to find default (plug and play, as they call it) Nameservers.
Hth
Sybrand Bakker, Oracle DBA

TheKarma_at_yahoo.com wrote:

> Hi,
> Everytime we try to login to Oracle, it takes about 30 seconds to 2 minutes
> before we actually get the SQLPLUS prompt. What could be the problem?? Same
> thing happens when we try to exit. It hangs for a while before we get the OS
> prompt. (ORACLE TRACE is not on.)
>
> any hint/help will be greatly appreciated.
>
> thanks.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Aug 12 1998 - 14:41:14 CDT