My Oracle Support Banner

Ora-12514 Errors - Cannot Connect to the Oracle Instance Locally On Server (Doc ID 332493.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle Net Services - Version 8.1.7.4.0 to 10.2.0.4 [Release 8.1.7 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

 

You cannot connect to an Oracle Database running on Windows 2000 Server after the
machine was restarted.

ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Verified the issue by the script output provided in TAR text showing the connection attempt
using 'connect / as sysdba' fails with the ORA-12514 error message.

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
Cause
Solution


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