My Oracle Support Banner

Analytics Installer Fail when Database Service Name and SID is Not Same (Doc ID 2128353.1)

Last updated on MAY 14, 2021

Applies to:

Oracle Communications Services Gatekeeper - Version 6.0.0 and later
Information in this document applies to any platform.


When the staging DB's service name is not same with SID, running analysis installer will fail.

For example:
SID: orcl
Service Name: orcl.<Domain_Name>

On the 'analytics parameters' page, if you enter SID (orcl) in field 'DBMS/Service', it will fail with 'failed to connect to database', if you enter service name(orcl.<Domain_Name>) in it, the installer will take it as the SID, it will fail later. The error will be:

INFO: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor


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

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