webMethods

I’m trying to create a connection and have entered all the necessary information, but I keep receiving this error. I’ve tried creating connections with different connections, reinstalling the Oracle database, and placing the necessary jars, but the problem persists.
Additionally, sometimes after 1000 attempts, I succeed once and the connection is immediately enabled again. I would appreciate any assistance.

ERROR :
Error encountered

[ART.118.5011] Adapter Runtime (Connection): Unable to create new connection JDBC_Connection.connection:OracleDatabase. [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleConnectionPoolDataSource”. Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=localhost))(CONNECT_DATA=(SID=XE)))

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/66667e5d4da023cd73406c471c7ef7dd806ae455_2_1035x541.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/66667e5d4da023cd73406c471c7ef7dd806ae455.png 2x" data-dominant-color="F1F1F1">

Adapterconnectionissue1372×718 38.8 KB

Hi Manikanta,

please provide your IS version, JDBC Adapter version, Database Version and Driver version.
Any Fixes applied to IS and JDBC Adapter?

Are you able to connect to the database with another client, i.e. Oracle SQL Developer?

Regards,
Holger

My gut feeling is that this the first point to check.

What is your OS? Have you checked that the DB is actually listening on the port?

What IP address does localhost point to? Some Linux distros do funny changes to /etc/hosts out-of-the-box.

Hi Christoph,

in this case it might be a good idea to try with explicit 127.0.0.1 address.

Regards,
Holger

Hi @Holger_von_Thomsen,

I’ve included the necessary information you requested; please study it.

IS version = 10.15
JDBC Adapter version = 10.3
Database Version = 10.2.0.1.0 (Oracle Database 10g Express Edition)
Any Fixes applied to IS and JDBC Adapter =I recently changed my licence key, however the problem persisted even before.

http://127.0.0.1:8080/apex/f?p=4500:1003:2337244119763506::NO::: I’m connecting to my local Oracle database using this URL.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/eac0b95fe8252432c6ddf3dd59dedbab9d0047a6_2_1035x424.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/eac0b95fe8252432c6ddf3dd59dedbab9d0047a6_2_1380x566.png 2x" data-dominant-color="F6F7F7">

image1879×772 27.6 KB

Thanks,
Manikanta Anisetti.

Try connecting using the same port. You tested with a different protocol. Port 8080 can be functional while 1521 is disabled somewhere.

Hi @engin_arlak
I tried port 8080 as you suggested, however a new issue has arisen, which I have attached a screenshot of.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/27730bec8dbbf7e8fe9b35e57ad9352c527bec2a_2_1035x460.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/27730bec8dbbf7e8fe9b35e57ad9352c527bec2a_2_1380x614.png 2x" data-dominant-color="E3E6E9">

image1487×662 39.9 KB

Port 8080 is not used for the DB itself but the web application stuff.

Have you checked that something is running on port 1521?

Is there anything in the log files of Oracle?

Can you connect with other tools (esp. sqladmin or Oracle Developer)?

It is really important that you do these checks!

I recommended testing 1521 port from another client, not the other way around.

Probably the db server you created on localhost is not configured properly. From the screenshot, looks like you are using 10.X (probably 10.15) and you are probably using 10.3 jdbc adapter. If you have provided the correct JDBC drivers, it should connect.

Test the DB with another client as Holger mentioned and share the connection details if you can successfully connect with another client.

Run the netstat command:
Type netstat -ano | findstr :<YourPortNumber> and press Enter.
Replace <YourPortNumber> with the port number you want to check.

For example, the default Oracle port is usually 1521, so you would type netstat -ano | findstr :1521

it will make sure which port is used for what purpose.

This is the key part of the error. Focus on resolving this and getting any client tool (SQL Developer, TOAD, SQL*Plus, etc.) to connect. Something seems to be amiss with listener.ora, sqlnet.ora or tnsnames.ora files. Once one of those tools is working, then you can focus on the adapter connection pool.

yes its was connected to Oracle Edition in my system and successfully created Data users in it.

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/0180db89abed36cd609cdb6d511fcf448c17438f_2_1035x400.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/0180db89abed36cd609cdb6d511fcf448c17438f.png 2x" data-dominant-color="F4F3F4">

image1243×482 38.4 KB

Additionally, Yes something running at port 1521

image1165×761 12.7 KB

This error is coming from oracle DB. I did a quick search. Most of them indicate it is a DB configuration problem. Check the links below, they might help. I don’t think it is a JDBC adapter issue though.

This may have applicable info:

May need to use “Other Properties” to set the service name instead of using “Database Name” and the SID. May be able to use URL notation:

url=jdbc:oracle:thin:@//localhost:1521/XE;driverType=thin

Empty the database name field, and in other properties specify: ServiceName=XE
If ServiceName=XE doesn’t work, try with SID=XE

See https://empower.softwareag.com/sl24sec/SecuredServices/document/java/wmsuite10-3/DataDirect_Connect/5-1-4_DataDirect_Connect_Users_Guide.pdf, page 319.