Installing the Oracle Instant Client will save you ~600 megabyes compared to the ‘full’ Oracle Client.
- Read some basic info here…
- Download Basic Package for Oracle site
- Unzip to directory x (your ORACLE_HOME)
- Set PATH (Windows) or LD_LIBRARY_PATH (*nix) to the Instant Client directory x
- Move TNSNAMES.ora to directory x/network/admin (or set TNS_ADMIN and ORACLE_HOME).
- Extend with SQL*Plus Package from (optional)
- Start your application
Read my full article here: Whiteblog – Installing the Oracle Instant Client. (links in referred blog might not work!)
OLE DB, .NET and ASP.NET drivers are not included in the instant client (first Oracle link might suggest it is). These are included in the ODAC package, download them separately at these locations:
Instant Client vs Full Client (Administrator and Runtime)
What Are The Different Oracle Client Components Installed With Different Installation Type In (too much to sum up):
Client mater note
Master Note For Oracle Database Client Installation (Doc ID 1157463.1)
Checked for relevance on 7 March 2016.
Have a look at my Whitehorses Blog where I will explain in more detail.
Final conclusion (on one line):
CustomLog "|<midtier>\Apache\Apache\bin\rotatelogs logs\ssl_request_log 43200" "%t %... %b"
They have finally arrived, the Windows 64 and 32 bit versions of Oracle 11gR2.
Download Oracle Database 11g Release 2 for Windows
The 64 bit version was released a bit earlier, so I was hoping the 32 bit version would not come… Why do we want the 32 bit versions? Older systems? Ancient systems! Why…?!
Now I don’t have an excuse to update my almost 10 years old Windows XP OS (running on 64bit hardware) to a much nicer Windows 7 64 bit. The only excuse now is that I could use 600+ megs of memory… enough to run that XP OS virtually!
When having multiple Oracle homes on Windows, how is decided which Oracle home (in the registry) is used by an Oracle binary? Which NLS_LANG or TNS_ADMIN setting from the registry is used?
The answer is binary, path, oracle.key, registry… and which for Windows. Continue reading
Ever want to set or remove Windows environment variables permanently within a command file, so you can use it in other command sessions? Use setx en reg !
When getting the following message using JInitiator: “Unable to verify the certificate – code will be treated as unsigned.”, please check “Control Panel > JInitiator > Cache”, to which location Java will store the ‘Oracle Jar Cache’ and JInitiator settings (like the ‘Grant Always’ setting and ‘Oracle Jar Cache’ directory) in <USERHOME>\.jinit\properties<jinit version> and jpicerts<jinit version>.
Java will get the USERHOME path from the Windows registry [HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders\Desktop] when looking for the Desktop path setting and truncates the ‘Desktop’ part. Most of the time this will result in the correct USERHOME directory, but when this setting is changed to a network path where users are not granted write access, Java is not able to store the Cache and JInitiator settings.
Ofcourse, this can be one of a few problems, but if you suspect a case like this, there might be a solution… Continue reading
Did you notice that when you install Windows Desktop Search, it replaces the Search Companion in the Windows Explorer? Probably you did…
If you want to change this back, for whatever reason, change the following registry entries:
Just for you:
[HKCU\Software\Microsoft\Windows Desktop Search\DS]
For all users:
[HKLM\SOFTWARE\Microsoft\Windows Desktop Search\DS]