Skip to main content
Solved

Migration Job Failing

  • Dec 12, 2024 12:21 PM UTC
  • 2 replies
  • 140 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';

View original
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)
  • Dec 15, 2024 3:39 AM UTC

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
  • Dec 20, 2024 11:15 AM UTC

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 & ConditionsAccessibility statement