Skip to Content
0
Former Member
Feb 07, 2009 at 06:20 AM

data bace check log error

119 Views

hi to experts,

i am using orcale 10.2 with ecc6.0 on windows 2003 and i am taking daily online backup through assigning in db13 evrey thing is ok .but before some days i got a run time error.

Runtime Errors DBIF_REPO_SQL_ERROR

The system is no longer linked to an ORACLE instance. |

| No further operations can be performed on the database.

and after that i check DB13 then i found no back up activity has done....when i check the error then i found the log

SQL error -20 at location BrDbConnect -2

ORA-00020 maximum no of processes(%s) exceeded

so i restart the server all CI,DI,and application server

and try to initilaze the tape through DB13 but it is not completed show the error in log

BR0301E SQL error -27046 at location BrInitOraCreate-3

ORA-27046: file size is not a multiple of logical block size

then i change the Processes 300 in INT.ORA and spfile and then restart the server

server started properly but after 1 minutei found all workprocess stop....so again i restart and alter the database

as alter system set processes=300 scope=spfile:

and commit:

then again restart

but server started peoperly all process comes into green and work process also show wait status but with in 1 minute thsese are stop....

so again i go through command promt level and through sqlplus

SQL> shutdown immediate

and then SQL>startup

and after that try to start server it works and also back up activity also completed.

Tape Initilize and whole online databace backup+redolog back up and updatics and check log.all are ok

but get the two error in DB16

QUERY_REWRITE_ENABLED

TYPE =PROF

Description =Value: TRUE (<> FALSE) # Allow rewrite of queries using materialized views

00600

TYPE=ORA

Description =Time: 2009-02-05 21.33.06, line: ORA-00600: internal error code, arguments: [733], [538970172], [pga heap], [], [], [], [], []

provide me the solution for that

Thanks & regards

dik