Error While backup on Windows 7 Client of Oracle 11gR2 Database [message #505297] |
Mon, 02 May 2011 03:07 |
jimit_shaili
Messages: 237 Registered: June 2006 Location: India, Ahmedabad
|
Senior Member |
|
|
Dear Friends
I have facing problem while taking backup on Windows 7 client of Oracle 11g R2 database. I have installed oracle 11gR2 for windows on windows 7 machine. I have created a directory like below in database.
On Database Server
SQL> create directory win_expdp_dir as 'd:\expimp';
Directory created.
SQL> grant read, write on directory win_expdp_dir to lab;
Grant succeeded.
On Windows 7 machine (client machine)
D:\app\product\11.2.0\client_1\BIN>expdp lab/lab@wbdata.wbh-db11g DIRECTORY=win_expdp_dir DUMPFILE=lab.dmp LOGFILE=lab.log
Export: Release 11.2.0.1.0 - Production on Mon May 2 12:51:44 2011
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 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
I have give all sharing rights on d:\expimp directory. My main question is why i'm getting this error. Is there any thing missing in setup. Please suggest me the way how to take export on windows 7 client.
Regards
Jimit
|
|
|
|
|
|
|
Re: Error While backup on Windows 7 Client of Oracle 11gR2 Database [message #505312 is a reply to message #505310] |
Mon, 02 May 2011 06:02 |
jimit_shaili
Messages: 237 Registered: June 2006 Location: India, Ahmedabad
|
Senior Member |
|
|
Dear Littlefoot
I have created directory on database server , which is on RHEL 5.4 OS. Here giving whole error stack (which is received on windows 7 machine). I have installed oracle 11g R2 on windows machine with administrative control option.
D:\app\product\11.2.0\client_1\BIN>expdp lab/lab@wbdata.wbh-db11g DIRECTORY=win_expdp_dir DUMPFILE=lab.dmp LOGFILE=lab.log
Export: Release 11.2.0.1.0 - Production on Mon May 2 16:27:32 2011
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 - Produc
tion
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
Regards
Jimit
|
|
|
Re: Error While backup on Windows 7 Client of Oracle 11gR2 Database [message #505313 is a reply to message #505312] |
Mon, 02 May 2011 06:18 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
RHEL is "Redhat Linux", right? It is UNIX-ish operating system. You created a directory (database object) that points to (physically created operating system directory called) "d:\expimp" which sounds Windows-ish.
Are you sure you did that correctly?
First of all: directory MUST EXIST on a database server. Oracle's CREATE DIRECTORY command does not create a directory (file system directory; you can't see it with the DIR command, for example, or Windows Explorer or whatever tool Linux uses), it just creates a database object called "directory" that points to an operating system directory. So: does this ("EXPIMP") directory exist there?
If it exists, and Oracle database object "directory" points to it, make sure that Oracle user (on a database server) has privileges to access it (on an operating system level). I don't know how it is done on Linux, so I can't assist much.
|
|
|