Oracle Errors

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.
LVL 1
CHI-LTDAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) 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.
0
CHI-LTDAuthor Commented:
I have found alert.orcl.log which has a number of errors within.
Would this help?
0
CHI-LTDAuthor 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):
0
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

CHI-LTDAuthor Commented:
dump file
0
slightwv (䄆 Netminder) 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.
0
CHI-LTDAuthor Commented:
Got ya.  Is there anything in here that could help prove its 100% software crash?
0
slightwv (䄆 Netminder) 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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CHI-LTDAuthor 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
0
johnsoneSenior Oracle DBACommented:
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.
0
CHI-LTDAuthor 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
0
slightwv (䄆 Netminder) 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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.