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.

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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

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)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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

SOLUTION

johnsone

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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.