Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Failed To Start A Dedicated Server Process

user522620May 16 2008 — edited May 30 2008

Hi
Oracle 9.2
Windows Advanced OS
6G Ram

We switched our server from Shared Server to Dedicated. All was going well, but suddenly no one could log in. Currently logged in users were okay.

Alert Log showed several of the following errors:
skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn

No errors in the listener.log

Attempted login with sqlplus reported ORA-12500: TNS:listener failed to start a dedicated server process

At the time less than 2G of the 6G was being utilized.

Also, during the time of this event, the event log showed several of the following:
Event Type: Error
Event Source: Oracle.ACP
Event Category: None
Event ID: 31
Date: 5/16/2008
Time: 9:48:59 AM
User: N/A
Computer: ACP
Description:
Unable to begin another thread.

Any help would be appreciated.
kd

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2008

Added on May 16 2008

#general-database-discussions

12 comments

10,947 views