It's obvious :
If you can do it the two ways that means you work locally on your machine.
The first way uses SQLNET, the second no.
Probably, the problems is in the solving of the node address in network
layers...
TheKarma_at_yahoo.com a écrit dans le message
<6shpll$f06$1_at_nnrp1.dejanews.com>...
>Hi,
>We have a Oracle 7.3 instance called "Risk" on Sun machine. The tnsnames
alias
>for this is also called "Risk".
>
>The problem is, if we try to connect to the database using
>userid/password_at_risk, i.e. by explicitly giving the connect string, the
>system hangs for about 5 mintutes to 20 minutes before we get sqlplus
prompt.
>but if export the oracle_sid=risk and connect just by using userid/password
>it is quick(which it should be). What could possibly the problem?
>
>any 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 Sep 02 1998 - 04:29:41 CDT
