Saturday, April 6, 2013

Connection Failed Error in OBIEE 11 g Admin tool

Hi Friends,

when you create a New RPD and try to import the metadata  you might get the following error.




Solution : Copy your tnsnames.ora file form

C:\app\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN

to

C:\OBIHOME\Oracle_BI1\network\admin.

and  Stop and start BI services.

Now you will be able to see the next screen.



Friday, April 5, 2013

OBIEE11g - Stopping and Starting Services from Command Line


OBIEE11g - Stopping and Starting Services from Command Line

In the previous post I showed how to stop/start OBIEE 11g services using Fusion Middleware Control. This post shows how to achieve same using command line.

OBIEE 11g installer creates opmnctl.bat file for each instance. To manage services start command prompt and go to the bin folder of the instance \{MWH}\instances\instance1\bin

Run following command to check the status of all the services running under the instance.

opmnctl status




You can use ias-component name in the output to stop/start individual service.

For example, following command stops presentation service.

opmnctl stopproc ias-component=coreapplication_obips1


And following command starts presentation service

opmnctl startproc ias-component=coreapplication_obips1




Following commands can be used to stop/start all services in the instance.

opmnctl stopall   opmnctl startall


OBIEE 11g Debug

OBIEE System Component Log Locations

You have to check the below logs if you have any startup issues for any of your OBIEE components. 
The first step is to check the status of all components using opmnct status -l, if any of the component status is down go to the corresponding
log file for more information.

To individually start components for an example to start the presentation services you would use the below command

opmnctl startproc ias-component=coreapplication_obips1

Similarly to start other components replace the coreapplication_obips1 with correct names.

Presentation Services:

OBIEE_HOME\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1

sawlogo.log - Fro any issues related to Presentation Services start/stop
BI Server Component:

OBIEE_HOME\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1

nqquery.log - For any issues related OBIEE Analysis & RPD issues
nqserver.log - For any issues related to Server Component start/stop

BI Scheduler Component:

OBIEE_HOME\instances\instance1\diagnostics\logs\OracleBISchedulerComponent\coreapplication_obisch1

nqscheduler.log - For any issues related to Scheduler Component start/stop
BI Cluster Component:

OBIEE_HOME\instances\instance1\diagnostics\logs\OracleBIClusterControllerComponent\coreapplication_obiccs1

nqcluster.log - For any issues related to Cluster Component start/stop

Java host Component:

OBIEE_HOME\instances\instance1\diagnostics\logs\OracleBIJavaHostComponent\coreapplication_obijh1

jh.log - For any issues related to Java Host Component start/stop

Weblogic Server Log Locations


BI Managed Server:

OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\bi_server1\logs

bi_server1.out - For any issues related to bi_server1

Admin Server:

OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\AdminServer\logs

AdminServer.log - For any issues related to AdminServer

-----------------------------------------------------------------------------------------***********

ORACLE_BIEE_HOME = C:\Oracle\Middleware\obiee11g (This is your root folder where you installed OBIEE 11g)

Please note that by default "instance1" is created but if you tried to install multiple times you might have different name (ex: instance2)
If your instance name is different replace the instance1 with your correct instance name.

Start your Oracle Database

Start Weblogic Node Manager
ORACLE_BIEE_HOME/wlserver_10.3/server/bin/startNodeManager.cmd

Steps to Manually Start Oracle BIEE 11g

1. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/startWebLogic.cmd

2. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.cmd bi_server1

3. ORACLE_BIEE_HOME/instances/instance1/bin/opmnctl startall

Steps to Manually Stop Oracle BIEE 11g

1. ORACLE_BIEE_HOME/instances/instance1/bin/opmnctl shutdown

2. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/stopManagedWebLogic.cmd bi_server1

3.ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/stopWebLogic.cmd

Thursday, April 4, 2013

The chosen installation conflicts with software already installed.. Oracle Re Installation



The chosen installation conflicts with software already installed.. Oracle Re Installation


This error occurs because I have already installed the Oracle 11g Database and later I have remove the Oracle 11g Database and restored my registry. But when I again try to install the database, installer found any traces of previous installation somehow and show the error.

Solution:
I have just change the dbhome_1 to dbhome_2 and problem solved. :)
Reason:
Installer found the entry of dbhome_1 from anywhere in my system and when again I tried to installed the same home installer showed the error. So I just change the home name.



http://oracleared.blogspot.com/2012/11/the-chosen-installation-conflicts-with.html



In the middle of the installation it throws an error...

An Oracle standard DB install issue with OracleMTSRecoveryService


During Oracle 11g DB (standard version) install, I run into an error, "Error in starting the service. The service OracleMTSRecoveryService was not found".

If I check the service panel, i can see this:

I ignored it a few times. Then I decided to take a closer look and found a work around. here is my solution.
When this error box pops up, keep it there. Fire up regedit go to "computer\hkey_local_machine\system\controlset001\service\OracleMTSRecoveryService". Double click on ImagePath, then change the path to where your Oracle is actually installed.

I ignored it a few times. Then I decided to take a closer look and found a work around. here is my solution.
When this error box pops up, keep it there. Fire up regedit go to "computer\hkey_local_machine\system\controlset001\service\OracleMTSRecoveryService". Double click on ImagePath, then change the path to where your Oracle is actually installed.

In my case, the ImagePath has a value of 
C:\Oracle\product\11.2.0\dbhome_1\bin\omtsreco.exe "OracleMTSRecoveryService"

I had to change it to:
C:\app\myaccount\product\11.2.0\dbhome_1\bin\omtsreco.exe "OracleMTSRecoveryService"

then click on "retry". that solved my problem.

Uninstall OBIEE11g from windows box


Deinstalling an Oracle Business Intelligence installation on a single computer involves the following tasks:
  1. Run the deinstall script and select the Deinstall instances managed by a WebLogic domain option.
  2. Stop all Oracle Business Intelligence processes and servers, including all OPMN-controlled components and JEE components.
  3. Drop the Metadata Services (MDS) and Business Intelligence Platform (BIPLATFORM) schemas using RCU.
  4. Run the deinstall script and select the Deinstall the Oracle home option.
  5. Deinstall the Oracle Common home manually or by running the deinstall script that it contains.
  6. Use the Oracle WebLogic Server uninstaller to uninstall WebLogic Server.
  7. Remove the Oracle home (if necessary).
  8. Remove the Middleware home and any other homes (Domain home, Applications home, and Instance home) that might have been installed outside of the Middleware home.

Wednesday, April 3, 2013

Installation of OBIEE 11g invloves 4 steps and Pre-requisites for Installing OBIEE 11g


Installation of OBIEE invloves 4 steps:
1) Installation of Loopback adopter
2) Installation of database
3) Installation of RCU (Repository Creation Utility)
4) Installation of OBIEE software


Pre-requisites for Installing OBIEE 11g


Pre installation Steps in Windows 7
1) Java:
Ensure java jdk( V 1.6 and above ) is installed.
Point to Note
Jdk should be installed in a folder without space, say like "C:/Java/"
DONT install java in "C:/Program Files/Java"; the reason is that the Space(" ") between the  word "Program files" will cause error while installing OBIEEv11g
IF YOU HAVE INSTALLED JAVA under "PROGRAM FILES" Uninstall it and Reinstall the same
After Installation:
Add JAVA_HOME in your environment variables.
In Windows7, Right Click "My Computer"-> Properties->Advanced tab ->Environment Variables
Click the New button and add VARIABLE NAME as "JAVA_HOME" and variable path as
"C:/JAVA/JDK;"
If you have installed java in "C:/" use "C:/JAVA/JDK;" path variable

2) In Windows, Install Loopback adapter, Follow the below link to install the loopback adapter in windows 7.
After Installation:
You will see a network icon in systray. Click on that and go to "Open Network Connection" Click
on the installed Loopback Adapter Properties and Under General Tab,
Click on the Internet Protocal Ip4 and Click on the properties.
IN the PopUp under General tab give 10.10.10.10 for IP Address and for subnet mask provide
"255.255.255.0"
You can give any IP address here. But Oracle follows 10.10.10.10. Lets religiously follow what Oracle does ;)
Adding This Static IP to your windows Host
Start->search for Notepad-> RIght click and open as Administrator
Once you are in Open the following file "C:/Windows/system32/drivers/etc/hosts" Add the following at the end of file :
10.10.10.10 localhost localhost.local.com
Save & Close the file.
This Step is important because after obiee11g installation we would access the url by "10.10.10.10:<port>/analytics"
We are installing loopback adapter to create a static IP rather than to Create a dynamic IP which would keep changing whenever you connect to your ISP.
3) Install Oracle Database
You can either go for oracle 10g or 11g. Any database is fine, But its recommended to use oracle
11g DB to realise the full potential features of Database and OBIEE.
Note: While Installing Please provide the AL32UTF8 Unicode Character set. Else while installing
RCU below error will be shown :
"The database you are connecting is with non-AL32UTF8 Character set. oracle strongly
recommends using of AL32UTF8 as database character set."
4) Download & Install Repository Creation Utility - RCU


5) After all these steps; OBIEE 11g should be installed

Tuesday, April 2, 2013

Stop and Start OBIEE 11g Linux / WIndows

Stop and Start OBIEE11g on Linux

http://lamont-consulting.com/index.php/blog/obiee/11g/117-stop-and-start-obiee-11g-linux



Start the OBIEE 11g on windows


http://gerardnico.com/wiki/dat/obiee/start_11g




list of stop / start commands for each of the system components:



BI Service:
opmnctl stopproc ias-component=coreapplication_obis1
opmnctl startproc ias-component=coreapplication_obis1

Javahost:
opmnctl stopproc ias-component=coreapplication_obijh1
opmnctl startproc ias-component=coreapplication_obijh1

Presentation Service:
opmnctl stopproc ias-component=coreapplication_obips1
opmnctl startproc ias-component=coreapplication_obips1

Scheduler Service:
opmnctl stopproc ias-component=coreapplication_obisch1
opmnctl startproc ias-component=coreapplication_obisch1

Cluster Service:
opmnctl startproc ias-component=coreapplication_obiccs1
opmnctl stopproc ias-component=coreapplication_obiccs1