Showing posts with label 12c. Show all posts
Showing posts with label 12c. Show all posts

Monday, April 17, 2017

Difference between OBIEE 11G & 12C



S.N0
                   OBIEE 11G
           OBIEE 12C
1
There is no testing and validation tool available after updating 11g                                            
Validation tool provided by oracle after upgrading  to 12c
2
Unable to build using external content from the front end
Report can be build by using external source as well
3
Heat matrix view is not present
Heat matrix view is present
4
Sorting for graphs/pivot table are not Present
Sorting added
5
Have to open the view to edit the Properties
Able to open properties of view from Compound layout only
6
Upload RPD through  User Interface
No more deployment  from Enterprise Manager
7
OPMNP process control is present
OPMN is removed
8
Security GUID’s used
Security GUID’s removed
9
Complicated Security Socket Layer (SSL) configuration
Simplified Security Socket Layer (SSL) configuration
10
RPD, Catalog, roles are scattered
BAR Archive Process used in 12c

Friday, April 22, 2016

12C Database Installation for BIAPPS 11.1.1.10.1 in Redhat 6


  Before starting installation process please check our Pre-Requisites for ODI BIAPPS IN Linux  

1. Configure the KERNEL


    a) We need to configure the RedHat 6.0 Linux kernel to support Oracle

       Edit the vi /etc/sysctl.conf and add following lines.


  b) Now execute sysctl -p command to apply the new settings:
 C)  Edit the vi /etc/pam.d/login file and add following line


   d)  Edit the vi /etc/security/limits.conf file and add following lines:


      e)  modify the vi /etc/sysconfig/selinux change value of SELINUX variable to disabled:



    1.  Add the Oracle User:

    2. a) Next we need to create the Oracle user account, OS groups and mount point.

     The Oracle software will be installed and owned by the oracle user account. In additional  
     several OS groups are created that allow other non-oracle OS users privileged access to the
     database.
                  b)   Login as root and create the user oracle account and the OS groups:







   c) Now we can log into our new oracle account and configure the bash profile:
       vi ~/. bash_profile
       Add the following lines to the profile script:
4)  Install Database
           Since we are going to install the Database in silent mode, we need a response file.
 The response file will provide instructions to the installer program on how we want Oracle 12.1.0.1 Database software configured.
  1.      Change into the database directory and launch the runInstaller script as follows: 
    in my case i used above rsp file





   b) At the conclusion of the install we need to log in as root and execute the

     /u01/app/oracle/product/11.2.0/dbhome_1/root.sh script.



..... to be continued Navigate to OBIEE 11g Installation