Connectivity errors : TNS 15241
Hello all of you,
I'am installing virtual box 4.0 on a windows 7 laptop . I'am trying to put on this virtualization software this prebuilt VM
http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html (a Oracle Enterprise Linux and 11gR2 Oracle Database)
On the host I installing and Oracle Warehouse Builder 11g Release 2 (11.2.0.1.0) Standalone Software .
I would like to connect Warehouse Builder tools (Design Center , Repository Administration) to the repository inside the Oracle database (inside VM) . But I'am not succeding ...
I used 'tnsping owb' from my laptop but I got 12541 : no listener
On my host machine (my laptop) I added a entry like this one:
OWB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
Inside the virtual machine I have /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora file ,it looks like this
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 80))
(PROTOCOL_STACK =
(PRESENTATION = HTTP)
(SESSION = RAW)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 21))
(PROTOCOL_STACK =
(PRESENTATION = FTP)
(SESSION = RAW)
)
)
)
ADR_BASE_LISTENER = /ho$me/oracle/app/oracle
logging_listener_name=on
I understand this depends about network settings from this wirtual box machine - NAT,Bridged Adapter,Host only adapter,internal network and network configs of host machine.
My laptop gets IP address from dhcp .
I understand Bridged networking is best suited for my needs (it's recomended for running servers)
Why do you think I getting troube?
Many thanks,
Aurel