My Oracle Support Banner

Problem: Grid MAnagement Repository creation fails with ORA-12514 (Doc ID 292938.1)

Last updated on OCTOBER 26, 2019

Applies to:

Enterprise Manager Base Platform - Version 10.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The Grid Management Repository Creation in a seed 9.0.1.5 database fails with the following error:
Could not connect to
SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=<port>)))(CONNECT_DATA=(SE
VICE_NAME=<DBNAME>.))): ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor (DBD ERROR: OCIServerAttach)
Repository Creation Failed

There is a "." appended to the service_name emrep

The listener.ora shows:
[...]
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /ORACLE_HOME)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = <DBNAME>)
(ORACLE_HOME = /ORACLE_HOME)
(SID_NAME = <DBNAME>)
)
)

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.