Majlos

BO connection problem

Discussion created by Majlos on Nov 19, 2010
Hi

I have two servers.
1. Win2003x64 with clarity 12.1 and DB oracle 10.2.0.4
2. Win2003x64 BO 3 Oracle client 10.2.0.1 for 32bit

After installing the BO and oracle client a seted everything and imported the universe for oracle. Then I tried to test from BO designer ->Tools->connection - from the connection list I selected CA_Clarity and tried to connect. I got message "DBD: ORA-12154: TNS:could not resolve the connect identifier specified"
I tried to connect to the DB due to sqlplus and it works fine. I seted the DSN, but I do not think so, that for oracle connection is necessary and it works fine too.

tnsnames from DB server

CLARITY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.0.0.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = clarity)
)
)

tnsnames from BO server

NIKU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.0.0.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = clarity)
)
)


Please anybody can help me?

Regards, Majlos

Outcomes