Skip to Content
0

DBD: ORA-12154: TNS:could not resolve the connect identifier specified

Mar 30, 2017 at 07:25 AM

296

avatar image
Former Member

Hi

I am getting error(DBD: ORA-12154: TNS:could not resolve the connect identifier specified) while testing connections. but i can connect from sql/toad using the same service name.

checked tns file too and it seems fine.

any solution?

thanks

Ravi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

James Zhang
Mar 30, 2017 at 07:57 AM
0

Hi Ravi,

Please let me know where you hit this error? sqlplus or sap dbco?

Normally this error means the ip interpreted via tnsnames.ora (if used) is wrong, or following connection string ip is wrong:

conn username/password@listenerhost:port/servicename

So please show us the connection string.

Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 30, 2017 at 09:49 PM
0

Hi James,

I am getting this error in SAP designer.

In parameters, I got this error while testing service name.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Ravi,

Sorry I am not pretty sure of sap designer, but you can check by yourselves:

1. whether tnsnames.ora is used
2. if yes, then please check this file, and test the connect string in tnsnames.ora directly
3. if not, then please check how you maintain the db connection string

Because the problem is pretty clear: wrong connection string, so as long as we can find out the connecting string we used, we can fix this issue.

Best regards,
James

0