Home » RDBMS Server » Server Utilities » Oracle Directory and Datapump (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit,PL/SQL Release 10.2.0.3.0 ,CORE 10.2.0.3.0, TNS for Solaris: Version 10.2.0.3.0, NLSRTL Version 10.2.0.3.0)
Oracle Directory and Datapump [message #449779] Wed, 31 March 2010 19:12 Go to next message
sam5127
Messages: 17
Registered: April 2007
Junior Member
We have three instances on the RAC, When I create a directory is there a default instance that it gets created on?

When I execute an datapump export on instance 1, it works but on 2 and 3 it fails with error relating to directory.

Error -
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation


Is my only option is to use shared storage space?

Thanks
Sam
Re: Oracle Directory and Datapump [message #449780 is a reply to message #449779] Wed, 31 March 2010 19:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is my only option is to use shared storage space?
NO.
invoke expdp only from instance where DIRECTORY exists; otherwise errors result.
Re: Oracle Directory and Datapump [message #449781 is a reply to message #449779] Wed, 31 March 2010 19:39 Go to previous messageGo to next message
sam5127
Messages: 17
Registered: April 2007
Junior Member
Thank you for the quick reply.

The export job is run from a ksh which is kicked off from control-M, we have a virtual path that the control-m looks to see if the instance is down and automatically connects to a different instance.

Any other possible soution?

Is there any way that I can find out on which instance the directory got created? Other than test running the export job.

Thanks,
Sam

[Updated on: Wed, 31 March 2010 19:43]

Report message to a moderator

Re: Oracle Directory and Datapump [message #449782 is a reply to message #449781] Wed, 31 March 2010 19:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
query DBA_DIRECTORIES then match DIRECTORY_PATH content with existing OS file/directory structure
Re: Oracle Directory and Datapump [message #449783 is a reply to message #449779] Wed, 31 March 2010 19:57 Go to previous messageGo to next message
sam5127
Messages: 17
Registered: April 2007
Junior Member
Sorry about the confusion, let me re-phrase my question -

Is there anyway I can query in sqlplus to find on what instance the directory is on (To figure it out at runtime from the ksh script)


Sam
Re: Oracle Directory and Datapump [message #449784 is a reply to message #449783] Wed, 31 March 2010 20:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Sorry about the confusion, let me re-phrase my question -
What are you confused about?

>Is there anyway I can query in sqlplus to find on what instance the directory is on (To figure it out at runtime from the ksh script)

You need to clarify about exactly you are asking.
One problem is the word "DIRECTORY"; which must exist both at the DB level & at the filesystem/OS level.

Within a RAC DBA_DIRECTORIES exists for all instances, but the OS directory may only exist for one instance.

Good Luck with any attempt to determine if/where an OS directory exists.

[Updated on: Wed, 31 March 2010 20:41]

Report message to a moderator

Re: Oracle Directory and Datapump [message #454052 is a reply to message #449784] Mon, 03 May 2010 19:52 Go to previous message
sam5127
Messages: 17
Registered: April 2007
Junior Member
Hi Blackswan

Am able to get the directories setup from our DBA in the global shared file system so that I need not worry about the instance on which the datapump job is running.

I got a bit confused as I was using a directory path that is not global in my earlier testing, so the import job running on instance 2 was not able to see the export dump file on instance 1.

Thanks for all the replies/help.

Regards,
Sam
Previous Topic: expdb remap_schema
Next Topic: sql loader how to ignore error due to quotes
Goto Forum:
  


Current Time: Tue Sep 28 21:17:59 CDT 2021