Solved

export schema

Posted on 2014-02-27
2
609 Views
Last Modified: 2014-03-05
I ran the script  
below..

what is happening when script is done?

There are about 40 applicaiton schema..
we need to export all...
I order to export application schema

what we do next?

nj09mhf0362[oracle:sprefuat1] 46: sh /ldba/10gR2_migration_to_exadata/expdp_sch.sh*
+ . /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/openwin/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/SUNWspro/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
USER=
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_EXADATA1 DUMPFILE=expdp_sprefuat1__%U.dmp PARALLEL=4 FILESIZE=4G JOB_NAME=expdp_job_ SCHEMAS= LOGFILE=expdp_sprefuat1_.log EXCLUDE=STATISTICS
LRM-00116: syntax error at 'LOGFILE' following '='

+ exit 0

Open in new window


**Formatting added by Netminder 2 Mar 2014**
0
Comment
Question by:thomasliju
2 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39892546
>>what is happening when script is done?

There is an error.

Pay attention to this line:
LRM-00116: syntax error at 'LOGFILE' following '='

From your previous TWO question on this, looks like you are not passing in the USER you want to export.

It needs to be a parameter to the shell script.

Check the syntax in either of your two previous questions.
0
 

Author Closing Comment

by:thomasliju
ID: 39905741
Thanks...
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

791 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