RE: Strange problem

  • From: "Marco Gralike" <Marco.Gralike@xxxxxxx>
  • To: "Marco Gralike" <Marco.Gralike@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 12 Jun 2007 15:36:47 +0200

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Marco Gralike
Sent: dinsdag 12 juni 2007 10:27
To: oracle-l@xxxxxxxxxxxxx
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.log
Listening 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-l


Other related posts: