Just bought and installed dbforge for oracle. But it won't connect to any of my databases:
64bit Windows 7. I first had to install the 64bit oracle client (11.2.0.1) because I only had a 32bit before.
When I try to add a new site, I click the test connection button and get "Server did not respond within the specified timeout interval".
So I try a direct connection and it fails with the same timeout interval message.
Toad, SqlPlus and other database applications are working fine. Any ideas what might be wrong?
New install - cannot connect
Make sure that the Oracle x64 client is set correctly, and that data in the tnsnames.ora file is correct.
Please check if the data for connecting in the Direct mode was input correctly. To do this, you can take the line you from your tnsnames.ora file that you are using to connect through the client. For example,
To connect in the Direct mode, check the Direct checkbox on the General tab.
After that set the needed values in the Connection timeout and Execute timeout fields on the Advanced tab if the default values are not appropriate to you according to the example below:
Besides, check the settings of your firewall – if it is on, it may block dbForge work.
Please check if the data for connecting in the Direct mode was input correctly. To do this, you can take the line you from your tnsnames.ora file that you are using to connect through the client. For example,
Code: Select all
ORCL1120 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dboracle)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL1120)
)
)
After that set the needed values in the Connection timeout and Execute timeout fields on the Advanced tab if the default values are not appropriate to you according to the example below:
Code: Select all
Server: dboracle
SID: ORCL1120
Port: 1521
-
- Posts: 13
- Joined: Mon 18 Apr 2011 16:37
Firewall Software
You said firewall and that got me thinking:
A while ago I had installed Comodo firewall software. I uninstalled that and am able to connect to the database.
However, when I perform a compare, I get the "This program has stopped working" message from windows.
A while ago I had installed Comodo firewall software. I uninstalled that and am able to connect to the database.
However, when I perform a compare, I get the "This program has stopped working" message from windows.