Problem

After installation of B2Bi Server 2.1.0 with Oracle 11G, error occured at first startup of Interchange :

2016-02-01 14:51:38,742 - ERROR [Startup] (UpgradeExecuter.executeUpgrades:69) - Error executing upgrade class:
com.cyclonecommerce.webservices.upgrade.postupgrade.UpdateWebservicesSHAAlgorithmNames
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found

Resolution

1) Connect to the database as sysdba :
connect /as sysdba

2) Change the PROCESSES and SESSIONS values :
alter system set PROCESSES=1000 SCOPE=SPFILE ;
alter system set SESSIONS=1000 SCOPE=SPFILE ;

3) Restart the database

4) Check that the values has been saved :
select name, value from v$parameter where name in (’processes’,’sessions’);

5) Start Interchange