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

SQL> !ls -l ../

SQL> On Mon, Nov 3, 2008 at 7:14 PM, Mike Haddon <m.haddon_at_tx.rr.com> wrote:

> 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>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 <mark.bobak_at_il.proquest.com>
>> www.proquest.com
>> 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>
>> 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 <mark.bobak_at_il.proquest.com>
>> www.proquest.com
>> www.csa.com
>>
>> *ProQuest...*Start here.
>>
>>
>>
>> *From:* 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
>> *Cc:* oracle-l
>> *Subject:* Re: Somewhat Perplexed - Very Sheepish - Totally
>> Ignorant:SQPLUS after 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>
>> 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