Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12541: TNS:No listener error

513920Mar 17 2011 — edited Mar 17 2011
Hi,
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2011
Added on Mar 17 2011
28 comments
13,312 views