I am trying to set up an Oracle 11g database server on windows 2008 R2. The server runs in VMWare Player which runs on Windows 7 Enterprise edition. The host and virtual pcs are connected with a bridged network. I can ping the virtual pc from the host pc:
PS C:\Users\wikus> ping testdbserver
Pinging testdbserver [fe80::ac94:69d8:74a9:f8e9%25] with 32 bytes of data: Reply from fe80::ac94:69d8:74a9:f8e9%25: time<1ms
etc.
When I try to tnsping the virtual pc, I see this:
PS C:\Users\wikus> tnsping testdbserver
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 30-JAN-2012 13:05:13
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files: C:\Oracle\product\11.1.0\client_1\network\admin\sqlnet.ora
Used EZCONNECT adapter to resolve the alias Attempting to contact
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=169.254.248.233)(PORT=1521
))) TNS-12532: TNS:invalid argument
I can tnsping the DB server (using the same command) when I am logged into the DB server. (ie. In the VM from the command line). I can also log in to the HR sample database.
This is the listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\Oracle_Server\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle_Server\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = testdbserver)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\Oracle_Server
Additional Info: I do not have "@" in any password. All firewalls are disabled.
Do anyone know what may cause this?