Igor Neyman, OCP DBAineyman@perceptron.com-Original Message-From:oracle-l-bounce@freelists.org mailto:oracle-l-bounce@freelists.org On Behalf Of Jared.Still@radisys.comSent: Thursday, February 26, 20041:18 PMTo: oracle-l@freelists.orgSubject: NEWS Oracle Database9ir2 Interval Conversion Buffer OverflowHas anyone here heard of this?FirstI've seen it.
How To Install Oracle Instant Client
We are upgrading our databases from 9iR2 to 11g.1) would you recommend upgrading all the client machines that have 9i client to 11g too. Is there any benefit to that or 9i would still work fine.2) Would you recomment going to instant client which does not use TNS aliases or that would requrie code changes in application. Any benefit to instant client other than size of software.3) Can i have a windows 2000 machine with 9i client and 1g client for testing purposes.4) Would 11g have major features that 9i applications may not work with it.thanks. 1 - yes, to ensure your clients fully support the datatypes and security of the database. 9i is supported with 11g but it's always best to get as close as possible for maximum compatibility2 - instant client can still use tns aliases, maybe I'm misunderstanding your question3 - yes, and for testing purposes I would recommend doing so, and also if you have legacy applications running on older databases the 11g client may not talk to them4 - out of the box your 9i applications may run into ACL errors since those are new security changes, but easily rectified, other than that, I would expect your 9i app to run just fine in 11g 'as is'. There may be things you want to change to take advanted of new features but the older code should still be supported. My 2 cents.1.
Oracle Odbc Driver
I am learning now 'Oracle Database 11g: Administration Workshop'. From this fall also I will switch to Oracle 11g at the University at my lectures. This is so, because 11g is the future, 9i is history. The migration is painful.
The good old iSQL.Plus is history. Classic export - also. But the quick we made the transition the better will our future. So invest time and efforts in this transition.2.
Instant client (at least 10g) uses aliases, but I will recommend to use also 11g.3. Will not recommend to have two clients on the same Windows machine. Yo'll have troubles with the PATH variable - Oracle will read it from left to right and will check and select the first met binary. But this leads the incorrect libraries, binaries and is a big mess. Right now on my laptop I have installed Oracle 9i and Oracle Developer Suite 10g.
Thats a full mess.4. I do not expect troubles between 9i applications and 11g DB. But it depends on the application. You have to check if it certified to work with 11g.
Possibly upgrade will not hurt.Good luck! I am confused.The first link i listed was forOracle Database 11g Release 1 Client (11.1.0.6.0)for Microsoft Windows (32-bit)win3211gR1client.zip (510,809,607 bytes)The second link you mentioned wasOracle Database 11g Release 1 Client (11.1.0.7.0)for Microsoft Windows 2008 Server (32-bit)win3211gR1client.zip (552,398,260 bytes)I want to install this on windows 2000 machine. The second one seem to be for windows 2008 server machine.2) Is the client the same for windows 2000 and windows XP? I want to test this on windows 2000 machine but the production machines might have XP on them.
Do you think there might be issues due to that and i should only test under XP.