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

User · Answer

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

User · Answer

In some versions  it stores it under   lt installed path gt  system oracle jdeveloper db connection 11 1 1 0 11 42 44  IDEConnections xml

User · Answer

On linux systems      sqldeveloper system lt sqldeveloper version gt  o jdeveloper db connection connections xml

User · Answer

With SQLDeveloper v19 1 0 on Windows  I found this as a JSON file in  C  Users  lt username gt  AppData Roaming SQL Developer system lt versionNumber gt  o jdeveloper db connection   The file name is connections json

User · Answer

For OS X my connection xml files are in   Users  lt username gt   sqldeveloper system lt sqldeveloper version gt  o jdeveloper db connection  lt oracle version  gt

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

for macOS    Users joseluisbz  sqldeveloper system18 1 0 095 1630 o jdeveloper db connection connections xml

User · Answer

I found mine in   C  Users  lt user gt  AppData Roaming SQL Developer system2 1 1 64 45 o jdeveloper db connection 11 1 1 2 36 55 30 connections xml

User · Answer

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

User · Answer

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

User · Answer

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

[oracle] Where does Oracle SQL Developer store connections?

Examples related to oracle

Examples related to oracle11g