expdata.sh报错LRM-00112: multiple values not allowed for parameter 'log'

本文记录了在使用 Oracle 数据库进行数据导出时遇到的问题及解决过程。通过调整 shell 脚本中的参数设置,解决了多次出现的错误,并最终成功完成了数据导出任务。

expdata.sh内容如下:

rq=`date '+%Y%m%d%H%M'`
exp user/passwd owner=user file=/home/oradb_${rq}.dmp buffer=204800 log=/home/oradb_${rq}.log>/home/oracle/out.log


[oracle@rac1 bk]$ ./expdata.sh 
LRM-00112: multiple values not allowed for parameter 'log'


EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
: command not foundne 5: 


expdata.sh内容如下:
rq=`date '+%Y%m%d%H%M'`
exp user/passwd file=/home/oradb_$rq.dmp buffer=204800 log=/home/oradb_$rq.log


[oracle@rac1 bk]$ ./expdata.sh 
LRM-00112: multiple values not allowed for parameter 'log'


EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
: command not foundne 3: 


将expdata.sh内容修改为如下:


rq=`date '+%Y%m%d%H%M'`
exp user/passwd file=/home/oradb_$rq.dmp buffer=204800 log=/home/oradb_`date '+%Y%m%d%H%M'`.log

注意引号分别是~下面的符号和单引号,log下面不能带空行,否则执行完脚本最后一行会报如下错误:

. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
: command not found3:

[oracle@rac1 backup]$ ./expdatanew.sh 


Export: Release 11.2.0.3.0 - Production on Tue Dec 24 22:22:35 2013


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.




Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Tes
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.


methods::getClass("DESeqDataSet")@contains # 应包含"ExpData" $RangedSummarizedExperiment An object of class "SClassExtension" Slot "subClass": [1] "DESeqDataSet" attr(,"package") [1] "DESeq2" Slot "superClass": [1] "RangedSummarizedExperiment" attr(,"package") [1] "SummarizedExperiment" Slot "package": [1] "DESeq2" Slot "coerce": function (from, strict = TRUE) { value <- methods::new("RangedSummarizedExperiment") for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } <bytecode: 0x0000020b35726ed0> <environment: namespace:DESeq2> Slot "test": function (object) TRUE <bytecode: 0x0000020b35725f10> <environment: namespace:methods> Slot "replace": function (from, to, value) { for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(from, what) <- methods::slot(value, what) from } <bytecode: 0x0000020b35725d88> <environment: namespace:DESeq2> Slot "simple": [1] TRUE Slot "by": character(0) Slot "dataPart": [1] FALSE Slot "distance": [1] 1 $SummarizedExperiment An object of class "SClassExtension" Slot "subClass": [1] "DESeqDataSet" attr(,"package") [1] "DESeq2" Slot "superClass": [1] "SummarizedExperiment" attr(,"package") [1] "SummarizedExperiment" Slot "package": [1] "DESeq2" Slot "coerce": function (from, strict = TRUE) { from <- { value <- methods::new("RangedSummarizedExperiment") for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } { value <- methods::new("SummarizedExperiment") for (what in c("colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } } <bytecode: 0x0000020b3572cbf0> <environment: namespace:SummarizedExperiment> Slot "test": function (object) TRUE <bytecode: 0x0000020b3572b728> <environment: namespace:methods> Slot "replace": function (from, to, value) { .value <- methods::as(from, "RangedSummarizedExperiment", TRUE) methods::as(.value, "SummarizedExperiment") <- value value <- .value { for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(from, what) <- methods::slot(value, what) from } } <bytecode: 0x0000020b3572b5a0> <environment: namespace:DESeq2> Slot "simple": [1] TRUE Slot "by": [1] "RangedSummarizedExperiment" attr(,"package") [1] "SummarizedExperiment" Slot "dataPart": [1] FALSE Slot "distance": [1] 2 $RectangularData An object of class "SClassExtension" Slot "subClass": [1] "DESeqDataSet" attr(,"package") [1] "DESeq2" Slot "superClass": [1] "RectangularData" attr(,"package") [1] "S4Vectors" Slot "package": [1] "DESeq2" Slot "coerce": function (from, strict = TRUE) { from <- { value <- methods::new("RangedSummarizedExperiment") for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } { from <- { value <- methods::new("SummarizedExperiment") for (what in c("colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } from } } <bytecode: 0x0000020b3572ff60> <environment: namespace:methods> Slot "test": function (object) TRUE <bytecode: 0x0000020b357328d8> <environment: namespace:methods> Slot "replace": function (from, to, value) { .value <- methods::as(from, "RangedSummarizedExperiment", TRUE) methods::as(.value, "RectangularData") <- value value <- .value { for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(from, what) <- methods::slot(value, what) from } } <bytecode: 0x0000020b35732750> <environment: namespace:DESeq2> Slot "simple": [1] TRUE Slot "by": [1] "RangedSummarizedExperiment" attr(,"package") [1] "SummarizedExperiment" Slot "dataPart": [1] FALSE Slot "distance": [1] 3 $Vector An object of class "SClassExtension" Slot "subClass": [1] "DESeqDataSet" attr(,"package") [1] "DESeq2" Slot "superClass": [1] "Vector" attr(,"package") [1] "S4Vectors" Slot "package": [1] "DESeq2" Slot "coerce": function (from, strict = TRUE) { from <- { value <- methods::new("RangedSummarizedExperiment") for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } { from <- { value <- methods::new("SummarizedExperiment") for (what in c("colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } from } } <bytecode: 0x0000020b357311e0> <environment: namespace:methods> Slot "test": function (object) TRUE <bytecode: 0x0000020b3572dbd0> <environment: namespace:methods> Slot "replace": function (from, to, value) { .value <- methods::as(from, "RangedSummarizedExperiment", TRUE) methods::as(.value, "Vector") <- value value <- .value { for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(from, what) <- methods::slot(value, what) from } } <bytecode: 0x0000020b3572da48> <environment: namespace:DESeq2> Slot "simple": [1] TRUE Slot "by": [1] "RangedSummarizedExperiment" attr(,"package") [1] "SummarizedExperiment" Slot "dataPart": [1] FALSE Slot "distance": [1] 3 $ExpData An object of class "SClassExtension" Slot "subClass": [1] "DESeqDataSet" attr(,"package") [1] "DESeq2" Slot "superClass": [1] "ExpData" attr(,"package") [1] "SummarizedExperiment" Slot "package": [1] "DESeq2" Slot "coerce": function (from, strict = TRUE) { from <- as(from, "RangedSummarizedExperiment", strict = strict) { from <- as(from, "SummarizedExperiment", strict = strict) from } } <bytecode: 0x0000020b35736428> <environment: namespace:methods> Slot "test": function (object) TRUE <bytecode: 0x0000020b35735c80> <environment: namespace:methods> Slot "replace": function (from, to, value) { .value <- methods::as(from, "RangedSummarizedExperiment", TRUE) methods::as(.value, "ExpData") <- value value <- .value { for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(from, what) <- methods::slot(value, what) from } } <bytecode: 0x0000020b35735af8> <environment: namespace:DESeq2> Slot "simple": [1] FALSE Slot "by": [1] "RangedSummarizedExperiment" attr(,"package") [1] "SummarizedExperiment" Slot "dataPart": [1] FALSE Slot "distance": [1] 3 $Annotated An object of class "SClassExtension" Slot "subClass": [1] "DESeqDataSet" attr(,"package") [1] "DESeq2" Slot "superClass": [1] "Annotated" attr(,"package") [1] "S4Vectors" Slot "package": [1] "DESeq2" Slot "coerce": function (from, strict = TRUE) { from <- { value <- methods::new("RangedSummarizedExperiment") for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } { from <- { value <- methods::new("SummarizedExperiment") for (what in c("colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } from } } <bytecode: 0x0000020b357384a8> <environment: namespace:methods> Slot "test": function (object) TRUE <bytecode: 0x0000020b35740e18> <environment: namespace:methods> Slot "replace": function (from, to, value) { .value <- methods::as(from, "RangedSummarizedExperiment", TRUE) methods::as(.value, "Annotated") <- value value <- .value { for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(from, what) <- methods::slot(value, what) from } } <bytecode: 0x0000020b35740c90> <environment: namespace:DESeq2> Slot "simple": [1] TRUE Slot "by": [1] "RangedSummarizedExperiment" attr(,"package") [1] "SummarizedExperiment" Slot "dataPart": [1] FALSE Slot "distance": [1] 4 $vector_OR_Vector An object of class "SClassExtension" Slot "subClass": [1] "DESeqDataSet" attr(,"package") [1] "DESeq2" Slot "superClass": [1] "vector_OR_Vector" attr(,"package") [1] "S4Vectors" Slot "package": [1] "DESeq2" Slot "coerce": function (from, strict = TRUE) { from <- { value <- methods::new("RangedSummarizedExperiment") for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } { from <- { value <- methods::new("SummarizedExperiment") for (what in c("colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(value, what) <- methods::slot(from, what) value } from } } <bytecode: 0x0000020b3573f720> <environment: namespace:methods> Slot "test": function (object) TRUE <bytecode: 0x0000020b3573a100> <environment: namespace:methods> Slot "replace": function (from, to, value) { .value <- methods::as(from, "RangedSummarizedExperiment", TRUE) methods::as(.value, "vector_OR_Vector") <- value value <- .value { for (what in c("rowRanges", "colData", "assays", "NAMES", "elementMetadata", "metadata")) methods::slot(from, what) <- methods::slot(value, what) from } } <bytecode: 0x0000020b35739f78> <environment: namespace:DESeq2> Slot "simple": [1] TRUE Slot "by": [1] "RangedSummarizedExperiment" attr(,"package") [1] "SummarizedExperiment" Slot "dataPart": [1] FALSE Slot "distance": [1] 4
05-14
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值