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
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
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
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.