Question

ORA-12154: TNS:could not resolve the connect identifier specification

Version 9 Workflow

Updated January 13, 2016

asked on March 1, 2015 • Show version history

hi to all

I am facing very strange problem with the Oracle Connectivity.

I created System DSN trough ODBC and tested it is working fine but when I try to call same DSN to workflow and try to test I am getting ORA-12154 Error which is TNS related.

OS : windows Server 2012 R2 64 bit

Oracle Driver : 11.2.0.1.0 64 bit

for more information I am attaching Screen Shots.

Best Regards

Mazahir Naya

Windows ODBC.tif (168.95 KB)

| Download

Workflow-Designer.tif (165.21 KB)

| Download

0 0

Replies

replied on March 4, 2015

After install Oracle Client 12.1.0.1.0 we are able to connect to the DB.

1 0

replied on January 10, 2016

hi Ben

yes after install Oracle client 12 as mentioned version we did not face any issue.

Thank You.

1 0

replied on January 11, 2016

Thanks for your reply, Mazahir.

1 0

replied on January 13, 2016

Anytime Ben...

0 0

replied on March 2, 2015

There isn't enough information to troubleshoot. Please take screenshots of the configuration of your data source and open a support case.

0 0

replied on March 2, 2015

Thanks Miruna will Open support case and provide detailed information.

Regards

Mazahir Naya

0 0

replied on January 6, 2016 • Show version history

Hi Mazahir,
At a customer site, we were OK using Oracle 11.0x (11g) client on Win2012 but had the same issue with Win2012 R2. I'd lke to hear more about your issues. Did you end up logging a call after installing client 12.

-Ben

0 0

You are not allowed to follow up in this post.

Question

Question

ORA-12154: TNS:could not resolve the connect identifier specification

Replies

Sign in to reply to this post.