We have old software (under Windows NT 4.0 SP5) that is working with Oracle 7. The installation of this software is automatic and we are not able to modify this one. I want to upgrade to Windows XP but Oracle 7 can't run under XP, therefore I must migrate to Oracle 8 or later. I have exported from Oracle 7 and imported to Oracle 8, and some of the components of the software are working normally but the components that belong to TNS listener service are not running (SQL*Net 184.108.40.206.0 is under Oracle 7). After running the job in log file I have java.sql.SQLexception: protocol violation (I have copied classes12.zip but no difference by classes111.zip). Do you have solution for this problem please?
Oracle works with the operating system so when the OS is upgraded, you must take into consideration which release of Oracle database software is supported and certified with the new release of the operating system. In this case, you are moving from Windows NT to Windows XP. Referring to the
Oracle Certification Matrix
, Oracle8 is not supported or certified on Windows XP. If you are going to the trouble of upgrading your operating system, you should upgrade your database to a supported release which, in this case, would be Oracle9i release 2 (9.2.) and above. There is not much point to upgrading to a release of Oracle that is not supported or certified for the operating system you are running. With respect to your TNS issue, after you upgrade your database, you should be running the listener from the new ORACLE_HOME so that it is compatible with your database release. If you upgrade to Oracle 9.2, you should run the 9.2 listener. The problems you are experiencing may also be due to the incompatibility of Oracle and the operating system.
Dig Deeper on Oracle database export, import and migration
Can I use /var/opt/oracle/oratab to specify listener information?
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...
I'm getting errors while installing the Database Configuration Assistant.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.