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

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

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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
根据引用的内容来看,这个问题出现的原因是在执行关闭数据库命令或其他命令的过程中出现异常断电或命令人为中断导致开启数据库的初始化文件丢失或异常。 解决这个问题的步骤如下: 1. 首先,通过conn / as sysdba连接到数据库。 2. 使用everything软件或Windows搜索工具,找到一个pfile文件夹下的init.ora文件或init.ora.12345678文件,这个文件就是备份文件。 3. 关闭数据库。 4. 找到报错路径,将备份文件复制到报错路径中,并将其重命名为与路径中相同的文件名。 5. 重新启动数据库,使用startup命令。此时应该可以正常启动数据库。 这些步骤应该能够解决这个问题,使数据库能够正常启动。如果问题仍然存在,可能需要进一步检查和修复数据库的配置文件和参数。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file 解决过程](https://blog.csdn.net/jianyuwuyi/article/details/113827485)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *2* *3* [ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file](https://blog.csdn.net/XWxDSJ/article/details/127732920)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值