Oracle hangs!

Hi all,

We are experiencing some strange symtoms. For the first time ever, I have seen Oracle just hang!

We are running Oracle 734 on Sun 5.6.
One instance has two databases:
ORACLE_SIDs: ntst1, and ltfd1.

The main database is ntst1. I added ltfd1 recently. Each database is set to 100 processes.

The developers are running a java process that polls the database once a minute. It can then do a select and an insert.

The developer was minding his own business, and suddenly the database just hung. He was trying to select * from a small table. I could get on, but it just hung for me too.

A shutdown immediate just hung also.
Shutdown abort worked. It restarted and worked fine.

The crazy thing is that there is no error message.

Last night, I resized the main tablespace. I also had to change, in the /etc/system file: set semsys:seminfo_semmns=400

I notice that there are lots of processes for the first database, but only a few for the other one. Did I fail to set something up?

$ ps -e -f |grep ora |grep ntst1

  oracle  1627     1  0 19:13:16 ?        0:13 ora_dbwr_ntst1
  oracle  1625     1  0 19:13:16 ?        0:00 ora_pmon_ntst1
  oracle  1629     1  0 19:13:16 ?        0:00 ora_arch_ntst1
  oracle  1633     1  0 19:13:16 ?        0:00 ora_smon_ntst1
  oracle  1635     1  0 19:13:16 ?        0:00 ora_reco_ntst1
  oracle  1667  1666  0 19:13:27 ?        0:00 oraclentst1

  oracle 1665 1664 0 19:13:27 ? 0:00 oraclentst1
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

  oracle 1659 1658 1 19:13:25 ? 2:36 oraclentst1
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

  oracle 1663 1662 0 19:13:26 ? 0:00 oraclentst1
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

  oracle 1661 1660 0 19:13:26 ? 0:00 oraclentst1
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

  oracle  1631     1  0 19:13:16 ?        0:02 ora_lgwr_ntst1
  oracle  3409     1  0 10:05:12 ?        0:42 oraclentst1 (LOCAL=NO)
  oracle  3392     1  0 10:01:44 ?        0:01 oraclentst1 (LOCAL=NO)
  oracle  3888     1  0 11:15:07 ?        0:00 oraclentst1 (LOCAL=NO)


$ ps -e -f |grep ora |grep ltfd1
  oracle  3989     1  0 11:36:13 ?        0:02 ora_dbwr_ltfd1
  oracle  3993     1  0 11:36:13 ?        0:02 ora_lgwr_ltfd1
  oracle  3995     1  0 11:36:13 ?        0:00 ora_smon_ltfd1
  oracle  3997     1  0 11:36:13 ?        0:00 ora_reco_ltfd1
  oracle  3987     1  0 11:36:13 ?        0:00 ora_pmon_ltfd1
  oracle  4073     1  0 11:41:25 ?        0:00 oracleltfd1 (LOCAL=NO)
  oracle  3991     1  0 11:36:13 ?        0:00 ora_arch_ltfd1

Thanks,

Argosy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 28 2000 - 00:00:00 CDT