Last post Aug 27, 2011 10:48 PM by Lannie
Jul 26, 2011 10:12 AM|pinky8|LINK
I install Oracle Database 18.104.22.168.0 64bit and Oracle Client 32bit on a new laptop that runs Windows 7 64bit operating system. The reason I need Oracle Client 32bit instead of 64bit is because I think PL/SQL Developer version 8 32bit will only work with
Oracle Client 32bit. It would be nice to be able to use Oracle Database 32bit as well, but I was told that it would not run on a 64bit operating system. Do I need to install anything else such as ODAC or the installation of Oracle Database already covers it?
I will also install Visual Studio 2010 on the laptop. If I have to install ODAC separately, I see these links from OTN and do not know which version I should download and install to be compatible with what I have. The links are:
Jul 28, 2011 12:06 PM|Lannie|LINK
I have Oracle 11g 201 64-bit in one Oracle Home running on static IP using Microsoft Loopback Adapter as per Windows Install Guide Oracle.
I have Oracle 11g 201 32-bit client in another Oracle Home installed from the ODAC Client Install.
I have VS 2010 mixed 64 and 32 bit app development.
I have Oracle SQL Developer and TOAD running as 32-bit applications.
OS is WIndows 7 64-bit.
All is well.
Jul 29, 2011 10:02 AM|pinky8|LINK
Did you install Oracle Database 11g 201 64-bit in ORACLE_HOME_1 (for example), and then install Oracle 11g 201 32-bit client in ORACLE_HOME_2 in that order? After that I guess you installed VS 2010?
Do you have URL for downloading the ODAC Client Install? I want to be sure I download the correct one.
Jul 29, 2011 11:11 AM|Lannie|LINK
I installed the database first (11g 64-bit) on a static IP with MS Loopback adapter, Visual Studio 2010, 32-bit ODP.NET Client install in another Oracle Home, then TOAD and Oracle SQL Developer.
I avoid Oracle Visual Studio tools, which I find too buggy to use, so I use SQL prompt, TOAD or SQL Developer, and Oracle database control to manage database objects.
All my apps config string use the TNSNAMES.ORA for the database, both 32-bit and 64-bit, and ODP.NET seems to figure out which client to use.
Each download of 32-bit ODP.NET contains the option for Database install (which is really an upgrade of ODP.NET) or Client install on setup installation configuration.
(Of course, if I want to upgrade ODP.NET for my database, I would use the 64-bit ODP,NET Database install to upgrade the files in database home and the 64-bit GAC.)
I usually stick with the version of ODP.NET that comes with the database version, instead of getting messed up with ODP.NET upgrades, etc. Too many headaches for me.)
For selection of the correct version of ODAC, go find OracleDataAccess.dll in your database home odp.net folder, right click and get version number.
Oracle is better about making newer versions of ODAC retroactively compatible with prior versions. However, to make my apps more portable, I put my version of ODAC directly into the application BIN folder and make a local reference for it. I just seem
to have less troubles moving to PRODUCTION doing it that way.
The main mistake folks make is installing more than one 32-bit client version on the same machine.
Uninstall the old one first if you are moving to newer version of ODP.NET and then do the CLIENT install.
Aug 17, 2011 05:59 PM|pinky8|LINK
Thanks for the info. Did you install IIS and .Net Framework? What version of IIS? And what was the order of installation for them and Visual Studio 2010, Oracle database and client?
When you install IIS on Windows 7, did you check the entire Web Management Tools or just the IIS Management Console? If IIS 6 Management Compatibility is installed, does it mean IIS6 Management Console is installed? If yes, will there be a conflict if you have
both IIS6 and IIS7.5 Management Console?
How come it doesn't create wwwroot folder after IIS is installed? That folder is needed to add a new website in IIS.
Aug 18, 2011 11:03 PM|Lannie|LINK
.NET framework all patches all versions
IIS 70 with IIS Mgt Console only
IIS70 creates default website in INET directory, which contains the default wwwroot.
But I create my own IISAPP directory for one or more web applications websites, create my own app pool(s), and disable default app pools and web sites.
The quirky thing is some web functions work in Visual Studio web environment and then fail in IIS hosted web environment,
so MS Technet helps with understanding IIS limitations.
Aug 23, 2011 01:42 PM|pinky8|LINK
Windows Updates doesn't show any .NET Framework for me to install on Windows 7 operating system. How can the framework be installed when it's not shown? I remember on Windows XP, the Windows Updates automatically shows .NET Framework 2.0, 3.5, and 4.0 for
me to select for installation.
Aug 23, 2011 04:09 PM|Lannie|LINK
Look in C:\Windows\Microsoft.NET\Framework
and you should see all the installed versions of .NET 1, 1.1, 2.0, 4, 3.5, and v4.0.30319
I suspect you may have missed some updates with Windows 7 propensity suddenly announce update installs while you are shutting down..no warning. Dang Annoyance at times.
Also, manually run Windows Update from IE Tools Windows Update, and you be surprised what it finds.
Aug 23, 2011 05:32 PM|pinky8|LINK
I see subfolders for 1, 1.1, 2.0, 3, 3.5 in C:\Windows\Microsoft.NET\Framework folder. There is no v4.0. I run Windows Update from IE Tools Windows Update and see an optional update: "Miscrosoft .NET Framework 4 Client Profile for Windows 7 x64-based Systems".
Is that the v4.0.30319 you mentioned? Should I install that optional update?
It's strange that I don't see any framework when I View Update History.
Aug 23, 2011 08:32 PM|Lannie|LINK
I would go to Microsoft Downloads and get the .NET 4.0 installer, then run Windows update over and over until you have all the patches
Aug 23, 2011 08:36 PM|Lannie|LINK
http://www.microsoft.com/download/en/confirmation.aspx?id=17718 full standalone install for development
Aug 24, 2011 12:27 PM|pinky8|LINK
What's the difference between the download from
http://www.microsoft.com/net and the full standalone install for development?
Aug 24, 2011 01:45 PM|Lannie|LINK
Not much from what I have seen.
But I do carry the standalone installer around with me to update client workstations.
Aug 24, 2011 02:36 PM|pinky8|LINK
Windows Update had .NET Framework 4 Client Profile as an optional update. After installing that update, Windows Update gives 2 more Updates for .Net framework 4. I installed them all.
Now Windows\Microsoft .Net folder has Framework and Framework64 folders. Framework folder has from v1.0 to 4.0 while Framework64 folder has from v2.0 to 4.0. I guess that means my machine already has framework 4.0 installed, correct? And Framework folder
is for 32bit? Not sure why it needs both 32bit and 64bit when my O.S. is 64bit.
Aug 25, 2011 06:55 PM|pinky8|LINK
Any comments please?
Aug 25, 2011 10:53 PM|Lannie|LINK
Your OS might be 64-bit
but Visual Studio is 32-bit
and you can compile both 32-bit and 64-bit apps
you need both
Aug 26, 2011 08:00 AM|pinky8|LINK
I install IIS Mgt Console only and it creates an empty inetpub folder. When I go into IIS and try to expand Default Web Site it pops up an error: Could not find a part of the path 'C:\inetpub\wwwroot'. How can that be fixed?
In windows XP when it installs IIS it creates inetpub folder and wwwroot subfolder. But why doesn't windows 7 do the same? Windows 7 doesn't create wwwroot subfolder.
Aug 27, 2011 10:48 PM|Lannie|LINK
I disable the default website and application pool (STOP command).
Create your own Directory like C:\MYIIS
then inside that you can add a folder for each website (one or more).
then create your own application pool
then create new website linked to the physical folder
assign the application pool to the web site.
You will have to learn some of the basics of web site configuration in IIS.
Many problems with IIS set up are traceable to PERMISSIONS PERMISSIONS PERMISSIONS.
IIS 7 in Windows 7 does not create same default folder schema as IIS 6 in XP.
Do some reading on IIS7. Most of what I know I picked up in this cheap pocket book.
For development, you can assign your website the static IP of your LAN card and a free port like 7780.
(turn off Auto IP and Auto DNS and use Static)