Products | Versions |
---|---|
TIBCO BusinessConnect | - |
Not Applicable | - |
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.