Home » RDBMS Server » Backup & Recovery » Error While backup on Windows 7 Client of Oracle 11gR2 Database (Oracle 11g R2, 11.2.0.1.0, RHEL 5.4)
Error While backup on Windows 7 Client of Oracle 11gR2 Database [message #505297] Mon, 02 May 2011 03:07 Go to next message
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 #505304 is a reply to message #505297] Mon, 02 May 2011 03:37 Go to previous messageGo to next message
Littlefoot
Messages: 21420
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Directory object is created on a database server, not on a client.
Re: Error While backup on Windows 7 Client of Oracle 11gR2 Database [message #505305 is a reply to message #505304] Mon, 02 May 2011 04:18 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Littlefoot

Thanks for prompt reply, but my question is how can i create/add such directory on client node to take export of database. please suggest/provide some script/site for further details.

Regards

Jimit
Re: Error While backup on Windows 7 Client of Oracle 11gR2 Database [message #505308 is a reply to message #505305] Mon, 02 May 2011 05:36 Go to previous messageGo to next message
Michel Cadot
Messages: 65572
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't from Oracle point of view. It must be local.
Try to mount the file system on the local server.

Regards
Michel
Re: Error While backup on Windows 7 Client of Oracle 11gR2 Database [message #505310 is a reply to message #505308] Mon, 02 May 2011 05:50 Go to previous messageGo to next message
Littlefoot
Messages: 21420
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Sorry, I didn't see that the first step you performed (creating a directory) was on a database server. Partially blind, I presume.

Anyway: what operating system do you use on the database server? I tried it here, on my location. Database server is MS Windows Server 2003 SP2. Client (my computer) is MS Windows 7 Enterprise edition. I have 10g XE installed on my PC, so I used its EXPDP utility to export a table from a schema that resides in 10g (10.2.0.1.0) database on the server. It works just fine, no problem at all.

Just wondering: did you paste the WHOLE error stack in your first message? I tried to simulate that error (and managed to do it - simply revoked privileges) and got this:
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name MYDIR is invalid

So - what is YOUR last line?
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 Go to previous messageGo to next message
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 Go to previous message
Littlefoot
Messages: 21420
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.
Previous Topic: RMAN RETENTION PERIOD
Next Topic: how do i apply an level_1 backup to a level_0 backup ?
Goto Forum:
  


Current Time: Mon Jul 23 01:24:42 CDT 2018