BC Create Installation failed due to no appropriate service handler found.

BC Create Installation failed due to no appropriate service handler found.

book

Article ID: KB0084588

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect -
Not Applicable -

Description

Resolution:
Description:
============
BC is able to "Test Connection" sucessfully however while doing "Create installation", it fails throwing the error:
>>>>
Installation Creation Failed . java.sql.SQLException: Cannot get db connection for url: jdbc:oracle:thin:@host:port:XE: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: host:Port:XE”
<<<<

Environment:
============
All Platforms
All BusinessConnectversions

Cause:
======
Possible causes for this error :

1).The remote_listener parameter is set in the init/spfile but the local_listener is not running.

2).The instance is not fully mounted.

3).The instance is shutting down.

4).The maximum number of concurrent sessions has been reached.

5).The node load is at a maximum.

Generally the error is due to limited number of concurrent connections or db processes that are allowed.

Resolution:
===========
To avoid this error:

1). Increase number of processses. To do this, run the following  SQL*Plus command:

"alter system set processes=200 scope=spfile;”

2). Restart the database.

This will allow a greater number of DB processes.

Issue/Introduction

BC Create Installation failed due to no appropriate service handler found.