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: 10.2.0.1.0
This problem can occur on any platform.

Symptoms

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

Changes

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

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