From: http://livenzhao.spaces.live.com/blog/cns! 6e0000be9f6ddd872! 595. entry· PL/SQL Developer skills
1. PL/SQL Developer remember the Login Password
When PL/SQL Developer is used, PL/SQL Developer needs to remember the username and password
This is one of the most common errors while creating linked server to Oracle database. Today I will discuss the reason for this error and possible resolutions.
Full error message:
Ole db provider "MSDAORA" for linked server "LINKED_ORA"
ORA-12154: TNS: unable to resolve the specified connection identifier resolved
I believe that people who have used Oracle databases must have encountered the "ORA-12154: TNS: unable to resolve the specified connection identifier" error, I would like
I believe that people who have used Oracle databases must have met ldquo; ORA-12154: TNS: unable to resolve the specified connection identifier rdquo; error, I would like to make a small summary here.
I believe that people who have used Oracle
I believe that people who have used Oracle databases must have encountered the "ORA-12154: TNS: unable to resolve the specified connection identifier" error, I would like to make a small summary here. The connection to the Oracle database in a
PL/SQL Developer
Remote connection to Oracle Database
I searched many methods online. This is feasible!
1. Configure the server tnsnames. ora file. If oracle is not installed on the local machine, you can copy one (tnsnames. ora file) in the
Oracle appears ora-12154 cannot resolve resolution for the specified connection identifier, oracleora-12154
I believe that people who have used Oracle databases must have encountered the "ORA-12154: TNS: unable to resolve the specified connection
IT Ninja Turtles PL/SQL Developer tips and shortcuts, Ninja Turtles developer
1. SQL plus Window: File-> New-> Command Window. This is similar to the SQL plus client tool of oracle, but it is much easier to use than it.
2. Set the Keyword to
Log on to PL/SQL Developer, log on to the local database, and check that the Oracle listening service is not started. Right-click to start the listening program and report an error. How can this problem be solved ?,
I. Error description
When you
Possible problems: 1. windows Firewall. 2. The environment variable PATH does not contain % ORACLE_HOME % \ bin, which leads to many ORACLE connection setting methods. Four methods are provided here, however, it is mainly about the remote connection
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.