Run DB scripts in background mode - Oracle 19c
To execute Oracle Database queries in the background, allowing the process to persist even if the Linux server console is closed or the user logs out, use the following command: nohup sqlplus -S username/’password’@service_name @script_name.sql > log_file. log 2>&1 & Output: The query execution details will be logged in log_file.log for review. You can monitor the process in real-time by using the following command: tail -f log_file.log