Category Archives: Installs

Windows Server 2008 R2 Firewall for SQL Server and FTP

Posted on 23 December 2010 by Andrew Fraser

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

Posted on 25 October 2010 by Andrew Fraser

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

Posted on 17 June 2010 by Andrew Fraser

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

Fix for Oracle XE 1608: unable to create InstallDriver instance, return code -2147221164

Posted on 8 March 2010 by Andrew Fraser

I got this annoying error when attempting to install Oracle XE: 1608: unable to create InstallDriver instance, return code -2147221164 The fix for this on my PC was: Identify your TEMP folder – choose start -> run -> type “cmd”, … Continue reading →

Posted in Installs | 6 Comments

Oracle Installer on Windows crashes without adequate TEMP space

Posted on 13 March 2009 by Andrew Fraser

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

Posted on 13 March 2009 by Andrew Fraser

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 | 2 Comments

Free X windows emulator for running Oracle Installer

Posted on 19 April 2007 by Andrew Fraser

It’s often a pain getting X windows GUIs like the Oracle Installer and DBCA to run on Micrsoft Windows PC clients. Emulators like Reflection-X, KEA-Term, and Exceed work ok, but they cost money to licence and require source media and … Continue reading →

Posted in Installs, Linux | 7 Comments

Silent installer on unix still needs X windows until 10g

Posted on 2 February 2007 by Andrew Fraser

It’s not always easy to get X windows properly, or to get hold of X windows emulator software for Windows PCs. So it was a bit of a step backwards when the installer moved away from the ugly but effective … Continue reading →

Posted in Installs | Leave a comment

Old c compilers needed for 9i on Red Hat Linux

Posted on 12 January 2007 by Andrew Fraser

9i on Red Hat Linux (with the exception apparently 32-bit on RH3) won’t install unless you revert the c compilers back to old versions. Horrible. But fixed (I am told) with oracle 10g. And its not something you necessarily want … Continue reading →

Posted in Installs, Linux, Old | Leave a comment

9i unix startup / shutdown with listener password

Posted on 11 January 2007 by Andrew Fraser

Thanks to Laurent Schneider for tips on how to handle listener passwords in scripts. [Update 12-Jan-2007 - ammended script following Laurent's comment, and update 09-Feb-2007 - ammended script following Kevin's comment] A system startup/shutdown shell script I just used that … Continue reading →

Posted in Installs, Scripts, SQL*Net | 6 Comments