Solved

export errors

Posted on 2014-02-27
3
312 Views
Last Modified: 2014-06-09
I have some export errors

nj09mhf0362[oracle:sprefuat1] 11: nohup expdp_sch.sh TULLETT &
[1] 28921
nj09mhf0362[oracle:sprefuat1] 12: + . /ldba/set_sprefuat.sh
DB_NAME=sprefuat
ORACLE_SID=sprefuat1
ORACLE_BASE=/ora_home/app/oracle
ORACLE_HOME=/ora_home/app/oracle/product/10.2.0
SERVER_ABBREV=mhf0362
ORA_CRS_HOME=/crs_home/10.2
+ /usr/ucb/whoami
+ [ oracle = oracle ]
PATH=/usr/openwin/bin/xview:/usr/openwin/bin:/usr/bin:.
DBA_MAIL_LIST=/ldba/com/bin/dbamail_list
+ export DBA_MAIL_LIST
BKUP_MAIL_LIST=/ldba/mhf0362/bin/bkup_mail_list
+ export BKUP_MAIL_LIST
SERVER_MAIL_LIST=/ldba/mhf0362/bin/server_mail_list
+ export SERVER_MAIL_LIST
TNS_ADMIN=/ldba/com/sqlnet
ORACLE_TERM=vt100
ORA_NLS=/ora_home/app/oracle/product/10.2.0/ocommon/nls/admin/data
ORA_NLS10=/ora_home/app/oracle/product/10.2.0/nls/data
LD_LIBRARY_PATH=/ora_home/app/oracle/product/10.2.0/lib:/usr/lib:/usr/local/lib:                                                                                        /ora_home/app/oracle/product/10.2.0/jdbc/lib:/usr/ccs/lib:/usr/ucb/lib:/ora_home                                                                                        /app/oracle/product/10.2.0/ctx/lib
JAVA_HOME=/usr/java
JDBC_HOME=/usr/jconnect40
CLASSPATH=/usr/java/lib/classes.zip:/ora_home/app/oracle/product/10.2.0/jdbc/lib                                                                                        /classes111.zip:/usr/jconnect40/classes:.
LC_COLLATE=
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
+ export NLS_LANG
+ /usr/bin/grep -c ^/ora_home/app/oracle/product/10.2.0
+ echo /usr/openwin/bin/xview:/usr/openwin/bin:/usr/bin:.
+ [ 0 -eq 0 ]
PATH=/usr/local/bin:/usr/sbin:/usr/ucb/bin:/usr/ccs/bin:/opt/SUNWspro/bin:/usr/o                                                                                        penwin/bin/xview:/usr/openwin/bin:/usr/bin:.
PATH=/ora_home/app/oracle/product/10.2.0/bin:/ora_home/app/oracle/product/10.2.0                                                                                        /ctx/bin:/usr/java/bin:/usr/local/bin:/usr/sbin:/usr/ucb/bin:/usr/ccs/bin:/opt/S                                                                                        UNWspro/bin:/usr/openwin/bin/xview:/usr/openwin/bin:/usr/bin:.
+ export ORACLE_HOME ORACLE_SID TNS_ADMIN ORACLE_TERM ORA_NLS ORA_NLS10 DB_NAME
+ export LD_LIBRARY_PATH PATH LC_COLLATE
+ export JAVA_HOME CLASSPATH SERVER_ABBREV JDBC_HOME
+ export ORACLE_BASE
+ export ORA_CRS_HOME
NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
+ export NLS_LANG
USER=TULLETT
LDBAPSWD=/ldba/mhf0362/bin/.ldbapswd
LDBAPSWD=/ldba/mhf0362/bin/.ldbapswd.sprefuat1
+ awk {print $2}
+ grep -w SYSTEM /ldba/mhf0362/bin/.ldbapswd.sprefuat1
PASSWORD=tun1ng
+ expdp SYSTEM/tun1ng DIRECTORY=DUMP_EXADATA DUMPFILE=expdp_sprefuat1_TULLETT_%U                                                                                        .dmp PARALLEL=4 FILESIZE=4G JOB_NAME=expdp_job_TULLETT SCHEMAS=TULLETT LOGFILE=e                                                                                        xpdp_sprefuat1_TULLETT.log EXCLUDE=STATISTICS

Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 27 February, 2014 10:                                                                                        00:55

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit                                                                                         Production
With the Partitioning, Real Application Clusters, Data Mining and Real Applicati                                                                                        on Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/backup6/expdp_sprefuat1_TULLETT_01.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted w                                                                                        ith correct options
Additional information: 2


+ exit 0
^C
[1]    Done                 expdp_sch.sh TULLETT

Open in new window


**Formatting added by Netminder 2 Mar 2014**
0
Comment
Question by:thomasliju
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39892163
>>ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

This is the important message.

Here is the error code:
http://ora-27054.ora-code.com/
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 40121510
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the dā€¦
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question