Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error connecting to Oracle 9.0.2 on Win2K

I have installed Oracle 9.0.2 on Win2K. When I connected to the database, it worked the first time. When I try to connect again, it gives the error TNS-12560 Protocol Adapter Error Windows 32 error, Illegal Byte Sequence.

I can't connect to TNS listener anymore and can't restart TNSlistener service. When I try to restart, it gives two issues. 1. Sometimes it doesn't start giving TNS-12560 error. 2. It works for first connection and throws the same 12560 error for subsequent connection attempts.

I tried reinstalling Oracle but the problem doesn't go away. I even tried installing Oracle on three different machines. Do you have any ideas?
This sounds like either a resource issue, a configuration problem or a bug. If you're using some non-English languages or non-default character set(s), this may be part of the problem. There was at least one bug related to an NLS issue that may be related to your problem report, but it was too vague to tell for sure.

I'd make sure you have the most recent patchset applied and if the problem still reproduces, then I'd file a TAR with Oracle Support to nail down the root cause of the problem.

This was last published in June 2004

Dig Deeper on Oracle database installation, upgrades and patches

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close