Category Archives: Windows

Replace all tnsnames.ora files with a single master file using TNS_ADMIN

Maintaining large numbers of client tnsnames.ora files is a pain.  Oracle Internet Directory is the recommended solution to this, but it is not an easy exercise to set up or migrate to. An easier alternative is to set TNS_ADMIN in all … Continue reading

Posted in SQL*Net, Windows | Leave a comment

Remote Desktop Connection Manager

Remote Desktop Connection Manager, a free download from http://www.microsoft.com/en-gb/download/details.aspx?id=21101, lets you switch quickly between windows servers, saves the servers and your login details in a list.

Posted in SQL server, Windows | Leave a comment

Windows 2008 Disappearing Printers Trick

Windows Server 2008 and Windows 7 both hide printers that use the same port as another printer. But the printers aren’t really gone, they just take a little more effort to see – details at http://blogs.technet.com/b/askperf/archive/2010/03/02/windows-7-where-are-my-printers.aspx Your friends will be … Continue reading

Posted in Windows | Leave a comment

Windows Server 2008 R2 Firewall for SQL Server and FTP

Windows Server 2008 R2 has a strict firewall by default. It will not let you run FTP (client) from the server and get files from other servers/sites It will also not let you run “SQL Server Management Studio” from your … Continue reading

Posted in Installs, SQL server, Windows | 2 Comments

Windows 2008 remote database connections

Windows Server 2008 by default has a firewall that does not allow remote database connections. Fix is at http://technet.microsoft.com/en-us/library/ms175043.aspx

Posted in Installs, Windows | Leave a comment

Install latest version of Oracle ODBC

To install latest version of Oracle ODBC: Go to http://www.oracle.com/technology/tech/oci/instantclient/ to download: Instant Client Package – Basic Instant Client Package – ODBC Unzip both of them into the same folder (e.g. c:\oracle). Add that folder name into the PATH environment … Continue reading

Posted in Installs, Windows | Leave a comment

Oracle Installer on Windows crashes without adequate TEMP space

Oracle installer on Windows can fail to run, crashing out without a useful error message. I found fix was to change the temp directories in a command window set temp=d:\junk set tmp=d:\junk and then run the installer (setup.exe) from that … Continue reading

Posted in Installs, Windows | Leave a comment

Fix for windows ftp filling up c: drive space

Windows ftp can fill up C: drive. This happens either putting or getting files, even if you try putting/getting them to a drive other than C:. This happens because the ftp file is written to temporary area first by ftp, … Continue reading

Posted in Installs, Windows | 3 Comments

Which PC Memory Module type (SDRAM, DDR, or DDR2) do I need?

Adding more memory to PCs is a cheap and easy upgrade method. But there are different types of PC memory modules available – SDRAM, DDR, DDR2 – and computers are limited to being compatible with one type only. So you … Continue reading

Posted in Windows | Leave a comment