2 Replies Latest reply: Sep 27, 2013 2:11 AM by SamikAcharya RSS

    Multiple insertion problem

    SamikAcharya

      when two or more clients trying to insert data even into different tables, database will not work and needs to be restarted... ... i am using Oracle 10G  Enterprise Edition (10.2.0.1.0)  on Red Hat Linux 32bits OS...

       

      actually i've no clear idea about this restart problem what would be the possible way to track the error. i noticed some exception in my java application when accessing database at that time .

       

      Feel free to know any more info or way to extract the info, if you need

       

      These are some values collected from DBA_ALERT_HISTORY. column names and values are provided for 4 (four) records at the time restarting

      -

      Record 1-

      Reason Id-121

      object_name-Concurrency

      object type-EVENT_CLASS

      Reason- Metrics "Database Time Spent Waiting (%)" is at 31.35287 for event class "Concurrency"

      Metric Value-31.352871419091333

      Suggested Action-Run ADDM to get more performance analysis about your system.

      Message Type-Notification

      Message Group-Performance

      Message Level-32

      Module Id-SERVER MANAGEABILITY:kelr.c

       

      Record 2-

      Reason Id-135

      object_name-jpcdb.jpc.org

      object type-INSTANCE

      Reason- Instance jpcdb.jpcdb.jpc.org up on node dbserv.jpc.org as of time 2013-09-23 16:15:35.000000000 +05:30; reason code: user

      Metric Value-0

      Suggested Action-No action is necessary

      Message Type-Warning

      Message Group-High Availability

      Message Level-5

      Module Id-Clusterware:IMON:clsrfdbe.pc

       

      Record 3-

      Reason Id-136

      object_name-jpcdb.jpc.org

      object type-INSTANCE

      Reason- Instance jpcdb.jpcdb.jpc.org down on node dbserv.jpc.org as of time 2013-09-23 16:15:34.000000000 +05:30; reason code: unknown

      Metric Value-0

      Suggested Action-Restart if desired and not automatically restarting

      Message Type-Notification

      Message Group-High Availability

      Message Level-32

      Module Id-Clusterware:IMON:clsrfdbe.pc

       

      Record 4-

      Reason Id-121

      object_name-Other

      object type-EVENT_CLASS

      Reason- Metrics "Database Time Spent Waiting (%)" is at 0 for event class "Other"

      Metric Value-0

      Suggested Action-Run ADDM to get more performance analysis about your system.

      Message Type-Notification

      Message Group-Performance

      Message Level-32

      Module Id-SERVER MANAGEABILITY:kelr.c