ceecil
asked on
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=(P ROTOCOL=be q)))')
    )
  )
   (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_serv ices = (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\trac e
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_SERV ICES= (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-icac he )
  )
 )
# Descriptive name  to connect to cache via OEM performance monitor.
ocmidtier.techobs.com-icac he =
 (DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = IPC)(KEY = icache))
  )
  (CONNECT_DATA = (SERVICE_NAME = ocmidtier.techobs.com-icac he )
  )
 )
# 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)(POR T = 1521)
   )
  )
  (DESCRIPTION =         # IIOP Connections.
   (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
   )
   (ADDRESS = (PROTOCOL = TCP)(HOST = ocmidtier.techobs.com)(POR T = 2481))
  )
 )
SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
   (GLOBAL_DBNAME = ocmidtier.techobs.com-icac he)
   (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\tnsp ing.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\sqln et.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_SERV ICES = (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_addrfil e: construction of local names file failed
nncpmsf_make_sys_addrfile: system names file is D:\ORACLE\iSuites\network\ admin\tnsn ames.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_pat h
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\tnsn ames.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
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)(
    )
  )
   (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
--------------------------
-- SQLnet.ORA of \Oracle\806 -------------
sqlnet.authentication_serv
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\trac
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_SERV
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-icac
  )
 )
# Descriptive name  to connect to cache via OEM performance monitor.
ocmidtier.techobs.com-icac
 (DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = IPC)(KEY = icache))
  )
  (CONNECT_DATA = (SERVICE_NAME = ocmidtier.techobs.com-icac
  )
 )
# 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)(POR
   )
  )
  (DESCRIPTION =         # IIOP Connections.
   (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
   )
   (ADDRESS = (PROTOCOL = TCP)(HOST = ocmidtier.techobs.com)(POR
  )
 )
SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
   (GLOBAL_DBNAME = ocmidtier.techobs.com-icac
   (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\
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source D:\ORACLE\iSuites\network\
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\
 LOG_DIRECTORY_LISTENER = D:\ORACLE\iSuites\network\
 TRACE_DIRECTORY_LISTENER = D:\ORACLE\iSuites\network\
 TRACE_DIRECTORY_CLIENT = D:\ORACLE\iSuites\network\
 TRACE_FILE_SERVER = SERVER
 SQLNET.AUTHENTICATION_SERV
 TRACE_DIRECTORY_SERVER = D:\ORACLE\iSuites\network\
 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_addrfil
nncpmsf_make_sys_addrfile:
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_pat
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\
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
ASKER
For Schwertner:
I am not a DBA and I specialize in Oracle Clinical. I have done te installation after a terrible struggle. However, I am now left with this one headache to make this work. Everything has been inatllaed and configured to an extent. But I am surprised that it gives me an error to connect.
I am currently usingthe Middle tier as a client and hence I will not need a DB or infrastructure. This is only to test the connection. Once this works, I will setup the client and start from there. The Oracle home on the Middle tier is \Oracle\806 because that is where the Forms servlets are I presume.
When I TNSPING from the middle tier, it gives me this error:
TNS-03505 : Message 3505 not found; No message file for PRODUCT=NETWORK, facility=TNS. I am not able to understand this. I found that the msg files .msb are in the \Oracle\806\net80 directory.
How can I use Net GUI?. From where do I get that?.
I am not a DBA and I specialize in Oracle Clinical. I have done te installation after a terrible struggle. However, I am now left with this one headache to make this work. Everything has been inatllaed and configured to an extent. But I am surprised that it gives me an error to connect.
I am currently usingthe Middle tier as a client and hence I will not need a DB or infrastructure. This is only to test the connection. Once this works, I will setup the client and start from there. The Oracle home on the Middle tier is \Oracle\806 because that is where the Forms servlets are I presume.
When I TNSPING from the middle tier, it gives me this error:
TNS-03505 : Message 3505 not found; No message file for PRODUCT=NETWORK, facility=TNS. I am not able to understand this. I found that the msg files .msb are in the \Oracle\806\net80 directory.
How can I use Net GUI?. From where do I get that?.
Look, this is normal.
I had the same problem.
I installed Oracle9i and Forms/Reports server on my laptop.
In PATH environment variable the entries for Forms/Reports server came before the entries for Oracle server.
So if you are using a component give the full path to the executable for avoiding misunderstanding.
What is your computer configuration?
What have you installed - standalone Forms/reports server or OAS9i?
OAS9i for Forms/Reports can be installed only with infrastructure DB.
Standalone Forms/reports server do not needs Infrastructure DB.
The best installation will e on different computers.
I had the same problem.
I installed Oracle9i and Forms/Reports server on my laptop.
In PATH environment variable the entries for Forms/Reports server came before the entries for Oracle server.
So if you are using a component give the full path to the executable for avoiding misunderstanding.
What is your computer configuration?
What have you installed - standalone Forms/reports server or OAS9i?
OAS9i for Forms/Reports can be installed only with infrastructure DB.
Standalone Forms/reports server do not needs Infrastructure DB.
The best installation will e on different computers.
ASKER
Schwertner:
-- Â What have you installed - standalone Forms/reports server or OAS9i?
For this installation of Oracle Clinical, I had to install components for the DB ad Middle tier as per the manual.
OS - W2k server on both DB server and Middle Tier. DB server is the PDC.
1. DB server _ Oracle 9i 9.2.0.1.0 patched to 9.2.0.6.0 - Enterprise edition complete.
Created database orcl - not used.
Then installed Oracle Clinical and patched it.
Created and configured Oracle Clinical database and started and mounted database.
2. Middle Tier.
Installed Oracle 9iAs Enterprise Edition. - component configuration and startup -> Oracle 9iAS Forms Server abnd Oracle 9iAs reports Server. Â (Then instructed to stop and remove the Forms and reports Services). This created 2 homes as mentioned above for the Forms and Apache Webserver.
3. Installed Oracle 10G - Forms and Reports server. i.e. Oracle Clinical uses this for the reports Server. Dpn't ask me why but that is as per the manual. Another home created \Oracle\10G
4. No database created on the Middle Tier. Used only for Webserver, Forms and reports server and Jinitiator 1.1.8.24
--- Â So if you are using a component give the full path to the executable for avoiding misunderstanding.
This uses java applet, forms servlets and the web - Formsweb.cfg, default.env and so forth. I will post the contents of the PATH on the middle tier at the end.
--- What is your computer configuration?
DELL DIMENISON Â 3100 Â 2.8Ghz 80Gb HDD 1GB memory (2 machines) same for Middle tier
PATH on Middle Tier in the same order as shown here. ORACLE HOME = \Oracle\806
D:\ORACLE\806\bin;
D:\ORACLE\806\FORMS60;
D:\ORACLE\806\FORMS60\java ;
D:\ORACLE\806\jdk\bin;E:\o papps45\bi n;
E:\opapps45\opa;
D:\ORACLE\iSuites\BIN;
C:\Program Files\Oracle\jre\1.3.1\bin ;
C:\Oracle\iSetup\bin;
D:\ORACLE\806\vbroker\bin;
D:\Oracle\10g\jdk\jre\bin\ classic;
D:\Oracle\10g\jdk\jre\bin;
D:\Oracle\10g\bin;
D:\Oracle\10g\jlib;
D:\Oracle\10g\jre\1.1.8\bi n;
D:\ORACLE\iSuites\Apache\P erl\5.0050 3\bin\mswi n32-x86;
C:\WINNT\system32;
C:\WINNT;
C:\WINNT\System32\Wbem;
C:\Program Files\Symantec\Norton Ghost 2003
-- Â What have you installed - standalone Forms/reports server or OAS9i?
For this installation of Oracle Clinical, I had to install components for the DB ad Middle tier as per the manual.
OS - W2k server on both DB server and Middle Tier. DB server is the PDC.
1. DB server _ Oracle 9i 9.2.0.1.0 patched to 9.2.0.6.0 - Enterprise edition complete.
Created database orcl - not used.
Then installed Oracle Clinical and patched it.
Created and configured Oracle Clinical database and started and mounted database.
2. Middle Tier.
Installed Oracle 9iAs Enterprise Edition. - component configuration and startup -> Oracle 9iAS Forms Server abnd Oracle 9iAs reports Server. Â (Then instructed to stop and remove the Forms and reports Services). This created 2 homes as mentioned above for the Forms and Apache Webserver.
3. Installed Oracle 10G - Forms and Reports server. i.e. Oracle Clinical uses this for the reports Server. Dpn't ask me why but that is as per the manual. Another home created \Oracle\10G
4. No database created on the Middle Tier. Used only for Webserver, Forms and reports server and Jinitiator 1.1.8.24
--- Â So if you are using a component give the full path to the executable for avoiding misunderstanding.
This uses java applet, forms servlets and the web - Formsweb.cfg, default.env and so forth. I will post the contents of the PATH on the middle tier at the end.
--- What is your computer configuration?
DELL DIMENISON Â 3100 Â 2.8Ghz 80Gb HDD 1GB memory (2 machines) same for Middle tier
PATH on Middle Tier in the same order as shown here. ORACLE HOME = \Oracle\806
D:\ORACLE\806\bin;
D:\ORACLE\806\FORMS60;
D:\ORACLE\806\FORMS60\java
D:\ORACLE\806\jdk\bin;E:\o
E:\opapps45\opa;
D:\ORACLE\iSuites\BIN;
C:\Program Files\Oracle\jre\1.3.1\bin
C:\Oracle\iSetup\bin;
D:\ORACLE\806\vbroker\bin;
D:\Oracle\10g\jdk\jre\bin\
D:\Oracle\10g\jdk\jre\bin;
D:\Oracle\10g\bin;
D:\Oracle\10g\jlib;
D:\Oracle\10g\jre\1.1.8\bi
D:\ORACLE\iSuites\Apache\P
C:\WINNT\system32;
C:\WINNT;
C:\WINNT\System32\Wbem;
C:\Program Files\Symantec\Norton Ghost 2003
ceecil:
In Fall 2005 I have installed (and in Germany now work) standalone Forms/Reports server.
Now I have installed OAS 10g (the most complicated configuration -Business Intellegence - it includes Forms/Reports Server).
I warn you that Forms/Reports Server in OAS 10g (not sure for 9i) cannot work without Infrastructure. And this infrastructure is based on Oracle server installed on the midd tier.
May be you do not need to install OAS9i. Directly install standalone Forms/Reports server 10g (it comes with HTTP(Apache) Â and works fine.
May be you need OAS9i for the Portal (but Portal configuration also needs Infrastructure Oracle instance at least in OAS10g).
Seems you have to read the manual very careful. Sometimes Oracle people do not write them correct and clear.
In Fall 2005 I have installed (and in Germany now work) standalone Forms/Reports server.
Now I have installed OAS 10g (the most complicated configuration -Business Intellegence - it includes Forms/Reports Server).
I warn you that Forms/Reports Server in OAS 10g (not sure for 9i) cannot work without Infrastructure. And this infrastructure is based on Oracle server installed on the midd tier.
May be you do not need to install OAS9i. Directly install standalone Forms/Reports server 10g (it comes with HTTP(Apache) Â and works fine.
May be you need OAS9i for the Portal (but Portal configuration also needs Infrastructure Oracle instance at least in OAS10g).
Seems you have to read the manual very careful. Sometimes Oracle people do not write them correct and clear.
ASKER
Schwterner:
From what I see and have carefully checked, the information that I have posted is correct. The installation of Oracle components and Oracle Clinical componenets have ben carefully selected EXACTLY as per the Oracle Clinical manual. Keep in mind that this has been done and working in other companies and I am doing it at home.
My point is simply that I CANNOT tnsping my database from the Middle tier. Â The OAS 9i Enterprise edition installs all the required services including iSuites Agent, Client cache, Http server, Data gatherer, Paging server, TNSlistener, Webcache, Webcache Admin.
All these services are up and running corectly.
So I don't see any problem.
All the logs were good when I did the install.
Oracel Clinical uses the forms servlet as it is web based using Apache http server.
Oracle Clinical uses 10G componets Forms and Reports only for the Reports server.
There is absolutely no database created on this machine where the Middle Tier has been installed.
I have posted all the information for analysis and the path has been displayed. All I need to know is what needs to be modified to TNSping my database.
The only problem right now is that I cannot tnsping the database on the DB server. Network is running fine and I can oing the DB server from the Middle tier.
From what I see and have carefully checked, the information that I have posted is correct. The installation of Oracle components and Oracle Clinical componenets have ben carefully selected EXACTLY as per the Oracle Clinical manual. Keep in mind that this has been done and working in other companies and I am doing it at home.
My point is simply that I CANNOT tnsping my database from the Middle tier. Â The OAS 9i Enterprise edition installs all the required services including iSuites Agent, Client cache, Http server, Data gatherer, Paging server, TNSlistener, Webcache, Webcache Admin.
All these services are up and running corectly.
So I don't see any problem.
All the logs were good when I did the install.
Oracel Clinical uses the forms servlet as it is web based using Apache http server.
Oracle Clinical uses 10G componets Forms and Reports only for the Reports server.
There is absolutely no database created on this machine where the Middle Tier has been installed.
I have posted all the information for analysis and the path has been displayed. All I need to know is what needs to be modified to TNSping my database.
The only problem right now is that I cannot tnsping the database on the DB server. Network is running fine and I can oing the DB server from the Middle tier.
ASKER
OK Shwertner,
I have decided to forget about trying to TNSping my database from the Middle Tier. This is what has happened. Normally, to test the connection we TNSping the database to see that all is well. This did not work for me for some reason or for that matter because according to the Oracle Clinical manual, I was not really installing everything that a normal installation would entail.
All I did was that I attemoted to bring up the Oracle Clinical screen from the Middle Tier (used as a client).
I lauched the Oracle Clincial acreen and keyed in a valid username and password. Then I keyed in the database name along with the domain name and after a few seconds, it simply connected and brought up the Oracle Clinical menu screen. Well, Now, I am on my way to configure the application for use.
Thanks for your insghts. You can take 100 points for your thoughts. If you feel  that your commenst were worht more, let me know.
This issue is now closed.
I have decided to forget about trying to TNSping my database from the Middle Tier. This is what has happened. Normally, to test the connection we TNSping the database to see that all is well. This did not work for me for some reason or for that matter because according to the Oracle Clinical manual, I was not really installing everything that a normal installation would entail.
All I did was that I attemoted to bring up the Oracle Clinical screen from the Middle Tier (used as a client).
I lauched the Oracle Clincial acreen and keyed in a valid username and password. Then I keyed in the database name along with the domain name and after a few seconds, it simply connected and brought up the Oracle Clinical menu screen. Well, Now, I am on my way to configure the application for use.
Thanks for your insghts. You can take 100 points for your thoughts. If you feel  that your commenst were worht more, let me know.
This issue is now closed.
Close the question. Points are not important.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
The tnsnames on the middletier is used only to make connection to the backend DB.
If you use the Net GUIs (like NetManager) to create the local name string you can also test if it works. This will also give you waranti
that the actual tnsnames.ora is accessed.