Home » RDBMS Server » Server Administration » Oracle not available
icon8.gif  Oracle not available [message #127887] Wed, 13 July 2005 22:29 Go to next message
nhom9a
Messages: 51
Registered: July 2005
Location: VN
Member
hi all.
My database is shuting down now. and it has a mess: Oracle not available. can anybody help me this problem. Why does my database automatic shutdown ?

Thanks

Report message to a moderator

Re: Oracle not available [message #127894 is a reply to message #127887] Thu, 14 July 2005 00:16 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Have you checked your alert.log file?

Best regards.

Frank

Report message to a moderator

Re: Oracle not available [message #128282 is a reply to message #127894] Sat, 16 July 2005 23:58 Go to previous messageGo to next message
Achchan
Messages: 86
Registered: June 2005
Member
What did happen? Send us your latest section of alert log.
May be someone else scheduled the shutdown(?)
-Regards

Report message to a moderator

Re: Oracle not available [message #128363 is a reply to message #128282] Mon, 18 July 2005 03:55 Go to previous messageGo to next message
nhom9a
Messages: 51
Registered: July 2005
Location: VN
Member
Today my database automatic shutdown
this is log file.

Mon Jul 18 12:04:29 2005
ARC0: Evaluating archive log 2 thread 1 sequence 180
ARC0: Beginning to archive log 2 thread 1 sequence 180
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORACLE\ORADATA\DIV_12\ARCHIVE\ARC00180.001'
ARC0: Completed archiving log 2 thread 1 sequence 180
Mon Jul 18 13:21:54 2005
ARC1: Evaluating archive log 3 thread 1 sequence 181
Mon Jul 18 13:21:54 2005
Thread 1 advanced to log sequence 182
Current log# 1 seq# 182 mem# 0: E:\ORACLE\ORADATA\DIV_12\REDO01.LOG
Mon Jul 18 13:21:54 2005
ARC1: Beginning to archive log 3 thread 1 sequence 181
Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORACLE\ORADATA\DIV_12\ARCHIVE\ARC00181.001'
ARC1: Completed archiving log 3 thread 1 sequence 181
Mon Jul 18 14:40:21 2005
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 31
Mon Jul 18 14:40:30 2005
Errors in file e:\oracle\admin\div_12\udump\odiv12_j000_4044.trc:
ORA-00600: internal error code, arguments: [qerrmOFBu1], [1089], [], [], [], [], [], []

Mon Jul 18 14:40:33 2005
Error 3106 trapped in 2PC on transaction 7.27.8686. Cleaning up.
Error stack returned to user:
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from OBR06_CNNA
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [qerrmOFBu1], [1089], [], [], [], [], [], []
Mon Jul 18 14:40:33 2005
Errors in file e:\oracle\admin\div_12\udump\odiv12_j000_4044.trc:
ORA-12012: error on auto execute of job 491
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from OBR06_CNNA
ORA-12008: error in materialized view refresh path
ORA-00600: internal error code, arguments: [qerrmOFBu1], [1089], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1

Mon Jul 18 14:40:36 2005
All dispatchers and shared servers shutdown
Mon Jul 18 14:40:37 2005
Errors in file e:\oracle\admin\div_12\udump\odiv12_ora_3232.trc:

[Updated on: Mon, 18 July 2005 03:59]

Report message to a moderator

Re: Oracle not available [message #128388 is a reply to message #128363] Mon, 18 July 2005 05:21 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Log a TAR with Oracle Support
& install latest patchset from Oracle for 9i.

Report message to a moderator

Re: Oracle not available [message #128572 is a reply to message #128388] Tue, 19 July 2005 08:01 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
And tell us what is in THIS file:

Errors in file e:\oracle\admin\div_12\udump\odiv12_j000_4044.trc:

Report message to a moderator

Re: Oracle not available [message #128575 is a reply to message #128572] Tue, 19 July 2005 08:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you using any MV or DBLINK?

Report message to a moderator

Re: Oracle not available [message #128878 is a reply to message #128575] Thu, 21 July 2005 01:08 Go to previous messageGo to next message
nhom9a
Messages: 51
Registered: July 2005
Location: VN
Member
I have Database link in this Database.
and some snapshot views refresh automatic by time.

Report message to a moderator

Re: Oracle not available [message #128989 is a reply to message #128878] Thu, 21 July 2005 08:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>ORA-00600 qerrmOFBu1
Is a tricky one.
It will always hide the original error and whine about something.
Applying latest patchsets may help this.

As per your log

>>ORA-12012: error on auto execute of job 491
>>ORA-03106: fatal two-task communication protocol error
>>ORA-02063: preceding line from OBR06_CNNA
>>ORA-12008: error in materialized view refresh path
>>ORA-00600: internal error code, arguments: [qerrmOFBu1], [1089], [], [], [], [], [], []

>>ORA-12008: error in materialized view refresh path
You need to look into the origin of this error.
Something is wrong here which is raising another error
>> ORA-02063: preceding line from OBR06_CNNA
ORA-02063 is fetch out of sequence error which typically occurs when different versions of oracle talk to each other or if there is a difference in charactersets. Look if OBR06_CNNA is all good.

Report message to a moderator

Re: Oracle not available [message #128993 is a reply to message #127887] Thu, 21 July 2005 08:11 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Rule of thumb,

ORA 600 - search Metalink for the exact ora-600 error. If you are lucky, you will find something that exactly matches your error.

At the mean time, open a TAR with oracle. Keep allyou alert log and trace files, specially the ones specified in the alert log.

Good luck.
--
Sanjay

[Updated on: Thu, 21 July 2005 08:12]

Report message to a moderator

Previous Topic: Installation of oracle 9i
Next Topic: ORA-00600: internal error code, arguments: [17182]
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 08:17:17 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.