copy and paste this google map to your website or blog!
Press copy button and paste into your blog or website.
(Please switch to 'HTML' mode when posting into your blog. Examples: WordPress Example, Blogger Example)
oracle database - Difference between using a TNS name and a service . . . There are multiple ways to connect to the database: SID, TNS name, Service name I would like to understand what is the difference between each of these connections and what would be the recommended connection (SID, TNS, or service) if connecting to a clustered database
Use tnsnames. ora in Oracle SQL Developer - Stack Overflow I am evaluating Oracle SQL Developer My tnsnames ora is populated, and a tnsping to a connection defined in tnsnames ora works fine Still, SQL Developer does not display any connections Oracle
Oracle ORA-12154: TNS: Could not resolve service name Error? ORA-12154: TNS:could not resolve the connect identifier specified Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured
sql - ORA-12560: TNS:protocol adaptor error - Stack Overflow -2 In my case, (ORA-12560: TNS protocol adapter error)Issue cause of database connection issue like database, user name and password Once you got the issue Initially you have to check connection details, after check the oracle service and further more
PL SQL Developer cannot find my tnsnames. ora file 0 I recently had the problem of deleting the tnsnames ora from the path where I had it, my solution was to create an environment variable called TNS_NAME with the value the path where the tnsnames ora file is located and ready
ORA-12154: TNS:could not resolve the connect identifier specified . . . ORA-12154: TNS:could not resolve the connect identifier specified I am able to use SQLPLUS from the command line to connect to the database, and tnsping returns successfully, but I can't figure out why PLSQL Developer will not work - it's using the right tnsnames ora file, and the connection string in there is correct because it's the same one
oracle database - Where is TNSNAMES. ORA? - Stack Overflow SQL State=S1000 [Oracle][ODBC][Ora] ORA-12170: TNS: Connect timeout occurred I presume, though I am no DBA, that this has something to do with my TNS Service Name not being in TNSNAMES ORA which points oracle toward the right server, port, etc However I cannot find TNSNAMES ORA I have an ORACLE_HOME environment variable, but it is empty
oracle database - ORA-12505, TNS:listener does not currently know of . . . But the connection failed with error-ORA-12505 TNS listener doesn't currently know of SID given in connect descriptor I was at sea as to how this problem occurred since it was working fine with the SQL utility and I had also created few Informatica mappings using the same
ORA-12170: TNS:Connect timeout occurred - Stack Overflow I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I kept on ha