From: Thomas, Thomas (ThomasT@pginw.com)
Date: Thu Feb 19 2004 - 18:05:42 EST
Dear Managers,
We observed that the database connections were being established to ics0.
The database listener log file shows,
19-FEB-2004 06:38:14 *
(CONNECT_DATA=(SID=dbsid)(CID=(PROGRAM=)(HOST=host.domain.com)(USER=oracle))
) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.X.X.X2)(PORT=9175)) * establish * DBSID
* 0
19-FEB-2004 06:38:14 *
(CONNECT_DATA=(SID=dbsid)(CID=(PROGRAM=)(HOST=host.domain.com)(USER=oracle))
) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.X.X.X2)(PORT=9171)) * establish * DBSID
* 0
The address 10.X.X.X2 is the cluster interconnect (ics0).
My question is why is the database using the cluster interconnect (ics0) to
make the Oracle SQL*Net connections.
Is there any way to use the NIC port (tu0) instead? What needs to be
configured to use tu0 ?
The database tnsnames.ora and listener.ora files are configured to use the
hostname (host.domain.com).
But somehow in the connection process it gets re-directed to ics0
(10.X.X.X2).
The enrty in /etc/hosts file is,
10.X.X.X2 hostname-ics0
10.Y.Y.Y2 host.domain.com
This does not happen on our development server. The connections there are
correctly being established to the network interface (tu0).
We think this may be the reason for performance degradation on our
production server. Your advice will be much appreciated.
Thanks,
Thomas
------------ PGI Internet E-mail Confidentiality ------------ Please note:
This message may contain information which is privileged and confidential.
If you are not the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you believe you have received this message in error, please
forward to Postmaster@pginw.com.
------------ Confidencialidad de Correo Electronico de PGI ------------
Nota: Este mensaje puede contener informacion privilegiada y confidencial.
Si usted no es el destinatario, esta notificado que cualquier diseminacion,
distribucion o copia de esta comunicacion esta estrictamente prohibida. Si
usted cree que ha recibido este mensaje por error, por favor reenvielo a
Postmaster@pginw.com. (Informacion intencionalmente sin acentos)
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:49:52 EDT