Critical Issue meant regarding Business Objects web Intelligence product

[Former Member]

Hi,

After the migrations of some of the oracle databases used in our BO Webi product, one of our application is no more accessible via Webi.

However, the entries of the concerned databases have been updated in the oracle tnsnames.ora file.

The new oracle server has exactly the same OS configuration and oracle version (version 10).

Actually the lonely changes are the server database name and the port (1522 instead of 1521) in the tnsnames.ora file.

Is there a configuration file somewhere on the applicative server in which there may have a trace of the oracle server name or its IP address.

Or is there anything else to configure?

After many minutes of trying to load the page, our users meet this "classical error" ORA-12170: TNS:Connect timeout occurred

NB: Our tnsnames entries look like:

database.domain =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = database)

)

)

Thanks in advance for you help

[Former Member]

If Oracle Client is installed on your Server, have you tried Connecting to the Oracle Server ..?

If it works, then goto ODBC DSNs and check for the Oracle Driver version installed on the server.

You can find the same ODBC DSN version on your Oracle Server.

Have a look , the Drivers Versions may have some conflicts like Backward Compatibility.

Have you tried copying the tnsnames file from some other Client machine , from where you are able to access the Oracle Server..?

Lets do it...

Even we had changed the oracle servers and database names.. but we ended up cool... succesfully.

[Former Member]

I can tnsping the databases on the oracle server successfully from the applicative server with success...

On the applicative server the ODBC version for oracle driver is 2.576.3959.00