Oracle SQL Developer 在哪里存储连接？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7954759/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Where does Oracle SQL Developer store connections?
提问by Shane
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.
我有一个应用程序无法连接到我的 Oracle 数据库 11g 快捷版。我在这个版本中创建了一个测试数据库，我可以使用 Oracle SQL Developer 很好地连接到数据库，创建表、视图等。但是，我很难通过我的应用程序连接。连接信息在哪里？在什么文件里？我想将我的连接信息与 SQL Explorer 文件中设置的信息进行比较。我找到了所有 *.ora 文件并将它们重命名，以查看是否可以找到存储连接的文件（通过消除过程），但我没有成功。任何帮助，将不胜感激。
回答by Dowlers
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
回答by iDurocher
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
- 打开 SQL 开发人员
- 右键单击连接
- 选择导入连接...
- 单击浏览（应打开到您的 SQL Developer 目录）
- 深入到“systemx.x.xx.xx”（用您以前版本的 SQL Developer 替换 x）
- 查找并钻取到具有“.db.connection”的文件夹。在里面（对我来说，它在 o.jdeveloper.db.connection.11.1.1.4.37.59.48 中）
- 选择connections.xml并点击打开
You should then see the list of connections that will be imported
然后，您应该会看到将要导入的连接列表
回答by Steven Kuypers
If you don't find the connections.xmlthen right-click on Connectionsin the Connections view of SQLDeveloper, and choose Export connections.
如果在 SQLDeveloper 的 Connections 视图中没有找到，connections.xml则右键单击Connections，然后选择Export connections。
回答by Shane
It is stored in a file called connections.xml under
它存储在名为connections.xml的文件下
\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.
当我重命名文件时，我所有的连接信息都消失了。我把它改回来了，一切又回来了。当我查看 XML 文件时，我发现了测试连接别名、端口、用户名、角色、身份验证类型等。
回答by Lenin Raj Rajasekaran
In some versions, it stores it under
在某些版本中，它将其存储在
<installed path>\system\oracle.jdeveloper.db.connection.11.1.1.0.11.42.44
\IDEConnections.xml
回答by eebbesen
For OS X my connection.xml files are in
对于 OS X 我的 connection.xml 文件在
/Users/<username>/.sqldeveloper/system<sqldeveloper_version>/o.jdeveloper.db.connection.<oracle_version?>/
回答by myers18111
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
回答by Aniket Thakur
SqlDeveloper stores all the connections in a file named
SqlDeveloper 将所有连接存储在一个名为
connections.xml
In windows XP you can find the file in location
在 Windows XP 中，您可以在 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
在 Windows 7 中，您将在 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
回答by Ajit K'sagar
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.
如果您以前安装过 SQL Developer，那么它会将连接详细信息存储在位于下面提到的路径中的“connection.xml”中。
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.
一旦你得到'connection.xml'，尝试通过右键单击CONNECTIONS将它导入SQLDeveloper。
回答by Siva Adusumilli
In a simpler way open search window and search for connection.xmlgives a right click on that file and select open file/folder location.
Once you get that connection.xmltry to import it into SQLDeveloper by right clicking to CONNECTIONS.
以更简单的方式打开搜索窗口并搜索，connection.xml右键单击该文件并选择打开文件/文件夹位置。一旦你得到它，connection.xml尝试通过右键单击 CONNECTIONS 将其导入 SQLDeveloper。
