Help SQL Plus 3.3 will not connect from Win-95

Environment
Server runs 7.3.3, PC under Win-95 runs 3.3. IP address assigned, all internet browsing, telnet etc working fine.

Problem:
* Cannot find TNC, either with SQL-Plus, or with tnsping. SQL Plus just hangs until it times-out.
* The alias is properly set up (compared this with another 'working' PC's setup)
* Have reinstalled Oracle client a number of times to ensure there have no hangovers.

I tried to activate tracing by updating the sqlnet.ora file to:

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = ADMIN
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world
names.default_domain=world

but I still don't even get any tracing files created. It is almost as though the tnsnames.ora and sqlnet.ora files are being ignored completely, but I cannot work out why... registry looks like this:

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"ORACLE_HOME"="C:\\ORAWIN95"
"API"="C:\\ORAWIN95\\DBS"
"MSHELP"="C:\\ORAWIN95\\mshelp"
"NLS_LANG"="AMERICAN_AMERICA.WE8ISO8859P1"
"COMPANY_NAME"="Curtin"
"ORACLE_GROUP_NAME"="Oracle for Windows 95"
"RDBMS73"="C:\\ORAWIN95\\RDBMS73"
"OTRACE73"="C:\\ORAWIN95\\OTRACE73"
"PLSQL23"="C:\\ORAWIN95\\PLSQL23"
"PRO18"="C:\\ORAWIN95\\PRO18"
"NLSRTL32"="C:\\ORAWIN95\\NLSRTL32"
"ORA_NLS32"="C:\\ORAWIN95\\NLSRTL32\\DATA"
"UTIL_DFLT"="73"
"SMGR_DFLT"="23"
"MSHELP_TOOLS"="C:\\ORAWIN95\\MSHELP"
"SQLPATH"="C:\\ORAWIN95\\DBS"
"PLUS33"="C:\\ORAWIN95\\PLUS33"
"EXECUTE_SQL"="PLUS33"
"PLUS_DFLT"="PLUS33"
"NET20"="C:\\ORAWIN95\\NETWORK"
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Misc_Reg_Entries]

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES] [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE1]
"ORACLE_HOME"="C:\\ORAWIN95"
"API"="C:\\ORAWIN95\\DBS"
"MSHELP"="C:\\ORAWIN95\\mshelp"
"NLS_LANG"="AMERICAN_AMERICA.WE8ISO8859P1"
"COMPANY_NAME"="Curtin"
"ORACLE_GROUP_NAME"="Oracle for Windows 95"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORACLE_HOMES\ORACLE1\Misc_Reg_Entries]

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\Software Manager]
"Console Directory"="C:\\ORAWIN95\\Sysman\\OSM10"

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OO4O]
"CacheBlocks"="20"
"FetchLimit"="20"
"FetchSize"="4096"
"HelpFile"="C:\\ORAWIN95\\MSHELP\\oracleo.hlp"
"PerBlock"="16"
"SliceSize"="256"
"TempFileDirectory"="c:\\temp"

===

Any pointers would be really helpful. It's clear that the problem is some fundamental to SQLPlus, but I've been unable to identify the differences between the system that fails to operate and the other which works fine.

Ian Received on Mon Aug 10 1998 - 05:12:30 CDT