verify config fails with 'Error logging on to <SID>' (4302789)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

verify config fails with 'Error logging on to '
Description

Verify config fails with error
sp_ctrl (Source:2162)> verify config testconfig
Error logging on to source_SID
See event_log for details
In the event_log was the message:
Notice 2016-04-06 17:04:19.574315 30398 1390045952 Command server: Parameter SP_ORD_LOGIN_O.source_SID not found (connecting from Source) [module pdb]
Cause

This can happen with various reasons.
1. Wrong Data source (source SID) in the config file.
2. SharePlex upgraded from old version with new PRODDIR and VARDIR but using the same SharePlex user.
Resolution

Correct the Data Source information in the config file.
If the issue occurs after upgrade and there no active config yet,
a. Remove the current entries from connections.yaml.
b. Re-run ora_setup with a new SharePlex user. If you want to use the same SharePlex DB as before, drop it with Cascade option before recreating it with ora_setup.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title