TNS listener components not working after upgrade
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 22.214.171.124.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.
This was first published in May 2007