ORACLE BI Admintool.exe “The connection has failed”

First of all, let’s briefly describe Oracle Business Intelligence  Administartion Tool.

This tool is for to build, create, manage Oracle BI repository. The tool can be downloaded from Oracle site:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

choose Oracle Business Intelligence Developer Client Tools Installer.

As you can see the tool is just for windows. I don’t know why, maybe Oracle gays are so busy, I hope it will be for Linux too.

The installation for Oracle BI Suite(not Admin Tool) is for Windows as well as Linux. Installing on Windows is much easier, but because of I prefer Linux for my servers, I installed it on Linux. Unfortunately, I was not able to use Admin Tool on my Linux, and of course I did not want to install it with Wine. So I decided to configure Admintool.exe on windows with Oracle database client installed on it and tried to connect to the remote database called orcl. The error was the following “The connection has failed”

image

If you have the same error and all previous steps are satisfied (means you have installed Oracle client and AdminTool.exe on windows, you have database instance on somewhere that you can connect) the solution is very simple.

1. Close admin tool .

2. Describe TNS_ADMIN environment variable and set it to the value where tnsnames.ora file is located:

My Computer->Properties->Advanced System Settings. Appears the following windows and choose Environment Variables

image

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Click New button in System variables section and fill fields by the following:

Variable name: TNS_ADMIN

Variable value: %ORACLE_HOME%\network\admin

image

 

 

 

 

 

 

 

 

 

 

 

 

 

Click OK

3. Re-run AdminTool.exe

That is all, good luck. I hope the post was helpful for you.

Advertisements

4 Responses to ORACLE BI Admintool.exe “The connection has failed”

  1. raj says:

    does not workk for me

  2. Sone says:

    Hi, I follow like your recommence but it still the same connect fail, i’m not sure that Administrator Tool should be installed in Client or BI Server, For me I installed in my PC

    • dba010 says:

      You should install this tool on windows server from where TCP 1521 port is open to the BI server.
      So try to telnet 1521 port from your computer to BI Server, also you must have installed oracle client on your PC.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: