Ask the Expert

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 is under Oracle 7). After running the job in log file I have java.sql.SQLexception: protocol violation (I have copied but no difference by Do you have solution for this problem please?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: