URGENT: Error connection to Oracle after update to 8.3.1

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

URGENT: Error connection to Oracle after update to 8.3.1

Post by cointec » Thu 03 Sep 2020 14:18

Hello,

After update Unidac to latest version 8.3.1, when trying to connect to Oracle Direct Mode, I get an exception with:

NET: Invalid port:

The connection string is III.XXX.YYY.ZZZ:1521/instance

If I downgrade to prior version or if the connection string does not contain the port all runs fine.

This connection string runs fine III.XXX.YYY.ZZZ/instance

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: URGENT: Error connection to Oracle after update to 8.3.1

Post by MaximG » Fri 04 Sep 2020 13:00

We're working on the issue. Are you using a single-instance database or a cluster database (RAC)? Are you getting the error on connection attempt to a specific Oracle server or any Oracle server? Could you provide us with temporary limited access to your Oracle server? You can send us access credentials via the contact form on our website: https://www.devart.com/company/contactform.html

cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Re: URGENT: Error connection to Oracle after update to 8.3.1

Post by cointec » Fri 04 Sep 2020 13:02

More info:

Our customer uses Oracle RAC, the connection string with an Oracle server without RAC runs fine.

cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Re: URGENT: Error connection to Oracle after update to 8.3.1

Post by cointec » Wed 09 Sep 2020 11:15

Sorry for insist, but this problem is urgent to solve. The connection only fails if it is done against an Oracle RAC Server (DirectMode)

Call Stack Information:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Methods |Details|Stack |Address |Module |Offset |Source |Unit |Class |Procedure/Method |Line |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|*Exception Thread: ID=31848; Parent=0; Priority=0 |
|Class=; Name=MAIN |
|DeadLock=0; Wait Chain= |
|Comment= |
|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|04 |00000000|00A3D023|Project1.exe |0063D023|OraClassesUni.pas |OraClassesUni |TOCIConnection |OraError |2472[48] |
|00000060|04 |0019F0C0|00A3CE15|Project1.exe |0063CE15|OraClassesUni.pas |OraClassesUni |TOCIConnection |Check |2411[2] |
|00000060|04 |0019F0DC|00A3E855|Project1.exe |0063E855|OraClassesUni.pas |OraClassesUni | |ConnectDefaultOCI80 |2841[152] |
|00000020|04 |0019F0E4|00A3E8E6|Project1.exe |0063E8E6|OraClassesUni.pas |OraClassesUni | |ConnectDefaultOCI80 |2853[164] |
|00000020|04 |0019F0F0|00A3E94B|Project1.exe |0063E94B|OraClassesUni.pas |OraClassesUni | |ConnectDefaultOCI80 |2857[168] |
|00000060|04 |0019F128|00A3EFFF|Project1.exe |0063EFFF|OraClassesUni.pas |OraClassesUni |TOCIConnection |Connect |2971[40] |
|00000020|04 |0019F134|00A3F1AF|Project1.exe |0063F1AF|OraClassesUni.pas |OraClassesUni |TOCIConnection |Connect |3020[89] |
|00000020|04 |0019F16C|00992340|Project1.exe |00592340|Uni.pas |Uni |TUniTransaction |SetITransaction |3778[5] |
|00000060|04 |0019F1A0|0094D2ED|Project1.exe |0054D2ED|DBAccess.pas |DBAccess |TCustomDAConnection|DoConnect |4433[19] |
|00000060|04 |0019F1D0|0098D744|Project1.exe |0058D744|Uni.pas |Uni |TUniConnection |DoConnect |1859[3] |
|00000060|04 |0019F214|0094D77E|Project1.exe |0054D77E|DBAccess.pas |DBAccess |TCustomDAConnection|PerformConnect |4563[8] |
|00000060|04 |0019F230|00950D6F|Project1.exe |00550D6F|DBAccess.pas |DBAccess |TCustomDAConnection|SetConnected |5634[109]

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: URGENT: Error connection to Oracle after update to 8.3.1

Post by MaximG » Mon 21 Sep 2020 16:06

We continue working on this issue. We hope to get results in the shortest time.

cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Re: URGENT: Error connection to Oracle after update to 8.3.1

Post by cointec » Mon 21 Sep 2020 16:41

Thank you

cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Re: URGENT: Error connection to Oracle after update to 8.3.1

Post by cointec » Thu 01 Oct 2020 06:28

Any news about this?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: URGENT: Error connection to Oracle after update to 8.3.1

Post by MaximG » Fri 09 Oct 2020 09:37

We've reproduced the issue and fixed it. The fix will be included in the next build of our product. As a workaround, we can send you a night UniDAC build including the required changes. For this provide us with your license number and IDE version you are interested in For your convenience, please use the e-support form https://www.devart.com/company/contactform.html

Post Reply