My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.