Re: PL/SQL HOST Command Hangs
Date: 17 Dec 1994 20:59:02 GMT
Message-ID: <3cvjem$9ad_at_netaxs.com>
In article <3cntgi$24s_at_charm.magnus.acs.ohio-state.edu>, ktoepke_at_magnus.acs.ohio-state.edu (Kevin M Toepke) says:
Thanks for the help.
>Every time the DBAs switched from TCP/IP to Named Pipes every HOST call
>would hang. Echo $ORACLE_SID to find out if you are using Named Pipes.
>e.g., T:host:instance - TCP/IO
> P:host:instance - Named Pipes
>
>Hope this helps.
>
>Kevin Toepke
Our ORACLE_SIDs do not have a T: or P: in them and our DBA is on vacation,
so I'm not sure which we use. Could it be that named pipes are used for
local DB access and TCP used over the net? I ask because one of our non-Oracle
admins. suggested that the Sun we are running on is too old. We tried running
on a different machine, connecting to the DB on the old machine using the
_at_SID on the end of the password. This seems to have stopped the hangs.