.sh 的问题
时间:2011-10-19
来源:互联网
01_before_file_upload文件下有四个文件夹,两个文件,分别是:
csv(文件夹)
ctl(文件夹)
log(文件夹)
sql(文件夹)
101_load_and_validation.sh
setenv.sh
------------------------------------------------------------
其中setenv.sh中的内容如下:
DB_NAME=cmsanzdb
DB_USER=lanita
DB_PASSWORD=lanita
---------------------------------------------------------------
其中101_load_and_validation.sh中的内容如下:
. ./setenv.sh
rm log/*.log
rm log/*.bad
rm log/*.dsc
sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @sql/101_generate_disable_constraints_sql.sql
sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @sql/101_disable_constraints.sql
sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @sql/101_clear_data_setup_from_master.sql
sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @sql/101_create_ds_tables.sql
sqlldr userid=$DB_USER/$DB_PASSWORD@$DB_NAME data=csv/HOLIDAY.csv control=ctl/HOLIDAY.ctl bad=log/HOLIDAY.bad discard=log/HOLIDAY.dsc log=log/HOLIDAY.log > log/101_load_and_validation.log 2>&1
--------------------------------------------------------------
我在cygwin中执行
./101_load_and_validation.sh
出现下面的错误:
Administrator@CRMSERVER /cygdrive/d/share/lanita/01_before_file_upload
$ ./101_load_and_validation.sh
: No such file or directoryh: line 1: ./setenv.sh
./101_load_and_validation.sh: line 2: $'\r': command not found
rm: cannot remove `log/*.log\r': No such file or directory
rm: cannot remove `log/*.bad\r': No such file or directory
rm: cannot remove `log/*.dsc\r': No such file or directory
./101_load_and_validation.sh: line 6: $'\r': command not found
请问是什么原因呢?应当怎么解决呢?
csv(文件夹)
ctl(文件夹)
log(文件夹)
sql(文件夹)
101_load_and_validation.sh
setenv.sh
------------------------------------------------------------
其中setenv.sh中的内容如下:
DB_NAME=cmsanzdb
DB_USER=lanita
DB_PASSWORD=lanita
---------------------------------------------------------------
其中101_load_and_validation.sh中的内容如下:
. ./setenv.sh
rm log/*.log
rm log/*.bad
rm log/*.dsc
sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @sql/101_generate_disable_constraints_sql.sql
sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @sql/101_disable_constraints.sql
sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @sql/101_clear_data_setup_from_master.sql
sqlplus $DB_USER/$DB_PASSWORD@$DB_NAME @sql/101_create_ds_tables.sql
sqlldr userid=$DB_USER/$DB_PASSWORD@$DB_NAME data=csv/HOLIDAY.csv control=ctl/HOLIDAY.ctl bad=log/HOLIDAY.bad discard=log/HOLIDAY.dsc log=log/HOLIDAY.log > log/101_load_and_validation.log 2>&1
--------------------------------------------------------------
我在cygwin中执行
./101_load_and_validation.sh
出现下面的错误:
Administrator@CRMSERVER /cygdrive/d/share/lanita/01_before_file_upload
$ ./101_load_and_validation.sh
: No such file or directoryh: line 1: ./setenv.sh
./101_load_and_validation.sh: line 2: $'\r': command not found
rm: cannot remove `log/*.log\r': No such file or directory
rm: cannot remove `log/*.bad\r': No such file or directory
rm: cannot remove `log/*.dsc\r': No such file or directory
./101_load_and_validation.sh: line 6: $'\r': command not found
请问是什么原因呢?应当怎么解决呢?
作者: lanita 发布时间: 2011-10-19
. ./setenv.sh 可以先cd ..再./setenv.sh
\r出错是回车键有问题
rm你换成绝对路径
\r出错是回车键有问题
rm你换成绝对路径
作者: Esperantor 发布时间: 2011-10-19
呵呵,解决了。。
dos2unix 101_load_and_validation.sh
就成了
dos2unix 101_load_and_validation.sh
就成了
作者: lanita 发布时间: 2011-10-19
注意路径。。
作者: xiangliangyu2008 发布时间: 2011-10-19
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28