ORA-12514: Service_name has a '.' full stop (period) at the end
(Doc ID 2332320.1)
Last updated on MARCH 31, 2022
Applies to:
Oracle Net Services - Version 11.2.0.3 and laterOracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.
Symptoms
Application reporting ORA-12514 errors because the Database Service is showing a '.' "full stop" (period) at the end of the Dynamic Service.
Example:
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=REGISTER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Host name)(PORT=1521)))
Services Summary...
Service "ORCLDEV." has 1 instance(s).===============>>Full stop at end of the service name.
Instance "ORCL1DEV", status READY, has 1 handler(s) for this service...
Changes
None
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 |