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

There is a possibility that the directory you are in is a symbolic link. To test this execute this command and let us know what is returned

SQLPLUS> !ls -l ../

Mike

David Barbour wrote:
> SQL> !ksh
> orapr1_at_r3prdci1>
> orapr1_at_r3prdci1>exit
>
> SQL> host ls
>
> SQL> exit
> Disconnected from Oracle Database 10g Enterprise Edition Release
> 10.2.0.4.0 - 64bit Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
> orapr1_at_r3prdci1>ls
> 102_64 mirrlogA saparch
> sapdata4 saptemp sqlnet.log
> 920_64 mirrlogB sapbackup
> sapdata5 saptrace tdpoerror.log
> Mail oraInventory sapcheck
> sapdata6 sapundo
> dbvchk.sh oraarch sapdata1
> sapdata7 scripts
> dead.letter origlogA sapdata10
> sapdata8 smit.log
> em1 origlogB sapdata2
> sapdata9 smit.script
> jre oui sapdata3
> sapreorg smit.transaction
> orapr1_at_r3prdci1>sqlplus / as sysdba
>
> SQL*Plus: Release 10.2.0.4.0 - Production on Mon Nov 3 11:39:21 2008
>
> Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
> Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
>
> SQL> host ksh
> orapr1_at_r3prdci1>
>
>
>
> I've filed a Service Request and I'll do some more checking. Thanks.
>
> On Mon, Nov 3, 2008 at 11:27 AM, Bobak, Mark <Mark.Bobak_at_proquest.com
> <mailto:Mark.Bobak_at_proquest.com>> wrote:
>
> 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
> <mailto:david.barbour1_at_gmail.com>]
> *Sent:* Monday, November 03, 2008 11:22 AM
> *To:* Bobak, Mark
> *Cc:* alever_at_libero.it <mailto:alever_at_libero.it>; oracle-l
>
> *Subject:* Re: Somewhat Perplexed - Very Sheepish - Totally
> Ignorant:SQPLUS after 10.2.0.4 <http://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