Re: ORA-00600: internal error code
- From: Uwe Küchler <uwe@xxxxxxxxxxxx>
- To: dmarc-noreply@xxxxxxxxxxxxx
- Date: Sun, 30 Nov 2014 13:28:05 +0100
Mostafa,
as for the ORA-600 you should try the
“ORA-00600-Troubleshooting Tool
<https://support.oracle.com/epmos/faces/ui/gr/GrHome.jspx?domainId=ORA600>”
on My Oracle Support for a suggestion. Upload the corresponding trace
file or an IPS package and see what the tool comes up with.
As for the recovery error, you didn't provide us with much information.
Why did you have to "recover database" in the first place? Could it be
that your database is already open instead of just mounted?
Regards,
Uwe
---
http://oraculix.com/
On 30.11.2014 11:55, Mostafa Eletriby (Redacted sender m_etrib@xxxxxxxxx
for DMARC) wrote:
> Hello DBAs,
> I have a problem regarding Ora-600 error at Alert log file.
> It appears regularly at alert log file and stops database and needs to
> re-open database.
> Please tell me which procedures that I should follow in order to solve
> the problem.
>
> Database has no previous backup taken.
> Database was in no archive mode before problem happened but now it is
> switched to archive log mode
>
> ------------------------------------
> SQL> recover database;
> ORA-00283: recovery session canceled due to errors
> ORA-01124: cannot recover data file 1 - file is in use or recovery
> ORA-01110: data file 1: '/oraData/cdsdb/system01.dbf'
>
>
> Please advice me.
>
> Thanks
> Regards,
>
>
Other related posts:
