connecting to ORACLE

[Wodisch]

Hello Kapil,

well, first, how long does the name resolution of the
client's hostname into an ip-addr (and vice versa) last
on the server?
You could run a loop to this for about a hundred times
to get some average value... Is this slow? Then check
"/etc/nsswitch.conf" and "/etc/reolv.conf" on that server.

Second, could you do that kind of benchmarking from
the client to the server using "tnsping"? Again for a
couple of times? How fast is "tnsping" on reaching the
server?

What is the ouput of that "tnsping" showing: which
config files does it use, those in "/etc/" or those in
"$ORACLE_HOME/network/admin/"? Are they the ones
you changed?

Third, have a look into your "listeners'" log files (in
"$ORACLE_HOME/network/log/") if there are any
errors in there.
Check the output of your "lsnrctl start" and of your
"lsrnctl status", does this refer to the "/etc/" or the
other directory?

As far as I know, you do not get any patches for Oracle7
from Oracle corp. any longer, but do you have a current
state of patches? Check against Oracle's patch server
and Oracle Technet, perhaps.

Did you relink the Oracle codefiles after patching HP-UX?
If not, do it (well, after a backup, of course ;-).

HTH,
Wodisch

[makoto uchino]

Hello Kapil,

PROTOCOL.ORA is protocol specific configuration file.

The following protocols require you to configure additional parameters, syntax is
LOCAL_LOOKUP=alias (The LOCAL_LOOKUP parameter points to a non-global address in a PROTOCOL.ORA file) in TNSNAMES.ORA or LISTENER.ORA

APPC/LU6.2
ASYNC
X.25
OSI4

To configure persistent buffer flushing, add the following parameter in your PROTOCOL.ORA file:

tcp.nodelay = yes

Please refer to Net8 Administrator's Guide.