Hi People,
I know the same question has been asked million times but none of them matches mine. So please help.
Platform: Windows Server 2008 R2 64bit
Database: Oracle 11.2 64 bit
I have both Client and Server installed.
The server is on D:\app\Administrator
The client is on E:\app\Administrator
The server name is HOMER2922-DC1.homer2922.local
It looks like there is no problem to tnsping the server
C:\Users\Administrator.HOMER2922-DC1>tnsping homer2922-dc1.homer2922.local
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 08-AUG-2013 21:40:50
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
E:\app\Administrator\product\11.2.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=fe80::4db:1a2a:3f57:ff57%13)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.168)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=2001:0:9d38:953c:4db:1a2a:3f57:ff57)(PORT=1521)))
OK (10 msec):
here is my tnsname.ora:
homer=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOMER2922-DC1.homer2922.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = homer)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
The listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = HOMER2922-DC1.homer2922.local)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Administrator
I couldn't figure what was wrong.
Appreciated for any helps.
JB.