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
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT DEBIAN
ocf_heartbeat_sapdatabase
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)