I’m used to working in a UNIX environment and when I was asked to build a database and manage on Windows, I was faced with some new challenges. One of them is searching through the Alert log and without standard UNIX grep I wanted to write something that could perform the same function. Also show … Read more
Write the contents out to a CSV file import sys import cx_Oracle import os def printf (format,*args): sys.stdout.write (format % args) def printException (exception): error, = exception.args printf (“Error code = %s\n”,error.code); printf (“Error message = %s\n”,error.message); username = sys.argv[1] password = sys.argv[2] databaseName = sys.argv[3] new_user = sys.argv[4] new_password = sys.argv[5] print(‘Connecting to ‘ … Read more
How to resolve close waits from the OS Lets look at the close waits and see how many and the offending port. The following will show us the port and IPof the close wait netstat -an |grep -i close tcp 1 0 icudbaup02-priv.xxx.:53494 icudbaup01-priv.xxx.:61020 CLOSE_WAIT tcp 1 0 icudbaup02-priv.xxx.:53447 icudbaup01-priv.xxx.:61020 CLOSE_WAIT tcp 1 0 icudbaup02-priv.xxx.:53451 … Read more