Re: PL/SQL HOST Command Hangs

In article <3cvjem$9ad_at_netaxs.com>, Stephen Tyson <tyson_at_netaxs.com> wrote:
>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.

Two things, we were having host calls fail whether or not the database was on the local machine or not, and I meant TWO_TASK, not ORACLE_SID.

Sorry about any confusion.

Kevin Toepke Received on Mon Dec 19 1994 - 21:26:29 CET