Thursday, July 30, 2015

Configuring SSL (Secure Socket Layer) in OBIEE 11g

Step 1:login to  weblogic administration console page.
Step 2:Click Lock & Edit
        C:\Users\Rajkumar\Desktop\https server\Untitled.png
Step 3:Click Environment        
C:\Users\Rajkumar\Desktop\https server\Untitled1.png
Step 4:click Servers
C:\Users\Rajkumar\Desktop\https server\Untitled2.png
Step 5:
          Click bi-server1
C:\Users\Rajkumar\Desktop\https server\Untitled3.png
Step 6:
           Go to Configuration and genaral tab
C:\Users\Rajkumar\Desktop\https server\Untitled4.png 
step 7:
            Check the SSL Listen Port Enabled and change the port number to 443           

C:\Users\Rajkumar\Desktop\https server\Untitledw.png
(*1: 443 is the default SSL port and is automatically recognised by most browsers)
(*2: 80 is the default non SSL port is automatically recognised by most browsers)

Step 8:
        Click Save.

C:\Users\Rajkumar\Desktop\https server\Untitled6.png
Step 9:
          Then click Activate Changes
C:\Users\Rajkumar\Desktop\https server\Untitledfhj.png

Step 10:
       We  need to edit the StartStopServices.cmd file,
usally found in : <<BI_HOME>>\instances\instance1\bifoundation\OracleBIApplication\coreapplication
In my Case D:\OBIEE_HOME\instances\instance3\bifoundation\OracleBIApplication\coreapplication
C:\Users\Rajkumar\Desktop\https server\Untitled10.png
Step 11:
          We have to change set BI_URL=http://%wls.host%:%wls.mgd.port%/analytics   to
set BI_URL=https://%wls.host%/analytics
           
C:\Users\Rajkumar\Desktop\https server\Untitled11.png
C:\Users\Rajkumar\Desktop\https server\Untitled8.png

Step 11:
            Reboot the System
Step 12:
    Now login with https://host:port/analytics
In My case     https:// SSS2014012PC:443/analytics


Wednesday, July 29, 2015

Starting and Stopping OBIEE Services on Linux Environment

Step1: Check whether the database services are in running mode, if not, start up the database

by following commands.

Open terminal.

Enter lsnrctl start

Open sql plus.

Login with user id: sys as sysdba

Enter password: <sys user password>

Enter Startup

Step2: Start Administration Server, Login with the user who owns the OBIEE installation.

a. Open terminal and Start Administration Server

b. Navigate to /OBIEE11g/user_projects/domains/bifoundation_domain/ using cd

command, enter following command.

./startWebLogic.sh

Step3: Start Node Manager by following command.

a. Navigate to /OBIEE11g/wlserver_10.3/server/bin/ using cd command, enter following

command.

./startNodeManager.sh

Step4: Start Managed Server by following command.

a. Navigate to /OBIEE11g/user_projects/domains/bifoundation_domain/bin/ using cd

command, enter following command.

./startManagedWebLogic.sh bi_server1 http://localhost:7001

Step5: Start opmnctl by following command.

a. Navigate to /OBIEE11g/instances/instance1/bin/ using cd command, enter following

command.

./opmnctl startall

Stopping OBIEE Services

Step1: Stop opmnctl by following command.

a. Navigate to /OBIEE11g/instances/instance1/bin/ using cd command, enter following

command.

./opmnctl stopall

 Step2: Stop Managed Server by following command.

a. Navigate to /OBIEE11g/user_projects/domains/bifoundation_domain/bin/ using cd

command, enter following command.

./stopManagedWebLogic.sh bi_server1 http://localhost:7001

 Step3: Stop Administration Server by following command.

a. Navigate to /OBIEE11g/user_projects/domains/bifoundation_domain/ using cd

command, enter following command.

./stopWebLogic.sh

Tuesday, July 21, 2015

Migrate the Informatica code from Unix Server to Windows Server


Step 1:  Open exported unix .xml file

Change the encoding =”UTF-8” and   CODEPAGE=” UTF-8” as like below
encoding =”Windows-1252” and   CODEPAGE=”MS1252”
Save the XML file.
Step 2:
Open Informatica Power Center Repository Manager
-> Connect Repository
-> Import object and select the XML file

Click next
Click Add all  and  click next
Click next
Click  replace and select  apply resolution to all conflicts and click next
Click next
Click close and click import




How to Execute the Load Plans through Command Prompt in ODI


  1. Create scenario
  2. Create load plans
  3. Create Agent
  4. Run the load plan through command line

  1. Create a scenario

Now to create a ODI scenario first locate the folder where the interface or package you would want to convert into a ODI scenario.

C:\Users\Mohankrishna\Desktop\Capture.PNG
Once you have located the folder, highlight the folder and right mouse click.  You will see a few options.  

Locate the “Generate All Scenarios” and click the following option.C:\Users\Mohankrishna\Desktop\Capture2.PNGScreen Shot 2014-08-31 at 2.08.13 AM
A popup will appear in which you will be asked to select a few options.Replace, Re-generate, and Creation
o   Here you can either replace an existing scenario, re-generate a scenario due to updates and changes or create a new scenario.
  • Object to Generate
o   Here you have options on what ODI components in which you would want to convert to a ODI scenario.
  • Marker Filter
  • You can add the following scenario into a group and add a marker.

C:\Users\Mohankrishna\Desktop\Capture3.PNG
For our example you will select “Creation” for your generation mode and select “Packages” for objects to generate. 
For the marker filter options you will leave this as “None.”
Once you have selected the following options, click “OK.”
Your scenario should be generating.
C:\Users\Mohankrishna\Desktop\Capture4.PNG
If do have a ODI variable within your package, the scenario variables option will pop up asking you the startup parameter. 
Leave the following checked and click “Ok.”
C:\Users\Mohankrishna\Desktop\Capture5.PNG
You should not have received a pop up letting you know your scenario has been created.

C:\Users\Mohankrishna\Desktop\Capture6.PNG
In addition, you can validate your scenario has been created by going to the “Load Plans and Scenarios” tab and find your scenario.

Please note:  You can also execute your scenario similar to a ODI interface or package.
C:\Users\Mohankrishna\Desktop\Capture7.PNG
Step 2: Create a load plan
Go to Load Plans and Scenarios navigator in designer-> new load plan as follow below screen short  
C:\Users\Mohankrishna\Desktop\lp.PNG
Enter any name here TestLoadPlan1 given
load_plan_1

Then goto steps
C:\Users\Mohankrishna\Desktop\lp1.PNG
Right click on root_step and select add step
And select the step serial or parallel
C:\Users\Mohankrishna\Desktop\lp2.PNG

C:\Users\Mohankrishna\Desktop\lp3.PNG
Right click on serial step and select add step and select run scenario

C:\Users\Mohankrishna\Desktop\lp4.PNG
C:\Users\Mohankrishna\Desktop\lp5.PNG
Click Next
for select the scenario, click on brow button
And click finish.
load_plan_2

  1. Create agents:
3.1 Modify the odiparams.bat
3.2 Create agent at topology
Encode ODI Agent Password
Before creating an ODI agent, you must run the encode password command to generate an encrypted password and paste it into the odiparams.bat parameter file. To do so, perform the following steps:
3.1.1
Navigate to the ODI_HOME directory, where ODI is installed and open the agent\bin sub-directory: ( C:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\bin). Navigate to the odiparams.bat file, right-click this file and select Edit to open it with a text editor. Leave this editor open; you will run a batch file from a Command window and return to this text editor to copy the results into the odiparams.bat file.
Explanation: You need to edit the odiparams.bat file to set the repository connection information for the ODI Agent to use. The password information is stored as an encrypted string. You will generate the encrypted string in a Command window.
Screenshot for Step

3.1.2
Leave the text editor open, and open the Command window (Start -> Run -> cmd) and change the directory to the ODI_HOME\agent\bin directory:
C:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\bin
Screenshot for Step
3.1.3.
To generate the encrypted password string, you will be using the agent command: encode <password>. Because your password is the word “ oracle1”, enter and execute the following command in the Command window:
encode oracle1
Keep the Command window open, as you will be returning to it after editing the odiparams.bat file.
Screenshot for Step
3.1.4
Copy the generated encrypted password from the Command window (from the Command window’s pull-down menu, select Edit > Mark, then highlight the password with your mouse) and insert it into the odiparams.bat file as the value for the ODI_MASTER_ENCODED_PASS parameter. Verify and, if necessary, edit settings for otherparameters from the table below, save the odiparams.batfile, and then close it. The agent’s connectivity is now set up.
Parameter
Value
ODI_MASTER_DRIVER
oracle.jdbc.OracleDriver
ODI_MASTER_URL
jdbc:oracle:thin:@localhost:1521:orcl
ODI_MASTER_USER
snpm1
ODI_MASTER_ENCODED_PASS
Insert your encoded password.
ODI_SECU_WORK_REP
WORKREP1
ODI_SUPRVISOR_ECODED_PASS
Leave the default value.
ODI_USER
Leave the default value.
ODI_ENCODED_PASS
Leave the default value.
ODI_JAVA_HOME
C:\jdk1.6.0_18
Notes:
User snpm1 is RDBMS schema/user (Oracle 11g) for Master repository. It was created for this and subsequent OBEs in OBE "Creating and Connecting to ODI Master and Work Repositories".
Work Repository name is WORKREP.
Because each time when you encode the password, it gets different values, your encoded password will differ from the one provided in the screenshot.
Do not change the default value of the ODI_USER and ODI_ENCODED_PASS parameters. Those parameters were pre-coded during ODI installation.
Screenshot for Step

Screenshot for Step
Now that you have generated an encoded password and pasted it into the odiparams.bat file
Screenshot for Step
  1. Create the ODI Physical and Logical Agents

you need to create the ODI physical and logical agent definitions.
4.1.1
If not started, start Oracle Data Integrator: Start > Programs > Oracle > Oracle dat Integrator > ODI Studio. Click “Connect To Repository”. Select WORKREP1 from the LoginName drop-down list. For Password, enter: SUNOPSIS. Click OK.
Screenshot for Step
Screenshot for Step

Screenshot for Step

4.1.2.
Click Topology tab. In Topology, select the Physical Architecture panel. Right-click the Agents node. Select New Agent.
Screenshot for Step 
4.1.3
Fill in the following fields:
  • Name: localagent
  • Host: Network name or IP address of the machine the agent has been launched on. Verify that this parameter is set to localhost.
  • Port: Listening port used by the agent. By default, this port is 20910. Leave the default value.
  • Web Application Context: Name of the web application corresponding to the J2EE agent deployed on an application server. For standalone agents, this field should be set to oraclediagent.
  • Set Maximum number of sessions supported by this agent to 250.
Click Save button.
Screenshot for Step

4.1.4
Now you have to insert a logical agent in Logical Architecture, and map it to the newly created Physical agent. Click the LogicalArchitecturetab. Right-clickAgents and select New LogicalAgent. On the screen that follows, set the Name to “localagent.” Set Physical Agents to localagent . From file menu click Save, and then close the Logical Agent tab.
Screenshot for Step
Screenshot for Step

Screenshot for Step



  1. Starting ODI Agent from the Command Line and Testing Connection
Now that you have created the agent and defined the ODI physical and logical agents, you can start the agent directly from the command line. You also test connection to your ODI standalone agent.
5.1.1.
Switch back to the Command window you left open at the ODI_HOME\agent\bin directory ( C:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\bin). Execute the agent.bat file using the following command:
agent -NAME=localagent
Screenshot for Step
The agent is now starting. Verify that ODI Agent is successfully started. Minimize the window Command Prompt – agent-NAME=localagent.
Note : This command window should remain open during all labs. 
Screenshot for Step

5.1.2.
In ODI, click Test icon to verify connection of the ODI agent localagent. Click OK.
Screenshot for Step

Screenshot for Step
You successfully created and connected to ODI agent. 
5.1..3 run the load plans in command prompt:
To start a Load Plan from a command line:
  • Change directory to /agent/bin directory of the Oracle Data Integrator installation.
  • Enter the following command to start a Load Plan.

On WINDOWS systems:
startloadplan.bat <load_plan_name> <context_code> [log_level]"-AGENT_URL=<agent_url>" ["-KEYWORDS=<keywords>"] ["<variable>=<value>"]*

Example:
startloadplan.bat Testloadplan1 GLOBAL "-AGENT_URL=http://localhost:20910/oraclediagent"

C:\Users\Mohankrishna\Desktop\Capture1.PNG

Then goto Operator and check the status.