I will take you with me how to resolve following error that I have recieved through EF
Higher message from EF
The underlying provider failed on Open.
Inner exception message:
"The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)"
I have found multiple solutions about this problem.
Source1: msdn forum
Source 2: stackoverflow.com
I have checked running services on my local pc and on server.
I have restarted server. No change. Restarting local pc.
This error lead me to error mesage
ora-12560 tns protocol adapter error
I have run command:
lsnrctl stat
with results:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-SEP-2012 11:41
:18
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 03-SEP-2012 11:14:57
Uptime 0 days 0 hr. 26 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oracle\product\10.2.0\server\network\admin\listener.ora
Listener Log File C:\oracle\product\10.2.0\server\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TestOrangeDB001.FocusData.local)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Ok and lastly check if database is online.
No comments:
Post a Comment