Cannot TNSping my Oracle 9i database from the Middle Tier with 9iAS

Windows 2k Server - OS  Oracle 9i Database 9.2.0.6.0
Windows 2k Middle tier - Oracle 9iAS
Windows client from Middle Tier.

I installed and created Oracle 9i and have a database that start and works correctly.  
I then installed Oracle 9iAS on the Middle tier machine. This installation created 2 Oracle homes.
1. \Oracle\806  for forms
2. \Oracle\iSuites for Webserver

Then I installed Oracle 10G Forms and reports server. That created a home \Oracle\10g

I have 3 tnsnames.ora, one for each home. I have a common sqlnet.ora BUT, I have only ONE LISTENER on the Middle tier. There is no database on the Middle tier.

I included the database from the DB server's tnsnames.ora into the TNSnames.ora of the Middle tier machine.
My home on the Middle tier is set to \Oracle\806. when I try to TNSPING my DB server from the Middle tier, I get this message.

TNS-03505 message 3505 not found, No message file for PRODUCT=Network, facility = TNS.

How can I connect to my database or what is it that is wrong here?.  I ahve posted the .ora files of rht e midll tier and the lof of TNSping. Please help with this frustrating problem that is holding up all my work.

Note: the TNSnames.ora were created by the system. I have only included the database octrn section from the DB server's tnsnames.ora.  I am not sure about the beq-protocol and why it is there in one of the tnsnames.ora files. look closely, I changed orcl to octrn (ARGV0 = oracle80octrn) in that section of  \oracle\806 tnsnames.ora file

----------------------------------------------------------------------------------------------------------------

-- TNSNAMES OF \Oracle\806 FORMS SERVER --

Beq-local.techobs.com =                                   (What is this protocol? Do I need it?)
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = BEQ)
          (PROGRAM = oracle80)
          (ARGV0 = oracle80octrn)
          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
        )
    )
     (CONNECT_DATA = (SERVICE_NAME = octrn.techobs.com)
    )
  )
Tcp-loopback.techobs.com =                                   (What is this protocol? Do I need it?)
  (DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )
    )
    (CONNECT_DATA = (SID = octrn)
    )
  )
# This one below taken from tnsnames.ora of W2KOCSVR.techobs.com

OCTRN.techobs.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.101)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = octrn.techobs.com)
    )
  )
rep90ocmidtier.techobs.com=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.15.102)(PORT=1949))
----------------------------------------------------------------------------------------------------------------------
-- SQLnet.ORA of \Oracle\806 -------------

sqlnet.authentication_services = (NONE)
names.directory_path = (TNSNAMES, ONAMES, HOSTNAME)
names.default_domain = techobs.com
name.default_zone = techobs.com
automatic_ipc = off

TRACE_LEVEL_SERVER = ADMIN
TRACE_FILE_SERVER = SERVER
TRACE_DIRECTORY_SERVER = D:\ORACLE\806\network\trace

TRACE_LEVEL_LISTENER = 16
TRACE_FILE_LISTENER = LISTENER
TRACE_DIRECTORY_LISTENER = D:\ORACLE\806\net80\trace

LOG_FILE_LISTENER = LSNR
LOG_DIRECTORY_LISTENER = D:\ORACLE\806\net80\log

TNSPING.TRACE_LEVEL = ADMIN
TNSPING.TRACE_DIRECTORY = D:\ORACLE\806\NET80\TRACE

SQLNET.AUTHENTICATION_SERVICES= (NONE)

TRACE_LEVEL_CLIENT = ADMIN
TRACE_FILE_CLIENt = WEBCLIENT
TRACE_DIRECTORY_CLIENT = D:\ORACLE\806\NET80\TRACE

log_file_client = sqlnet.log
log_directory_client =D:\ORACLE\806\net80\log

---------------------------------------------------------------------------------------------------


--  TNSNAMES of \Oracle\iSuites  -----


# Internal mame for local Oracle8i Cache.
ora_icache =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = icache))
    )
    (CONNECT_DATA = (SERVICE_NAME = ocmidtier.techobs.com-icache )
    )
  )

# Descriptive name  to connect to cache via OEM performance monitor.
ocmidtier.techobs.com-icache =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = icache))
    )
    (CONNECT_DATA = (SERVICE_NAME = ocmidtier.techobs.com-icache )
    )
  )

# Support for external procedures within Oracle8i cache.
extproc_connection_data =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = ipc)(KEY = icache)
    )
    (CONNECT_DATA = (SID = iCache_extproc)(SERVER = DEDICATED)
    )
  )

# Support for mod_ose over normal TCP connections.
inst1_http =
  (DESCRIPTION =
    (ADDRESS =
      (PROTOCOL = TCP)
      (HOST = ocmidtier.techobs.com)
      (PORT = 1521)
    )
    (CONNECT_DATA =
      (SERVICE_NAME = MODOSE)
      (SERVER = shared)
      (PRESENTATION = http://admin)
    )
  )
# last one below taken from tnsnames.ora of W2KOCSVR

OCTRN.techobs.com =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.101)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = octrn.techobs.com)
    )
  )
REP_OCMIDTIER.TECHOBS.COM =
  (ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.15.102)(PORT = 1949))

==================================================================


------  listener.ora of \Oracl\eiSuites ===========


CONNECT_TIMEOUT_LISTENER = 0
LOGGING_LISTENER = ON

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =                # Local connections.
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = icache))
      )
    )
    (DESCRIPTION =                # General TCP connections.
      (ADDRESS =
          (PROTOCOL = TCP)(HOST = ocmidtier.techobs.com)(PORT = 1521)
      )
    )
    (DESCRIPTION =                # IIOP Connections.
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = ocmidtier.techobs.com)(PORT = 2481))
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ocmidtier.techobs.com-icache)
      (ORACLE_HOME = D:\ORACLE\iSuites)
      (SID_NAME = icache)
    )
    (SID_DESC =
      (ORACLE_HOME = D:\ORACLE\iSuites)
      (SID_NAME = iCache_extproc)
      (PROGRAM = extproc)
    )
  )

==================================================================
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 28-MAR-2006 21:18:11

(c) Copyright 1997 Oracle Corporation.  All rights reserved.


--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is D:\ORACLE\iSuites\network\trace\tnsping.trc
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source D:\ORACLE\iSuites\network\admin\sqlnet.ora
Parameter source loaded successfully

 -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
  sqlnet.expire_time = 5
  TNSPING.TRACE_LEVEL = ADMIN
  name.default_zone = techobs.com
  TRACE_FILE_LISTENER = LISTENER
  TRACE_LEVEL_SERVER = ADMIN
  automatic_ipc = off
  TRACE_LEVEL_CLIENT = ADMIN
  TRACE_LEVEL_LISTENER = 6
  NAMES.DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME)
  TNSPING.TRACE_DIRECTORY = D:\ORACLE\iSuites\network\trace
  LOG_DIRECTORY_LISTENER = D:\ORACLE\iSuites\network\log
  TRACE_DIRECTORY_LISTENER = D:\ORACLE\iSuites\network\trace
  TRACE_DIRECTORY_CLIENT = D:\ORACLE\iSuites\network\trace
  TRACE_FILE_SERVER = SERVER
  SQLNET.AUTHENTICATION_SERVICES = (NONE)
  TRACE_DIRECTORY_SERVER = D:\ORACLE\iSuites\network\trace
  LOG_FILE_LISTENER = LSNR
  TRACE_FILE_CLIENt = WEBCLIENT
  NAMES.DEFAULT_DOMAIN = techobs.com
--- PARAMETER SOURCE INFORMATION ENDS ---

--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "standard output"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nnfgiinit: entry
nnftboot: entry
nnftboot: exit
nnfoboot: entry
nnfoboot: exit
nnfoboot: entry
nnfoboot: exit
nnfhboot: entry
nnfhboot: exit
nnfnboot: entry
nnfnboot: exit
nnfnboot: entry
nnfnboot: exit
nnflcls: entry
nnflcls: exit
nncpmlf_make_local_addrfile: construction of local names file failed
nncpmsf_make_sys_addrfile: system names file is D:\ORACLE\iSuites\network\admin\tnsnames.ora
nncpcin_maybe_init: first request sent to name server will have ID 0
nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs
nncpcin_maybe_init: max request retries per name server is 1
nngsini_init_streams: initializing stream subsystem, cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
nncpcin_maybe_init: default name server domain is techobs.com
nnfun2a: entry
nlolgobj: entry
nnfgrne: entry
nnfgrne: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
nnfgsrdp: entry
nnfgsrdp: Setting path:
nnfgsrdp: checking element TNSNAMES
nnfgsrdp: checking element ONAMES
nnfgsrdp: checking element HOSTNAME
nnfgsrdp: Path set
nnfgrne: Going though read path adapters
nnfgrne: Switching to TNSNAMES adapter
nnfgrne: Original name: octrn
nnftqnm: entry
nnfcagmd: entry
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit
nncpldf_load_addrfile: initial load of names file D:\ORACLE\iSuites\network\admin\tnsnames.ora
nncpldf_load_addrfile: success
nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.15.101)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = octrn.techobs.com))) for name octrn.techobs.com
nnfcraa: entry
nnfgrne: Name successfully queried
nnftans: entry
nnfcran: entry
nnfcran: 64 rrs requested, 1 remaining, 1 total
nnfcran: exit
nnfgrne: exit
nlolgserv: entry
nnfggav: entry
nnfggav: exit
nnfgfrm: entry
nnfgfrm: exit
nlolgserv: exit
nlolgobj: exit
nlolfmem: entry
nlolfmem: exit
nsmal: 140 bytes at 0x11ed9d8
nscall: connecting...
nttbnd2addr: entry
nttbnd2addr: port resolved to 1521
nttbnd2addr: using host IP address: 192.168.15.101
nttbnd2addr: exit
nsmal: 420 bytes at 0x11ec818
nsmal: 1712 bytes at 0x11ea7d8
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: No PROTOCOL.ORA file is found
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 888.
nttcni: exit
nttcon: set TCP_NODELAY on 888
nttcon: exit
nsopen: transport is open
nsnainit: call
nsnainit: NA not wanted - disabling and returning
nsoptions: lcl[0]=0x0, lcl[1]=0x10, gbl[0]=0x0, gbl[1]=0x0, cha=0x0
nsoptions: lcl[0]=0x1fefff, lcl[1]=0x10, gbl[0]=0xf83f, gbl[1]=0x0
nsopen: global context check-in (to slot 0) complete
nsopen: lcl[0]=0x1fefff, lcl[1]=0x10, gbl[0]=0xf83f, gbl[1]=0x0, tdu=32767, sdu=2048
nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=7, flg=0x4201, mvd=0
nsmal: 44 bytes at 0x11ecd18
nsmal: 44 bytes at 0x11ecd50
nlidg8: entry
nlidg8: exit
nsdo: nsctxrnk=0
nsdo: cid=0, opcode=67, *bl=29, *what=8, uflgs=0x0, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=14, flg=0x4205, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=2019
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nspsend: plen=87, type=1
nttwr: entry
nttwr: socket 888 had bytes written=87
nttwr: exit
nspsend: 87 bytes to transport
nsdo: nsctxrnk=0
nsdo: cid=0, opcode=68, *bl=256, *what=9, uflgs=0x2000, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=2, flg=0x4205, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=2019
nscon: recving a packet
nsmal: 44 bytes at 0x11ecd88
nsprecv: reading from transport...
nttrd: entry
nttrd: socket 888 had bytes read=73
nttrd: exit
nsprecv: 73 bytes from transport
nsprecv: tlen=73, plen=73, type=4
nscon: got NSPTRF packet
nscon: got 61 bytes connect data
nsdo: nsctxrnk=0
nscall: refused
nstimarmed: no timer allocated
nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x40, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=3, flg=0x4201, mvd=0
nsdo: nsctxrnk=0
nsclose: closing transport
nttdisc: entry
nttdisc: Closed socket 888
nttdisc: exit
nsclose: global context check-out (from slot 0) complete
nsmfr: 1712 bytes at 0x11ea7d8
nsmfr: 140 bytes at 0x11ed9d8
nsmfr: 420 bytes at 0x11ec818

Start Free Trial