Error ORA-12154 :TNS:Could not resolve the connect identifier specified". in Vb.net

Question

1.00/5 (2 votes)

See more: (untagged)

CSS

The following Error Occured while Connecting to Database.
"ORA-12154 :TNS:Could not resolve the connect identifier specified".
Plz Give Me Solution to solve this error.

Posted 10-Feb-10 1:21am

SushilPatil1

Updated 7-Mar-17 4:54am

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2010-02-10T02:43:00

Solution 1

Ever heard of google?

http://ora-12154.ora-code.com/[^]

Posted 10-Feb-10 2:43am

#realJSOP

Wjousts · Answer 2 · 2010-02-10T04:06:00

Solution 2

This is an Oracle error rather than a .NET error. Check your TNSNames.ora file.

Posted 10-Feb-10 4:06am

Wjousts

N a v a n e e t h · Answer 3 · 2010-02-10T04:07:00

Solution 3

The connect identifier which you are using is not available in your tnsnames.ora file. You need to edit this file and add proper details.

Posted 10-Feb-10 4:07am

N a v a n e e t h

Dnyaneshwar Pawar · Answer 4 · 2012-01-24T03:18:00

SYMPTOM
Receive the error message, "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.

For example, if the type of connect identifier used was a net service name, then the net service name could not be found in a naming method repository, or the repository could not be located or reached.

RESOLUTION
If you are using local naming (TNSNAMES.ORA file)

1. Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)

2. Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.

3. Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.

4. Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable.

If you are using directory naming

1. Verify that "LDAP" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).

2. Verify that the LDAP directory server is up and that it is accessible.

3. Verify that the net service name or database name used as the connect identifier is configured in the directory.

4. Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier

If you are using easy connect naming

1. Verify that "EZCONNECT" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).

2. Make sure the host, port, and service name specified are correct.

3. Try enclosing the connect identifier in quote marks. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming.

Member 13044051 · Answer 5 · 2017-03-07T04:54:00

ora-12154 tns could not resolve the connect identifier

if you are still facing this error please go through this !!!!

same error we will get if we don't follow the oracle password policies

check the below link for password setup rules for oracle https://docs.oracle.com/cd/B28359_01/network.111/b28531/guidelines.htm#CHDEGEIF

I also had this issue, and the root cause was, my password has '@' character. I just enclosed the password in double quotes and it worked. e.g. connect system/"p@sswor