OBIEE Online Training

Tuesday, July 10, 2012

OBIEE11g - Stopping and Starting Services from Command Line

Hi,



Starting/Stoping  by All BI Components:(Via OPMN)
=========================================================


D:\Oracle\Middleware\instances\instance1\bin>opmnctl status


Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
coreapplication_obiccs1          | OracleBIClusterCo~ |    7396 | Alive
coreapplication_obisch1          | OracleBIScheduler~ |    6204 | Alive
coreapplication_obijh1           | OracleBIJavaHostC~ |    6016 | Alive
coreapplication_obips1           | OracleBIPresentat~ |    7812 | Alive
coreapplication_obis1            | OracleBIServerCom~ |    4512 | Alive




D:\Oracle\Middleware\instances\instance1\bin>opmnctl restartall


Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
coreapplication_obiccs1          | OracleBIClusterCo~ |    7396 | Alive
coreapplication_obisch1          | OracleBIScheduler~ |    6204 | Alive
coreapplication_obijh1           | OracleBIJavaHostC~ |    6016 | Alive
coreapplication_obips1           | OracleBIPresentat~ |    7812 | Alive
coreapplication_obis1            | OracleBIServerCom~ |    4512 | Alive


Starting/Stoping  by individual BI Components:(Via OPMN)
=========================================================


D:\Oracle\Middleware\instances\instance1\bin>opmnctl stopproc  ias-component=cor
eapplication_obips1
opmnctl stopproc: stopping opmn managed processes...


D:\Oracle\Middleware\instances\instance1\bin>opmnctl startproc  ias-component=co
reapplication_obips1
opmnctl startproc: starting opmn managed processes...


D:\Oracle\Middleware\instances\instance1\bin>opmnctl status coreapplication_obip
s1


Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
coreapplication_obiccs1          | OracleBIClusterCo~ |    7396 | Alive
coreapplication_obisch1          | OracleBIScheduler~ |    6204 | Alive
coreapplication_obijh1           | OracleBIJavaHostC~ |    6016 | Alive
coreapplication_obips1           | OracleBIPresentat~ |   19064 | Alive
coreapplication_obis1            | OracleBIServerCom~ |    4512 | Alive


D:\Oracle\Middleware\instances\instance1\bin>


Reference:
http://docs.oracle.com/cd/E25054_01/bi.1111/e10541/components.htm


Thanks
Deva

Changing User Password in OBIEE 11G


1) OBIEE11g – Changing your password in OBIEE 11G
(Default Authenticator Method)

User Requirement:
Our Users want to Change His or Her Password in Answers/Dashboard with OBIEE 11g

Issue Item:
The Current obiee11.1.1.5.0 version users can’t able change his/her own password.

Workaround Solution Ref:

Note: in obiee10g it’s available but in obiee11g out of box(Oracle recommended external authentication method)
Ref: My Blog:


OBIEE11g Bug Reference:

in OBIEE 10g, Repository Users could change their passwords by exposing a link in the My account page of Answers/Dashboards.

However, in OBIEE 11g, there are no repository Users, so this functionality is not relevant and hence Users need to depend on the functionality of the LDAP to change the passwords.

The following Enhancement Request is logged for addressing this feature in OBIEE 11g.

Bug 11845872 - ABILITY FOR THE END USERS TO CHANGE THEIR PASSWORDS IN OBIEE11G

For more: refer doc:

Change Password Link In Answers/Dashboard Obiee 11g [ID 1302091.1]


Conclusion:

While checking Rittman mead blog, They did some work around with java/J2ee  Bean class then achieved so kindly arrange some one to help me to resolve this J2ee – Bean class (Customized Code deployment and integration with obiee11g)

Java code for changing user password for Default Authenticator:

Hi,


Just use the below java code (Changepwd.java) and compile and run using javatool(JDEV,Netbeans etc)  and get the jar/war file and deploy the war file via Weblogic console then call the link (jmx bean url) in your analysis by using Action link method.
-------------------------------------------------------------------------------
package obiee.chngpwd;


import java.io.IOException;
import java.util.Set;


import javax.management.InstanceNotFoundException;
import javax.management.IntrospectionException;
import javax.management.MBeanException;
import javax.management.MBeanInfo;
import javax.management.MBeanOperationInfo;
import javax.management.MBeanParameterInfo;
import javax.management.MBeanServerConnection;
import javax.management.MalformedObjectNameException;
import javax.management.ObjectName;
import javax.management.ReflectionException;
import javax.management.remote.JMXConnector;
import javax.management.remote.JMXConnectorFactory;
import javax.management.remote.JMXServiceURL;


public class Changepwd {
private JMXConnector jmxConnector = null;
private MBeanServerConnection mBeanServerConnection = null;


public Changepwd() throws IOException, MalformedObjectNameException, NullPointerException, InstanceNotFoundException, IntrospectionException, ReflectionException {
JMXServiceURL serviceURL = new JMXServiceURL("service:jmx:rmi://IP/jndi/rmi://IPaddress:1090/jmxconnector");
System.out.println("Connecting to: " + serviceURL);


jmxConnector = JMXConnectorFactory.connect(serviceURL);
mBeanServerConnection = jmxConnector.getMBeanServerConnection();
Set<ObjectName> mbeans = mBeanServerConnection.queryNames(null, null);
for (ObjectName mbeanName : mbeans) {
System.out.println(mbeanName);
System.out.println("Service:" + mbeanName.getKeyPropertyListString() + "Domain:" + mbeanName.getDomain());

}
//ObjectName securityMBeanName = new ObjectName("jboss:service=JNDIView");
//ObjectName securityMBeanName = new ObjectName("jboss:service=JNDIView");
ObjectName securityMBeanName = new ObjectName("Security:Name:myrealmDefaultAuthenticator");
MBeanInfo mbeanInfo = mBeanServerConnection.getMBeanInfo(securityMBeanName);
MBeanOperationInfo[] opInfo = mbeanInfo.getOperations();
        System.out.println("Security Operations: ");
        for(int o = 0; o < opInfo.length; o ++) {
            MBeanOperationInfo op = opInfo[o];


            String returnType = op.getReturnType();
            String opName     = op.getName();
            System.out.print(" + " + returnType + " " + opName + "(");


            MBeanParameterInfo[] params = op.getSignature();
            for(int p = 0; p < params.length; p++)  {
                MBeanParameterInfo paramInfo = params[p];


                String pname = paramInfo.getName();
                String type  = paramInfo.getType();


                if (pname.equals(type)) {
                    System.out.print(type);
                } else {
                    System.out.print(type + " " + securityMBeanName);
                }


                if (p < params.length-1) {
                    System.out.print(','); 
                }
            }
            System.out.println(")");
        }
Object objUser[] = new Object[]{("userId"), ("oldPassword"), ("newPassword") };
//Object objUser[] = new Object[]{("destroy")};
String objStr[] = new String[]{("java.lang.String"), ("java.lang.String"), ("java.lang.String") };
//String objStr[] = new String[]{("java.lang.String")};


try {
//mBeanServerConnection.addNotificationListener(securityMBeanName, new PasswordListener(), null, null);
//Object responseObj = mBeanServerConnection.invoke(securityMBeanName, "jbossInternalLifecycle", objUser, objStr);
Object responseObj = mBeanServerConnection.invoke(securityMBeanName, "changeUserPassword", objUser, objStr);
System.out.println("Response:" + responseObj);




} catch (InstanceNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (MBeanException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ReflectionException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
 * @param args
 * @throws IOException 
 * @throws NullPointerException 
 * @throws MalformedObjectNameException 
 * @throws ReflectionException 
 * @throws IntrospectionException 
 * @throws InstanceNotFoundException 
 */
public static void main(String[] args) throws MalformedObjectNameException, NullPointerException, IOException, InstanceNotFoundException, IntrospectionException, ReflectionException {
// TODO Auto-generated method stub
new Changepwd();


}


}


For More about change password info:
http://www.rittmanmead.com/2011/10/changing-your-password-in-obiee-11g/ 


OBIEE11.1.1.6.0 Software Only Installation on Windows 7

Hi,

I have seen there are so many people getting difficulty with installing obiee11g on windows 7 32/64 bit Home/ultimate/pro edition,after 3 attempts i just make it work obiee11.1.1.5.0 as well obiee11.1.1.6.0 (simple/software only installation type) got woking fine.

while 1st and 2nd time installation and configuration duration have faced below issues,

Creating domain failed,configuration getting hang over and Admin Server/opmn failed kind of issues. after checking  oracle documents and uninstall and reinstall several times then i found the solution for above issues due to 

java unable to find it weblogic domain creation steps, and there is some looback adaptor and windows 7 dell laptop permission issues. after correcting this things then its got working fine with 1st attempt itself.i just sharing this steps with screen short...i will help full..who are stugglling with windows 7.



Prerequisites for OBIEE 11g:

1) OBIEE11g & RCU 11.1.1.6.0 Software Download:

OBIEE11.1.1.6.0 you can download the software from the Oracle Technology Network (OTN).
for practice pupose you can register for one for free. if your are OBIEE Server implementation you need to download with licenced OTN Customer Account.


also download RCU11.1.1.6.0 32bit for installing MDS/DEV_BIPLATFORM Schemar. (Note: Before installing obiee11g we need to install RCU. there is no 64bit rcu you have to download 32bit one and need to install it on 64 bit machine. it will support.


 once you complet the download the downloaded files will stored like below root structure(note: once complete the download plz confirm fully downloaded double check this size some times the network probel it may inttupted.


Java download:


I just download Jrockit 1.6 64bit version jrockit-jdk1.6.0_31-R28.2.3-4.1.0-windows-x64.exe
 and then installed jave like below path 

C:\java\jrockit-jdk1.6.0_29-R28.2.2-4.1.0\bin
C:\java\jrockit-jre1.6.0_29-R28.2.2\bin

System Requirements

System Configuration:

Windows 7 Home Premium/Ultimate/Professional Edition
System Type: 32/64 bit operating system
Disk Space  20GB or higher
Physical Memory Min 4GB and above
Temp Space 1GB
Swap Space 3GB
CPU & Processor: intel dual-core i3/i5/i7 64 Bit, 2.10GHz or greater
Internet Explorer 8 or google chrom/mozilla/firebox etc..

Other Requirements

Environmental Variables TEMP and TMP (make sure this root folder should not keep any space)
Install Loopback Adapter with Static IP Address
Note: hots/host/etc file the static ip should be set like below
# localhost name resolution is handled within DNS itself.
10.10.1.7     localhost Deva-PC
(IP address host domain name  host/computer name)
JDK 1.6.0_29 and above version (64bit)
Adobe Flash Player 10 and above
Oracle Database 11.1.0.7.0 or higher
SQL Server 2005/2008 R2 64 bit
RCU Installation

Weblogic 10.3.6.0 64bit download and kept it like below path (u can also use weblogic 10.3.5)

you can download weblogic 10.3.5/6 by using below screen,



D:\OBIEE111160\wls1036_generic.jar

Weblogic 10.3.5/6 64bit installtion must run like below

go --> windows --->type run ==> cmd prompt -->

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Deva>cd..

C:\Users>cd..

C:\>cd C:\java\jrockit-jdk1.6.0_29-R28.2.2-4.1.0\bin

C:\java\jrockit-jdk1.6.0_29-R28.2.2-4.1.0\bin>java -D64 -jar D:\OBIEE111160\wls1
036_generic.jar


Note: weblogic 10.3.6 64bit installtion u need to use above command.




Weblogic 10.3.6.0 64 bit installation steps on windows 7:

click next and select Middleware (weblogic server) installation drive (note:make sure you have 20GB free hard disk space )


click next and select no 
 uncheck and click next,



uncheck and click next,select as no


 uncheck and select no then 

uncheck and check configuration this machine,



just select installtion type as "custom" by this step u can install selective weblogic installation settup files.
if you goes with typical also no issues but i will include the oracle coherence settup files but its not required our obiee11g. 



uncheck oracle coherence and click next,



if its correctly pointing java path then its automattically picked up here..


 just click next and...


 next....




 finish installation completed...





RCU 11.1.1.6.0 Installation Step




just go to you rcu downloaded path ...


D:\OBIEE111160\rcuHome\BIN\rcu.bat and run as Administrator the select radio button as create..like below screen...





give it your RCU Schema information here i am using SQL Server. 



click next...



select Business intelligenct platform and MDS schema..




click ok and next ..


give it your schema password and please remember this password. this password we need to give it at obiee installation time.



click next...



click next and finish it.






OBIEE11.1.1.6.0 Software Only installation type on windows 7 64bit 


Go to you obiee11g download saved file path mine is like below E:\Share_DEV\OBIEE111160\bishiphome\Disk1\setup.exe run as administrator and click next...













click next...



OBIEE11.1.1.6.0 Configuration Steps:


click next ...D:\Oracle\Oracle_BI1\bin\config.bat and run as "Adminstrator"







click next and make sure status as green all should be ok..



here you can give it your own weblogic password this password must be as "Administrator" so plz remember this password.



clieck next and just keep it as it as...(default configuration)












For check the Bi Components status via OPMN Command..




Till Next Time..

OBIEE11g Manual Steps to Start/Stop Services on Windows


Hi,


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


Thanks
Deva

OBIEE 11g Log Path


Hi,


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


Till Next Time..