Another Syntax Error in BASH Shell

[wak1967]

Hi all

In the following script I am getting an error on the 'if' line. I'm guessing the problem is with the brackets. Any ideas?


if [ $db_status = "MOUNTED" -o $db_status = "OPEN" ]; then
#
# Get the archivelog-mode of the database
#
ARCHIVELOG=`sqlplus -s &quot;/ as sysdba&quot; <<EOF
set heading off
set feedback off
set verify off
select log_mode from v\\$database;
exit
EOF
`

 

[danielhozac]

Posting the error messages helps. //Daniel

 

[wak1967]

Sorry, afetr a weekend looking at this script I'm going crazy!

the error was bash: [: too many arguments.

I also need to mention that the script ends with a 'fi'

 

[danielhozac]

Did you try placing the [tt]$db_status[/tt] in quotes ([tt]&quot;$db_status&quot;[/tt])? //Daniel

 

[wak1967]

Hi Daniel

I tried the quotes without success. Then I changed db_status to DB_STATUS and it all works now, with or without the quotes. Must be case sensitive.

Many thanks for your time.

Wak