Over the holidays our 19c database has been upgraded to 23c. When I try to connect from Toad I now get the following error: NET: Invalid input arguments The Items Checked in the pop-up windows shows that the correct tnsnames.ora was located. The link to the knowledge base provides no useful info…

I'm not sure. We have 23c databases here and there is no problem. Can you turn on spool SQL and show us the output? Which version of Toad are you using? If older than 17.0, does it help if you update to 17.0? Based on the error starting with "NET:", it seems like you are not using an Oracle clie…

I'm using Toad 17 (the latest version). I've determined that if I check the "Connect using Oracle Client" checkbox and use the installed Instant Client - 19.20.0.0 then I'm able to connect to a 23c database. This isn't necessary for connecting to a 19c database! As this checkbox can only be chang…

As this checkbox can only be changed the very first time a connection is made after starting Toad, if I first connect to a 19c database, then I cannot then change the checkbox and connect to a 23c database without first re-starting toad. The "Connect using Oracle Client" checkbox is disabled when…

Hi John, all I see when spooling sql is the following when I try to make a connection to a 23c database and do NOT check the "Connect using Oracle Client" checkbox: [image] Sorry, but I have to protect my clients privacy so have blacked out some of the details.

Of course - no problem on the blackouts. I don't need that info anyway. What you posted is helpful. The error is coming from the database access components that we use in Toad. I have posted a message on that vendor's forum. Hopefully they will provide an answer in the coming days. I have add…

@JohnDorlon Unfortunately, I haven't got the required privileges to install software into the Remote Desktop provided by my client and I know from experience they will resist my requests to install a Beta version of Toad. It was hard work to persuade them to install Toad in the first place as I'm t…

Not really, no. But I'll add this code anyway and hopefully before long someone else will experience it. And/or maybe I'll get an answer from our 3rd party oracle connectivity component vendor. I'll keep you posted. Leave your support case open. I've logged this in our internal bug tracking sy…

I'm getting the same error, version 16. This just started out of the blue. Any fix? We can't upgrade.

The error should go away if you install and use an Oracle client with Toad.

NET: Invalid input arguments when connecting to Oracle 23c

Toad for Oracle & DevOps Toolkit

JohnDorlon August 13, 2024, 6:42pm 11

This has been fixed. See this post for the cause.

Topic		Replies	Views
After CPUjul2024 19cDB patch Version 19.24.0.0.0, TOAD connection fails Toad for Oracle & DevOps Toolkit	35	2883	October 22, 2024
Which Version of Toad for Oracle Supports, oracle 19C connection Toad for Oracle & DevOps Toolkit	3	9320	July 26, 2021
Toad 10 with Oracle 19c Client Toad for Oracle & DevOps Toolkit	5	3979	October 23, 2023
Taod Data Point Connection error Toad Data Point & Toad Intelligence Central	8	1232	December 23, 2024
Facing issue connecting to Database with following Error Toad for Oracle & DevOps Toolkit	2	1544	September 30, 2019

NET: Invalid input arguments when connecting to Oracle 23c

Related topics