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)
)
)