vizagpower Posted January 25, 2013 Report Posted January 25, 2013 Naa Database start chestunte ORA-01033 error vastundi, google cheste [color=#000000][font=tahoma, verdana, sans-serif][size=2]shutdown the database and then try starting the db step by step..[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]sqlplus "/ as sysdba"[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]sql> shutdown abort[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]sql>startup nomount[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]sql> alter database mount[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]sql> alter database open[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]ee steps as it is follow avtunte[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]ee error vastundi please help[/size][/font][/color] SQL> shutdown abort ORACLE instance shut down. SQL> startup nomount ORACLE instance started. Total System Global Area 778387456 bytes Fixed Size 1374808 bytes Variable Size 427820456 bytes Database Buffers 343932928 bytes Redo Buffers 5259264 bytes SQL> alter database mount 2 ; Database altered. SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [291], [47013], [47015], [], [], [], [], [], [], [] ani vastundi , please help mee? SQL> [color=#000000][font=tahoma, verdana, sans-serif][size=2] [/size][/font][/color]
Power Star Posted January 25, 2013 Report Posted January 25, 2013 ora 600 vochindi ante internal error vay just open oracle ticket thats it nee alert log post cheyyi ikkada chudam em ayyindoo
CheGuevara Posted January 25, 2013 Report Posted January 25, 2013 direct ga start open ani try chey nomount, mount kakund...
Gachibowli_Diwakar Posted January 25, 2013 Report Posted January 25, 2013 https://forums.oracle.com/forums/thread.jspa?threadID=1088888
VamsiKakumanu Posted January 25, 2013 Report Posted January 25, 2013 hii-- Try to run the below statements, please run them if it is the express edition that you installed on your system! Also you need to replace "C:#oraclexe#app#oracle#oradata#XE#" with the corresponding location of your installation!! Also you need to replace "C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG "--> with the corresponding location of your installation!! If you get any errors they might be because of the locations that you were referencing, try to understand them and replace with locations in you current installtion!! Also please let us know if this is useful or not replace # with \ replace ! with . set echo on SHUTDOWN ABORT STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 'C:#oraclexe#app#oracle#fast_recovery_area#XE#ONLINELOG#O1_MF_1_8GNCYJ7T_!LOG' SIZE 50M, GROUP 2 'C:#oraclexe#app#oracle#fast_recovery_area#XE#ONLINELOG#O1_MF_2_8GNCYM5B_!LOG' SIZE 50M -- STANDBY LOGFILE DATAFILE 'C:#oraclexe#app#oracle#oradata#XE#SYSTEM!DBF', 'C:#oraclexe#app#oracle#oradata#XE#UNDOTBS1!DBF', 'C:#oraclexe#app#oracle#oradata#XE#SYSAUX!DBF', 'C:#oraclexe#app#oracle#oradata#XE#USERS!DBF' CHARACTER SET WE8MSWIN1252 ; -- Configure RMAN configuration record 1 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS!DBMS_BACKUP_RESTORE!SETCONFIG('CONTROLFILE AUTOBACKUP','OFF'); -- Configure RMAN configuration record 2 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS!DBMS_BACKUP_RESTORE!SETCONFIG('RETENTION POLICY','TO REDUNDANCY 2'); -- Commands to re-create incarnation table -- Below log names MUST be changed to existing filenames on -- disk! Any one log file from each branch can be used to -- re-create incarnation records! -- ALTER DATABASE REGISTER LOGFILE 'C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG#2010_02_25#O1_MF_1_1_%U_!ARC'; -- ALTER DATABASE REGISTER LOGFILE 'C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG#2010_02_25#O1_MF_1_1_%U_!ARC'; -- ALTER DATABASE REGISTER LOGFILE 'C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG#2010_02_25#O1_MF_1_1_%U_!ARC'; -- ALTER DATABASE REGISTER LOGFILE 'C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG#2010_02_25#O1_MF_1_1_%U_!ARC'; -- ALTER DATABASE REGISTER LOGFILE 'C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG#2010_02_25#O1_MF_1_1_%U_!ARC'; -- Recovery is required if any of the datafiles are restored backups, -- or if the last shutdown was not normal or immediate! RECOVER DATABASE -- All logs need archiving and a log switch is needed! ALTER SYSTEM ARCHIVE LOG ALL; -- Database can now be opened normally! ALTER DATABASE OPEN; -- Commands to add tempfiles to temporary tablespaces! -- Online tempfiles have complete space information! -- Other tempfiles may require adjustment! ALTER TABLESPACE TEMP ADD TEMPFILE 'C:#oraclexe#app#oracle#oradata#XE#TEMP!DBF' SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; -- End of tempfile additions!
juvenile Posted January 25, 2013 Report Posted January 25, 2013 metalink access unte chudu bhayya , 600 diag tool untundi .. trace file , alert log file update cheste possible solution vastundi ..
VamsiKakumanu Posted January 25, 2013 Report Posted January 25, 2013 [quote name='vizagpower' timestamp='1359077317' post='1303169846'] Naa Database start chestunte ORA-01033 error vastundi, google cheste [color=#000000][font=tahoma, verdana, sans-serif][size=2]shutdown the database and then try starting the db step by step..[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]sqlplus "/ as sysdba"[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]sql> shutdown abort[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]sql>startup nomount[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]sql> alter database mount[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]sql> alter database open[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]ee steps as it is follow avtunte[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]ee error vastundi please help[/size][/font][/color] SQL> shutdown abort ORACLE instance shut down. SQL> startup nomount ORACLE instance started. Total System Global Area 778387456 bytes Fixed Size 1374808 bytes Variable Size 427820456 bytes Database Buffers 343932928 bytes Redo Buffers 5259264 bytes SQL> alter database mount 2 ; Database altered. SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [291], [47013], [47015], [], [], [], [], [], [], [] ani vastundi , please help mee? SQL> [/quote] ye hero problem solve ayyindhaa leeka maaanchi gaa laagincheesi mancham yekkesava?
vizagpower Posted January 25, 2013 Author Report Posted January 25, 2013 [quote name='SeedhaSaadha' timestamp='1359091343' post='1303171979'] ye hero problem solve ayyindhaa leeka maaanchi gaa laagincheesi mancham yekkesava? [/quote] no luck bro ,
Gachibowli_Diwakar Posted January 25, 2013 Report Posted January 25, 2013 [quote name='SeedhaSaadha' timestamp='1359086324' post='1303170690'] hii-- Try to run the below statements, please run them if it is the express edition that you installed on your system! Also you need to replace "C:#oraclexe#app#oracle#oradata#XE#" with the corresponding location of your installation!! Also you need to replace "C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG "--> with the corresponding location of your installation!! If you get any errors they might be because of the locations that you were referencing, try to understand them and replace with locations in you current installtion!! Also please let us know if this is useful or not replace # with \ replace ! with . set echo on SHUTDOWN ABORT STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "XE" NORESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 'C:#oraclexe#app#oracle#fast_recovery_area#XE#ONLINELOG#O1_MF_1_8GNCYJ7T_!LOG' SIZE 50M, GROUP 2 'C:#oraclexe#app#oracle#fast_recovery_area#XE#ONLINELOG#O1_MF_2_8GNCYM5B_!LOG' SIZE 50M -- STANDBY LOGFILE DATAFILE 'C:#oraclexe#app#oracle#oradata#XE#SYSTEM!DBF', 'C:#oraclexe#app#oracle#oradata#XE#UNDOTBS1!DBF', 'C:#oraclexe#app#oracle#oradata#XE#SYSAUX!DBF', 'C:#oraclexe#app#oracle#oradata#XE#USERS!DBF' CHARACTER SET WE8MSWIN1252 ; -- Configure RMAN configuration record 1 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS!DBMS_BACKUP_RESTORE!SETCONFIG('CONTROLFILE AUTOBACKUP','OFF'); -- Configure RMAN configuration record 2 VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS!DBMS_BACKUP_RESTORE!SETCONFIG('RETENTION POLICY','TO REDUNDANCY 2'); -- Commands to re-create incarnation table -- Below log names MUST be changed to existing filenames on -- disk! Any one log file from each branch can be used to -- re-create incarnation records! -- ALTER DATABASE REGISTER LOGFILE 'C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG#2010_02_25#O1_MF_1_1_%U_!ARC'; -- ALTER DATABASE REGISTER LOGFILE 'C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG#2010_02_25#O1_MF_1_1_%U_!ARC'; -- ALTER DATABASE REGISTER LOGFILE 'C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG#2010_02_25#O1_MF_1_1_%U_!ARC'; -- ALTER DATABASE REGISTER LOGFILE 'C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG#2010_02_25#O1_MF_1_1_%U_!ARC'; -- ALTER DATABASE REGISTER LOGFILE 'C:#ORACLEXE#APP#ORACLE#FLASH_RECOVERY_AREA#XE#ARCHIVELOG#2010_02_25#O1_MF_1_1_%U_!ARC'; -- Recovery is required if any of the datafiles are restored backups, -- or if the last shutdown was not normal or immediate! RECOVER DATABASE -- All logs need archiving and a log switch is needed! ALTER SYSTEM ARCHIVE LOG ALL; -- Database can now be opened normally! ALTER DATABASE OPEN; -- Commands to add tempfiles to temporary tablespaces! -- Online tempfiles have complete space information! -- Other tempfiles may require adjustment! ALTER TABLESPACE TEMP ADD TEMPFILE 'C:#oraclexe#app#oracle#oradata#XE#TEMP!DBF' SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; -- End of tempfile additions! [/quote] control file re-create cheyamantunnaav if no option left, then he can do that, moreover control file recreate chesthe, resetlogs tho db ni open cheyali anukunta.. not sure, can give a try and see
Recommended Posts