I have installed Oracle 9.0.2 on Win2k. When I connect to database, it works for the first time. When I try to connect again, it gives the error TNS-12560 Protocol Adapter Windows 32 error, Illegal Byte Sequence. I can't connect to TNS listener anymore and can't restart TNS listener 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? I am stuck badly and can't work anymore due to this issue.
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.