I used the steps below to apply patchset 11.2.0.3 to an existing 11.2.0.2 2-node RAC cluster on linux RHEL 5.8 64 bit. Note that GRID_HOME and DB_HOME locations will both be changed as part of this patchset. 0) Download and unzip software from My Oracle Support into e.g. /unzipped Main patch is 7 large zipfiles, […]
Read More Patch upgrade Oracle RAC 11.2.0.2 to 11.2.0.3 on linuxWindows 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 ODBCI 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”, then type “set temp” in the command window. Navigate to this folder in windows. It […]
Read More Fix for Oracle XE 1608: unable to create InstallDriver instance, return code -2147221164Oracle 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 spaceIt’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 local admin rights to install. Those things can take an age to organise in large […]
Read More Free X windows emulator for running Oracle InstallerIt’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 clunky text display that it had in version 7 and below. Running the installer in […]
Read More Silent installer on unix still needs X windows until 10g9i 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 to do just for the install – because future patchsets and even some one off […]
Read More Old c compilers needed for 9i on Red Hat Linux