Unable to Start Database Using Enterprise Manager: TNS-12514

(Doc ID 437451.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Net Services - Version:
This problem can occur on any platform.


Database will not start through OEM (Start/stop Instance), attempts fail with error shown below. We can start/stop database just fine from command line with SQL*Plus.

Error seen:
TNS-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor


No static configuration for the instance is present (SID_LIST_ in LISTENER.ORA)


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