此内容已被标记为最终。 显示 5 条回复
The protocol adaptor error message is coming because your db service OracleserviceORCL is not started yet. What you can do is try to recreate teh service using oradim command. Using this, you would need to delete teh service and recreate it. This should take care of the service non-startup error. But the bigger worry is the dll file error that you are getting. Did you try to check what's the reason that you have got the dll corrupted ?
cakire82 wrote:This is a Windows kernel error - saying that is it unable to load a DLL into memory. As the Oracle process needs the services/interface provided by that DLL, it cannot proceed without it. The Oracle +.exe+ process will therefore fail as a result with an error (but this would be a symptom of the actual error - the fact that the DLL could not load).
and there was this error box (windows) appeared with the message:
The application or DLL C:\oracle\product\10.2.0\db_1\bin\ORASPAWN.DLL is not a valid Windows image. Please check this against your installation diskette.
Strange though that you got the error you did... and I cannot recall offhand ever seeing an oraspawn library on the Linux side. Could be Win32 specific..
If you know how the binary header of a Win32 executable looks like, you can edit the DLL and have a look at it (DLLs are also executables, minus a data segment and have a similar header to an EXE).
You can run chkdsk from a command console to check for disk and file corruption. Or it could be a case of accidentally having replaced the original DLL with another file, or having truncated the DLL (0 byte file size).
You can try and find the original DLL on the source installation CD (assuming the installation is not in CAB format - cannot recall Oracle installations in the old days using it). Pop in the CD, open a command console and change dir to the CD root - then use dir/s/b oraspawn.* to search for it. It could be in compressed format as file oraspawn.dl_ - you then need to use the expand command to uncompress it to its original format and replace your broken DLL.
Of course, it could be a lot easier to simply uninstall and re-install Oracle.
DLL file was looking corrupted you can download that file from http://www.dll-error.net/dll-file/oraspawn.dll.html and it is bug http://support.microsoft.com/kb/192731.
better stop the service or restart the server and start the oracle service again.
I have no idea how this DLL got corrupted. I have copied the oraspawn.dll from my friends laptop who also has the same version of everything I have with the same Oracle service name. Now, when I try to connect I only get the TNS adapter error. DLL error has disappeared.