Re: Net8-Problem

Hi Brian / Happychappy,

thanks a lot for your answers!
Unluckily I still have the same problem. Sometimes it is a ORA-12222 (TNS:no such protocol adapter), but I think that is the same. Oracle still does not open tnsnames.ora.

Maybe my sqlnet.ora/listener.ora files are not correct(?): sqlnet.ora:
names.default_domain = myhost.mydomain
sqlnet.expire_time = 10
names.directory_path = (TNSNAMES)
trace_level_client = 16
/

listener.ora:
LISTENER =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))   )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME=FHF)
(ORACLE_HOME=c:\orant8i)
(GLOBAL_DBNAME=FHF)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
/

Maybe the sqlnet.trc migth help: --- TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is "sqlnet.trc" New trace level is 16 --- TRACE CONFIGURATION INFORMATION ENDS --- nigini: entry nigini: Count in NI global area now: 1 nigini: Count in NI global area now: 1 nrigbi: entry nrigbni: entry nrigbni: Unable to get data from navigation file tnsnav.ora nrigbni: exit nrigbi: exit nigini: exit niqname: Hst is already an NVstring. niqname: Inserting CID. (ac57) niotns: entry (ac57) niotns: niotns: setting up interrupt handler... (ac57) snsbitini_ts: entry (ac57) snsbitini_ts: normal exit (ac57) snsbitcl_ts: entry (ac57) snsbitcl_ts: normal exit (ac57) snsbitini_ts: entry (ac57) snsbitini_ts: normal exit (ac57) niotns: Not trying to enable dead connection detection. (ac57) niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=or acle80FHF)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNEC T_DATA=(SID=FHF)(CID=(PROGRAM=C:\orantAPP\ows\4.0\jdk\bin\java.exe)(HOST=myho st)(USER=Administrator)))) ... ...

Thanks for any help.
Michael

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 15 2000 - 14:33:20 CST