Skip to main content
Solved

Migration Job Failing

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

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';

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

2 replies

AshenR
Hero (Partner)
Forum|alt.badge.img+11
  • AshenR
  • Author
  • Hero (Partner)
  • 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+11
  • AshenR
  • Author
  • Hero (Partner)
  • 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/
Terms & ConditionsCookie settingsAccessibility statement