ORA-12541: TNS:No listener error
513920Mar 17 2011 — edited Mar 17 2011Hi,
I was have hard time solving this issue;
I have a Host (Win 7 Pro) with Oracle 11g r2 running perfectly, using for all my applications on the guest.
I have VirtualBox with XP Pro (guest) with Oracle 11g client. When trying to tnsping a host db from guest I am getting - ORA-12541: TNS:No listener error
Network configuration: Host-Only network
DHCP: OFF (manually turned off)
Guest Static IP: 192.168.56.2
Firewall on Guest & Host: OFF
Ping Status: Able to ping both (vise-versa)
TNSNAMES: (On both Guest & Host)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pc-e6510)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
I have to configure host-only network only (not Bridge / NAT) because its my office PC, so can't have an anonymous IP accessing the network. So Host-Only apply best for my case. After trying and searching for solution its time for me post a thread.
Folks, if you find anything missing or changes required please help.
Thanks,
Yar.