Errors in alert log

Posted on 2007-12-06
Last Modified: 2013-12-19
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.
Question by:sunitdhake
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 11

Accepted Solution

Akenathon earned 168 total points
ID: 20418518
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)
LVL 48

Assisted Solution

schwertner earned 166 total points
ID: 20419258
There are many reasons for that.
Check the alert log files for detail explanation.
Check the available RAM and disk space.

Assisted Solution

Fayyaz earned 166 total points
ID: 20571466
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.

Expert Comment

ID: 20936939
Forced accept.

Community Support Moderator

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question