Re: PL/SQL HOST Command Hangs
Date: Tue, 20 Dec 1994 10:39:25 GMT
Message-ID: <James.Lawrence.67.000AA882_at_epamail.epa.gov>
In article <3cvjem$9ad_at_netaxs.com> tyson_at_netaxs.com (Stephen Tyson) writes:
>From: tyson_at_netaxs.com (Stephen Tyson)
>Subject: Re: PL/SQL HOST Command Hangs
>Date: 17 Dec 1994 20:59:02 GMT
>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.