In windows server where OBIEE 11g was installed, no oracle client was installed. I was unable to import tables because DSN to oracle Database cannot created.
To overcome this problem we have to create a tnsnames.ora file in the directory E:\OBIEE11g\Oracle_BI1\network\admin. Tnsnames.ora file will have the TNS entries to the Database.
E is drive on which I have oracle BI installed and OBIEE11g is where I have installed OBIEE 11g or the middleware home.
To overcome this problem we have to create a tnsnames.ora file in the directory E:\OBIEE11g\Oracle_BI1\network\admin. Tnsnames.ora file will have the TNS entries to the Database.
E is drive on which I have oracle BI installed and OBIEE11g is where I have installed OBIEE 11g or the middleware home.
No comments:
Post a Comment