| Oracle Directory and Datapump [message #449779] |
Wed, 31 March 2010 19:12  |
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 #449781 is a reply to message #449779] |
Wed, 31 March 2010 19:39  |
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 #449783 is a reply to message #449779] |
Wed, 31 March 2010 19:57 |
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 |
 |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
