sqldeveloper can not connect to database

I have installed oracle 11g in my opensuse 11.1 KDE 4.2.2. I wanted to use Oracle Sqldeveloper, so I installed it. But when I try to connect with the database it fails and gives error message “The network adapter failed to establish connection”. I have changed the /etc/hosts file as
[FONT=Courier New]…
# linux-esxp.site linux-esxp
my_ip_address linux-esxp.site linux-esxp

The connection details I provided in sqldeveloper are:
Connection Name: Test
username: my_local_database_connection _name
Password: connection_password
Role: Default
Connection Type: Basic
Hostname: linux-esxp
Port:Port_from listner.ora(1521)
sid: database_oracle_sid

Any help will be appreciated…


And yes I can ping any website or ip but not of my own!!

Hash: SHA1

So you cannot ping your DB machine? Is Oracle already listening on that
box? Is that separate from your client box? On the DB box run the
following and post the output:

netstat -anp | grep :1521 #assuming 1521 is your DB port by default

  • From your client box:

netcat -zv ipAddressOfDBBox 1521

If you cannot ping the DB box then let’s just get basic network
information from both systems:

ip addr sh
ip route sh
cat /etc/resolv.conf

Good luck.

vendetta18 wrote:
> And yes I can ping any website or ip but not of my own!!
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org


**Thanks fro replying. Here is what you wanted…

netstat -anp | grep :1521

tcp 0 0* LISTEN 3269/tnslsnr
tcp 0 1 SYN_SENT 4490/ora_pmon_orcl

netcat -zv 1521 inverse host lookup failed: Unknown host
(UNKNOWN) [] 1521 (ncube-lm) open

   # ip addr sh                     

1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet brd scope host lo
inet brd scope host secondary lo
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1400 qdisc pfifo_fast state UP qlen 1000
link/ether 00:16:36:f1:16:48 brd ff:ff:ff:ff:ff:ff
inet brd scope global eth0
inet6 fe80::216:36ff:fef1:1648/64 scope link
valid_lft forever preferred_lft forever
3: wmaster0: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN qlen 1000
link/ieee802.11 00:19:d2:78:8a:0a brd ff:ff:ff:ff:ff:ff
4: wlan0: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN qlen 1000
link/ether 00:19:d2:78:8a:0a brd ff:ff:ff:ff:ff:ff
5: pan0: <BROADCAST,MULTICAST> mtu 1500 qdisc noop state DOWN
link/ether 56:b5:49:11:72:68 brd ff:ff:ff:ff:ff:ff

ip route sh dev eth0 proto kernel scope link src metric 1 dev lo scope link
default via dev eth0 proto static

cat /etc/resolv.conf

/etc/resolv.conf file autogenerated by netconfig!

Before you change this file manually, consider to define the

static DNS configuration using the following variables in the

/etc/sysconfig/network/config file:




or disable DNS configuration updates via netconfig by setting:


See also the netconfig(8) manual page and other documentation.

Note: Manual change of this file disables netconfig too, but

may get lost when this file contains comments or empty lines

only, the netconfig settings are same with settings in this

file and in case of a “netconfig update -f” call.

Please remove (at least) this line when you modify the file!

search reliancebroadband.co.in


I got it working. But I have confusion now. I found out that I am dynamic IP allocation. So whenever my machine starts I have a new IP address. The document I referred to while installing oracle said

Check /etc/hosts - Comment out and put your server’s IP
address. sles10.novell.com sles10 sles10.novell.com sles10

Now, am I supposed to make changes to /etc/hosts everytime I log in or is there a solution?