Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

O11.2.0.3 : ORA-00445: background process "W000" did not start after

Hello,

I regularly have the following error with an recently installed Oracle 11.2.0.3.

---

Process W000 died, see its trace file

Sun Apr 07 00:48:23 2013

***********************************************************************

Fatal NI connect error 12537, connecting to:

(LOCAL=NO)

  VERSION INFORMATION:

        TNS for Solaris: Version 11.2.0.3.0 - Production

        Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Pr

oduction

        TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production

  Time: 07-APR-2013 00:48:23

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12537

   

TNS-12537: TNS:connection closed

    ns secondary err code: 12560

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

Sun Apr 07 00:49:29 2013

opiodr aborting process unknown ospid (17179) as a result of ORA-609

Sun Apr 07 01:01:14 2013

Errors in file /oracle/xxx/saptrace/diag/rdbms/xxx/xxx/trace/xxx_smco_7937.trc  (incident=85849):

ORA-00445: background process "W000" did not start after 120 seconds

Sun Apr 07 01:03:30 2013

Incident details in: /oracle/xxx/saptrace/diag/rdbms/xxx/xxx/incident/incdir_85849/xxx_smco_7937_i85849.trc

Sun Apr 07 01:17:37 2013

Process 0x480433ce8 appears to be hung while dumping

Current time = 938816049, process death time = 938749879 interval = 60000

Attempting to kill process 0x480433ce8 with OS pid = 7937

OSD kill succeeded for process 480433ce8

Sun Apr 07 01:18:22 2013

Restarting dead background process SMCO

Sun Apr 07 01:18:38 2013

SMCO started with pid=30, OS id=26990

---

Would you know how to solve this problem?

Thanks in advance for your answer.

replied

Hello,

The problem was related to blocking write issues at the Solaris Level.

After open a Oracle Solaris SR we have changed the following kernel parameter:

  • zfs:zfs_arc_max must be lower than the free memory of the machine      
    This avoids stucks related to an over usage of the memory.
  • zfs:zfs_vdev_max_pending is set to 128
    This increases the IO throughput.
  • zfs:zfs_write_limit_min is set to 2516582400
    This avoids IO writes from starving because IO reads           have a higher priority.
  • primarycache is set to metadata for        /oracle/SID/sapdata* and /oracle/SID/oraarch filesystems      
    This avoid waste and over usage of the ZFS cache.

Regards,

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question