You need not, we can do it either by setting it as an environment variable or use -oh command. I always use -oh and it works fine.

Hi Here is the syntax: opatch apply <PATCHpath> -oh <ORACLE_HOME_PATH> -jre <Java path> example ./opatch apply 21672441 –oh /obiee/app/oracle/product/Middleware/oracle_common -jre /obiee/app/oracle/product/Middleware/jdk1.6.0_121

Hi Check, we have recently migrated OBIEE 11.1.1.9 to OBI12C using below command , validate if you have done something similar. Copy the file $MW_HOME/bi/migration-tool/jlib/bi-migration-tool.jar from OBIEE 12c to OBIEE 11g. Create a directory and move the file to the same: mkdir $MW_HOME/migration_2_12c cp…

Hi Check Base DN , Group DN configuration.

Yes, all the deployments are up.

Hi Which version of ODI Studio are you using and we can see the error that the Java version is not compatible. Error: ODI can't recognize the JDK version Are you accessing this from the server or client machine?

No! Providing a wrong password cannot bring down a service.

Hi I did face same issue when we upgraded OBIEE 11G to 12c. Kindly follow these steps: INSTALLATION DOCUMENTS BY RAVI: Administration link is missing obiee after upgrade

Hi Krishna We recently faced similar issue with exact same version. I observed that if you wait for more than 1 hour before trying to start the service then the configurator does not pick the latest status of the service. Timing is very important. I would recommend re-configuration of OBIEE and wait for step to reach…

Hi Silent installation is not a very good idea unless you have clear understanding of every response/parameter. The response file seems fine, just fill in all the details you have left blank like MW Home, Static port file etc. You need to have everything filled up. Logically you are providing responses for each screen in…

Hi Install Oracle 10G and 11G clients for the exact version you want that will get the drivers along with it. Thanks Anjum

Maybe this line made me feel that you need RDBMS details and not the source system or ERP - It will support only for Oracle sources or will support for non oracle source systems also .means if the source system is SQL server then will it support as source . . In that case in the Certification Matrix you should find the…

Hi BI products have an excel called Compatibility Matrix available easily on Google. Download it and it will provide you the list of RDBMS servers compatible with OBIA. I see from there and it lists only Oracle DB versions - 11.2.0.1+

This maybe related to the hosts file on your environment.

Hi ODI is not able to connect to the schema in your database, it could be one of these reasons 1. Database server is down or listener is down 2. Passwords expired 3. Hostname or JDBC connection string is incorrect in the ODI login page 4. Incorrect schema name or password Thanks AA

Hi Mahesh You can check with your system team or ODI team if they have setup automation process to purge the tables not quite possible that it does it on its own.

Hi Carla The latest one available is 11.1.1.10.1 which you can find in http://edelivery.oracle.com, for the older version you can raise a Contact Us SR with Oracle and they will provide you link to it which is active for 1 week and you can download from there. Thanks AA

You can list out the users in the Oracle DB by using select * from all_users. Maybe you would be able to recall which exact user is related to your repository.

Make sure your Oracle DB is running on the specified port. You can always check by running following command on cmd prompt TELNET <DBSERVERNAME> <DBPORT> This shows first if the port is open between the machine you are trying to setup DSN to the Oracle DB. If it enters a blank page that means the DB is up and running and…

Hi The ODBC drivers are missing in the library path of your server. If they do not exist install it and then point them as below. Ref below links: Why do I get error "libodbc.so.1: open failed: No such file or directory"? Progress KB - "error while loading shared libraries: libodbc.so: cannot open shared object file: No…