The BISQLGroupProvider is not available in dropdown list.

Problem: 
While creating a BISQLGroupProvider Authentication Provider, you might not get it in dropdown list of Type.

The BISQLGroupProvider is not available in dropdown list.

Solution:
Please check the existence of BISecurityProviders.jar in location $MW_HOME/wlserver_10.3/server/lib/mbeantypes

If not, copy the file from $MW_HOME/ORACLE_HOME/bifoundation/security/providers to $MW_HOME/wlserver_10.3/server/lib/mbeantypes

Restart all services (AdminServer + bi_server + OPMN) to reflect the changes.

You are done.!! :-)

Start/Stop OBIEE 11g services on Unix platform

Steps to start the OBIEE services on UNIX platform:

1. Start node manager:
   Navigate to,
   /<MW_HOME>/wlserver_10.3/server/bin
   
   command,
   nohup sh ./startNodeManager.sh &
   To confirm whether nodemanager is up and running, you can check the log in nohup.out file, you can find this file at above location only.
   
   Note: nohup will start nodemanager in backend, so you will be able to use the existing terminal for starting AdminServer or any other activitites.


2. Start the Administration Server:
   After confirming node manager is started, we need to start the AdminServer.
   
   Navigate to,
   MW_HOME/user_projects/domains/bifoundation_domain/bin
   
   command,
   ./startWebLogic.sh
   You need to provide Administrator user name and password here.
   
   Note: Do not close the terminal window later on, or the server will get shutdown.


3. Start Managed Servers:
   Navigate to,
   MW_HOME/user_projects/domains/bifoundation_domain/bin
   
   command,
   ./startManagedWebLogic.sh bi_server1 http://<administration_server_ip_address>:7001
   You need to provide Administrator user name and password here.


4. In the end, you need to start OPMN process.
   Navigate to,
   /<MW_HOME>/instances/instance1/bin
   
   command,
   ./opmnctl startall
   
   To check the status of OPMN processes,
   command,
   ./opmnctl status

Steps to stop the OBIEE services:

1. Stop OPMN processes:
   First, you need to stop OPMN process.
   Navigate to,
   /<MW_HOME>/instances/instance1/bin
   ./opmnctl stopall


2. Stop Managed Servers:
   Navigate to,
   MW_HOME/user_projects/domains/bifoundation_domain/bin
   ./stopManagedWebLogic.sh bi_server1 http://<administration_server_ip_address>:7001
   
   To confirm whether Managed Server is stopped, execute the below command..
   ps -ef|grep java|grep obiee|grep bi_server


3. Stop the Administration Server:
Navigate to,
MW_HOME/user_projects/domains/bifoundation_domain/bin
./stopWebLogic.sh

To confirm whether AdminServer is stopped, execute the below command..
ps -ef|grep java|grep obiee|grep AdminServer


4. Stop node manager:
   Just kill the nodemanager process, use the below command
   kill -9 <nodemanager_pid>
   
   To confirm whether nodemanager is stopped, execute the below command..
   ps -ef|grep java|grep obiee|grep nodemanager