平臺: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

         Windows 2003(32bit)

問題：

standby database 斷電后，再啟動時startup nomount;

報錯：ORA-00600: internal error code, arguments: [733], [1780491312], [pga heap], [],[], [], [], []

參考

相关产品

Hdr: 2544998 9.2.0.1 RDBMS 9.2.0.1 RDBMS PRODID-5 PORTID-912 ORA-600
Abstract: DATABASE STARTUP FAILS WITH ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [733]

*** 09/03/02 01:53 am ***
TAR:
----

PROBLEM:
--------
1. Clear description of the problem encountered

   Database startup failes with error
   ORA-600: internal error code, arguments: [733], [538969648], [pga heap], 
    [], [], [], [], []
   Unable to open database.

2. 2. Pertinent configuration information (MTS/OPS/distributed/etc)
N/A

3. Indication of the frequency and predictability of the problem
All times

4. Sequence of events leading to the problem
Setting the parameter O7_DICTIONARY_ACCESSIBILITY=true leads to this error.

5. Technical impact on you. Include persistent after effects.
Cannot open database.

DIAGNOSTIC ANALYSIS:
--------------------

WORKAROUND:
-----------
None

RELATED BUGS:
-------------

REPRODUCIBILITY:
----------------
State if the problem is reproducible.
Yes
If so, has it been reproduced at the customer's site or in-house?
customer's site
If it is reproducible at the customer's site, is it only in the
same database? only in the same schema?
On all the databases
Is it reproducible every time or intermittently?
Everytime

List the versions in which the problem
has reproduced.
9.2.0.1

TEST CASE:
----------

STACK TRACE:
------------
ksedmp ksfdmp.108 kgeriv kgesiv ksesic2 VInfreq__ksmapg b kghgex.21
kghalf ksmovr ksmals kspptsp kpoparsp opiodr ttcpip opitsk opiino opiodr
opidrv sou2o opimai OracleThreadStart

SUPPORTING INFORMATION:
-----------------------

24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------

DIAL-IN INFORMATION:
--------------------

IMPACT DATE:
------------

*** 09/03/02 01:56 am ***
*** 09/03/02 02:17 am *** (CHG: Sta->16 Asg->NEW OWNER)
*** 09/03/02 10:52 pm ***
The pga heap being requested is unusually high 538969648 ( ~500 MB ).
ORA-600 [733] is occuring everytime during normal database startup :
...
....
Mon Sep 02 17:36:59 2002
Completed: ALTER DATABASE CLOSE NORMAL
Mon Sep 02 17:36:59 2002
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Sep 02 17:40:04 2002
Errors in file c:\oracle\ora92\rdbms\trace\mm1_ora_3276.trc:
ORA-600: internal error code, arguments: [733], [538969648], [pga heap], [],
[], [], [], []
*** 09/03/02 11:37 pm ***
Successful database startup does not have O7_DICTIONARY_ACCESSIBILITY set to
true.
*** 09/04/02 01:39 am *** (CHG: Sta->10)
*** 09/04/02 01:39 am ***
The heap memory is being requested to read in SPFILE.
The spfileSID.ora might have been corrupted.
set O7_DICTIONARY_ACCESSIBILITY = TRUE in initSID.ora and
recreate the spfile by issuing :

SQL> connect / as sysdba

SQL> create spfile from pfile;

and restart the database.
*** 09/16/02 02:46 am *** (CHG: Sta->32)
*** 09/16/02 02:46 am ***
*** 04/22/05 10:28 am *** (CHG: Sta->92)