Connectivity errors : TNS 15241
Hello all of you,
I Installed virtual box software on my windows 7 laptop. I downloaded a virtual box VM from here http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html
On my laptop I installed too Oracle Warehouse Builder 11g Release 2 (11.2.0.1.0) Standalone Software . I would like to use this tools (Design Center,Administrators tools)
to connect to warehouse repository (builtin Oracle11gR2) inside vm . But I can not to connect :(
I can ping vm from host software . (from windows 7 command prompt I can ping 192.168.56.1 with succes).
But when I used (from the same comand prompt) "tnsping owb" (where own is a entry in tnanames.ora on my laptop) I get TNS 12541 TNS : 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 = /home/oracle/app/oracle
logging_listener_name=on
I can not connect with Administration repository neither (another tool from warehouse builder stanalone software) .
I get INS0009 Unable to connect to the database with user system java.sql.SQLException : The network adapter could not establish the connect .
Please give me a hint to solve the problem.
Many thanks,
Aurel