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 <[email protected]> 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 <[email protected]> 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 >>> [email protected] >>> https://www.redhat.com/mailman/listinfo/spacewalk-list >>> >> >> >> >> -- >> RHCE#805007969328369 >> >> _______________________________________________ >> Spacewalk-list mailing list >> [email protected] >> https://www.redhat.com/mailman/listinfo/spacewalk-list >> > > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list > -- RHCE#805007969328369 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
