Avatar of CHI-LTD
CHI-LTD
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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.
Oracle DatabaseHardware

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon
SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
CHI-LTD

ASKER
I have found alert.orcl.log which has a number of errors within.
Would this help?
CHI-LTD

ASKER
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):
CHI-LTD

ASKER
dump file
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
slightwv (䄆 Netminder)

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.
CHI-LTD

ASKER
Got ya.  Is there anything in here that could help prove its 100% software crash?
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
CHI-LTD

ASKER
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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
CHI-LTD

ASKER
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
slightwv (䄆 Netminder)

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.