Q

TNS listener components not working after upgrade

We have old software on Windows NT working with Oracle 7. 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.

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 2.3.3.0.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

Dig deeper on Oracle database export, import and migration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close