2

Last night my production server database (ORACLE 10.2.04) was showing me number of connection exceeded as some times it show me. Then as usual I shut down abort my database then at the time database start-up it just stays blank and writing no error log and alert log after 30 min I abort the shut down by CTRL+c and issue the start up process once again then in alert.log file I found the ksvcreate: Process() creation failed this error but my database failed to start up please help me out why it is happening and any solution for it or nay parameter check for it.

4
  • Please check first permission on the OS file system, either oracle is able to read and write files to that file system (where database files resides). I was also facing the same problem once.
    – user40867
    Jun 11, 2014 at 8:44
  • You might need to clear up semaphores and shared memory segments if there's still some remnants of an Oracle instance there. Edit your question with the output of ipcs -a|grep oracle
    – Philᵀᴹ
    Jun 11, 2014 at 10:50
  • 1
    "then as usual I shut down abort my database" - that is a terrible way to do "usually". shutdown abort should be the last resort. shutdown immediate should be the "usual" way of shutting down Oracle.
    – user1822
    Jun 11, 2014 at 11:52
  • This error usually indicates that the server has run out of memory Jun 17, 2014 at 14:16

1 Answer 1

0
  • Did anything on that server change recently?
  • What OS/version?
  • What hardware sizing?
  • What processes are on it?
  • How much memory is allocated for the database[s]? (sum sga & pga)

Normally this error has to do with a lack of resources. What else is running on this server that consumes memory? There is a good chance that due to lack of memory your server is swapping and doing so, it takes too long to start processes.

Monitor your memory usage.

If your application does bulk updates, without limits, this could easily fill your entire memory. See Bulk Processing with BULK COLLECT and FORALL for a good explanation. If your data set is growing over time, surprises are waiting to happen. Use limits in the pl/sql code.

Shutting down a database because there are performance problems is not exactly a solution for a problem, it is the denial of a real existing problem. Normally a database is online and available, a solid piece of foundation for an application. If your database/data has any value for your company, hire a dba to help you evaluate your systems.

4
  • No change have done recently. OS VERSION RHEL5.8 64bit. hardware Size 64Gb ram 32Gb of SWAP. 2 Processor xeon 2.4 GHz having 12 core each .SGA AND PGA 16Gb. Only Our Database is running on this server. Jun 11, 2014 at 8:07
  • don't forget that the pga_aggregate_target does not inpose a limit. Your app can easily allocate more than available memory, causing swap problems. Setup memory usage monitoring.
    – user953
    Jun 11, 2014 at 8:58
  • Could u please explain it little elaborately Jun 11, 2014 at 9:54
  • your application could be using bulk updates on large collections. See <oracle.com/technetwork/issue-archive/2012/12-sep/…> for a nice example and explanation.
    – user953
    Jun 11, 2014 at 11:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.