Accessing Oracle through TOAD (Oracle 10g hosted in VMWARE WORKSTATION GUEST OS RHEL 5.0) : TNS error : ORA-12560

I have VMWare Workstation 4.1.20  with Windows XP Pro as Host and RHEL 5 as Guest. Oracle 10g is installed and everything is fine from that end. But I can't get the client on Windows to connect the Oracle server. checked both tnsnames.ora, used sqlplus and tnsping, always get TNS/ORA-12560: TNS:protocol adapter error.

The VMWare network setting is localhost.localdomain

Solution:

Step:  1) use ip address instead off  remote hostname. (Add the contents to TNSNAMES.ORA  to your locally installed SQLPLUS. This can be done through toad.

2) Stop the firewall services in Linux.

--TNSNAMES.ORA

/* The local DB Name is SYS and hosted DB in RHEL is XE*/

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

SYS=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=sys)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SERVER=dedicated)
      (SERVICE_NAME=sys)
    )
  )

EXTPROC_CONNECTION_DATA=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=IPC)
      (KEY=EXTPROC1)
    )
    (CONNECT_DATA=
      (PRESENTATION=RO)
      (SID=PLSExtProc)
    )
  )

XE=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=192.168.1.172)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SERVER=dedicated)
      (SERVICE_NAME=XE)
    )
  )

EXTPROC_CONNECTION_DATA=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=IPC)
      (KEY=EXTPROC_FOR_XE)
    )
    (CONNECT_DATA=
      (PRESENTATION=RO)
      (SID=PLSExtProc)
    )
  )

   

Disable Firewall on RHEL / CentOS / RedHat Linux

Next enter the following three commands to disable firewall.

# service iptables save

# service iptables stop

# chkconfig iptables off

If you are using IPv6 firewall, enter:

# service ip6tables save

# service ip6tables stop

# chkconfig ip6tables off

Thanks & Regards

Rajani