OBIEE Administration Tool show no tables

Its complicated when you have to import some tables using oracle Admin Tools and there show no tables! You run to the database and they are there.

Ok, to fix it, you have to download Oracle Database Client, and install OCI (Oracle Call Interface)

Oracle Call Interface (OCI) is the comprehensive, high performance, native C language interface to Oracle Database.  It exposes the full power of Oracle Database to custom or packaged C applications.  Oracle In-Memory Database Cache also supports access from OCI programs. http://www.oracle.com/technetwork/database/features/oci/index-090945.html

To download Client for Oracle Database 11g Release 2:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html

After download, when installing, select Oracle Call Interface (OCI) and finish.

Now you can import yout tables and schemas on import metadata wizard with no problem!!

This happend because the library 'oracore11.dll' isn’t provided by InstantClient, so you must install the full Oracle Client.

OBIEE Software Only Installation Step-by-step Part-3

Part 3

Hey there!

On part 1 & 2 we made a lot of things required for OBIEE works fine! Operational System, Java JDK, System Variables, listener and database. If you are ok let's go, if not, please, review your work and make sure you have completede all steps before.

Weblogic configuration
Unzip weblogic 10.3.6 generic file and execute it:

[oracle@obiee wls] java -jar wls1036_generic.jar

1- Click next
2- Create a middleware home in /u01/app/middleware

3- Ignore Pop-up, continue
4- Select "Typcal" install type and Next
5- Select Java JDK installed on Step 1, Next
6- Verify the directory is correct and Next
7- View the resume of your configuration, Next
8- Wait the install progress, check "Run Quickstart", Done
9- Select "Create a new Weblogic domain", Next

10- Select "Generate a domain....", Next

11- Check directory path and base domain name, Next

12- Set "weblogic" user password, this tutorial is using welcome1 as default, next
13- Select Java JDK, Next
14- Left the check boxes here uncheck, next
15- Review your instalation, Create
16- After the configuration, Done.

Weblogic and admin server? Done!
Now lets install Oracle Business Intelligence and configure it!

Unzip all obiee rar parts on a directory, navigate on Disk1/bin folder and execute:

[oracle@obiee bin] ./runInstaller

1- Next
2- Skip, next
3- Select "Software Only Install", next
4- Make sure all prerequisite checks are ok, next
5- Select middlware folder and Oracle Home Directory, next

6- Select "Weblogic Server", next
7- Review your installation summary, install
8- Next
9- Finish.

Now we have the OBIEE software installed, but no domain created. Let's create him and finish this work!

navigate to: /u01/app/middleware/Oracle_BI1/bin folder

[oracle@obiee bin] ./config.sh

1- Next
2- Make sure all prerequisite are ok, next
3- Select "Create a new BI System", next

4- Left all domain, instance and instance name as default, next
5- Mark all option, next
6- Connect to dev_biplatform

7- Connect to dev_mds

8- Check auto-port configuration
9- Skip email check
10- Review your configuration
11- After install, click Finish.

Just acess:
http://localhost:9704/analytics
Use weblogic/welcome1 as user/password

Enjoy!!!!!

[]'s
Igor Gentil

OBIEE Software Only Installation Step-by-step Part-2

Part 2

Ok, now we have to create and configure the listener.

The listener is a separate process that runs on the database server computer. It receives incoming client connection requests and manages the traffic of these requests to the database server. This chapter describes how to configure the listener to accept client connections. http://docs.oracle.com/cd/B10501_01/network.920/a96580/listener.htm

[oracle@localhost /]$ netca 

Done!

Now we will create a database instance.

Database Configuration Assistant (DBCA) is the preferred way to create a database, because it is a more automated approach, and your database is ready to use when DBCA completes. DBCA can be launched by the Oracle Universal Installer (OUI), depending upon the type of install that you select. You can also launch DBCA as a standalone tool at any time after Oracle Database installation. http://docs.oracle.com/cd/B28359_01/server.111/b28310/create002.htm#ADMIN12479

[oracle@localhost /]$ dbca

Ok, let's test the database.
[oracle@obiee ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 28 17:35:57 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


SQL>

Nice job!

Now we have a database, next step is create the OBIEE required repositories.

Many of the Oracle Fusion Middleware components require the existence of schemas in a database prior to installation. These schemas are created and loaded in your database using the Repository Creation Utility (RCU). http://docs.oracle.com/cd/E21764_01/doc.1111/e14259/overview.htm#RCUUG291

Unzip rcu 11.1.1.9 and execute it.

[oracle@obiee bin]$ ./rcu

Ok, now we finished the Part 2 of the tutorial.

The next step is create the weblogic server, OBIEE in software only mode and create the domain.

[]'s

Igor Gentil

OBIEE Software Only Installation Step-by-step Part-1

Part 1

Hey There!

Today I'll post a complete installation process of Oracle Business Intelligence Enterprise Edition version 11.1.1.9. Not just OBIEE, but the operational system OS, java, environment variables, repositories, weblogic server and OBIEE.

It will be a lot of information for this installation. So, download all required files for this tutorial.

The operational system will be Oracle Linux x64, therefore all files must be linux and x64 architecture.

all installations will be held in Oracle Virtual Box.

Oracle Virtual Box
Oracle Linux 5.7 x64
Java JDK 1.6.0_45  x64
Oracle Database 11gR2 x64
Repository Creation Utility 11.1.1.9 x64
OBIEE 11.1.1.9 x64
Weblogic 10.3.6 x64 generic


So here we go!

With all files in hands, install Oracle Virtual Box, for install the OBIEE, I recomend at least 2 processors, 5 gb RAM and 150 gb harddrive space for the virtual machine. I'll use Host-only for network.

Oracle Linux Installation

1.1   - Create the virtual machine and mount Oracle Linux image. Press enter to start the installation.
1.2   - Skip disk test.
1.3   - Next
1.4   - Select your language, next.
1.5   - Select your keyboard type, next.
1.6   - Yes to clear the disk and start the installation.
1.7   - Next
1.8   - Yes
1.9   - Next (we will configure the network after)
1.10 - Select your Region, next.
1.11 - Type and confirm a root password. For this tutotial i will use "welcome1" for all passwords, next.
1.12 - Select these options:

This option will install all required parameters, user, groups etc for Oracle Database 11gR2.

1.13 - Next. The installation will start.
1.14 - Reboot
1.15 - Foward
1.16 - Agree the licence Agreement, foward.
1.17 - Set the firewall to Disabled, foward, yes.
1.18 - Set SELinux to Disabled, foward, yes.
1.19 - Foward
1.20 - Adjust date and time, foward.
1.21 - Foward, continue.
1.22 - Foward.
1.23 - Finish, ok for reboot.

Oracle Enterprise Linux created! Let's login and start the system configuration.
User: root
Password: welcome1

IMPORTANT!!!!

THIS IS NOT AN OFFICIAL INSTALLATION, PLEASE SEE ORACLE DOCS FOR PRODUCTION INSTALL

Operational System Configuration.

First of all, lets change oracle user password, so do this:

[root@localhost ~]# passwd oracle

I will use oracle/welcome1 as username and password.

Update /etc/hosts file

[root@localhost ~]# vi /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1             localhost.localdomain      localhost

192.168.56.101   obiee.hostonly.domain     obiee

~

~

Create the application directory and grant privileges:

[root@localhost /]# mkdir -p /u01/app

[root@localhost /]# chown -R oracle:oinstall /u01/app

[root@localhost /]# chmod -R 775 /u01/app

Install and Configure Java JDK 1.6.0_45

[root@localhost ~]# rpm -ivh /u01/download/jdk-6u45-linux-amd64.rpm

[root@localhost ~]# alternatives --install /usr/bin/java java /usr/java/jdk1.6.0_45/bin/java 17000

[root@localhost ~]# /usr/sbin/alternatives --config java

There are 2 programs which provide Java

  Selection    Command

-----------------------------------------------

 + 1           /usr/lib/jvm/jre-1.4.2-gcj/bin/java

*  2           /usr/java/jdk1.6.0_45/bin/java

Enter to keep the current selection[+], or type selection number: 2

Press Enter. Verifies if Java are correct.

[root@localhost ~]# java -version

java version "1.6.0_45"

Java(TM) SE Runtime Environment (build 1.6.0_45-b06)

Java HotSpot(TM) 64-Bit Server VM (build 20.45-b01, mixed mode)

Now we are done with root user. Change to oracle user and let's proceed.

Config the bash_profile file to set all required system variables for oracle database installation.

[oracle@localhost ~]$ vi ~/.bash_profile

#add the folloing

TMP=/tmp; export TMP^M

TMPDIR=$TMP; export TMPDIR^M

ORACLE_HOSTNAME=obiee; export ORACLE_HOSTNAME ^M

ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME ^M

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE^M

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME^M

ORACLE_SID=orcl; export ORACLE_SID^M

ORACLE_TERM=xterm; export ORACLE_TERM^M

PATH=/usr/sbin:$PATH; export PATH^M

PATH=$ORACLE_HOME/bin:$PATH; export PATH^M

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH^M

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

All clear... proceed to the oracle database installation!!

Oracle 11gR2 Database Install

Unzip the files

[oracle@localhost database]$ unzip V17530-01_1of2.zip

[oracle@localhost database]$ unzip V17530-01_2of2.zip

[oracle@localhost database]$ cd database/

[oracle@localhost database]$ ./runInstaller

In Part 2, I'll configure the listener and create one database.

Please Comment!

[] 'S