Home » RDBMS Server » Server Administration » Error while STARTUP database (oracle11g, aix5.3, unix)
Error while STARTUP database [message #421142] Fri, 04 September 2009 09:26 Go to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Hi,

I am unable to startup the database?

SQL*Plus: Release 11.1.0.7.0 - Production on Sun May 15 11:43:26 1994

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-03113: end-of-file on communication channel


please help me in this regard. Thanks in Advance...

Regards,
Chandu.
Re: Error while STARTUP database [message #421145 is a reply to message #421142] Fri, 04 September 2009 09:33 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/m/421141/136107/#msg_421140

Do NOT cross/multi-post

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: Error while STARTUP database [message #421149 is a reply to message #421142] Fri, 04 September 2009 10:07 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at alert.log file.

Regards
Michel
Re: Error while STARTUP database [message #421151 is a reply to message #421142] Fri, 04 September 2009 10:12 Go to previous messageGo to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
The below is the error i was get in error log.

----- End of Call Stack Trace -----

Errors in file /home/oracle/diag/rdbms/base58/base58/trace/base58_ora_110710.trc:
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code,
Non critical error ORA-00600 caught while writing to trace file "/home/oracle/diag/rdbms/base58/base58/trace/base58_ora_11071
0.trc"
Error message: ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1],

Writing to the above trace file is disabled for now on...
Errors in file /home/oracle/diag/rdbms/base58/base58/trace/base58_ora_110710.trc:
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
Errors in file /home/oracle/diag/rdbms/base58/base58/trace/base58_ora_110710.trc:
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
Errors in file /home/oracle/diag/rdbms/base58/base58/trace/base58_ora_110710.trc:
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
Errors in file /home/oracle/diag/rdbms/base58/base58/trace/base58_ora_110710.trc:
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
Errors in file /home/oracle/diag/rdbms/base58/base58/trace/base58_ora_110710.trc:
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4:kgstmLdiToMicroTs], [1], [], [], [], [], [], [], [], [], [], []
dbgtfRecWriteFailure: max write recursion depth, 10, reached
current file name: /home/oracle/diag/rdbms/base58/base58/trace/base58_ora_110718.trc


----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
dbgtfRecWriteFailur bl kgdsdst()
1103A88F0 ?
000000000 ?

e()+0b40

dbgtfPutStr()+0114 bl dbgtfRecWriteFailur
1103A88F0 ?
1103AC288 ?

e()

dbktPri()+019c bl dbgtfPutStr()
1103A88F0 ?
FFFFFFFFFFD3BE8 ?


000000028 ?

ksdfmw()+0264 bl dbktPri()


/home/oracle/diag/rdbms/base58/base58/trace/base58_ora_110718.trc
file the below error is there.

"/home/oracle/diag/rdbms/base58/base58/trace/base58_ora_110710.trc" [Last line is not complete] 2 lines, 397 characters
Trace file /home/oracle/diag/rdbms/base58/base58/trace/base58_ora_110710.trc
DDE was called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'DDE w
as called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'DDE was ca
lled in a 'No Invocation Mode'DDE was called in a 'No Invocation Mode'
~


Please help me.


Regards,
Chandu..
Re: Error while STARTUP database [message #421154 is a reply to message #421151] Fri, 04 September 2009 10:23 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Re: Error while STARTUP database [message #421156 is a reply to message #421142] Fri, 04 September 2009 10:36 Go to previous messageGo to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Dont we have any other solution for this? Please update me if any solution is there for the below.

I have placed the init.ora file. I am maintaining the 2 databases on this machine. Please suggest if anything is wrong from init.ora file.


base58.__java_pool_size=67108864
base58.__large_pool_size=16777216
base58.__oracle_base='/home/oracle'#ORACLE_BASE set from environment
base58.__pga_aggregate_target=704643072
base58.__sga_target=1023410176
base58.__shared_io_pool_size=0
base58.__shared_pool_size=335544320
base58.__streams_pool_size=0
*.audit_file_dest='/home/oracle/admin/base58/audit'
*.audit_trail='db'
*.compatible='11.1.0.7.0'
*.control_files='/home/itcdata/fs58/base58/control01.ctl','/home/itcdata/fs58/base58/control02.ctl','/home/itcdata/fs59/base5
8/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='base58'
*.db_recovery_file_dest='/home/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.diagnostic_dest='/home/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=base58XDB)'
*.memory_target=1717567488
*.open_cursors=2000
*.processes=2000
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'


Regards,
Chandu...
Re: Error while STARTUP database [message #421160 is a reply to message #421156] Fri, 04 September 2009 11:02 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Yes you have one solution. Check 810046.1

Thanks
Re: Error while STARTUP database [message #421162 is a reply to message #421142] Fri, 04 September 2009 11:08 Go to previous messageGo to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Hi,

Can you please post the exact path.

"Check 810046.1" means I did not get you.. Please provide the perfect information..

Regards,
Chandu...

Re: Error while STARTUP database [message #421164 is a reply to message #421162] Fri, 04 September 2009 11:13 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


It's metalink document id.

Babu
Re: Error while STARTUP database [message #421190 is a reply to message #421142] Sat, 05 September 2009 06:04 Go to previous messageGo to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Hi,

I got solution for this.

Actually after creating the database, we have changed the system date. With this change when we are restarting the database, Stuck up with the above error. Now we changed the date to original system date and now is working fine.

While startup the database, control file is reading system date
( which is less than the date on which control file is created).
This caused the above error.

Thank you very much to you Michel.


Regards,
Chandu.
Re: Error while STARTUP database [message #421192 is a reply to message #421190] Sat, 05 September 2009 06:26 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Thanks for your feedback. This is the information i already given you throw metalink document id.

Thanks
Re: Error while STARTUP database [message #421193 is a reply to message #421142] Sat, 05 September 2009 06:28 Go to previous messageGo to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Hi Babu,

Thank you for your reply. But Can you please tell me how to check the meta link? I will be very thankful to you if you update me how to check the meta link that you provided.


Regards,
Chandu..
Re: Error while STARTUP database [message #421199 is a reply to message #421193] Sat, 05 September 2009 10:28 Go to previous message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Metalink

Regards
Michel
Previous Topic: Oracle 10g Connection Failed (merged 5)
Next Topic: Upgrade Oracle client from 10.2.0.1 to 10.2.0.4
Goto Forum:
  


Current Time: Thu Sep 29 15:58:54 CDT 2016

Total time taken to generate the page: 0.13161 seconds