I recently installed a version of Oracle 8i Personal Edition on my desktop. When I try to establish a connection via SQLPlus, I get the following error:
ORA-12500 TNS: listener failed to start a dedicated
Prior to getting this message, I received other messages
pertaining to the Service Name and SID definitions in my connect string. I've checked and double-checked my listener and tnsnames .ora files making sure all parameters were defined properly in the Net 8 Assistant, but the problem noted above continues to persist. I noticed in the 8.1.6 version of the Net 8 Assistant, that a "Connection Type" parameter is available in the Service Identification panel. If I change the Connection Type to "Shared", I receive a different error:
ORA-12519 TNS: no appropriate service handler found
If I change the parameter back to "Dedicated Server" or "Database Default", the ORA-12500 error pops up in SQLPlus. The 8.1.5 version of the Net 8 Assistant does not include the Connection Type parameter, so I never had to deal with this before. Any ideas on how to set up the Listener configuration so that it thinks it has what it wants?