Skip to main content

Step by Step explaining of OBIEE 11g Architecture


 Over all stack is an Oracle BI Domain.

1. Made up of three areas WLS Admin server, WLS managed server (Java Components), System components (Non Java Components).

2. Same as in OBIEE 10g but now integrated with Fusion Middleware WLS stack.

3. Java components are installed in managed server and controlled by Fusion Middleware control.

4. Web logic service Admin server used for controlling WLS platform like Startup, shutdown, security, Non-OBIEE specific tables.

5. Fusion Middleware Control (Enterprise Manager) used for managing OBIEE

6. OPMN used for starting and stopping system components.

7. Node manager is used for starting and stopping managed servers.



Role of Fusion Middleware Control (EM):

1. Unified, system wide management of all nodes across BI domain.

2. Patching and upgrading, start and stop system components.

3. Management of rpds and web catalogs.

4. Performance monitoring

5. Replaces(in part, initially) hand editing of config files (nqsconfig.ini)

What hasn't changed since OBIEE 10g:

1. All configuration data still held in text file.

2. System components still need Restart after config change.

3. Still single rpd per BI server.

OPMN:

1. Used for start/stop/Restart services.

2. Process recovery, process ping.

3. Managed via EM or Command line.

4. Used for performance collection(DMS)

5. Standard Fusion Middleware process control tool.

Node Manager:

1. Used for starting and stopping distributed managed servers.

2. Can also restart managed servers that have crashed.

3. The equivalent as OPMN but for Java components.

4. In 11.1.1.5 only installed when managed server installed.

Web logic Domain:

1. Each OBIEE 11g OBIEE domain contains single web logic domain.

2. Contains one Admin server and at the start one managed server.

3. Web logic domain administered through Admin console and WLST (web logic scripting).

4. Managed servers can be started manually or through node manager.

The Bean Browser:

1. The list of OBIEE 11g administration M Beans can be viewed in M Bean browser.

2. Using EM, right click on Admin server --> Farm --> BI Foundation_Domain -->Web logic domain -->bi foundation_domain--> MBean Browser.

3. Key systems management API MBeans include

· Server configuration MBean: u[loaf and register new rpd.

· BI domain MBean: lock, commit and rollback changes to OBIEE config.

· BI instance MBean: start, stop and restart components.

· BI log configuration MBean, Email configuration MBean etc..,

4. Screen: Application defined MBeans: BI Domain

Step1: In Lock Application defined MBeans: BI Domain.BI Instance server configuration

Tab: Operations --> Upload repository.

Step2: Application defined MBeans:Domain config proxy.

Tab: attributes--> Repository Name; Restart Needed


Step3: In EM we press active changes

Operation: Commit

Updates nqsconfig.ini file.

Transfers rpd through biee_dta.zip archive file. Copies rpd password to credential store.

Now we have to restart the system components, capacity management-> Availability.

Step4: Application defined MBeans: OPMN:Instance1 from 4 to 13 all restarts.

Comments

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope