Where does Oracle SQL Developer store connections?

Question

I have an application that I can't get connected to my Oracle Database 11g Express Edition. I created a test database in this edition, and I can connect to the database fine using Oracle SQL Developer, create tables, views etc. However, I'm having a hard time getting connected via my application. Where is the connection information? In what file? I wanted to compare my connection info with what is set up in the SQL Explorer's file. I found all the *.ora files and renamed them to see if I could find what file (through the process of elimination) the connections were stored in, but I wasn't successful. Any help would be appreciated.

What OS are you using? Are you using SQL developer that came with an installation of the database, or did you download the standalone? — NullUserException, Oct 31 '11 at 14:06
Sorry! I am using Windows 7 (64 bit machinr) abd I downloaded the standalone. — Shane, Oct 31 '11 at 14:09
ah, i found it! I believe i found it on my own. It is stored in a file called connections.xml under \Users[User]\AppData\Roaming\SQL Developer\System\ When i renamed the file, all my connection info went away. I renamed it back, and it all came back. When i viewed the XML file, i found both test connection anliases, ports, usernames, roles, authentcation types, etc. — Shane, Oct 31 '11 at 14:31
Is the app with which you're trying to connect 32 or 64 bits? — Bob Jarvis - Слава Україні, Oct 31 '11 at 15:51

score 97 · Answer 1 · edited Apr 21 '16 at 16:12

97

It was in a slightly different location for me than those 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

edited Apr 21 '16 at 16:12

eebbesen

5,070
8
48
70

answered Jan 25 '13 at 21:56

Dowlers

1,434
16
26

3

Thanks! It would be interesting to know what these Oracle people are thinking when they come up with a path like that! – Jeff Roe May 06 '14 at 23:40
5

or substitute the stuff up through "Roaming" with the %APPDATA% environment variable, optionally – rogerdpack Nov 10 '14 at 20:45
2

... and the Connection _Folders_ are stored here: `\Users\[user]\AppData\Roaming\SQL Developer\system4.2.0.17.089.1709\o.sqldeveloper.12.2.1.17.89.1709\product-preferences.xml` – leo Sep 01 '17 at 10:39
3

This file is a `json` now. – Dherik Jul 17 '19 at 21:13

score 39 · Answer 2 · answered Nov 27 '12 at 18:31

39

Assuming you have lost these while upgrading versions like I did, follow these steps to restore:

Open SQL Developer
Right click on Connections
Chose Import Connections...
Click Browse (should open to your SQL Developer directory)
Drill down to "systemx.x.xx.xx" (replace x's with your previous version of SQL Developer)
Find and drill into a folder that has ".db.connection." in it (for me, it was in o.jdeveloper.db.connection.11.1.1.4.37.59.48)
select connections.xml and click open

You should then see the list of connections that will be imported

answered Nov 27 '12 at 18:31

iDurocher

875
9
11

This works but then I get the prompt 'Use a key to decrypt all passwords'. What do we do here please? I would have thought the connections.xml file will have the details including passwords. – AM_86 Jan 07 '20 at 16:39
How to find decrypt Key . I am getting this too. "Use a key to decrypt all passwords". – Jef Jan 14 '20 at 10:48

score 13 · Answer 3 · edited Nov 01 '12 at 14:17

13

If you don't find the connections.xml then right-click on Connections in the Connections view of SQLDeveloper, and choose Export connections.

edited Nov 01 '12 at 14:17

Alexis Pigeon

7,423
11
39
44

answered Nov 01 '12 at 13:54

Steven Kuypers

451
4
6

in more detail see http://www.thatjeffsmith.com/archive/2014/05/migrating-oracle-sql-developer-connections-with-passwords/ – Jan Mar 03 '16 at 11:32

score 11 · Answer 4 · edited Apr 21 '16 at 16:18

11

It is stored in a file called connections.xml under

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

When I renamed the file, all my connection info went away. I renamed it back, and it all came back. When I viewed the XML file, I found both test connection aliases, ports, usernames, roles, authentication types, etc.

edited Apr 21 '16 at 16:18

eebbesen

5,070
8
48
70

answered Dec 30 '11 at 18:12

Shane

1,325
3
12
18

score 9 · Answer 5 · answered Jan 03 '12 at 06:09

9

In some versions, it stores it under

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

answered Jan 03 '12 at 06:09

Raj

22,346
14
99
142

score 6 · Answer 6 · answered Apr 21 '16 at 16:16

6

For OS X my connection.xml files are in

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

answered Apr 21 '16 at 16:16

eebbesen

5,070
8
48
70

score 4 · Answer 7 · answered Dec 10 '19 at 16:39

4

With SQLDeveloper v19.1.0 on Windows, I found this as a JSON file in

C:\Users\<username>\AppData\Roaming\SQL Developer\system<versionNumber>\o.jdeveloper.db.connection

The file name is connections.json

answered Dec 10 '19 at 16:39

Alfabravo

7,493
6
46
82

score 3 · Answer 8 · edited Apr 21 '16 at 16:13

3

I found mine 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

edited Apr 21 '16 at 16:13

eebbesen

5,070
8
48
70

answered Aug 21 '13 at 15:36

myers18111

31
3

score 3 · Answer 9 · answered Aug 23 '14 at 11:10

SqlDeveloper stores all the connections in a file named

connections.xml

In windows XP you can find the file in location

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

In Windows 7 you will find it in location

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

score 2 · Answer 10 · edited Apr 21 '16 at 16:13

2

If you have previously installed SQL Developer then it will store the connection details in the 'connection.xml' which will be located in below mentioned 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 that 'connection.xml' try to import it into SQLDeveloper by right clicking to CONNECTIONS.

edited Apr 21 '16 at 16:13

eebbesen

5,070
8
48
70

answered Nov 10 '14 at 09:54

AKs

1,727
14
18

score 2 · Answer 11 · edited Jun 23 '17 at 09:21

2

In a simpler way open search window and search for connection.xml gives a right click on that file and select open file/folder location. Once you get that connection.xml try to import it into SQLDeveloper by right clicking to CONNECTIONS.

edited Jun 23 '17 at 09:21

Hema

988
1
16
38

answered Jun 23 '17 at 06:37

Siva Adusumilli

21
1

score 2 · Answer 12 · answered Jul 22 '22 at 19:52

To recover your password, locate the product_preferences.xml file in the following location:

C:\Users[username]\AppData\Roaming\SQL Developer\system*\o.sqldeveloper\product-preferences.xml

Then, search for the string db.system.id and copy the value of the v attribute. That is your decryption key to use when you are prompted to enter your decryption key on the Password Handling panel during the import processing on SQL Developer.

score 1 · Answer 13 · answered Feb 18 '20 at 15:21

1

for macOS

/Users/joseluisbz/.sqldeveloper/system18.1.0.095.1630/o.jdeveloper.db.connection/connections.xml

answered Feb 18 '20 at 15:21

joseluisbz

1,491
1
36
58

duplicate of https://stackoverflow.com/a/36775261/714112 – Sridhar Sarnobat Jun 23 '23 at 23:37

score 1 · Answer 14 · answered Jul 19 '23 at 09:09

Linux: Tested with SQLDeveloper v22.2

~/.sqldeveloper/system.x.y.z.yyy.ttt/o.jdeveloper.db.connection/connections.json stores all the connections in json format.

To pretty-print it you can use:

jq . ~/.sqldeveloper/system.x.y.z.yyy.ttt/o.jdeveloper.db.connection/connections.json

score 0 · Answer 15 · answered Jun 04 '19 at 15:50

0

On linux systems:

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

answered Jun 04 '19 at 15:50

axiopisty

4,972
8
44
73

Where does Oracle SQL Developer store connections?

15 Answers15

Linked