Re: PL/SQL HOST Command Hangs

In article <3cntgi$24s_at_charm.magnus.acs.ohio-state.edu>, ktoepke_at_magnus.acs.ohio-state.edu (Kevin M Toepke) says:
>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.

Thanks for the help. Received on Sat Dec 17 1994 - 21:59:02 CET