Topic: Database Administration >> TNSPING
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| shahul |
Posted: Dec 31, 2007 09:21:12 AM |
Total Post: 17
Joined: Sep, 2007
|
Hi guys,
I have some problem related to tnsping.
I have two database. one is oracle 9i(vm1) running in RH-4 ES,and another is oracle 10g(orcl) running in windows XP.
I can able to ping form linux to windows as well as tnsping and able to connect 10g database(orcl) from linux.
but i could able to ping from windows to linux but not able tnsping from windows. Can you please help me from this problem.
im giving the error below:
C:\Documents and Settings\Shahul>tnsping vm1
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 31-DEC-2007 19:36:02
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.70.18.10)(PORT = 1521))) (CONNECT_DATA = (SE
RVICE_NAME = vm1)))
TNS-12560: TNS:protocol adapter error
C:\Documents and Settings\Shahul>ping 10.70.18.10
Pinging 10.70.18.10 with 32 bytes of data:
Reply from 10.70.18.10: bytes=32 time<1ms TTL=64
Reply from 10.70.18.10: bytes=32 time<1ms TTL=64
Reply from 10.70.18.10: bytes=32 time<1ms TTL=64
Reply from 10.70.18.10: bytes=32 time<1ms TTL=64
Ping statistics for 10.70.18.10:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
C:\Documents and Settings\Shahul>
Here is the result from Linux server.
[oracle@Slash ~]$ tnsping orcl
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 31-DEC-2007 19:40: 05
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/u01/app/oracle/product/9.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.70.18.8)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE _NAME = orcl)))
OK (40 msec)
[oracle@Slash ~]$ ping 10.70.18.8
PING 10.70.18.8 (10.70.18.8) 56(84) bytes of data.
64 bytes from 10.70.18.8: icmp_seq=0 ttl=128 time=12.8 ms
64 bytes from 10.70.18.8: icmp_seq=1 ttl=128 time=1.27 ms
64 bytes from 10.70.18.8: icmp_seq=2 ttl=128 time=0.176 ms
--- 10.70.18.8 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2002ms
rtt min/avg/max/mdev = 0.176/4.775/12.880/5.748 ms, pipe 2
[oracle@Slash ~]$
Im Also giving the sqlnet.ora file in Linux server.
# SQLNET.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
And the Sqlnet.ora file from windows server.
# sqlnet.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Please advice me to rectify the problem.
Thanks in Advance,
Wish you all the HAPPY NEW YEAR 2008........................
|
|
|
 Mohammed Taj |
| Posted: Dec 31, 2007 09:25:25 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Dear,
what you tnsping ? VM1 OR ORCL ?
can you post here your tnsnames.ora file...
and did you tnsping ORCL on windows machine ?
|
|
|
|
|
| vikhardba |
| Posted: Dec 31, 2007 11:35:52 AM | |
|
Total Post: 86
Joined: Apr, 2007
|
Use netca to delete existing listener and tns ..
Select listener configuration > delete > select a listener you want to delete.
LIke wise, delete tnsname, again run netca > local net service name configuration > delete and follow wizard. Follow same on Windows XP too.
Once it is confirmed, recreate both listener and tns ... hope this should resolve your issue.
|
|
|
|
|
| shahul |
| Posted: Jan 01, 2008 07:41:08 AM | |
|
Total Post: 17
Joined: Sep, 2007
|
hi Taj,
Im Tnsping VM1 from windows.
This is my tnsnames.ora file.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.70.18.8)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
# tnsnames.ora Network Configuration File: D:\oracle1\ora92\bin\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
HGDENDC2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.102)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hgdendc2)
)
)
HGREP1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.160.61)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hgrep1)
)
)
ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.70.18.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
VM1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.70.18.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vm1)
)
)
VMWAREDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.70.18.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vmwaredb)
)
)
Where HREP1 and HGDENDC1 are client machine running with oracle 9i and im able tnsping and as well as able connect those db from windows server.
Thanks and Regards.
Shahul
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 816 |
| Mohammed Taj | 746 |
| Jayanta Sur | 479 |
| positive fanatic | 418 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 250 |
| Ramesh Jois | 245 |
| neeraj sharma | 243 |
| Bishal Khetan | 207 |
|
|
