Hi Guys,

I just created a second database in my NT machine, no problem in installtion now I try to configure SQL*Net, it is not successful. I have this error :


SQL> connect system/manager@test
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor


BUT when I issue this, look it works ...why ??

SQL> connect system/manager
Connected.


Also we use Oracle Name server instead of local sql*net, I added the entry to Name server and restart it as well !! No luck yet .. and I think when you use Oracle name server you only need Listener.ora .. Am I correct ?? And here is my listner file :

# D:\ORACLE\ORA81\NETWORK\ADMIN\SQLNET.ORA Configuration File:\Oracle\Ora81\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle Net8 Assistant

TRACE_DIRECTORY_CLIENT = C:\temp

TRACE_UNIQUE_CLIENT = on

TRACE_DIRECTORY_SERVER = C:\temp

TRACE_FILE_CLIENT = Net8trac.log

TRACE_FILE_SERVER = net8traS.log

TRACE_LEVEL_CLIENT = ADMIN

TRACE_LEVEL_SERVER = ADMIN

SQLNET.EXPIRE_TIME = 0

NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tod__d01)(PORT = 1575))
(ADDRESS = (PROTOCOL = TCP)(HOST = tod__d02)(PORT = 1575))
)

NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)


Can you rescue me from this stuck stage ... Also TNSPING works


Z:\frank>tnsping test ( test is my instance name )

TNS Ping Utility for 32-bit Windows: Version 8.1.5.0.0 - Production on 19-JUN-01 14:09:34

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

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=MOON.DEV.BEMANY.COM)(PORT=1521))
OK (120 msec)