Monday, February 29, 2016

ORACLE APEX INTEGRATION WITH OBIEE 11G

For Integrating OBIEE with APEX, follow these steps:
  • Download the APEX  ZIP from Oracle Website and extract it
  • After Extracting APEX ZIP

  • Give the command prompt which is shown below screen shot
Then run the command as follows
C:\Users\SSS2014012\Desktop\New folder (2)\4.PNG
After running above command, give the command as follows then only all images will load
After running above command, just run the follow command so that we can give the password, Port number.
In this case we gave password as? Welcome123 and the port number is 9800 and then give the url here in this cas
WORKSPACE: INTERNAL
USER: ADMIN
PASSWORD: ?Welcome123



CREATING WORKSPACE IN APEX
C:\Users\SSS2014012\Desktop\apex\2.PNG
C:\Users\SSS2014012\Desktop\apex\3.PNG
C:\Users\SSS2014012\Desktop\apex\5.PNG
C:\Users\SSS2014012\Desktop\apex\6.PNG
C:\Users\SSS2014012\Desktop\apex\7.PNG
C:\Users\SSS2014012\Desktop\apex\8.PNG


CREATING APPLICATION IN APEX
For creating new APPLICATION, we should logged in WORKSPACE which we are created
C:\Users\SSS2014012\Desktop\apex\9.PNG
C:\Users\SSS2014012\Desktop\apex\10.PNG
C:\Users\SSS2014012\Desktop\apex\11.PNG
C:\Users\SSS2014012\Desktop\apex\12.PNG

C:\Users\SSS2014012\Desktop\apex\13.PNG
C:\Users\SSS2014012\Desktop\apex\14.PNG
C:\Users\SSS2014012\Desktop\apex\15.PNG
C:\Users\SSS2014012\Desktop\apex\16.PNG
After Completion of above steps, we will get APPLICATION created Successfully which is shown below screenshot
C:\Users\SSS2014012\Desktop\apex\17.PNG
In APPLICATION, we can create pages, FORMS, REPORTS etc which is shown below screenshot
C:\Users\SSS2014012\Desktop\apex\22.PNG
Below Screenshot, click on SHARE COMPONENTS
C:\Users\SSS2014012\Desktop\apex\18.PNG
After click on SHARE COMPONENTS, we will get below screen
In this screen click on Security for defining the AUTHENTICATION SCHEMES
C:\Users\SSS2014012\Desktop\apex\19.PNG
Click on AUTHENTICATION SCHEMES, follow screenshot will appear
C:\Users\SSS2014012\Desktop\apex\20.PNG

Click on Edit in above screenshot we will get below screen, change SCHEME TYPE to NO AUTHENTICATION (using DAD) and Click on Apply Changes

C:\Users\SSS2014012\Desktop\apex\21.PNG 
Run the APPLICATION in below screenshot
C:\Users\SSS2014012\Desktop\apex\18.PNG

After Click on Run Application, we will get new window
C:\Users\SSS2014012\Desktop\apex\23.PNG

Copy the above URL and paste it in Text format(OBIEE) like below screen shot
C:\Users\SSS2014012\Desktop\apex\24.PNG

C:\Users\SSS2014012\Desktop\apex\26.PNG
C:\Users\SSS2014012\Desktop\apex\25.PNG

After that, created one report named as DEMO which is shown below screen shot
C:\Users\SSS2014012\Desktop\apex\27.PNG
Click on Connecting to APEX link which is shown above screen shot and it will re direct to APEX like below screen shot
C:\Users\SSS2014012\Desktop\apex\28.PNG
IF we want to add a new Row, click on ADD ROW, here in this case added name as srivatsan like below screen shot
C:\Users\SSS2014012\Desktop\apex\29.PNG
Then click on APPLY CHANGES. After clicking on APPLY CHANGES in APEX Window then refresh the OBIEE Report and the database, we can see the changes which is shown below screen shot

C:\Users\SSS2014012\Desktop\apex\30.PNG


Wednesday, February 24, 2016

Hyperion ESSbase Database Fragmentation and Removal

Database Fragmentation
Fragmentation is produced when Essbase writes a modified data block to a new  location on disk and leaves unused space in the former location of the data block, as shown on the slide. (Modified blocks are larger because data from a data load or calculation is added to the blocks.)
 


Measuring Database Fragmentation
Average clustering ratio:
  • An inverse measure of data block “scatter”
  • Higher average clustering ratio means lower fragmentation


Managing Database Fragmentation : Two management strategies that are not mutually exclusive 
  • Prevention strategy
–  Recognize contributing factors  
–  Optimize data loads
  •  Reduction strategy
–  Export and reload
–  Dense database restructure
Preventing Database Fragmentation: Tactics to help prevent database fragmentation
  • Recognizing contributing factors  
–  Read/Write/Calculation frequency
–  Data loads
–  Calc and Store
 –  Isolation level


  • Optimizing data loads
–  Fragmentation effect  
–  Load time effect


Reducing Database Fragmentation: Strategies to reduce database fragmentation 
  • Exporting and reloading  
  • Performing a full database restructure
Options  for Restructuring
  • Outline only—Restructures the outline  only; does not restructure the index  and data files (least time-consuming)
  • Sparse—Restructures and creates a new index.
  • Full—Restructures blocks and creates new index and data files (most  time consuming but removes database fragmentation)



Thursday, February 4, 2016

Red Hat Linux 5 - Installation

Red Hat Linux 5 - Installation
Step 1 – Insert the Red Hat Linux DVD into the DVD-drive of your computer. As soon as the following screen pops up, press ‘Enter’ to install Red Hat Enterprise Linux (RHEL) through GUI mode.
http://tutmaster.com/wp-content/uploads/2011/06/untitled.bmp
Step 2– RHEL installer would then prompt you conduct a check as to whether the CD media from which you’re installing is functioning correctly or not. Choose ‘Skip’, press enter and the installation would begin.
http://tutmaster.com/wp-content/uploads/2011/06/untitled1.bmp
Step 3– Next, we need to select the language- English or any other language as per your preference, and then press ‘Next’ .
http://tutmaster.com/wp-content/uploads/2011/06/untitled2.bmp

Step 4– In this step, the RHEL installer would ask you about the appropriate type of keyboard for the system. We take the ‘US English’ keyboard, you can pick any other option depending on the type of your keyboard. Then press ‘Next’ to move to the next step.
http://tutmaster.com/wp-content/uploads/2011/06/untitled3.bmp

Step 5– Next, the installer would ask for an ‘installation number’ if you wish to install full set of Red Hat functionalities. Enter the installation number and press ‘OK’ if you have an officially licensed installation number(for corporate clients that buy Red Hat’s backup support and full features).

Others can select ‘Skip entering installation number’ and press ‘OK’ to proceed. RHEL would show a warning message, press ‘Skip’ in it to continue.
http://tutmaster.com/wp-content/uploads/2011/06/untitled4.bmp
Step 6– The Red Hat installer would then require you to create partitions in your computer’s hard disk for the installation. You can do it in four ways but the simplest way is to select ‘Use free space on selected drives and create default layout’ as this option will not affect any other OS residing in your system.
Check the ‘review and modify portioning layout’ to create partitions and click next.
http://tutmaster.com/wp-content/uploads/2011/06/untitled5.bmp

Step 7– In this step you must create the required system partitions and mount points such as ‘/boot’, ‘/home’, ‘swap’ etc which are required for the Linux’s proper functioning.
To create different partitions such as /home, /var etc, click on ‘New’ to create the partitions.
http://tutmaster.com/wp-content/uploads/2011/06/untitled6.bmp
Then, select /home in the mount point and choose ‘ext3’ as the file system and give the desired size for it and then click ‘OK’. Similarly also create /boot and /var.
http://tutmaster.com/wp-content/uploads/2011/06/untitled7.bmp
Also, create a swap partition by clicking on ‘New’ and then choosing the filesystem as ‘swap’ and also give the size of Swap partition.(Usually size of swap partition SHOULD BE twice the size of RAM available to the system but you can keep its size less than that too)
http://tutmaster.com/wp-content/uploads/2011/06/untitled8.bmp
Once you have made all the desired partitions and given their mount points, click ‘Next’ to continue installation.
http://tutmaster.com/wp-content/uploads/2011/06/untitled9.bmp
Step 8– This step pertains to the default OS that will be loaded by the GRUB loader
http://tutmaster.com/wp-content/uploads/2011/06/untitled10.bmp
(Note- If you have multiple Operating Systems installed, you would see multiple options here and you have to check in front of the OS name that you want to be loaded by default when the system is started.)
Click ‘Next’ to continue.
Step 9– This step pertains to the network settings of the Linux system that you are going to install. You can select the Ethernet devices through which the system would communicate with other devices in the network.
You can also provide the hostname, Gateway address and DNS address to the system during this step. (However it’s better to adjust these settings once the system has been fully installed).
http://tutmaster.com/wp-content/uploads/2012/11/Untitled12.png
Step 10– The next step is to adjust the system clock to your particular time zone. Select your time zone and then click ‘Next’.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled13.png
Step 11 – This is a very important step that deals with the root(super-user) password for the system . Type the password and confirm it and then click next.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled14.png
Step 12 – The RHEL installer would then prompt you about if you wish to install some extra ‘Software Development’ or ‘Web Server’ features. By default, keep it at ‘Customize later’ and press ‘Next’.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled15.png
 Step 13– This next step will initiate the installation of Red Hat Linux, press ‘Next’ to begin the process.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled16.png
Step 14– Upon the completion of installation you should the following screen. Press Reboot and you’d be ready to use your newly installed Red Hat Linux OS.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled17.png
POST INSTALLATION CONFIGURATIONS
1. Accept the Red Hat License agreement and click ‘Forward.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled18.png
2. The next step is regarding the configuration of the Firewall. You can Enable or Disable the firewall according to your preferences and then click ‘Forward’.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled19.png
3. Next step is about the configuration of another security tool- SE Linux. By default you should keep it ‘Disabled’ unless you’re working with very secure information.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled20.png
4. You can also choose to configure the Kdump, that stores information about system crashes if your system fails but uses valuable disk space. By default don’t enable it.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled21.png
5. Next, adjust the time and date settings, and then click ‘Forward’.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled22.png
6. The next step is for software updates from Red Hat, at this point you should skip the registration and register at a later time and then click ‘Forward’.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled23.png
7. This step is to create a non-admin user for the system. Enter the details and click ‘Forward’.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled24.png
8. This step is about configuration of your Sound Card, choose a sound device and then click ‘Forward’.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled25.png
9. Click ‘Forward’ to complete the configurations and start using your Red Hat Linux OS.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled26.png
(Note- On clicking ‘Finish’ the system would require a reboot if you have made changes to the configurations of Firewall or SE Linux.)
Your Red Hat Linux OS is now all installed and configured, ready to be used. Good luck using and exploring various features of Red Hat Linux.
http://tutmaster.com/wp-content/uploads/2012/11/Untitled27.png