Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Strange problem
Solved...
Apparently it was a switch (network) problem... The machine has been hooked up, since yesterday, with a new network cable on a different switch. When using the old switch with the old network cable everything works OK. When using the new network connection on the different switch "large" data statements (like creating "big" PL/SQL objects) the session hangs for a long period of time (no return data, timeperiod >= 30 min). Select statements work in both situations as normal (at least not really noticable difference)...
GrZ
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Marco Gralike
Sent: dinsdag 12 juni 2007 10:27
To: oracle-l_at_freelists.org
Subject: Strange problem
The following strange issue happens...
I got a HPUX 11.23 machine.
When I connect remote via SQLPlus (SQLNET) to this database, I can select stuff etc.
A compile action of a trigger hangs the SQLPlus session (no locks, no
traces, no waiting seen from the database) The same action is doing fine
(compiling the trigger) on the machine itself via direct (using
ORACLE_SID) or SQLNET...
It looks like there is some kind of firewall / name resolution thingy going on.
As far as I (not HPUX specialist) can see the firewall is disabled and bastille (which apparently is default nowadays) is hopefully not into effect.
Does someone has any pointers ??? Would appriciate it
THX Marco
amisux08:[MTSO]:/oracle/10.2> lsnrctl status
LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 12-JUN-2007 10:23:32
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=amisux08)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for HPUX: Version 10.2.0.2.0 - Production Start Date 12-JUN-2007 07:23:06 Uptime 0 days 3 hr. 0 min. 26 sec Trace Level off Security ON: Password or Local OS Authentication SNMP OFF Listener Parameter File /oracle/network/admin/listener.ora Listener Log File /oracle/network/log/server/listener.logListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=amisux08.amis.local)(PORT=1521
)))
Services Summary...
Service "MTSO.amis.nl" has 1 instance(s).
Instance "MTSO", status READY, has 1 handler(s) for this service...
Service "MTSO_XPT.amis.nl" has 1 instance(s).
Instance "MTSO", status READY, has 1 handler(s) for this service...
Service "MTSTXDB.amis.nl" has 1 instance(s).
tnsnames entry
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=10.252.252.8)(Po
rt=1521)))(CONNECT_DATA=(SERVICE_NAME=mtso.amis.nl)(SRVR=DEDICATED)))
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 12 2007 - 08:36:47 CDT
![]() |
![]() |