URGENT : connection problem

[farrokhp]

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)

[sambavan]

Check your listener.ora and tnsname.ora files and confirm that they have been configured properly. Then if you are planning to connect to the database using the tnsnames, then modify the sqlnet.ora to check first into the tnsnames and then the oracle name server.

If this doesn't work use the netassist to configure and it might solve the problem for you.


Sam

[farrokhp]

Ok It worked Sam, Thanks man