Re: HP-UX 11i/9.2.0.3/sqlplus

Do "which sqlplus" and "whence sqlplus" from both shells? How about "ldd sqlplus" from both shells?

Just another check on environment settings, I guess. First one verifies PATH setting; second one verifies SHLIB_PATH / LD_LIBRARY_PATH setting...

Presumably, you are in the same working directory both ways; if not, check for a "login.sql" script in one of them...

...Ummmmm...that's all that I can think of for now...

...except, what precisely do you mean by "never-never land". It hangs? If it hangs, can you go to another session and see if it is consuming CPU?

on 5/19/03 3:37 PM, Vergara, Michael (TEM) at mvergara_at_guidant.com wrote:

> Tim:
>
> Checked both. Both Ok. Paths and environments are always the
> first thing I check when something is amiss. That's the
> proverbial low-hanging fruit. Any other notions or experiences?
>
> Thanks,
> Mike
>
>
> -----Original Message-----
> Sent: Monday, May 19, 2003 3:12 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Of course, make sure that PATH is set the same in both cases. You could be
> using different SQL*Plus executables, if the server has more than one
> ORACLE_HOME...
>
> Also, check to make sure that SHLIB_PATH and LD_LIBRARY_PATH are set the
> same way in both cases...
>
>
>
> on 5/19/03 12:57 PM, Vergara, Michael (TEM) at mvergara_at_guidant.com wrote:
>

>> Hi All:
>> 
>> We have recently started using Oracle 9.2 on HP-UX.  In csh,
>> "sqlplus /nolog" works fine.  In ksh, "sqlplus /nolog" goes into
>> never-never land, and requires a 'kill' from another process to
>> terminate.
>> 
>> I've never seen this before, and don't know what is wrong.  Any
>> suggestions?
>> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).