problem with oracle 9i on windows xp(Home edition)

**Mark Snowdon** · 2 September 2002, 11:25

there are bugs

Bernie,

there are various bugs around in version 8 and 8i that can cause this - dont know about 9i. The ora 3113 is an end of communication error, ie the netlink betwwen your session and the server has died.

there is a report of this problem where changing the column order fixes things !

also a report that repoving spaces from the tnsnames file solves it - all spaces around = signs.

does this happen if you do the same thing through other tools than sqlplus ?

anything in your logs ?

If you have multiple sqlplus sessions does it close all of them or just the one that you desc in ?

**Mark Snowdon** · 2 September 2002, 11:39

from oracle

Doc ID:
Note:120498.1
Subject:
How to Resolve Most ORA 3113
Type:
PROBLEM
Status:
PUBLISHED
Content Type:
TEXT/PLAIN
Creation Date:
25-SEP-2000
Last Revision Date:
02-APR-2002

Problem Description
-------------------

ORA-3113's can be caused by three different types of problems:

1. Those caused by the libraries not being linked correctly.
2. Those caused as an end result of the database doing a core dump,
which causes the client connection to be closed.
3. Those caused by network problems or normal network timeouts.

Solution Description
--------------------

1. Library linking problems can usually be resolved by relinking. Before
relinking, make sure the environment is set correctly including path
statements. At the operating system prompt, you should type "which make".
You should be using "/usr/ccs/bin/make".
Check the PATH and make sure /usr/ccs/bin is first in the path.

NOTE for # 2, above:
ORA-3113 caused by the database core dumping is not an easy fix. It can
be verified by looking in the alert.log and for trace files to see where the
real problem resides. This will not be addressed in this note.

3. There are several different methods of dealing with an ORA-3113 if the network
is timing out.

a. Create a PROTOCOL.ORA in the oracle_home/network/admin, net80/admin or
where the TNSADMIN points, depending on version of sqlnet/net80, on the server
side. Add one line:

TCP.NODELAY=YES

Then stop and restart the listener. This will turn on percistant tcp buffer
flushing. Be aware is can create some additional network traffic, but should
not cause any significate problems.

b. Edit the SQLNET.ORA in the oracle_home/network/admin, net80/admin or where
the TNSADMIN points, either remove the sqlnet.expire_time or set is to some
value like 30. It is set in increments of minutes. Then stop and restart the
listener for the change to take effect.

This will either turn off dead connection detection (DCD) or will increase the
time to 30 minutes before the connection can be marked for deletion. Sometimes
the pmon will mark connections as idle even though they are waiting for data.
The best solution is to work around the problem by either not using DCD or by
setting value high enough the most queries will return before that time has
passed.

c. The solution described below is a MS Windows 95/98/NT/2000 specific solution.
Again it is a server side solution. It address on old Microsoft problem with
"Black Hole Router Detect".

WARNING: Mis-using Registry Editor can cause serious problems
that may require you to reinstall your operating system.

Increase the TcpMaxDataRetransmissions in the window registry

On NT
HKEY_LOCAL_MACHINE
SYSTEM
CurrentControlSet
Services
Tcpip
Parameters
and add a key "TcpMaxDataRetransmissions"
(REG_DWORD) and set its value to 10.

On the Edit menu, click Add Value, and then add the following
information:
Value Name: TcpMaxDataRetransmissions
Value Type: REG_DWORD - Number
Valid Range: 0 - 0xFFFFFFFF
Default Value: 5 Decimal
New Value: 10 to Decimal

This time may vary as it is dynamically adjusted.

On Windows95

HKEY_LOCAL_MACHINE
SYSTEM
CurrentControlSet
Services
Winsock
and add a key "TcpMaxDataRetransmissions" and set its value to 10.

On the Edit menu, click Add Value, and then add the following
information:

Value Name: TcpMaxDataRetransmissions
Value Type: REG_DWORD - Number
Valid Range: 0 - 0xFFFFFFFF
Default Value: 5 Decimal
New Value: 10 Decimal

d. Edit the SQLNET.ORA in the oracle_home/network/admin, net80/admin or where
the TNSADMIN points, add the line BREAK_POLL_SKIP = some numeric value. The
value is set in seconds. The higher the value the less frequently,
BREAK_POLL_SKIP is checked. Again this is a server side setting. The listener
will need to be stopped and restarted.

e. Edit the SQLNET.ORA in the oracle_home/network/admin, net80/admin or where
the TNSADMIN points, add the line DISABLE_OOB=ON. Again this is a server
side parameter. Once the change is made, stop and restart the listener.

This will disable out of band break.

References
----------
NOTE 2064693.102, NOTE 2065013.4, BUG 1003298, NOTE 1079208.6, NOTE 39357.1

Additional Search Words
-----------------------
ORA-3113, TCP.NODELAY=YES, Linking, relink

**Barn Owl** · 3 September 2002, 13:40

Re: from oracle

Bernie,

Oracle 9i (releases one and two ) - Personal, Standard and Enterprise editions are designed for Windows XP  Professional edition. You will probably get several situations with errors relate to libraries not being linked correctly.

I was in a similar situation to yourself and eventually upgraded to use the Enterprise edition (with the additional libraries / modules installed) on Windows XP Professional.

**biffa** · 18 September 2002, 22:47

..

Took off XP Professional to install unsupported 8i on 2000 Professional.

Now have 9i techtrack (database and developer tools) and was thinking of reverting back to XP Pro but want to keep 6i Forms / Reports so am forced to keep 2000 Pro.

Why dont Oracle and others upgrade operating system compatability faster?? It would save a lot of hassle.

**balony ir t** · 1 February 2003, 11:16

oracle 9i

Still have not got round to installing Oracle 9i ,forms 9i..etc...been to busy lately. Previously I tried (unsucessfully) to load oracle 9i Personal Edition onto a Windows XP (home edition). Before I blow some hard earned cash on Windows Xp professional to load on my pc, can any oracle gurus out there advise me whether it is best to upgrade to Xp professional ,or to delete the Home Edition and load the fresh Installation?. I am worried that the upgrade might be missing a few important libraries that will result in not being able to load oracle 9i etc.
cheers peeps

**Barn Owl** · 3 February 2003, 17:34

Re: oracle 9i

I would prefer the 'full installation' variant of XP Professional and then download the Microsoft service packs for XP, Install Oracle 9i and finally other applications and data.

If the Oracle 9i installation goes wrong and/or you need to re-install Oracle you will need to edit and delete items in the registry.

problem with oracle 9i on windows xp(Home edition)