Connecting to Oracle DB using TCPS protocol

Integrations
,
1

Hi ,

I am using Katalon 8.3.0 trial version
Trying to connect to an Oracle db using TCPS protocol. But always getting the error: SQL Exception: IO Error: Connection reset

Using Toad we are connected to the db and able to run all queries on the db tables.
I am using the details as in the tnsname.ora file which is used to connect to db as given below:-

G4_19C=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=xxxxx)(PORT=1523))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=xxxxx))(SECURITY=(SSL_SERVER_CERT_DN=“xxxxx,OU=IEO,O=xxxxx,L=Round Rock,ST=Texas,C=US”)(MY_WALLET_DIRECTORY=C:\app\client\xxxxxxxx\product\19.0.0\client_1\network\admin\affinity_client_wallet\client_wallet)))

Tried including all details in connection string , but still getting error.
Is it the issue with the Licensing? Or Katalon required any firewall changes to be made to connect to via VPN?

Let me know if you need more details

2

Did you get your issue solved? I faced the same and after several attempts I was able to make it work.

3

Hi Team, I am facing the same issue. Please let me know the solution for the same

4

Did you read the below link?

There are some videos that might be interesting as well.

https://www.google.com/search?q=katalon+studio+connect+to+oracle&rlz=1C1GCEA_enCA965CA965&oq=katalon+studio+connect+to+oracle&gs_lcrp=EgZjaHJvbWUyBggAEEUYOTIHCAEQIRigATIHCAIQIRigAdIBCjEwMTM4ajBqMTWoAgCwAgA&sourceid=chrome&ie=UTF-8#fpstate=ive&vld=cid:177c31bd,vid:SX7rLQrS2OY,st:0

5

I am able to connect from Katalon to Oracle with below info

First of all, make sure your TNS file has correct info and try to connect with PL SQL. Below is what I have in my TNS file
and I am able to connect with Oracle client with the same. So I use as below in Katalon but your string is longer, so I matched with what I use and I know works for me.

G4_19C=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=xxxxx)(PORT=1523))(CONNECT_DATA=(SERVICE_NAME=xxxxx)))

GlobalVariable.sDatabaseName = G4_19C (Your TNS name for the string you want to connect with, Katalon will make reference
to the TNS file and extract the string as declared there.)

Then use as below

	String connectionString;
	System.setProperty("oracle.net.tns_admin", "PATH TO YOUR TNS FILE");
	connectionString = "jdbc:oracle:thin:@" + GlobalVariable.sDatabaseName;

	def sql = Sql.newInstance(connectionString, GlobalVariable.sUserId, GlobalVariable.sPassword);
	try {
		sql.eachRow("select count(*) from TABLE where CONDITION YOU NEED'"){ row ->

			println ("THIS IS THE OUTPUT QUERY: " + row);
		}
	} finally {
		sql.close();
	}