Where does Oracle SQL Developer store connections?

Question

I have an application with which I cannot connect to my Oracle Database 11g Express Edition. I created a test database in this release, and I can perfectly connect to the database using Oracle SQL Developer, create tables, views, etc. However, it is difficult for me to connect to my application. Where is the connection information? In which file? I wanted to compare the connection information with what is configured in the SQL Explorer file. I found all the * .ora files and renamed them to find out if I can find the file (through the repair process) in which the connections were saved, but I was not successful. Any help would be appreciated.

Answer 1

It was in a slightly different place for me than the ones listed above.

\Users\[user]\AppData\Roaming\SQL Developer\system3.2.20.09.87\o.jdeveloper.db.connection.11.1.1.4.37.59.48\connections.xml 

Answer 2

Assuming you lost them when upgrading versions like me, follow these steps to recover:

• Open SQL Developer
• Right click on Connections
• Selection of import connections ...
• Click Browse (opens in your SQL Developers directory).
• Go to "systemx.x.xx.xx" (replace x with your previous version of SQL Developer).
• Find and collapse the folder in which there is ".db.connection". in it (for me it was in o.jdeveloper.db.connection.11.1.1.4.37.59.48)
• select connection.xml and click "Open"

Then you will see a list of connections to be imported.

Answer 3

If you do not find connections.xml , right-click Connections in the Connections view of SQLDeveloper and select Export connections .

Answer 4

It is stored in a file called connections.xml under

 \Users\[User]\AppData\Roaming\SQL Developer\System\ 

When I renamed the file, all information about my connection disappeared. I renamed it back and it all came back. When I looked at the XML file, I found test connection aliases, ports, usernames, roles, authentication types, etc.

Answer 5

In some versions it stores it under

 <installed path>\system\oracle.jdeveloper.db.connection.11.1.1.0.11.42.44 \IDEConnections.xml 

Answer 6

For OS X, my connection.xml files are in

 /Users/<username>/.sqldeveloper/system<sqldeveloper_version>/o.jdeveloper.db.connection.<oracle_version?>/ 

Answer 7

I found myself in

 C:\Users\<user>\AppData\Roaming\SQL Developer\system2.1.1.64.45\o.jdeveloper.db.connection.11.1.1.2.36.55.30\connections.xml 

Answer 8

SqlDeveloper saves all connections in a file named

 connections.xml 

In Windows XP, you can find the file in the folder

 C:\Documents and Settings\<username>\Application Data\SQL Developer\systemX.XXXX\o.jdeveloper.db.connection.XXXXXXX\connections.xml 

On Windows 7, you will find it in a location

 C:\Users\<username>\AppData\Roaming\SQL Developer\systemX.XXXX\o.jdeveloper.db.connection.XXXXXXX\connections.xml 

Answer 9

If you previously installed SQL Developer, it will save the connection details in the connection.xml file, which will be located below the specified path.

 C:\Users\Username\AppData\Roaming\SQL Developer\system3.1.07.42\o.jdeveloper.db.connection.11.1.1.4.37.59.48 

Once you get this 'connection.xml' try importing it into SQLDeveloper by right-clicking on CONNECTIONS.

Answer 10

For Mac OS X:

 ~/.sqldeveloper/system4.1.3.20.78/o.jdeveloper.db.connection.12.2.1.0.42.151001.541/connections.xml 

Answer 11

The easiest way is to open the search window and search for connection.xml by right-clicking on this file and choosing the open location of the file / folder. Once you get connection.xml , try importing it into SQLDeveloper by right-clicking on CONNECTIONS.

Answer 12

On Linux systems:

~/.sqldeveloper/system<sqldeveloper_version>/o.jdeveloper.db.connection/connections.xml