Session Stopped and IxpStore Log "No Active Datawarehouse in the Pool" Due to ORA-12543

Asset ID:	1-72-2306029.1
Update Date:	2017-09-13
Keywords:

Solution Type Problem Resolution Sure

Solution 2306029.1 : Session Stopped and IxpStore Log "No Active Datawarehouse in the Pool" Due to ORA-12543

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.1.0 and later
Information in this document applies to any platform.

Symptoms

Following messages were generating in store process of the sessions:

0908:142935.173 STO1 Column Name: LINKSETNAME_; Type: VARCHAR2; TypeID: 1; TypeName: STRING; TypeCode: 3; unsigned: 0; [51098/StoDbInterface.cpp:301]
0908:142935.173 STO1 Column Name: WAY_; Type: NUMBER; TypeID: 2; TypeName: ENUM; TypeCode: 2; unsigned: 0; [51098/StoDbInterface.cpp:301]
0908:142935.173 STO1 Column Name: OPC_; Type: NUMBER; TypeID: 2; TypeName: POINT_CODE; TypeCode: 2; unsigned: 1; [51098/StoDbInterface.cpp:301]
0908:142935.173 STO1 Column Name: DPC_; Type: NUMBER; TypeID: 2; TypeName: POINT_CODE; TypeCode: 2; unsigned: 1; [51098/StoDbInterface.cpp:301]
0908:142935.173 STO1 Column Name: COUNTRY_; Type: VARCHAR2; TypeID: 1; TypeName: STRING; TypeCode: 3; unsigned: 0; [51098/StoDbInterface.cpp:301]
0908:142935.173 STO1 Column Name: OPERATOR_; Type: VARCHAR2; TypeID: 1; TypeName: STRING; TypeCode: 3; unsigned: 0; [51098/StoDbInterface.cpp:301]
0908:142935.173 STO1 Column Name: MSU_; Type: NUMBER; TypeID: 2; TypeName: UNSIGNED; TypeCode: 2; unsigned: 1; [51098/StoDbInterface.cpp:301]
0908:142935.173 STO1 Column Name: TOTALMSUBYTES_; Type: NUMBER; TypeID: 2; TypeName: UNSIGNED; TypeCode: 2; unsigned: 1; [51098/StoDbInterface.cpp:301]
0908:142937.176 TR-V OCIServerAttach() error: (12543) ORA-12543: TNS:destination host unreachable [51098/StoConnection.cpp:264]
0908:142937.176 STO2 No active datawarehouse in the pool [51098/StoDbInterface.cpp:471]
0908:142937.176 STO2 Unable to initialize the database interface [51098/StoKernel.cpp:212]
0908:142947.176 STO1 Session name: xxxxxx [51098/StoDbInterface.cpp:126]
0908:142947.177 STO1 Column Name: TIMETAG; Type: NUMBER; TypeID: 2; TypeName: UNIX_TIME; TypeCode: 2; unsigned: 0; [51098/StoDbInterface.cpp:301]
0908:142947.177 STO1 Column Name: DURATION_; Type: NUMBER; TypeID: 2; TypeName: UNSIGNED; TypeCode: 2; unsigned: 1; [51098/StoDbInterface.cpp:301]

Changes

Cause

Storage server of DWS assigned to sessions were not accessible:

[cfguser@ixp0001-1h ~]$ ping ip_address_of_DWS server
PING ip_address_of_DWS (xx.xx.xx.xx) 56(84) bytes of data.
From xx.xxx.xx.xxx icmp_seq=2 Destination Host Unreachable
From xx.xxx.xx.xxx icmp_seq=3 Destination Host Unreachable

Solution

Following steps can be performed to resolve the issue:

Recover the storage server from issue
Or
Create a new session with different storage pool.

Attachments

This solution has no attachment