ORA-12500 error when Advanced Networking Option activated on Oracle8 - help!

Hi,

One of our clients wants us to set up encryption for an extranet database, so I suggested using the Oracle Advanced Networking Option, which I haven't used before. I installed the 60-day trial version on an Oracle 8.0.3 60 day trial server, and then installed the ANO alone with SQL*Plus 8.0 on a client NT workstation. Both server and workstation are running on NT 4.0. I have run Net8 Assistant to set up the cipher; both are set to RC4_40. I then turned on the integrity options to "required". The crypto seed has a random string in it on both boxes. So I stopped and started the server, and now, this is all I get from the server:

ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process

I have tried stopping and starting the server and the listener from the NT Services control panel. What am I doing wrong? SQLNET.ORA on the server is reproduced below. When I turn off ANO by deleting the lines from the SQLNET.ORA file that refer to it, everything works fine.

Any thoughts on what's wrong would be greatly appreciated! On a (possibly) unrelated topic, I have been unable to get Oracle to trace *anything*. None of the lines in the SQLNET.ORA file seem to help in creating files; no files are ever created in any of the target directories.

Thanks for any help.

yours,
Simon Rakov

• SQLNET.ORA file
  # C:\ORANT\NET80\ADMIN\SQLNET.ORA Configuration File:C:\ORANT\NET80
  \ADMIN\sqlnet.ora
  # Generated by Oracle Net8 Assistant
  

SQLNET_CRYPTO_CHECKSUM_TYPE_SERVER=MD5 TRACE_DIRECTORY_CLIENT=c:\orant\trace

LOG_FILE_CLIENT=oralog.txt

TRACE_UNIQUE_CLIENT=on

NAME.DEFAULT_ZONE=world

NAMES.DEFAULT_DOMAIN=world

TRACE_DIRECTORY_SERVER=c:\orant\tracesrv

SQLNET.AUTHENTICATION_SERVICES= (NTS) LOG_DIRECTORY_CLIENT=c:\orant\clilog

TRACE_FILE_CLIENT=oraclitrace.txt

TRACE_FILE_SERVER=orasrvtrace.txt

TRACE_LEVEL_CLIENT=ADMIN LOG_DIRECTORY_SERVER=c:\orant\srvlog

SQLNET.CRYPTO_CHECKSUM_CLIENT=required

TRACE_LEVEL_SERVER=ADMIN SQLNET.ENCRYPTION_TYPES_SERVER= (RC4_40) SQLNET_CRYPTO_CHECKSUM_TYPE_CLIENT=MD5 SQLNET.EXPIRE_TIME=0 SQLNET.ENCRYPTION_SERVER=requested

SQLNET.CRYPTO_CHECKSUM_SERVER=required

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME) SQLNET.CRYPTO_SEED=qwertyuiopasdfghjkl;zxcvbnm

--
-
Simon Rakov
Senior Software Engineer
USWeb Corporation
70 Blanchard Rd, Burlington MA 01803

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sun Jul 19 1998 - 16:06:38 CDT