UNIX for Dummies Questions & Answers

Hi,

I created the following shell script file :

bash-3.00$ more Unlock_Statistics1.sh
#!/usr/bin/ksh

ORACLE_SID=prsal02; export ORACLE_SID
NLS_LANG=AMERICAN_AMERICA.AL32UTF8; export NLS_LANG

sqlplus -s /nolog << EOF
connect / as sysdba ;
set serveroutput on size 1000000;
execute dbms_stats.unlock_schema_stats('IDOADMIN') ;
exit;
EOF

When I tried to run it .. it gives error as under:

bash-3.00$ sh Unlock_Statistics1.sh
: command not foundsh: line 2:
': not a valid identifierne 3: export: `ORACLE_SID
': not a valid identifierne 4: export: `NLS_LANG
: command not foundsh: line 5:

Now, The above script is working fine on one of the Development server but its not working on production server as shown above.. moreover the command file generates this:

bash-3.00$ file *
Export.sh: a /usr/bin/ksh script text executable
Grants.sh: a /usr/bin/ksh script text executable
idoadmin_import.log: empty
idodbp01.dmp: DBase 3 data file (1380929624 records)
idouser1_import.log: empty
Import.sh: a /usr/bin/ksh script text executable
Increase_Column_Widths1.sh: a /usr/bin/ksh\015i script text executable
Migration.sh: a /usr/bin/ksh script text executable
Pre_Import_Destination_DB.sh: a /usr/bin/ksh script text executable
Unlock_Statistics1.sh: a /usr/bin/ksh\015i script text executable

I can see that files "Unlock_Statistics1.sh" and "Increase_Column_Widths1.sh" are showing diff result and they are the files that are throwing errors... rest of all shell files are working fine...

I have created them manually and not copied.....

Pls kindly help me in resolving the error...and cause of it..

Kindly note that i am new to unix but i do now basics of it..

Thanks

You have somehow added a CR character to each line. Fix by using dos2unix.