AnalyticsLoadEvents.bat (.sh) Fails With The Error "ORA-12505 Connection refused, the specified SID (<SID NAME>) was not recognized by the Oracle server" (Doc ID 1183083.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle WebCenter Analytics - Version 10.3.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Aug-2013**

Symptoms

WebCenter Analytics AnalyticsLoadEvents.bat (.sh) Fails With The Error:

ORA-12505 Connection refused, the specified SID (<SID NAME>) was not recognized by the Oracle server.


This error is also viewable in the eventloader.log file located at:
<BEA_HOME>/alui/ptanalytics/10.3.0/logs/

Changes

Run AnalyticsLoadEvents.bat (Windows) or AnalyticsLoadEvents.sh (Unix) as part of the WebCenter Analytics installation process.

This script is used to register events on the Analytics Server which are sent from the WebCenter Interaction Portal.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms