IBM Support

ORA-12519: TNS:no appropriate service handler found

Technote (troubleshooting)


Problem(Abstract)

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].

Document information

More support for: Cognos Planning
Contributor

Software version: 10.1.1, 10.2

Operating system(s): Windows

Software edition: All Editions

Reference #: 2003478

Modified date: 15 May 2017


Translate this page: