BI Administration Tool - import metadata select metadata objects shows nothing.

The administration tool is missing ddl as seen in the log file - Administrator_NQSAdminTool.log:


[2012-07-27T10:18:20.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 76c]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found. [[
.
The specified module could not be found.


I have found the solution here.
http://www.rittmanmead.com/2012/05/obiee-administration-tool-import-metadata-shows-no-schemas/

Custom install Oracle DB Client and make sure to install Oracle Call Interface (OCI).

Start Weblogic Without Entering Username and Password

Go to:
cd $MW_HOME/user_projects/domains/bifoundation_domain/servers/AdminServer/security/

and create file boot.properties this inside


username=Admin_Username
password=Admin_Password


Reference:
Enterprise Deployment Guide for Oracle Business Intelligence
E15722-01
5.2 Creating boot.properties for the Administration Server on APPHOST1
http://docs.oracle.com/cd/E14571_01/doc.1111/e15722.pdf

Uninstall Exalytics software

OBIEE
Oracle_BI1/oui/bin/setup.sh -deinstall
oracle_common/oui/bin/runInstaller -deinstall -jreLoc $JAVA_HOME

Weblogic
fmw/wlserver_10.3/uninstall/uninstall.sh

TimesTen
TimesTen//tt1122/bin/setup.sh -uninstall

Go to /etc/TimesTen
rm -rf /etc/TimesTen/*
touch /etc/TimesTen/instance_info

UnInstall TimesTen:
http://docs.oracle.com/cd/E11882_01/timesten.112/e21632/install.htm#autoId39

Remove Weblogic Server

$MW_HOME/wlserver_10.3/uninstall/uninstall.sh

Exalytics silent installer

It needs to be run in that way:
./setup.sh /home/oracle/EXALYTICS_
INSTALLERS/bi/bishiphome/Disk1/bimachine/scripts/bim-setup.properties

Go to Disk1/bimachine/
from there run setup.sh and the full path to bim-setup.properties
Otherwise an error message an error message saying:



./setup.sh scripts/bim-setup.properties

BUILD FAILED
/home/oracle/EXALYTICS_INSTALLERS/bi/bishiphome/Disk1/bimachine/scripts/bim-setup.xml:26: The following error occurred while executing this line:
/home/oracle/EXALYTICS_INSTALLERS/bi/bishiphome/Disk1/bimachine/scripts/bim-setup.xml:37: The following error occurred while executing this line:
/home/oracle/EXALYTICS_INSTALLERS/bi/bishiphome/Disk1/bimachine/scripts/bim-wls.xml:20: bim.temp.dir ${bim.temp.dir} does not exist!

Total time: 0 seconds

will appear.

Uninstall TimesTen

/u01/app/oracle/product/TimesTen/tt1122/bin/setup.sh -uninstall

$TIMESTEN_HOME/bin/setup.sh -uninstall


Reference:

Uninstalling TimesTen on UNIX systems

Uninstall Oracle Fusion 11g

$MW_HOMW/oracle_common/oui/bin/runInstaller.sh -deinstall -jreLoc $JAVA_HOME


Reference:

6.4.7 Deinstalling the Oracle Common Home

http://docs.oracle.com/cd/E23943_01/bi.1111/e10539/c6_deinstall.htm#CIHFDFEE

Uninstall OBIEE 11g on Linux

From OBIEE installation run ($ORACLE_HOME/oui/bin):
fmw/Oracle_BI1//oui/bin/runInstaller -deinstall

Save the settings for silent uninstaller as described here:

http://docs.oracle.com/cd/E23943_01/bi.1111/e10539/c6_deinstall.htm#autoId20
./runInstaller -silent -deinstall -response path_to_deinstall_instance_file/deinstall_instance_filename.rsp



Install Oracle and OBIEE under the same user in linux.

I was always installing Oracle DB under oracle user and OBIEE under obi user.

In this way under oracle $ORACLE_HOME was point to the database and under obi it was pointing to $MW_HOME\Oracle_BI1
The idea for separation was first suggested to me by Gerard Nico's blog .

So the variables that need to set are:

ORACLE_HOME=$MW_HOME/Oracle_BI1
TNS_ADMIN=$ORACLE_HOME/network/admin
# Create tnsnames.ora under MW_HOME/Oracle_BI1/network/admin


If setting the PATH variable make sure $MW_HOME/Oracle_BI1/bin is before database $ORACLE_HOME/bin.

If OBIEE is going to the DB tnsnames.ora, this type of error might show up:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)