Copy activity from Oracle to Lakehouse fails without staging

Hi vietng Even if you're choosing a Lakehouse it may still be using the SQL Endpoint behind the scenes, since I'm guessing you're writing in the /Tables area. Trying opening the 1433 port and see if it works. 

Hi vietng, 

One small correction, if you're targeting a lakehouse, it wouldn't be using the SQL endpoint to write data as the sql endpoint is read only, but deborshi_nag is correct that it might still be using the SQL ports to do the data movement.  

I always recommend opening all the ports found on this page when doing gateway maintenance: 
Adjust communication settings for the on-premises data gateway | Microsoft Learn