Home » RDBMS Server » Server Administration » Solution required soon
Solution required soon [message #174395] Mon, 29 May 2006 01:57 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
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.

Report message to a moderator

Re: Solution required soon [message #174417 is a reply to message #174395] Mon, 29 May 2006 04:06 Go to previous messageGo to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
this looks like some operating system resource issue. one suggestion is to try to increase the processes parameter.

first check its current value by:

show parameter processes


and then try to increase that value by 200 and check. how much ram do u have and also post output of show sga command. also look at listern logs to check if there are any messages there.

Report message to a moderator

Re: Solution required soon [message #174466 is a reply to message #174395] Mon, 29 May 2006 05:26 Go to previous messageGo to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
Can you tell me what kind of procces is this,"oracledb (LOCAL=NO)oracledb (LOCAL=NO)",why it's generated so many?

Report message to a moderator

Re: Solution required soon [message #174481 is a reply to message #174466] Mon, 29 May 2006 06:23 Go to previous message
orausern
Messages: 826
Registered: December 2005
Senior Member
They represent the oracle processes for client connetions to the server...

e.g. every time when you connect to oracle from client (e.g. using sql plus) the one more process is added and when u disconnect, one process is removed:

e.g. in my solaris system:

$ps -ef | grep "LOCAL" | wc -l
      32
--after disconnecting one of my sql plus client session..
$ps -ef | grep "LOCAL" | wc -l
      31
--after disconnecting one of my sql plus client session..
$ps -ef | grep "LOCAL" | wc -l
      30

[Updated on: Mon, 29 May 2006 06:24]

Report message to a moderator

Previous Topic: Snapshot Tablespace
Next Topic: Finding & Removing Duplicates
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 11:37:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.