Step by step installing Oracle Database Linux machine

PREREQUISITES SETTING

1. Download and stage the software

2. Disable the firewall by issuing the below command

# service iptables stop

3. Change selinux from enforcing to disable under /etc/selinux/config

# vi /etc/selinux/config

4. Create two groups i.e., oinstall and dba and make oinstall is the primary group and dba is the secondary group for the user Oracle as shown below

5. Changing kernel parameters

Go to /etc/sysctl.conf and add or modify the parameters

# vi /etc/sysctl.conf

6. Modify the file etc/pam.d/login by adding the line

# vi /etc/pam.d/login

7. Modify the /etc/security/limits.conf

# vi /etc/security/limits.conf

8. Make the directory structure as shown below in which the Oracle Home will be takes place. and make changes in the ownership for the /u01 as shown below

 # mkdir -p /u01/app/oracle/product/11.2.0/db_1
# chown -R oracle:oinstall /u01

9. Change from root user to the oracle user





INSTALLING ORACLE DATABASE

Start the database installation by executing runinstaller command

If you are not interested to give E-mail ..just uncheck the I wish to...box
Then click Next which is not shown in the screen

Select create and configure database and click next

Select Desktop Class and click next

Provide all the details and click next

Note: Always set Character set to UNICODE

Click yes to continue

Click next

Check the prerequisites are ok or not if anything is failed just see the message and install Rpm's which are shown in above screen

Click install

Click ok

Run the above scripts by connecting to Root user

Database installation completed successfully

Steps for checking prerequisites before installing OBIEE 12c on LINUX machine

1. Checking RPMs :

Below rpms must be present on the machine before we start the installation

2. Checking GNU libc version “recommended at least 2.12 “

3. Environment Variables

LD_ASSUME_KERNEL environment variable should not be set

4. SELinux should be disabled for installation

5. Configuring Kernel Parameters

Minimum required kernel version is 2.6.32

Change the user limits in /etc/security/limits.conf as below

6. Configuring Security Parameters

Add the following lines to /etc/sysctl.conf

7.  Processor Requirements

Requires a minimum of 1-GHz CPU.

8.  Memory Requirements

Minimum Disk space 160 GB or more

Minimum Memory 16GB or more for 64 bit operating systems

Minimum 8GB Swap space

Steps to configure custom styles and logo in OBIEE 12c

  1.      Extract the file structure of a new skin
  2.      Rename THE SKIN NAME
  3.      Change the skin files
  4.      Deploy the shared folder as application in weblogic
  5.   Modify the instanceconfig.xml file
  6.      Restart the BI Presentation Service
  7.       Viewing the Modifications

Extract the file structure of the new skin:

Make a temporary directory at any location on the server and copy the bicustom-template.ear file to this temp directory

Extract the ear file

Extract the bicustom.war file

Now make a directory with name analyticsRes under the path $ORACLE_HOME/user_projects/domains/bi/servers/obips1

Move res and WEB-INF folders to newly created analyticsRes folder

Rename the skin name:

Browse to  $ORACLE_HOME/user_projects/domains/bi/servers/obips1/analyticsRes/res and rename the s_Custom directory to the name you wish

Update this name in filemap.xml file under res folder

Change the skin files:

Replace the logo image file you want to display on analytics page with oracle_logo.png under the location $ORACLE_HOME/user_projects/domains/bi/servers/obips1/analyticsRes/res/s_test/master with same name

Deploy the shared folder as application in weblogic:

In the weblogic console, go to deployment,

Click on lock and edit

Install the new application

Click on install

Specify the path and select analyticsRes directory and click on next

Select install this deployment as an application and click on next

Select bi_cluster as target and click on next

Select I will make the deployment accessible from following location and click on next

Select yes, take me to the deployment’s configuration screen and click on Finish

Click on configuration tab and add /analyticsRes to context Root and click on save

Click ok

Click on activate changes

Now start the newly created application

Click on deployments

Select the analyticsRes checkbox in the deployments table and click on start and then select Servicing all requests

Click yes

Newly created application was started successfully

Modifying instanceconfig.xml file:

Browse to $ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS and modify the UI section and add the URL section in the instanceconfig.xml file as below

Save and close the file

Changing the title from Oracle Business Intelligence to CUSTOM NAME you want

Browse to $ORACLE_HOME/bi/bifoundation/web/msgdb/l_en/messages

Open the file productmessages.xml

Rename Oracle Business Intelligence to Ravi Kumar Lanke

Change the below line from 

<WebMessage name="kmsgHeaderBIBrandName"><TEXT>Oracle Business Intelligence</TEXT></WebMessage>

to

<WebMessage name="kmsgHeaderBIBrandName"><TEXT>Ravi Kumar Lanke</TEXT></WebMessage>

Save and close the file

Restart the obiee components and Login to analytics page and check