OraFAQ Forum: Data Guard » urgent please

Home » Server Options » Data Guard » urgent please

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

urgent please [message #235917]

Tue, 08 May 2007 07:18

zuhair
Messages: 12
Registered: February 2007
Location: DUBAI

Junior Member

dear all ,

after i implemnt the dataguard i usually fing these error in alert log

skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn

please any help,
regards

Report message to a moderator

Re: urgent please [message #235985 is a reply to message #235917]

Tue, 08 May 2007 10:46

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

Seems your machine is running out of memory or low memory due to overload of system.

Report message to a moderator

Re: urgent please [message #236072 is a reply to message #235985]

Wed, 09 May 2007 00:11

zuhair
Messages: 12
Registered: February 2007
Location: DUBAI

Junior Member

dear Sir,
MY PHYSICAL MEMORY IS 6 gb ,AND MY sga IS 2500 mb,
WHAT I HAVE TO DO ,

THANKS

Report message to a moderator

Re: urgent please [message #236169 is a reply to message #236072]

Wed, 09 May 2007 04:14

sriram717
Messages: 48
Registered: February 2007
Location: UNITED KINGDOM

Member

Contact Oracle support , raise a support case

Report message to a moderator

Re: urgent please [message #236553 is a reply to message #235917]

Thu, 10 May 2007 04:34

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

Found this through Google:

This is related to dispatcher (MTS/Shared server).
The dispatcher was unable to spawn a new shared server process to handle requests.
When you are running shared server (MTS) and more shared servers need to be started, they are automatically started up to the number of max shared servers specified in the init.ora file.
This problem is occurring because you are running out of resources on your machine that are required for the servers to startup.

Solutions:
1. Increase swap or memory.
2. Reduce the number of shared servers (dispatchers) that can be started.

Report message to a moderator

Re: urgent please [message #236566 is a reply to message #236553]

Thu, 10 May 2007 04:49

zuhair
Messages: 12
Registered: February 2007
Location: DUBAI

Junior Member

dear mlgoins,
my database is not working in MTS ,

regards

Report message to a moderator

Re: urgent please [message #236619 is a reply to message #235985]

Thu, 10 May 2007 07:18

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

Okay, here's another response from someone who encountered the error (also from a google search). He encountered it after doing a patch:

Check the parameters. Perhaps "maxuprc" and "shmmax" have dropped back to default values? Both are dynamic so they were changed immediately.

Possible cause....the system file had somehow gotten out of whack, so when patches were loaded and kernel rebuilt it used a system file that did not have these parms values contained in it, thus causing them to drop back to default values.

Report message to a moderator

Re: urgent please [message #236624 is a reply to message #236619]

Thu, 10 May 2007 07:26

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

Last thought from google -- perhaps it's an operating system limit:

"Check the oracle account's process limits. Is the executable
large memory enabled? (Check the comp.unix.aix archive on google
for an environment variable you can set to make a process run with large memory support.)"

Hope that helps,

Mike

Report message to a moderator

Re: urgent please [message #236627 is a reply to message #236624]

Thu, 10 May 2007 07:32

zuhair
Messages: 12
Registered: February 2007
Location: DUBAI

Junior Member

dear Mike,
i faced this error after i implement dataguard,
my operating system is windows 2003 server
physical RAM is 6 GB
SGA is 2.6 GB
PGA is 256 MB
how i can Check the oracle account's process limits?

Many Thanks

Report message to a moderator

Re: urgent please [message #236647 is a reply to message #236627]

Thu, 10 May 2007 08:38

mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO

Senior Member

You might check with a Windows System Administrator -- I'm not sure how windows manages memory allocation to specific applications, or how that is adjusted. Good luck!

Mike

Report message to a moderator

Previous Topic:	Port usage
Next Topic:	REDO LOGS IN STANDBY DATABASE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 18:16:07 CST 2025