Print Thread
PL/SQL Developer 14.0.6 - ORA-01804 connection to Oracle 19c database
#64402 01/31/23 05:50 PM
Joined: Jan 2023
Posts: 1
B
Member
OP Offline
Member
B
Joined: Jan 2023
Posts: 1
I'm using 19 C Oracle home driver and getting a the ORA-01804 Connection error: This is my System Info:
PL/SQL Developer
Version 14.0.6.1988 (64 bit)
12.136675 - Unlimited user license
Service Contract: 6/1/2022
Windows 10 Build 19041
en-US(1033)/English (United States)


Homes
OraClient12Home1 (C:\ODAC12.2.0_64\product\12.2.0\client_1)
OraClient12Home2 (C:\Oracle12.2.0_64\product\12.2.0\client_64)
OraClient19Home1 (C:\Oracle19.0_64\product\19.0.0\client_64)



Using
Home: OraClient19Home1
DLL: C:\Oracle19.0_64\product\19.0.0\client_64\bin\oci.dll
OCI: version 12.1 (19.3.0.0.0)

When I change the Oracle Home to OraClient12Home1
Here is my system info for that
Using
Home: OraClient12Home1
DLL: C:\ODAC12.2.0_64\product\12.2.0\client_1\oci.dll
OCI: version 12.1 (12.2.0.1.0)
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

I can login to Oracle 12 databases and Oracle 19c database but when I try to query 19c database I get
ORaOCIE12.ddll Access Violation. Could not logon..

Thanks in advance.

Re: PL/SQL Developer 14.0.6 - ORA-01804 connection to Oracle 19c database
Brian Willis #64404 02/01/23 09:33 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
There may be an Oracle Client configuration issue with the OraClient12Home1 home.

Does the OraClient19Home1 function correctly?


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.029s Queries: 16 (0.008s) Memory: 2.4965 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-03-28 19:49:10 UTC
Valid HTML 5 and Valid CSS