Sponsored Content
Special Forums UNIX and Linux Applications Problem in import & expdp Dump file Post 302938098 by clerck on Thursday 12th of March 2015 03:53:34 AM
Old 03-12-2015
Problem in import & expdp Dump file

Hi all,
i face a problem on (oracle database) installed on server Linux i need to export back as dump file, when i try to export give me the below error.

[root@srv1 mohamed]# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y



Export: Release 11.2.0.1.0 - Production on Thu Mar 12 09:27:09 2015

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation


the steps i had made on SQLpluse:

1-CREATE DIRECTORY test AS '/u01/backup/testdump';

GRANT read, write ON DIRECTORY test to system;
 

10 More Discussions You Might Find Interesting

1. SCO

XML Import & HTTP Post

this may be very basic to some but all new to me I have an application running on SCO Unix server which issues an HTTP Post request to a server with the results being returned in I.E browser window in XML format I need to import these results into my customers application and dont know how to... (1 Reply)
Discussion started by: ccarcher
1 Replies

2. Web Development

Confused maybe about MySQL Dump & PHP

Hello. the purpose of my efforts right now are to get a larger script of mine (which the admin told me he'd put into cron for me) to properly back-up my MySQL database. To test out the sql back-up part (before getting the whole script into cron, and having it not work) I wanted to test it. So... (12 Replies)
Discussion started by: jzacsh
12 Replies

3. Programming

Java import problem

In a default package, there are BankTest.java and package bank wich contains Account.class . // File: BankTest.java import bank.*; public class BankTest { public static void main(String args) { Account account; ... } } Trying to compile BankTest.java,... (0 Replies)
Discussion started by: Luke Bonham
0 Replies

4. Shell Programming and Scripting

Mysql import problem

Dear folks, i am importing a database since yesterday that is innodb tablespace, the space of dump file is 4GB, almost 24 pass out it is not yet complete. What should i do to import it fastly. I have disable foreign key check because it have some issues so thats why i am importing it with source... (2 Replies)
Discussion started by: learnbash
2 Replies

5. UNIX for Dummies Questions & Answers

Import dump to database

Hi... I have dump in unix machine...How can I this import dump to Oracle database? Many thanks in advance. (2 Replies)
Discussion started by: agarwal
2 Replies

6. Shell Programming and Scripting

Zip dump file using expdp:

Hi All, i am using expdp to create a dump file of contents from an oracle table. I want this dump file to be zipped. Is there a way/ option in expdp where the dump file will be automatically zipped when its been created. If not please suggest other methods. (8 Replies)
Discussion started by: qwertyu
8 Replies

7. UNIX for Dummies Questions & Answers

How to Import dump file with default value for single column?

Hi, I need to import more than 250K of records to another Database(Oracle).But I want particular column value to be changed in the destination table. Is it possible to do this during export or import process with out modifying data from original table.I do not want to run Update manually. ... (6 Replies)
Discussion started by: GOVINDARAJ.M
6 Replies

8. UNIX for Dummies Questions & Answers

How can I import a particular schema from full dump in Oracle?

Hi All, I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump. Is that possible in oracle. What will be the command for that? (6 Replies)
Discussion started by: Palak Sharma
6 Replies

9. UNIX and Linux Applications

How to import and dump file to remote Oracle server?

Hi All, I have a linux centos instance which has a dump file. I need to import the dump file to the oracle server which is located at some remote location. I have installed the oracle client on my machine and I am able to connect to the remote oracle server. Now how to import the dump to the... (3 Replies)
Discussion started by: Palak Sharma
3 Replies

10. Homework & Coursework Questions

Oracle dump file (del format) import into db2

1. The problem statement, all variables and given/known data: are the oracle dump files compatible to direct import into db2? I already tried many times but it always truncated results. anyone can help/ advice or suggest? 2. Relevant commands, code, scripts, algorithms: exp... (3 Replies)
Discussion started by: Sonny_103024
3 Replies
OCF_HEARTBEAT_SAPDAT(7) 					OCF resource agents					   OCF_HEARTBEAT_SAPDAT(7)

NAME
ocf_heartbeat_SAPDatabase - Manages any SAP database (based on Oracle, MaxDB, or DB2) SYNOPSIS
SAPDatabase [start | stop | status | monitor | meta-data | validate-all] DESCRIPTION
Resource script for SAP databases. It manages a SAP database of any type as an HA resource. SUPPORTED PARAMETERS
SID The unique SAP system identifier. e.g. P01 (unique, required, string, no default) DIR_EXECUTABLE The full qualified path where to find sapstartsrv and sapcontrol. (unique, optional, string, no default) DBTYPE The name of the database vendor you use. Set either: ORA,DB6,ADA (unique, required, string, no default) NETSERVICENAME The Oracle TNS listener name. (unique, optional, string, no default) DBJ2EE_ONLY If you do not have a ABAP stack installed in the SAP database, set this to TRUE (unique, optional, boolean, default false) JAVA_HOME This is only needed if the DBJ2EE_ONLY parameter is set to true. Enter the path to the Java SDK which is used by the SAP WebAS Java (unique, optional, string, no default) STRICT_MONITORING This controls how the resource agent monitors the database. If set to true, it will use SAP tools to test the connect to the database. Do not use with Oracle, because it will result in unwanted failovers in case of an archiver stuck (unique, optional, boolean, default false) AUTOMATIC_RECOVER The SAPDatabase resource agent tries to recover a failed start attempt automatically one time. This is done by running a forced abort of the RDBMS and/or executing recovery commands. (unique, optional, boolean, default false) DIR_BOOTSTRAP The full qualified path where to find the J2EE instance bootstrap directory. e.g. /usr/sap/P01/J00/j2ee/cluster/bootstrap (unique, optional, string, no default) DIR_SECSTORE The full qualified path where to find the J2EE security store directory. e.g. /usr/sap/P01/SYS/global/security/lib/tools (unique, optional, string, no default) DB_JARS The full qualified filename of the jdbc driver for the database connection test. It will be automatically read from the bootstrap.properties file in Java engine 6.40 and 7.00. For Java engine 7.10 and higher the parameter is mandatory. (unique, optional, string, no default) PRE_START_USEREXIT The full qualified path where to find a script or program which should be executed before this resource gets started. (unique, optional, string, no default) POST_START_USEREXIT The full qualified path where to find a script or program which should be executed after this resource got started. (unique, optional, string, no default) PRE_STOP_USEREXIT The full qualified path where to find a script or program which should be executed before this resource gets stopped. (unique, optional, string, no default) POST_STOP_USEREXIT The full qualified path where to find a script or program which should be executed after this resource got stopped. (unique, optional, string, no default) SUPPORTED ACTIONS
This resource agent supports the following actions (operations): start Starts the resource. Suggested minimum timeout: 1800. stop Stops the resource. Suggested minimum timeout: 1800. status Performs a status check. Suggested minimum timeout: 60. monitor Performs a detailed status check. Suggested minimum timeout: 60. Suggested interval: 120. validate-all Performs a validation of the resource configuration. Suggested minimum timeout: 5. meta-data Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5. methods Suggested minimum timeout: 5. EXAMPLE
The following is an example configuration for a SAPDatabase resource using the crm(8) shell: primitive p_SAPDatabase ocf:heartbeat:SAPDatabase params SID=string DBTYPE=string op monitor depth="0" timeout="60" interval="120" SEE ALSO
http://www.linux-ha.org/wiki/SAPDatabase_(resource_agent) AUTHOR
Linux-HA contributors (see the resource agent source for information about individual authors) resource-agents UNKNOWN 03/09/2014 OCF_HEARTBEAT_SAPDAT(7)
All times are GMT -4. The time now is 12:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy