DosTips.com

Dear all, Is there a way to pass multiple param value pairs to a batch file, param_value.bat db_domain="abc.com" log_archive_dest_1="location=R:\app\oracle\oradata\examplecdb" to param_value.bat ""db_domain="abc.com " log_archive_dest_1="location=R:\app\oracle\oradata\examplecdb" "" batch file is su...

thanks a lot,

I solve the problem

I wanted to confirm that if it no possible to do a multiple line if else statement in batch files.

many thanks

if %lower_prefix_log_with_datetime%==yes (SET second_stg_rman_log_trc_prefix=%source_host_db%_%log_datetime%_%partial_rman_script_log_prefix%) else (SET second_stg_rman_log_trc_prefix=%partial_rman_script_log_prefix%_%source_host_db%_%log_datetime%) echo second_stg_rman_log_trc_prefix %second_stg_r...

Dear all, I want to read a number of name=value pairs from the command line, how do I read them and output to a file? C:\Users\myself\read_name_value_pairs.bat log_archive_dest_1="location=R:\app\oracle\oradata\londoncdb" db_name=londoncdb output file temporary hardcoded to temp_pfile.ora db_name=lo...

Dear all, not workable sqlplus sys@localhost/worcl.cambridge.com as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 1 11:19:10 2022 Copyright (c) 1982, 2014, Oracle. All rights reserved. ERROR: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA working sqlplus sys@\"loc...

Dear all, My Objective: run a scheduled task on the local machine as the designed scheduled user, i.e. cambridge in this case SCHTASKS /Run /U rman /P cambridge@123 /TN delete_expired_backup /HRESULT ERROR: Invalid syntax. Cannot specify user name without specifying system name. Type "SCHTASKS /?" f...

Dear all, based on https://stackoverflow.com/questions/5837418/how-do-you-get-the-string-length-in-a-batch-file below is my code to find out string length of a variable called SET trace_log_script_name_prefix=%until_number%_%scn_or_sequence%_%source_host_db%_%log_datetime%_%rman_script_prefix% call ...