Hi,
I can't seem to tnsping the source db into target db.
Here's the source db's tnsnames.ora:
cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
DBA134 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dba134)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dba134)
)
)
the IP of dba134 is 192.168.1.2.
And here's the target db's tnsnames.ora:
# tnsnames.ora Network Configuration File: C:\app\Tayeen\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
dba134_1521 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =dba134)
)
)
Now, I cannot tnsping dba134_1521. The ping 192.168.1.2 seems to be doing okay but telnet 192.168.1.2 1521 is failing. What am I doing wrong? My Firewall is turned off as well.