I have a 8.0.3 and 9.2 on a windows2000 server. I have two listeners, listener for 8.0.3 on port 1526 and listener for 9.2 on port 1521 configured and started properly and tnsnames with sid and oracle_home configured properly.

The problem I am having is if I start 9.2 on sqlplus803 executable (in c:\orant\bin) I get the above error. Same thing with 9.2. If I start 803 with sqlplus 92 executable (in D:\ora92) I get ora-12500?

Any one had this error before?