Differences

This shows you the differences between two versions of the page.

--- windows_dos [2018/12/06 21:05] – created 91.177.234.129
+++ windows_dos [2019/11/29 19:55] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Windows/DOS ======
+==== Activate MS Office 2019/2016 for macOS - Microsoft_Office_2019_VL_Serializer ====
+  * [[https://gist.github.com/zthxxx/9ddc171d00df98cbf8b4b0d8469ce90a]]
+Note that Office2019 DO NOT support activate via simple copy/paste plist license file which is the simplest way to activate Office 2016. Fortunately, you can also use the VL Serializer tool, just install Office 2019 and Serializer, then run Serializer to activate.
+  *  Download Office 2019 Volume License Serializer from [[https://macadmins.software]]
+  *  Run Serialiser tool after installing - but before - opening Office.
-=====Kill processes by image name=====
+==== Kill processes by image name ====
 Have a runaway process with hundreds or thousands of programs (eg: cmd.exe) all running and need to kill them all in one go?
-<code>0@@</code>
+<code>
+taskkill /F /IM cmd.exe
+taskkill /F /IM bash.exe
+</code>
-=====How to force logoff a session on another server=====
+==== How to force logoff a session on another server ====
 **Method 1 with the TSM GUI**
-  * Launch Terminal Services Manager (in Administrative Tools)
+  *  Launch Terminal Services Manager (in Administrative Tools)
-  * In the menu: Actions "Connect to Computer..."
+  *  In the menu: Actions "Connect to Computer..."
-  * Enter name of server you want to get on to
+  *  Enter name of server you want to get on to
-  * Right-click and logoff one of the displayed sessions
+  *  Right-click and logoff one of the displayed sessions
 **Method 2 with Command prompt**
-  * Launch Windows (DOS) box
+  *  Launch Windows (DOS) box
-  * Enter "query session /server:<servername>"
+  *  Enter "query session /server:<servername>"
-  * Enter "logoff <ID> /server:<servername>"
+  *  Enter "logoff <ID> /server:<servername>"
-=====Return the value of a function into a variable in DOS batch .bat file=====
+==== Return the value of a function into a variable in DOS batch .bat file ====
 What an awful language!
-<code>1@@</code>
+<code>
+set NLS_LANG ======
+@echo NLS_LANG has been cleared
+@FOR /F "usebackq delims=!" %%i IN (`sqlplus -s /nolog @set_NLS_LANG.sql`) DO @set NLS_LANG=%%i
+@echo NLS_LANG has been set to %NLS_LANG%
+</code>
-=====Create a Scheduled Task from the command line=====
+==== Create a Scheduled Task from the command line ====
-This one is particularly interesting as I need to start a shell Cygwin shell script on a regular basis<br />
+This one is particularly interesting as I need to start a shell Cygwin shell script on a regular basis\\
-As crontab is not implemented by default, I use the Windows Scheduler to start the jobs.<br />
+As crontab is not implemented by default, I use the Windows Scheduler to start the jobs.\\
-This one creates a task called dbamon_dblist tat runs a shell every 10 minutes starting at 9 am and going on for 24 hours (so, forever).<br />
+This one creates a task called dbamon_dblist tat runs a shell every 10 minutes starting at 9 am and going on for 24 hours (so, forever).\\
 It is run a user different from the logged on user. The echo at the start is to answer N to the question "Task exists, do you want to replace it". For some reason that doesnt work too well :(
-<code>2@@</code>
+<code>
-=====Scheduled Task seems to do nothing. Runs but stops immediately=====
+echo N|SCHTASKS /Create /SC MINUTE /MO 10 /TN dbamon_dblist /TR "c:\\cygwin\\bin\\bash.exe -l -c /cygdrive/c/home/ibmtools/scripts/oracle/dbamon_dblist.ksh" /ST 09:00 /RU runasuser /RP runaspwd
-  * Check task scheduler log
+</code>
+==== Scheduled Task seems to do nothing. Runs but stops immediately ====
+  *  Check task scheduler log
 Advanced:View log ...
-<code>3@@</code>
+<code>
-  * Check error code given
+"Backup_archivelog_perl_NETTP_auto.job" (perl)
-<code>4@@</code>
+\tFinished 1/9/2015 1:10:00 PM
-Not very helpful on the part of Microsoft but the 80 error turned out to be a whole load of sqlplus.exe processes (100's) hanging around in the task manager<br />
+\tResult: The task completed with an exit code of (80).
+"dbamon_datapump.job" (bash.exe)
+\tFinished 1/9/2015 1:10:23 PM
+\tResult: The task completed with an exit code of (1).
+</code>
+  *  Check error code given
+<code>
+C:\\ibmtools\\scripts\\oracle\\perl>net helpmsg 80
+The file exists.
+C:\\ibmtools\\scripts\\oracle\\perl>net helpmsg 1
+Incorrect function.
+</code>
+Not very helpful on the part of Microsoft but the 80 error turned out to be a whole load of sqlplus.exe processes (100's) hanging around in the task manager\\
 Killed them and jobs started running again.