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)
ORA-12154 when connecting using tns alias - Stack Overflow Did you actually create a database instance named ORCL? Check out the actual name of your database with the command lsnrctl status This should tell you what services the listener knows about, which is what you're talking to when connecting with the @ syntax The reason you can connect without the @ORCL is that in that case you're using interprocess communication (IPC) and bypassing the
Database Net Services Administrators Guide A connection to the database or other service is requested using a connection alias, but the specified alias cannot be resolved into a connect descriptor using one of the configured naming methods
ORA-12154 TNS Connection Identifier Solution - Database Star Have you gotten an "ORA-12154: TNS:could not resolve the connect identifier specified" error? Learn what causes it and how to resolve it in this article ORA-12154 Cause If you attempt to access or log on to an Oracle database, you might get this error:
oracle database - ORA-12154: TNS:could not resolve the connect . . . 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
ORA-12154 - Database Error Messages - Oracle alias_value: The alias or connect identifier that is used repository_loc: The naming method repository or the repository that cannot be located or reached
oracle - ORA-12154 TNS: could not resolve the connect identifier . . . Which is wrong interpreted by sqlplus as: C:\programs\Oracle\Ora11g\BIN\sqlplus username@database_name Also, in Oracle, the owner of a schema (hence the schema name) is the user name Obviously, grants can be given to other users to perform DML DDL on other schemas, but you still have to login with a user with sufficient rights
Resolving the ORA-12154 Error: A Comprehensive Guide Understanding and Identifying Causes of ORA-12154 The ORA-12154 error: “TNS:could not resolve the connect identifier specified,” is a notorious snag that frustrates Oracle database users with its cryptic message