Re: Net8-Problem

Michael,

Your SQLNET.ORA file looks ok to me. It would be nice if you would've included your TNSNAMES.ORA file too.

From the docs:    

ORA-12222 TNS:no such protocol adapter

Cause: The protocol adapter requested (by way of the "(PROTOCOL=..)" keyword-value pair in a TNS address) is unknown. If the supplied address is typographically correct then the protocol adaptor is not installed.

Action: Install the protocol adapter or correct typographically error, as appropriate. Note: if the supplied address was derived from resolving the service name, check the address in the appropriate file (TNSNAMES.ORA, LISTENER.ORA or TNSNET.ORA).

I see in your trace file that you are trying to use the bequeath protocol. Have you installed this protocol? Have you specified this protocol in your TNSNAMES.ORA file for your TNS entry? What happens if you change it to the TCP protocol (which you have defined in your LISTENER.ORA file)?

HTH,
Brian

michaelbogen_at_my-deja.com wrote:
>
> 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.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================