Solution required soon
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Solution required soon

Hybrid View

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Solution required soon

    If the listener is not started in my database(Name:db(running in UNIX)),everything works fine,but if i start the listener,
    suddenly my system hanged up,while i checking the process using,
    it shows the following result(i ever seen this before)

    ps -ef | grep db (only part of output is shown)

    oracle 3301534 1 0 21:16:53 - 168:42 ora_j003_db
    oracle 3305568 1 0 11:22:10 - 0:00 oracledb (LOCAL=NO)
    oracle 3309786 1 0 11:19:54 - 0:00 oracledb (LOCAL=NO)
    oracle 3313704 1 0 11:16:50 - 0:00 oracledb (LOCAL=NO)
    oracle 3317970 1 0 11:22:03 - 0:00 oracledb (LOCAL=NO)
    oracle 3322070 1 0 11:17:37 - 0:00 oracledb (LOCAL=NO)
    oracle 3326064 1 0 11:20:01 - 0:00 oracledb (LOCAL=NO)
    oracle 3461188 1 0 21:16:43 - 0:09 ora_smon_db
    oracle 3465442 1 1 21:20:29 - 3:01 oracledb (LOCAL=NO)
    oracle 3473650 1 1 21:20:29 - 2:59 oracledb (LOCAL=NO)
    oracle 3477646 1 0 11:19:47 - 0:00 oracledb (LOCAL=NO)
    oracle 3481604 1 1 21:20:28 - 3:03 oracledb (LOCAL=NO)
    oracle 3485716 1 0 11:19:24 - 0:00 oracledb (LOCAL=NO)
    oracle 3490002 1 0 11:16:56 - 0:00 oracledb (LOCAL=NO)
    oracle 3493928 1 2 21:20:29 - 3:07 oracledb (LOCAL=NO)
    oracle 3498160 1 0 11:21:02 - 0:00 oracledb (LOCAL=NO)
    oracle 3502110 1 0 11:19:44 - 0:00 oracledb (LOCAL=NO)
    oracle 3506200 1 0 11:19:12 - 0:00 oracledb (LOCAL=NO)
    oracle 3510494 1 0 11:22:01 - 0:00 oracledb (LOCAL=NO)
    oracle 3514406 1 0 11:19:48 - 0:00 oracledb (LOCAL=NO)
    oracle 3518624 1 2 05:32:33 - 7:43 ora_j015_db
    oracle 3522720 1 0 11:19:42 - 0:00 oracledb (LOCAL=NO)
    oracle 3530796 1 0 11:21:45 - 0:00 oracledb (LOCAL=NO)
    oracle 3539098 1 0 11:19:14 - 0:00 oracledb (LOCAL=NO)
    oracle 3543258 1 0 11:22:04 - 0:00 oracledb (LOCAL=NO)
    oracle 3547254 1 0 11:19:11 - 0:00 oracledb (LOCAL=NO)
    oracle 3555538 1 0 11:19:44 - 0:00 oracledb (LOCAL=NO)
    oracle 3559534 1 0 11:19:45 - 0:00 oracledb (LOCAL=NO)
    oracle 3563622 1 0 11:19:45 - 0:00 oracledb (LOCAL=NO)
    oracle 3567850 1 3 05:32:33 - 9:27 ora_j014_db
    oracle 3571934 1 0 11:20:17 - 0:00 oracledb (LOCAL=NO)
    oracle 3576060 1 0 11:19:53 - 0:00 oracledb (LOCAL=NO)
    oracle 3579922 1 0 11:20:27 - 0:00 oracledb (LOCAL=NO)
    oracle 3584226 1 0 11:19:13 - 0:00 oracledb (LOCAL=NO)
    oracle 3588248 1 0 11:19:19 - 0:00 oracledb (LOCAL=NO)
    oracle 3592430 1 0 11:19:12 - 0:00 oracledb (LOCAL=NO)

    When i checked the alert log,it contains the following entries which
    i can't understand,

    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3
    skgpspawn failed:category = 27142, depinfo = 11, op = fork, loc = skgpspawn3

    Now i cant open to any session & even can't execute a single command in
    the server,It says,
    ksh: 0403-030 The fork function failed. Too many processes already exist.

    please help in sorting out this problem as soon as possible.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    it tells you the problem, Too many processes already exist. You need to do some investigation

  3. #3
    Join Date
    Feb 2006
    Posts
    162
    Can you tell me what kind of procces is this,"oracledb (LOCAL=NO)oracledb (LOCAL=NO)",why it's generated so many?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    that is someone trying to connect to your database, you have lots of connections coming in from somewhere.

    You need to investigate

  5. #5
    Join Date
    Sep 2005
    Location
    Germany
    Posts
    2
    Hi,
    tell your system administrator to increase the number of possible processes on your server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width