If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

ORA-12500: TNS:listener failed to start a dedicated server process

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?

Everything worked till I changed it to one listener. I configured my ora92 listerer like this so that I could eliminate 803 listener. Now I am getting ora-12500 again if I connect to 803 from 92sqlplus.

I swear to god that I did exactly as told. I cut and pasted the listerner.ora and tnsnames.ora and TNS_ADMIN for one lisetner. Still I get ORA-12500 when I tried to connect 803 from 92. I solved the problem by going back to two listeners.