Thanks for your post, was having that issue and your post was my first hit.
My databases are on windows and there is no patch, and sending stin to null is not an option, so I found that:
echo “ “ | expdp scott/tiger@ora19 …..
Will work just fine as it will auto input the…
Just tried this on Windows and found out mkstore.bat is botched and will fail when passing “?” character in argument.
Fix: Change line below these
rem If any of the args is equal to “-fips140_mode” then assume FIPS 140 mode.
Thanks for the updated workbook!
Another install variant convenient for Debian-flavours is to use the Instant Client Zips. This removes the need for alien, but you still need libaio1. And you need to run ldconfig or set LD_LIBRARY_PATH, unlike for the RPMs. Wallet files can be put in the (precreated) network/admin…
With Instant Client you shouldn’t set ORACLE_HOME. I think you have set this to get your wallet files read? If you had put those files in the default location ‘/usr/lib/oracle/19.3/client64/lib/network/admin’ (note the extra ‘/lib/’) then you wouldn’t have needed to set the variable. The ‘network/admin’ directory is pre-created ready for use…
i just started looking into Docker to facilitate automated testing of an application backed by Oracle. Possibly I should explore other options? How do you run automated tests for applications which depend on state of an Oracle database/schema?
I’m thinking to build the write trigger to a logical data guard, as for our reporting system, while the master cluster is for main application. But I’m not sure if the trigger will reduce the performance of dats sync? what do you guys think?