Toad World® Forums

ORA-12505 TNS:listener could not resolve SID given in connect descriptor and ORA-12154: TNS: could not resolve service name


I am a new user of toad for oracle 11g 64 bit and I tried to connect to the database on the virtual machine. But the error 12505 and 12154 keeps showing up for the databases I need to connect. I have put tnsname.ora file in the admin folder of Oracle and set the TNS_ADMIN environment variable correctly. I am wondering what is the most possible reason and solution for the issue. Thanks!
Database Connection Issue.pdf (269 KB)