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].
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg22003478