Skip to main content
Solved

Migration Job Failing

  • December 12, 2024
  • 2 replies
  • 61 views
AshenR
Hero (Partner)
Forum|alt.badge.img+9
  • AshenR
  • Hero (Partner)
  • 100 replies

Hi All, I'm currently attempting to run a migration job in a Linux-based environment. As part of this process, I have created an FTP location on a separate file share server, mounted that path to the Linux database server, and assigned ownership to the Oracle user.

However, when executing the migration job, I encounter the following error:

 

 

Has anyone here performed a similar procedure for a migration job? I'd like to confirm whether I might have missed anything. Additionally, are there any limitations, such as requiring the configuration file path to reside on the Oracle Linux server itself?

Best answer by AshenR

The issue was with the Oracle directory path. I mounted the shared file server path for the Oracle Linux database as master_control and gtc_ftp, and then created the directory paths accordingly.

 

CREATE OR REPLACE DIRECTORY MC_OUTBOUND AS '/master_control/MC_OUTBOUND';
CREATE OR REPLACE DIRECTORY MC_RESPONSE AS '/master_control/RESPONSE';
CREATE OR REPLACE DIRECTORY GTC_INBOUND AS '/gtc_ftp/GTC_INBOUND';
CREATE OR REPLACE DIRECTORY GTC_OUTBOUND AS '/gtc_ftp/GTC_OUTBOUND';

View original
Thanks and Best Regards, Ashen - https://www.linkedin.com/in/ashen-ranaweera-49562b30/
Did this topic help you find an answer to your question?

2 replies

AshenR
Hero (Partner)
Forum|alt.badge.img+9
  • AshenR
  • Author
  • Hero (Partner)
  • 100 replies
  • December 15, 2024

Issue is resolved. 

Thanks and Best Regards, Ashen - https://www.linkedin.com/in/ashen-ranaweera-49562b30/
AshenR
Hero (Partner)
Forum|alt.badge.img+9
  • AshenR
  • Author
  • Hero (Partner)
  • 100 replies
  • Answer
  • December 20, 2024

The issue was with the Oracle directory path. I mounted the shared file server path for the Oracle Linux database as master_control and gtc_ftp, and then created the directory paths accordingly.

 

CREATE OR REPLACE DIRECTORY MC_OUTBOUND AS '/master_control/MC_OUTBOUND';
CREATE OR REPLACE DIRECTORY MC_RESPONSE AS '/master_control/RESPONSE';
CREATE OR REPLACE DIRECTORY GTC_INBOUND AS '/gtc_ftp/GTC_INBOUND';
CREATE OR REPLACE DIRECTORY GTC_OUTBOUND AS '/gtc_ftp/GTC_OUTBOUND';

Thanks and Best Regards, Ashen - https://www.linkedin.com/in/ashen-ranaweera-49562b30/

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings