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.
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
