Ora-12500 Error While Connecting Through the Listener When the Database Started as Domain User (Doc ID 274441.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Net Services - Version: 8.1.7.0.0 to 9.2.0.8.0
Microsoft Windows 2000
Checked for relevance on 15-MAY-2008.

Oracle database and listener.

Symptoms

Connections via the listener on a Windows platform fail with an ORA-12500 TNS:listener failed to start a dedicated server process

Inspection of the Control Panel Service for the instance shows that the "Log on as" account information is configured for the domain user.   However, the listener service is configured to "Log on as" the Local System account. 

If the instance is changed so that the "Log on as" account information matches that of the listener, then connections are successful. 

Changes

The database service "Log on as" information has been changed recently or this has not worked since the installation took place.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms