Skip to Content
0
Former Member
Jul 26, 2016 at 07:06 PM

ORA-12154: Failed to Open the connection

1384 Views

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)

)

)