EXPERT RESPONSE
I would try disabling the shared server architecture completely since that's clearly the cause of your error. It is always possible that fixing one problem will cause another problem to appear, but that's all part of the joy of troubleshooting.
To disable the shared servers, set the initialization parameter shared_servers = 0. I would also make sure that the parameter dispatcher is not set (it has no default) to anything. These two parameters are responsible for configuring the shared server architecture in Oracle. Disabling them should cause your immediate error to disappear.
I should mention that "Check tnsnames.ora and sqlnet.ora" is unclear and that the only way you can be sure that those files contain no errors is if you created/modified them with the net assistant. It should be noted that neither of these files is mandatory and so simply removing them is a good step in troubleshooting any network-related issue until you can rule them out as part of the problem.
|
