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 client PCs to use a single common tnsnames.ora file set TNS_ADMIN=\\network\share\path All the client PCs […]
Read More Replace all tnsnames.ora files with a single master file using TNS_ADMINRemote 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.
Read More Remote Desktop Connection ManagerWindows 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 amazed.
Read More Windows 2008 Disappearing Printers TrickWindows 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 PC and connect that into the instance running on the server. To fix this, apply […]
Read More Windows Server 2008 R2 Firewall for SQL Server and FTPWindows 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
Read More Windows 2008 remote database connectionsTo 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 variable (right click my computer, manage, system properties, advanced tab, environment variables) Create a new […]
Read More Install latest version of Oracle ODBCOracle 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 same command window. TEMP was set to use c:\documents and settings before, and the installer […]
Read More Oracle Installer on Windows crashes without adequate TEMP spaceWindows 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, and moved to the final location at the very end. The solution is to set […]
Read More Fix for windows ftp filling up c: drive spaceAdding 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 have to know which type you want before buying, especially if buying online. 1) To […]
Read More Which PC Memory Module type (SDRAM, DDR, or DDR2) do I need?