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 – Where does Oracle SQL Developer store connections
oracleoracle11g
Related Solutions
SQL Developer will look in the following location in this order for a tnsnames.ora file
- $HOME/.tnsnames.ora
- $TNS_ADMIN/tnsnames.ora
- TNS_ADMIN lookup key in the registry
- /etc/tnsnames.ora ( non-windows )
- $ORACLE_HOME/network/admin/tnsnames.ora
- LocalMachine\SOFTWARE\ORACLE\ORACLE_HOME_KEY
- LocalMachine\SOFTWARE\ORACLE\ORACLE_HOME
To see which one SQL Developer is using, issue the command show tns in the worksheet
If your tnsnames.ora file is not getting recognized, use the following procedure:
Define an environmental variable called TNS_ADMIN to point to the folder that contains your tnsnames.ora file.
In Windows, this is done by navigating to Control Panel > System > Advanced system settings > Environment Variables...
In Linux, define the TNS_ADMIN variable in the .profile file in your home directory.
Confirm the os is recognizing this environmental variable
From the Windows command line: echo %TNS_ADMIN%
From linux: echo $TNS_ADMIN
Restart SQL Developer
- Now in SQL Developer right click on Connections and select New Connection.... Select TNS as connection type in the drop down box. Your entries from tnsnames.ora should now display here.
- In SQLDeveloper browse
Tools --> Preferences, as shown in below image.
- In the Preferences options
expand Database --> select Advanced --> under "Tnsnames Directory" --> Browse the directorywhere tnsnames.ora present. - Then click on Ok,
as shown in below diagram.
tnsnames.ora available atDrive:\oracle\product\10x.x.x\client_x\NETWORK\ADMIN
Now you can connect via the TNSnames options.
Related Topic
- Oracle – How to create a new database after initally installing oracle database 11g Express Edition
- Oracle and Sql developer Connection
- Ora-12505 error with sql developer connecting to oracle11g on windows 7
- Oracle – Can’t connect to Oracle database with SQL Developer (Ora00604 error occurred at recursive level 1 ORA – 12705)
Best Answer
It was in a slightly different location for me than those listed above