Oracle Errors

CHI-LTD
CHI-LTD used Ask the Experts™
on
Hi
We have an Oracle database server (maintained and supported by 3rd party co).  It developed an issue some time ago (its a standby server) whereby the connection cannot be made from the 3rd party program to the database via odbc.
They had a brief look at it and quoted to fix the issue 'due to a hardware problem' of some kind.  The server/database is running on a VM so we have argued that the problem isn't hardware, rather oracle/software.
They also said it has an 'internal oracle error 600' which relates to hardware problem.  I've searched and cannot see anything that would indicate this problem.  
We are now nowhere further to resolving.
Is there anyone that has come across this sort of problem and pointers for me proving this is really not a hardware fault?
Thanks

Logs:
Faulting application name: oradim.exe, version: 0.0.0.0, time stamp: 0x4904b488
Faulting module name: ntdll.dll, version: 6.1.7601.23677, time stamp: 0x589c99e1
Exception code: 0xc0000374
Fault offset: 0x00000000000bf3e2
Faulting process id: 0x1ee0
Faulting application start time: 0x01d2a9a62adfa328
Faulting application path: D:\app\pulse\product\11.1.0\db_1\bin\oradim.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: 7a7c0890-1599-11e7-b6d4-000c29059d1a

Were using Oracle v10 client.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
>>They also said it has an 'internal oracle error 600' which relates to hardware problem

The ora-0600 doesn't mea hardware problem.  It means some internal error has occurred that 99.9% of the time requires Oracle Support to help diagnose.  Most of the time I get them, it is a bug in Oracle software.



I'm not sure why ORADIM would be generating an error or why it is being executed in the first place.  I don't know everything it can be used for but from memory it is used to create the Oracle services on a Windows server.

Author

Commented:
I have found alert.orcl.log which has a number of errors within.
Would this help?

Author

Commented:
Thread 1 advanced to log sequence 11320 (LGWR switch)
  Current log# 1 seq# 11320 mem# 0: D:\APP\APP1\ORADATA\ORCL\REDO01.LOG
Thu Oct 06 15:24:55 2016
Errors in file d:\app\app1\diag\rdbms\orcl\orcl\trace\orcl_smon_2388.trc  (incident=10124897):
ORA-00600: internal error code, arguments: [13011], [260], [8462971], [2], [8462971], [3], [], [], [], [], [], []
Incident details in: d:\app\app1\diag\rdbms\orcl\orcl\incident\incdir_10124897\orcl_smon_2388_i10124897.trc
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Thu Oct 06 15:24:57 2016
Trace dumping is performing id=[cdmp_20161006152457]
Thu Oct 06 15:25:01 2016
Sweep Incident[10124897]: completed
Thu Oct 06 15:29:59 2016
Errors in file d:\app\app1\diag\rdbms\orcl\orcl\trace\orcl_smon_2388.trc  (incident=10124898):
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
dump file
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Be careful posting actual trace files on a public website.  They likely contain actual data from the database that you probably do not want the world to be able to see.

Author

Commented:
Got ya.  Is there anything in here that could help prove its 100% software crash?
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
>>Is there anything in here that could help prove its 100% software crash?

No.  It still might be a hardware issue that caused some corruption.

I think the place to start is with this part of the trace:
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.

If you have access to Oracle Support, there is a lot of information out there on this and there seem to be several causes.  Some bugs and some corruption.  I cannot post any of that information here.

What I will post is that you might have a corrupt TEMP tablespace datafile.  See if anything else you can find seems to point to that.

You can try to go through the trace files generated in the incident:
Incident details in: d:\app\app1\diag\rdbms\orcl\orcl\incident\incdir_10124897\orcl_smon_2388_i10124897.trc

I've rarely had any luck looking through those myself and finding anything I can work with.  That is why an ORA-600 typically involves Oracle Support.

Author

Commented:
Yes, looking at the trace file now.  Not much to report so far.
We pay oracle support via the 3rd party co.  Guess we might have a support contract, but unsure if in our name,  Ill check

Thanks
johnsoneSenior Oracle DBA
Commented:
If you can get into the support web site, I highly recommend searching for "ORA-0060 lookup tool".  It will ask you for the arguments that are found in the error message.  They are in this line in your log:

ORA-00600: internal error code, arguments: [13011], [260], [8462971], [2], [8462971], [3], [], [], [], [], [], []

If it is a published internal error, you could get some insight into what the issue is.  Sometimes one of those numbers is an OBJECT_ID that you can look up.  That can help find out where corruption is.  I have been able to track down corrupted indexes and things like that using the tool.

The absolute best way to determine the cause of an ORA-00600 would be Oracle Support.  They have better information on the issues and have the ability to decipher those trace files.

Author

Commented:
Thanks for the feedback.  I dont think im gong to get anywhere.  Does anyone have access to the tool and could they pass the log/errors through for me?

Thanks
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Sorry but that tool is only available through Oracle Support and running someone else's logs would likely be a violation of the support contract.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial