Oracle Database Discussions

One embarrased Oracle DBA. I've successfully installed Oracle on so many windows platforms that I've lost track.

The specs:

Dell Inspiron 5100
Windows XP Professional 2002 SP 1
2.66 GHz P4 CPU
512 MB RAM
1 GB Pagefile (swap)
Macafee Virus Protection (disabled)
Macaffee Firewall (disabled)
XP Firewall disabled in communication settings

Oracle 9i Release 2 EE base release
Processes = 150
Sessions = 170
shared_pool_size = 50 MB (tried setting as high as 150 MB)

I've tried every trick in the book

1. Clean de-install, reinstall
2. listener start with and without listener.ora
3. Enabling and disabling MTS (shared server)
4. LAN connection enabled (w/ appropriate parameters)
5. Standalone mode (no networking) w/ appropriate parameters
5. Increasing init.ora parms for memory, processes and sessions to ridiculous levels
6. Different listener ports other than 1521
7. deleting and recreating listener service
8. deleting and recreating Oracle service (oradim)
9. setting USE_SHARED_SOCKET in Oracle registry (in case the firewall was interfering with listener ports)
10. setting TNS_ADMIN (not relevant since there is only one Oracle Home
11. made sure ORACLE_SID was set in Oracle registry
12. setting ORACLE_SID and ORACLE_HOME at the command line and restarting listener/database in command window
13. Turning on listner and client tracing to admin level
14. ad infinitem

Tracing didn't reveal anything meaningful. I was able to briefly get a connection working (connecting on the laptop via SQL*NET to the local database) using MTS for about 3 minutes then it started malfunctioning again.

WHEN USING MTS (SHARED SERVER) TRACE ERROR MSG

*** 2003-11-07 08:51:07.000
network error encountered setting up listening port
listening address for dispatcher is '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'
NS Primary Error: TNS-12532: TNS:invalid argument
NS Secondary Error: TNS-12560: TNS:protocol adapter error
NT Generic Error: TNS-00502: Invalid argument
32-bit Windows Error: 22: Invalid argument

SQLNET LOG ERROR

Fatal NI connect error 12560, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 09-NOV-2003 08:10:36
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol adapter error
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

LISTNER.LOG

TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 09-NOV-2003 08:10:23

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is C:\oracle\ora92\network\admin\listener.ora
Log messages written to C:\oracle\ora92\network\log\listener.log
Trace information written to C:\oracle\ora92\network\trace\listener.trc
Trace level is currently 0

Started with pid=3512
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SARATOGA1)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
09-NOV-2003 08:10:25 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Greg))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * status * 0
09-NOV-2003 08:10:36 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oemdb.saratoga1)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=SARATOGA1)(USER=Greg))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.1)(PORT=1384)) * establish * oemdb.saratoga1 * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
32-bit Windows Error: 109: Unknown error

WINDOWS EVENT VIEWER

The OracleOraHome92TNSListener service terminated unexpectedly. It has done this 2 time(s).