Errors in alert log

Hi experts,

I have seen some errors in alert log file.

> pleaes refer below alter log contents -
>
>
> Mon Dec  3 09:56:26 2007
> Thread 1 advanced to log sequence 75248
>  Current log# 1 seq# 75248 mem# 0: /mtsoradata4/MATRIX/MATRIXredo01.log
>  Current log# 1 seq# 75248 mem# 1: /mtsoradata5/MATRIX/MATRIXredo01a.log
> Mon Dec  3 09:56:26 2007
> ARC1: Evaluating archive   log 2 thread 1 sequence 75247
> ARC1: Beginning to archive log 2 thread 1 sequence 75247
> Creating archive destination LOG_ARCHIVE_DEST_1:
> '/mtsarchive/MATRIX/archive/matrix175247.arc'
> ARC1: Completed archiving  log 2 thread 1 sequence 75247
> Mon Dec  3 09:56:45 2007 *
> Process P006 started up but failed with error = 20* *
> Mon Dec  3 09:56:47 2007* *
> Process P006 started up but failed with error = 20* *
> Mon Dec  3 09:57:03 2007* *
> Process P006 started up but failed with error = 20* *
> Mon Dec  3 09:57:16 2007* *
> Process P006 started up but failed with error = 20* *
> Process P006 started up but failed with error = 20* *
> Mon Dec  3 09:57:50 2007* *
> Process P006 started up but failed with error = 20* *
> Process P006 started up but failed with error = 20*
>
What are these error?
Please suggest.
sunitdhakeAsked:
Who is Participating?
 
AkenathonConnect With a Mentor Commented:
Pnnn are parallel query slaves, Oracle tried to start some but could not due to OS error 20. Check your OS log and cross-check what events are logged at that time (/var/syslog, or wherever your flavour of *nix happens to have it)
0
 
schwertnerConnect With a Mentor Commented:
There are many reasons for that.
Check the alert log files for detail explanation.
Check the available RAM and disk space.
0
 
FayyazConnect With a Mentor Commented:
It relates to parallel Query option. It may be due to the fact that, you have configured your server for parallel server, but there are not enough servers (processors ) that you want to use. For example, in your machine, you have only two processors... but in your queries you are trying to use more than 2 processors using PARALLEL_MAX_SERVERS parameter.

Please check the No. of processors in your machine and value of PARALLEL_MAX_SERVERS parameter.
0
 
Computer101Commented:
Forced accept.

Computer101
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.