Hello
We created a new Oracle 26ai database. We are not able to connect to this database using sql developer (version 24.3.1.347). We have other 26 ai databases where connecting is not an issue. I double checked the tns_names.ora file several times.
I can connect to the new database with sqlcl and sql developer for vs code. These tools use the same tns_names.ora file.
When creating a new connection (connection type tns, or basic (using service name)) and clicking [test] I get status succes. But as soon as I connect I get: Your database connection has been reset. Any pending transactions or session state has been lost (3 times). As soon as Iexpand the navigator node I get:
Cannot invoke "oracle.dbtools.raptor.navigator.ConnectionInfo.getConnectionType()" because "<parameter1>" is null
Details >>
java.lang.NullPointerException: Cannot invoke "oracle.dbtools.raptor.navigator.ConnectionInfo.getConnectionType()" because "<parameter1>" is null
at oracle.dbtools.raptor.navigator.db.xml.NavigatorHook.getConnectionType(NavigatorHook.java:254)
at oracle.dbtools.raptor.navigator.ObjectFactoryRegistry.createFactory(ObjectFactoryRegistry.java:164)
at oracle.dbtools.raptor.navigator.ObjectFactoryRegistry.getFactory(ObjectFactoryRegistry.java:153)
at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode.getObjectFactory(DatabaseTreeNode.java:91)
at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(DatabaseTreeNode.java:145)
at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(DatabaseTreeNode.java:119)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:204)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:798)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
I reinstalled sql dev, I deleted connections and created new ones, nothing seems to help.
Any ideas?
Regards Erik