0

I know this will be greeted with derision, but yes I'm running Oracle XE on Windows XP. Long story involving office policies and VMs.

Actually it's been working fine for a couple of years, but today I noticed I couldn't connect - I was getting ORA-12505, ORA-12541 and ORA-12560.

It soon transpired that the DB itself, not the listener, had stopped. Looking in services.msc, 'OracleServiceDB' is listed as not running (even though it's set to start automatically). Restarting it gives me a windows error: 'Error 1067 - the process terminated unexpectedly'. The event viewer shows several instances of the DB stopping by itself.

The only change I can think of which might have caused it to break was the installation of windows XP service pack 3 a couple of days ago.

I'm running windows inside a VirtualBox VM. There is plenty of disk space.

Any thoughts?

I looked in the log and found this:

Fatal NI connect error 12638, connecting to:
 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

 VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.2.0 - Production
Time: 04-NOV-2013 17:48:03
Tracing not turned on.
Tns error struct:
  ns main err code: 12638

TNS-12638: Credential retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Improve this question
7
  • Anything in the DB alert log?
    – Philᵀᴹ
    Commented Nov 6, 2013 at 15:57
  • The only thing which looks unusual is this: alter database open Beginning crash recovery of 1 threads
    – mdarwin
    Commented Nov 6, 2013 at 16:27
  • I assume you must have restarted XP after the installation of SP3, and I also assume Oracle XE was working after that? Therefore, I doubt SP3 is to blame.
    – Hannah Vernon ♦
    Commented Nov 6, 2013 at 17:13
  • Can you enable tracing - that might help you resolve the TNS-12638 error...
    – Hannah Vernon ♦
    Commented Nov 6, 2013 at 17:17
  • Have you seen this question on the Oracle forum - perhaps it will help... forums.oracle.com/thread/1065706?start=0&tstart=0
    – Hannah Vernon ♦
    Commented Nov 6, 2013 at 17:20

1 Answer 1

Reset to default
1

I ran the 'repair oracle installation' option from the setup.exe file which I used to install oracle in the first place.

So far, I've not had a recurrence and this seems to have fixed the problem.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.