[Spacewalk-list] oracle error on logmode

[Colin Coe]

Well, you've typed:

SELECT LOG_MODE FROM SYS.V$DATABASE;

and have an error message of:

SELECT LOG_MODE FROM SYS.V

Now, I freely admit I know little of Oracle but from the error output
it looks as if the $DATABASE has been interpreted as a shell variable.
 My suggestion is to replace

SELECT LOG_MODE FROM SYS.V$DATABASE;

with

SELECT LOG_MODE FROM SYS.V\$DATABASE;

This is referred to as 'escaping'.  What it essentially does is
instruct the shell to ignore $'s normal special meaning.

HTH

CC



On Thu, Nov 26, 2009 at 7:40 PM, rob morrien <rmorrien at xs4all.nl> wrote:
> sorry what do you mean
>
> sqlplus is new for me
>
>
>
> Looks like the $ is causing you problems.  Does it work if you escape the
>> $?
>>
>> CC
>>
>> On Thu, Nov 26, 2009 at 6:08 AM, rob morrien <rmorrien at xs4all.nl> wrote:
>>>
>>> hello
>>>
>>> i try to run
>>>
>>>  sqlplus /nolog
>>>  connect / as sysdba;
>>>  shutdown immediate;
>>>  startup mount
>>>  alter database archivelog;
>>>  alter database open;
>>>  SELECT LOG_MODE FROM SYS.V$DATABASE;
>>>  quit
>>>
>>> i get an error on the next line
>>> SQL>    SELECT LOG_MODE FROM SYS.V
>>>                            *
>>>
>>> who can help me
>>>
>>> _______________________________________________
>>> Spacewalk-list mailing list
>>> Spacewalk-list at redhat.com
>>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>>
>>
>>
>>
>> --
>> RHCE#805007969328369
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>



-- 
RHCE#805007969328369