We help IT Professionals succeed at work.

Oracle Errors

CHI-LTD
CHI-LTD asked
on
626 Views
Last Modified: 2018-02-02
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

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

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):

Author

Commented:
dump file
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

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?
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

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
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

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
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

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.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions