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 100 Informatica Interview Questions

I have attended Informatica interview last week in wipro and couple of other companies, Question below I faced in those companies. 1. What are the main issues while working with flat files as source and as targets ? 2. Explain about Informatica server process that how it works relates to mapping variables? 3. write a query to retrieve the latest records from the table sorted by version(scd) 4. How do you handle two sessions in Informatica 5. which one is better performance wise joiner or look up 6. How to partition the Session? 7. How many types of sessions are there in informatica.please explain them. 8. Explain the pipeline partition with real time example? 9. Explain about cumulative Sum or moving sum? 10. CONVERT MULTIPLE ROWS TO SINGLE ROW (MULTIPLE COLUMNS) IN INFORMATICA 11. DEPLOYMENT GROUPS IN INFORMATICA 12. LOAD LAST N RECORDS OF FILE INTO TARGET TABLE - INFORMATICA 13. LOAD ALTERNATIVE RECORDS / ROWS INTO...

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