Skip to Content
author's profile photo Former Member
Former Member

ORA-12154: Failed to Open the connection

Hello All,

My PC was re-imaged and I had to re-install Crystal Reports 2013. However, when i try to open the database connection, I get the following error message:

"Failed to open the connection. Details: ORA-12154: TNS:could not resolve the connect identifier specified. [Database vendor code: 12154]

Any suggestions on what may be going and how to fix this issue?

Here is how my tnsnames.ora file looks like:

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

CLARITY =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = mycompanydatabase)(PORT = 1536))

)

(CONNECT_DATA =

(SID = CLAR10G)

(SERVER = DEDICATED)

)

)

CLAR10G =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = mycompanydatabase)(PORT = 1536))

)

(CONNECT_DATA =

(SID = CLAR10G)

(SERVER = DEDICATED)

)

)

CLARPOC =

(DESCRIPTION =

(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 10.6.247.85)(Port = 1526)(queuesize = 1024))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = clarpoc)

)

)

CLARTST =

(DESCRIPTION =

(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 10.6.247.85)(Port = 1521)(queuesize = 1024))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = clartst)

)

)

ACCESSNP =

(DESCRIPTION =

(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 10.6.247.148)(Port = 1530)(queuesize = 1024))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = accessnp)

)

)

CLARVAL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.247.149)(PORT = 1526))

)

(CONNECT_DATA =

(SID = CLARVAL)

(SERVER = DEDICATED)

)

)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Aug 02, 2016 at 02:52 PM

    Are you able to do a TNS Ping for the connection using a Command prompt? Also I would suggest to make a entry in the host file for the Oracle Server Hostname and IP address.

    See if that helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 29, 2016 at 02:43 PM

    Hello Nimish

    Can you test with other applications the connectivity to the oracle servers works fine or not from outside of Crystal Reports?

    Also if you have odbc client installed for Oracle, can you create and test an odbc connection?

    BR,

    János

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi János,

      I checked and found that the Oracle SQL Developer has no issues in connecting to the database. I also have a User DSN and System DSN setup on my PC to this database and it works just fine.

      I am not sure if the issue is with the Oracle drivers or something because when I refresh a SQL Server based data source in the same Crystal Reports tool, it just works fine.

      Thanks

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.