Hi @Indu Srinivas Welcome to the Microsoft Q&A platform, thanks for posting the question
I understand You want to know migration tools/services which can use for database migration from ORACLE to MSSQL.
For offline Migration, you can use SSMA, SSIS
for an online, either you can build some custom solution using ADF etc or use 3P data integration tools
you can never have zero downtime. it will be minimal based on the data sync
Regards
Geetha