tnsping does not check for "CONNECT_DATA" line in tnsnames.ora file
Make sure this line has the correct SERVICE_NAME or SID
Regards
Joseph Amalraj
Jonathan Knight wrote: > tnsping doesn't give any additional information. > Below is the entire output from tnsping: > > C:\Documents and Settings\JonK>tnsping clsdev.world > > TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 > - Production on 18-JAN-2006 09:45:21 > > (c) Copyright 1997 Oracle Corporation. All rights > reserved. > > Attempting to contact > (ADDRESS=(PROTOCOL=TCP)(HOST=ud505)(PORT=1521)) > OK (110 msec) >
-- Regards
Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- http://www.freelists.org/webpage/oracle-l
<DIV>This shows that is is using 8.1.7.0.0,</DIV> <DIV> </DIV> <DIV>the listener is up on the host.</DIV> <DIV> </DIV> <DIV>tnsping does not check for "CONNECT_DATA" line in tnsnames.ora file </DIV> <DIV> </DIV> <DIV>Make sure this line has the correct</DIV> <DIV>SERVICE_NAME</DIV> <DIV>or </DIV> <DIV>SID</DIV> <DIV> </DIV> <DIV>Regards</DIV> <DIV> </DIV> <DIV>Joseph Amalraj<BR></DIV> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Jonathan Knight wrote: <BR>> tnsping doesn't give any additional information. <BR>> Below is the entire output from tnsping:<BR>> <BR>> C:\Documents and Settings\JonK> ;tnsping clsdev.world<BR>> <BR>> TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0<BR>> - Production on 18-JAN-2006 09:45:21<BR>> <BR>> (c) Copyright 1997 Oracle Corporation. All rights<BR>> reserved.<BR>> <BR >> Attempting to contact<BR>> (ADDRESS=(PROTOCOL=TCP)(HOST=ud505)(PORT=1521))<BR>> OK (110 msec)<BR>> <BR><BR>-- <BR>Regards<BR><BR>Wolfgang Breitling<BR>Centrex Consulting Corporation<BR>www.centrexcc.com<BR>--<BR>http://www.freelists.org/webpage /oracle-l<BR><BR><BR></BLOCKQUOTE> <DIV><BR></DIV>
