IBM Support

ORA-12519: TNS:no appropriate service handler found

Troubleshooting


Problem

While importing Contributor applications through the Deployment tool in the CAC, many errors are written to PlanningErrorLog.csv : Unable to open connection using connection string of Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)))(CONNECT_DATA=(SID=tnsalias)));User ID=username;Password=*********; and timeout of 15 seconds. ORA-12519: TNS:no appropriate service handler found

Cause

Oracle server tuning is insufficient : there are not enough available processes to handle all requests sent by Planning.

Environment

Oracle

Resolving The Problem

Increase the 'processes' parameter on your Oracle database server (for example to 300).
Note: Please consult your Oracle database administrator with respect to the setting of Oracle process parameters.

Steps:
The steps vary depending on whether your Oracle database server is using SPFILE or not.
If not using SPFILE, check the processes parameter in the init<sid>.ora file and increase the value.
Alternatively, if using an SPFILE, then run a command (SQLPLUS) similar to the following:
ALTER SYSTEM SET processes=300 scope=SPFILE;
[The above example sets processes to 300].

[{"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2;10.1.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22003478