I am using Oracle 7.1.6 on SCO Openserver 5.0.5. My applications are developed in Developer 2000, and we access the database via Windows 98 Standard Edition. We have started developing new applications on J2SE. We are using J2SDK 1.4.0 and the web server is Apache Tomcat 4.0. We have installed the J2SDK and Tomcat on Windows 98 Standard Edition. The listener is working nicely at the backend. I am able to connect to the database via SQL*Plus. The problem is that I am not able to connect via Oracle thin driver to my current Oracle database on Unix. I have exhausted all the resources to get this solved. If I make DSN via ODBC I am able to connect. But the JDBC simply isn't working. I tried the same with OCI also but in vain.
If this can't be solved then we would have to migrate our database from Oracle 7.1.6 on Unix to Oracle 8i on Windows NT/Windows 2000 Advance Server. If I have to migrate from Unix to Windows, what would be the steps involved in migrating? To my knowledge the only way is to export the full database in Unix and precreate the database, data files, tablespaces and users on Windows and then import the database. If I am correct, then can you guide me by giving some practical examples as how I should go about it?
First, I don't believe that any JDBC drivers will support connection to Oracle 7.1 since that used SQL*Net v1 and JDBC wasn't even born back then.
Migration: I would strongly urge you to consider moving to at least version 9.2, if not version 10g. Oracle 8.1.7 has already had its first level of desupport take effect (but maybe that isn't too important considering you're still using Oracle 7.1!). Upgrading to the most recent release and recent technology for your middle tier will mean a longer rest before you'll need to evaluate upgrading again.
The most direct path for your upgrade would be to install the new version on the target platform, do a full database export from your current database, and import the resulting dump file into the new database. After that, test everything very carefully. You'll be skipping over 6 major database releases, so I wouldn't be surprised if some things don't work as expected.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Dan Norris
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.