Hi all,

There are two hosts (A & B) as Oracle clients connect to a Oracle server. From host A, using tnsping have good result

A$ /opt/app/oracle/product/9.2.0.1.0/bin/tnsping crbt

TNS Ping Utility for Solaris: Version 9.2.0.1.0 - Production on 16-MAR-2007 16:24:41

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/opt/app/oracle/product/9.2.0.1.0/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Oracle-1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = crbt)))
OK (70 msec)

But from host B, using rsh to check DB connectivity of A, it doesn't work

B$ rsh A -l user /opt/app/oracle/product/9.2.0.1.0/bin/tnsping crbt

TNS Ping Utility for Solaris: Version 9.2.0.1.0 - Production on 16-MAR-2007 16:06:34

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS

If you experience with this, appreciate for advice.

Thanks,
milo

Ok here is what I would guess. When you "rsh" the ORACLE related env variables (E.g $ORACLE_SID, $ORACLE_HOME) do not get set and that's why the tnsping fails.

So, what you have to basically do is write a wrapper script script around tnsping which set the env variables and then call that script from the rsh.

E.g mytnsping.sh
#!/bin/sh

export ORACLE_SID=/aaa/bbb/watever1
export ORACLE_HOME=/ccc/ddd/watever2

/opt/app/oracle/product/9.2.0.1.0/bin/tnsping crbt

Now, call this from rsh like

rsh A -l user mytnsping.sh

Let me know if this works. This is only a guess - I did not try it