I have a quick question about SERVICE_NAME and SID.

I have two instances on the same server. one instance was created by database configurantion assistant this instance called TEST, on the tnsnames oracle used SERVICE_NAME=TEST. I created another database and this new database called MYTEST manually, and I also used SERVICE_NAME=MYTEST. For some reason, when I connect to MYTEST database I got the error:


ORA-12514: TNS listener could not resolve SERVICE_NAME given in connect

why was that??? I aslo add MYTEST sid_name into the listener.log and that doesn't help