Hi Team,

I am trying to access service deployed in Openshift and getting always below error , even though it is tested to work in SQL Developer and telnet.

Also its working fine in VM.

BIP2322E: Database error: SQL State '08001'; Native Error Code '0'; Error Text '[unixODBC][IBM][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.'.

Request a quick support.

Best regards

Sayed

Hello Sayerd,

Have you already configured the ODBC using the command mqsisetdbparms -n nameodbc -u user -p password and added the ODBC.ini using configmap?

Hi Team,

I am trying to access service deployed in Openshift and getting always below error , even though it is tested to work in SQL Developer and telnet.

Also its working fine in VM.

BIP2322E: Database error: SQL State '08001'; Native Error Code '0'; Error Text '[unixODBC][IBM][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.'.

Request a quick support.

Best regards

Sayed

Hi Team,

I am trying to access service deployed in Openshift and getting always below error , even though it is tested to work in SQL Developer and telnet.

Also its working fine in VM.

BIP2322E: Database error: SQL State '08001'; Native Error Code '0'; Error Text '[unixODBC][IBM][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.'.

Request a quick support.

Best regards

Sayed

------------------------------
Sayed Abdul Islam
------------------------------

You need to verify the following to identify the root cause of the issue. I am assuming you have access to the pod's terminal where IBM ACE is deployed and performed all configurations required for ODBC connectivity.

1. Verify whether oracle database server is accessible from pod and OpenShift cluster using telnet etc.
2. Verify ODBC configuration and connectivity using mqsicvp command.
3. Enable ODBC trace to get more details about the error. 

------------------------------
Irfan Shahzad
Integration Architect

Original Message:
Sent: Thu January 04, 2024 01:32 PM
From: Sayed Abdul Islam
Subject: Openshift- Ace12 DB Connection Failure

Hi Team,

I am trying to access service deployed in Openshift and getting always below error , even though it is tested to work in SQL Developer and telnet.

Also its working fine in VM.

BIP2322E: Database error: SQL State '08001'; Native Error Code '0'; Error Text '[unixODBC][IBM][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.'.

Request a quick support.

Best regards

Sayed

------------------------------
Sayed Abdul Islam
------------------------------

Thanks Experts for your advice and suggestions.

I am using  odbc.ini template provided by IBM and docs  and  including as a part of deployment process, not sure if missing something else as telnet connectivity is working fine at POD level.

Regards

Sayed

You need to verify the following to identify the root cause of the issue. I am assuming you have access to the pod's terminal where IBM ACE is deployed and performed all configurations required for ODBC connectivity.

1. Verify whether oracle database server is accessible from pod and OpenShift cluster using telnet etc.
2. Verify ODBC configuration and connectivity using mqsicvp command.
3. Enable ODBC trace to get more details about the error. 

------------------------------
Irfan Shahzad
Integration Architect

Original Message:
Sent: Thu January 04, 2024 01:32 PM
From: Sayed Abdul Islam
Subject: Openshift- Ace12 DB Connection Failure

Hi Team,

I am trying to access service deployed in Openshift and getting always below error , even though it is tested to work in SQL Developer and telnet.

Also its working fine in VM.

BIP2322E: Database error: SQL State '08001'; Native Error Code '0'; Error Text '[unixODBC][IBM][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.'.

Request a quick support.

Best regards

Sayed

------------------------------
Sayed Abdul Islam
------------------------------