1)I recently install obiee 11G, I get an error of ompnctl failed during installation.Does it affect my setup later.
2) I start creating RPD in 11G , I first created an System DSN and check the database connection it result in sucess.
Then i start creating RPD in offline mode when i click on import meatdata after that Import meatadata- select datasource screen i choose ODBC 3.5 and choose the
same DSN which i check previously and give the same user id and password it is giving me error The connection has failed.I also tried using OCI 10g/11g and in data source name i give the full connection string and giv the user id and password but still the problem remain same.
Can anyone please help me in debugging the issue.
The Database is in the same machine in which i installed OBIEE 11G
Edited by: 812531 on Nov 17, 2010 5:30 AM
Edited by: 812531 on Nov 17, 2010 5:36 AM
If your datasource is an Oracle DB, it's highly recommended to use the OCI connection.
How to set this up is written here: [url http://forums.oracle.com/forums/message.jspa?messageID=9149360#9149360]Re: Unable to import tables in RPD
A few days ago I installed the Administration and Clients OBIEE11g tools on my machine. To do so follow these steps:
- Install Weblogic Server 10.3.3
- Install OBIEE 11g using 'Software Only'.
I selected this installation because BI Server is installed on a Linux server.
In the machine on which I installed previously existed the following products:
- Oracle Client 10.2
- Oracle ODBC Driver 10.2.0.2
When trying to import Metadata into the repository, using Administrative tool in OBI 11g the import fails with both, ODBC and OCI drivers. Always the same error appears: “The connection has failed.”
I created the tnsnames.ora file (which points to the database) in the path [Middleware Home] \ OracleBI1 \ network \ admin.
I tried to import metadata for replacing the DSN connection string. For this I have followed this syntax: (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = [ip_address]) (PORT = 1521))) (CONNECT_DATA = (SID = [db_name ]))). But it does not import metadata. Always the same error appears: 'The connection has failed. "
Can anyone help?
Thanks in advance.
The Oracle Metalink note that i used to install ('How To Install Only The OBIEE 11g Administration And Client Tools [ID 1186342.1]') has been changed in these days, and it indicates a new method for installation of OBIEE 11G administration and clients tools.
I installed according to the steps in the new Oracle Metalink note and the installation was successful. I was able to connect to different data sources that need to implement the OBIEE repository.