SQL*Net 2.3 16 bit/32 bit on NT 3.51 WS SP5

SQL*Net 2.3 16 bit/32 bit on NT 3.51 WS SP5

Post by Alexander Mo » Mon, 21 Apr 1997 04:00:00



Hi !

I have a problem with SQL*Net on NT3.51 with SP5 installed.
(I have not yet tried the solutions provided in the list lately
because i
believe my problem is somewhat different)

For various reasons I have to use SQL*Net 2.3 16 bit as client-side
SQL*Net. Server side is 2.3 32bit.
I am using Oracle Workgroup Server 7.3.2, RunForms45 4.5.10 16bit.
SQL*Net works, but not fine !
32 bit TNSPING is excelent with 10-40ms responses. 16 bit TNSPING is
not so
good with 10-5000ms responses at random intervals.
The strangeest thing happens when i use 16bit TNSPING and change focus
from
TNSPING to something else on the desktop. Then suddenly i get
responses in
the 10-40ms from TNSPING in the background !
What is this and most importantly how do I fix it ?
Reponses in my application behave just the same; remove focus and
everything runs smoothly, gain focus and it is a drag !
Oh, almost forgot, this only happens on the Workstation hosting the
Oracle Server, not the other WS's.

Any help would be greately appreciated !

Late breaking news : Adjusting the priority settings in NT system in
control panel to equal for background and foreground jobs makes the
problem go away. But.. NT start to behave strange, freezing
screensaver etc. Alas.. It is a workaround, not a solution !
Please help !
TIA

PhoneNet : +47 22 49 74 60      SnailMail: HQDEFCOMNOR,Oslo Mil/Huseby
FaxNeet  : +47 22 49 71 14                 N-0016 OSLO, NORWAY
PagerNet : NONE !               MobileNet: +47 900 325 24
Any statements I make are still my own.

 
 
 

SQL*Net 2.3 16 bit/32 bit on NT 3.51 WS SP5

Post by Rich Wood » Mon, 21 Apr 1997 04:00:00



> Hi !

> I have a problem with SQL*Net on NT3.51 with SP5 installed.
> (I have not yet tried the solutions provided in the list lately
> because i
> believe my problem is somewhat different)

> For various reasons I have to use SQL*Net 2.3 16 bit as client-side
> SQL*Net. Server side is 2.3 32bit.
> I am using Oracle Workgroup Server 7.3.2, RunForms45 4.5.10 16bit.
> SQL*Net works, but not fine !
> 32 bit TNSPING is excelent with 10-40ms responses. 16 bit TNSPING is
> not so
> good with 10-5000ms responses at random intervals.
> The strangeest thing happens when i use 16bit TNSPING and change focus
> from
> TNSPING to something else on the desktop. Then suddenly i get
> responses in
> the 10-40ms from TNSPING in the background !
> What is this and most importantly how do I fix it ?
> Reponses in my application behave just the same; remove focus and
> everything runs smoothly, gain focus and it is a drag !
> Oh, almost forgot, this only happens on the Workstation hosting the
> Oracle Server, not the other WS's.

> Any help would be greately appreciated !

> Late breaking news : Adjusting the priority settings in NT system in
> control panel to equal for background and foreground jobs makes the
> problem go away. But.. NT start to behave strange, freezing
> screensaver etc. Alas.. It is a workaround, not a solution !
> Please help !
> TIA

> PhoneNet : +47 22 49 74 60      SnailMail: HQDEFCOMNOR,Oslo Mil/Huseby
> FaxNeet  : +47 22 49 71 14                 N-0016 OSLO, NORWAY
> PagerNet : NONE !               MobileNet: +47 900 325 24
> Any statements I make are still my own.

Oracle recommends you change NT tasking to anything other than
foreground more responsive than background, so that actually isn't a
workaround.  I've never had a problem doing this with either 3.51 or
4.0.  Can you provide any more info?
--
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.

 
 
 

1. SQL Net 16-bit and 32-bit on same NT PC

Is there a way to use the same tnsnames.ora with both 16-bit and
32-bit SQL*Net under Windows NT?  16-bit SQL*Net currently sits in
c:\orawin and 32-bit SQL*Net sits in c:\orant.  On Unix, TNS_ADMIN can
be used to locate tnsnames.ora and I have found that this does work
using 32-bit SQL*Net on NT but not with 16-bit.

Any suggestions?

===================================================
Richard Hansen

To respond, remove BITEME_SPAMMERS_ from my address
===================================================

2. foxpro2 printer driver problems

3. 16-bit and 32-bit versions of SQL*Net

4. OSQL utility

5. 16 bit application uses 32 bit SQL*Net under Win95

6. Citrix Resource Management Services, DB2 and ODBC

7. 16 bit application using 32 bit SQL*Net

8. BDE32 problems on Win95 R2 FAT32 ?

9. 16-bit/32-bit ODBC drivers - NT Environment

10. VB 16 bit vs 32 bit on NT machine

11. ODBC driver installation conflicts (between 16 bit and 32 bit drivers) on NT

12. 16-bit ODBC v2.0 from 32-bit NT APP