obiee11g bi_server1 state changed to admin mode when started.

Error: when started obiee bi_server1 state changed to Admin mode.

Error in log file: The Network Adapter could not establish the connection

Cause: bi_server not able to connect to the database.

Solution: Check the users that expired and locked in DB using the query.

Connect to your database from obiee installed machine using sqlplus

(sqlplus user/pass@hostname:1521/orcl)

select username, account_status from dba_users where ACCOUNT_STATUS LIKE '%EXPIRED%';

and check whether DEV_MDS or DEV_BIPLATFORM is there or not.

If these users are locked unlock the user.

In my case SYSMAN account is expired so unlock the user and restart OBIEE.

Connect to sqlplus using nolog : >sqlplus /nolog

after that unlock the user using below mentioned query.

SQL> conn / as sysdba

Connected.
SQL> alter user sysman identified by [new password]

2  /

User altered.
SQL> alter user sysman account unlock;

User altered.
SQL> exit

Data Warehouse and Concepts.

Why we need data warehouse ?

• Consider the case of a multinational company. In that company the source of data can be in different format and different type for example
• Customer data in Siebel (CRM Tool)
• HR System data in people soft 
• CSV files
• Excel files
• XML Sources
• Querying data from different systems will be a difficult task.

So what data warehouse doing is consolidating all the data from different systems into a single location. And that location is called data Warehouse and all the data from different sources are loaded into the data warehouse through ETL tools like informatica,ODI. And put together in a single location that will make our job simple and we can use data from different sources from the data warehouse.

OLTP and Data Warehouse(OLAP).

OLTP: 

• Contain large number of users and optimized for transnational processing
• For example amazon multiple users are connected and they are doing simple transactions.
• Real time validation is necessary because users are active in all time.
• Normalized data model.
• More and more joins so not preferred for fast data retrieval.

Data Ware House(OLAP): 

• Contain limited number of business users and used for analytical purpose,
• For example number for orders placed in last quarter. Large query include aggregations and calculations.
• Load data using ETL. No real time validation needed.
• De-normalized Model or Dimensional modelling: Star schema and Snow-flake schema.Star Schema: 
• Star Schema: 
• Fact and Dimensional table.
• Denormalized data Eg: Product dimension contain most of the details of product and Store dimension contain most of the details of stores.
• Dimensions are denormailzed.
• Dimension Table: Describe the details of dimension.
• Fact Table : Contain measures and foreign keys of dimension table.
• We can answer more questions using this model.
• Snowflake Schema:
• Dimensions are normalized: In snowflake schema we are simplifying our dimension table by normalizing the data. For example if the Product dimension table contain details of product,category,brand etc. then we are dividing this into different table like one table for Category and another for Brand. By this method we can make our Dimension table into multiple Dimension table.
• If we have large number of different Brands of product then it is better to keep this as a separate Brand table for better querying purpose.
• We choose this method when we have large volume of data in our dimension table.

Informatica Components Overview.

We call look into a high level architecture of informatica.

Informatica Components 

Informatica Domain

Informatica domain is the primary unit that manages administrative and management process in informatica and contain nodes and services associated with each node.

Node: Nodes are the physical machines. We can have single node or multiple node multiple nodes are used for high availability in informatica.

Under each node we have services.

Server Components

Infromatica tool consist of mainly 2 services

• Repository Service
• Integration Service

Repository Service

Repository service is used for maintain informatica metadata  and for managing connections between informatica repository and client tools. Metadata means data about data that contain details about 

• Source definition
• Target definition
• Transformation details
• Session details containing details about when to execute transformations.
• Connection details.

Integration Service

Integration service comes into picture when we run the transformation. 

• Integration service is responsible for movement of data from source to target.It get the connection details from repository and move the data accordingly.
• Responsible for scheduling of workflow and sessions.

Some other service is also there related to informatica

• Web service hub: This is used when we are connecting to any web content.
• Reporting Service: Informatica reporting tool
• Metadata manager service: 
• SAP BW Service: Used if we have source or Target as SAP.
• Model Repository service: Part of data quality
• Data integration service: Part of data quality
• Content Management Service: Part of data quality
• Analyst Service: Part of data quality

Client Components.

Informatica client components are

• Repository Manager:

• Used for administrative purpose .
• For managing permissions for users and groups.
• Designer:

• Used to create and design mappings.
• Used to import sort,target,mapplet and transformations.
• Workflow Manager:

• Used to crate sessions and workflows
• A session can be called as a run time entity of a mapping. All the information of a mapping can be configured from here.
• Workflow Monitor:

• For monitoring status of a workflow. 

[SOLVED] [Error] Deployer :Failed to initialize the application 'oraclediagent' due to error weblogic.application.ModuleException: Failed to load webapp: 'oraclediagent'.

Error: After implementing high availability in OBIEE when started, biserver_2 state changed to Admin.

error:

"<Error> <Deployer> <BEA-149205> <Failed to initialize the application 'oraclediagent' due to error weblogic.application.ModuleException: Failed to load webapp: 'oraclediagent'."


Cause:
In our environment we have total 3 managed servers

• bi_server1
• bi_server2
• odi_server1

and all the servers are deployed in bi_cluster. As we have bi_server2 is in different machine and only we are going for scale out of bi system, ODI related files will not be there in machine 2.

But when starting bi_server2 it tries to load odi related files also because odi and bi_server is hosted in bi_cluser.

Solution:

 

 Below mentioned applications are trying to deploy in bi_cluser.

/home/oracle/MWHome/Oracle_ODI1/setup/manual/oracledi-agent/oracle.odi-agent_11.1.1.jar 

/home/oracle/MWHome/Oracle_ODI1/setup/manual/oracledi-sdk/oracle.odi-sdk_11.1.1.jar 

/home/oracle/MWHome/Oracle_ODI1/setup/manual/oracledi-metadata-navigator/odiconsole.ear 

/home/oracle/MWHome/Oracle_ODI1/setup/manual/oracledi-agent/oraclediagent.ear 

So edit the config.xml file and manually edit the target for the above applications from bi_cluster to bi_server1,odi_server1,AdminServer so the applications will not try to deploy in bi_server2.

Eg of the config file.

"<library>

    <name>oracle.odi-sdk#11.1.1.5.0@11.1.1.5.0.1</name>

    <target>bi_server1,odi_server1,AdminServer</target>

    <module-type>jar</module-type>

    <source-path>/home/oracle/MWHome/Oracle_ODI1/setup/manual/oracledi-sdk/oracle.odi-sdk_11.1.1.jar</source-path>

    <security-dd-model>DDOnly</security-dd-model>

    <staging-mode>nostage</staging-mode>

  </library>"

VNC Screen Displaying Black screen with a cross mark:Error xsetroot,xterm,twm command not found.

VNC Application is used to remotely connect to a server from our local machine and work from our local instance, it works like Team Viewer. This application is really helpful in the situations like if our server is located in different network and while accessing our server from our client  it is really slow. Like this situation VNC application is really helpfull.

In our case  we have to access a server located in 10.#.#.# network from 192.#.#.# network so for that we installed VNC server in 10.#.#.# network and client in 192.#.#.# network.

Steps to install VNC viewer and client is provided in the below mentioned blog:

https://oracle-base.com/articles/linux/configuring-vnc-server-on-linux



After configuring VNC Server and Client when i connected to the server from my local windows i can only see a blank black screen and a cross mark.

So i checked the log files and the issue description is given below:

/root/.vnc/xstartup: line 27: xsetroot: command not found
/root/.vnc/xstartup: line 28: xterm: command not found
/root/.vnc/xstartup: line 29: twm: command not found

It shows some of the packages are missing.

So please download and install rpms related to xorg-x11-twm , xterm ,xsetroot.

yum install xorg-x11-twm
yum install xterm
yum install xsetroot

Then restart VNC Server.

After restarting server try connecting from client.