Posts

Multiple RPD's & Multiple Presentation Services in a Single OBIEE 11G & Weblogic Installation

Image
Purpose: To host Multiple RPD's & Multiple Presentation Services in a Single OBIEE & Weblogic Installation Following steps can be executed even on OBIEE 11.1.1.6.0 Step 1: Trigger rcu.bat and create required schemas, trigger RCU from the following location D:\obiee116\V29675-01\rcuHome\BIN Provide these schema names while executing Step 3 Step 2:  All the OBIEE servers should be up and running Step 3:  Trigger config.bat from the path below D:\obiee116\Oracle_BI1\bin\config.bat Post configuration you can see these new folders in your OBIEE installed folders Please feel free to post your comments on queries related to Multiple RPD & Presentation service deployments

Next set of Interview Q & A

1) How do you handle teams emotions.  2) How do you avoid leakages when there is lot me context switching.    3) Automation approach.    4) How do you manage when there is more work compared to your came width.  5) Conflict management.

Procedure to disable all user constraints on Oracle

BEGIN   FOR c IN   (SELECT c.owner, c.table_name, c.constraint_name    FROM user_constraints c, user_tables t    WHERE c.table_name = t.table_name    AND c.status = 'ENABLED'    ORDER BY c.constraint_type DESC)   LOOP     dbms_utility.exec_ddl_statement('alter table ' || c.owner || '.' || c.table_name || ' disable constraint ' || c.constraint_name);   END LOOP; END;
1) How do you decide the defect prone area ? 2) What do you do when you have resources with low competency ? 3) Example of risk and how to mitigate it ? 4) What do you do to increase teams productivity ? 5) What is effort estimation process in your company ?

EXP utility on 11gR2 will not work on empty tables with zero rows

1)Identify tables with 0 rows 2)Issue following command on those tables ALTER TABLE > ALLOCATE EXTENT; 3) Now EXP utility will work

Identify empty tables in oracle

SELECT * FROM User_Tables s WHERE s.num_rows=0

To find PORT availability on unix systems

To find PORT availability on unix systems netstat -an | grep >