RE: Somewhat Perplexed - Very Sheepish - Totally Ignorant:SQPLUS after 10.2.0.4 Upgrade

Hmm...so, escaping to a shell prompt actually works....but other commands don't? very weird.

What if you use 'host' instead of '!'?

SQL> host ls

??

If this is a bug, you may want to search on the SQL*Plus 'host' command. '!' is a synonym for 'host'.

Hope that helps,

-Mark

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak_at_proquest.com<mailto:mark.bobak_at_il.proquest.com>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: David Barbour [mailto:david.barbour1_at_gmail.com]
Sent: Monday, November 03, 2008 11:22 AM
To: Bobak, Mark
Cc: alever_at_libero.it; oracle-l
Subject: Re: Somewhat Perplexed - Very Sheepish - Totally Ignorant:SQPLUS after 10.2.0.4 Upgrade

SQL> !ksh
orapr1_at_r3prdci1>

On Mon, Nov 3, 2008 at 11:06 AM, Bobak, Mark <Mark.Bobak_at_proquest.com<mailto:Mark.Bobak_at_proquest.com>> wrote:

David,



What happens if you do:

SQL>  !sh



(or bash, or ksh, or whatever your preferred shell is?)



-Mark



--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak_at_proquest.com<mailto:mark.bobak_at_il.proquest.com>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>

ProQuest...Start here.



From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of David Barbour
Sent: Monday, November 03, 2008 11:00 AM
To: alever_at_libero.it<mailto:alever_at_libero.it>
Cc: oracle-l
Subject: Re: Somewhat Perplexed - Very Sheepish - Totally Ignorant:SQPLUS after 10.2.0.4<http://10.2.0.4> Upgrade



Thanks, but the directory has both files and directories.  But I just don't get a list.  So I decided to see if other commands which should return output might work.  I tried the cat command.  SQL> !cat arch.txt     Guess what, no output.  Simply came back to a prompt.

On Mon, Nov 3, 2008 at 10:34 AM, Alessandro Vercelli <alever_at_libero.it<mailto:alever_at_libero.it>> wrote:

Sorry, I was wrong: the directory in which you run the command needs to be empty (no files and no directories).

Alessandro



>The "ls" command can give also a null response, if you are placed in a directory which has non files (i.e. an empty directory or containing only directories).

>

>If the returned prompt is SQL>, that colud be the right behaviour.

>

>Alessandro

>

>

>>Morning,

>>


<cut>



>>session and type (for instance) SQL>!ls - it returns to a prompt without

>>listing the files in the directory.  Anybody had this happen to them

>>before?  I tried searching on Metalink, but I don't even know how to phrase


<cut>

--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l