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.
Asked
Active
Viewed 636 times
2
marc_s
- 9,052
- 6
- 46
- 52
smn_onrocks
- 119
- 3
1 Answers
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.