OBIEE SampleAppv406 Automatic startup configuration, obieesampleappv406

OBIEE SampleAppv406 Automatic startup configuration, obieesampleappv406

SampleApp introduction:

 

SampleApp is an all-in-one service that demonstrates almost any top-level features that can be imagined in OBIEE. It is a VirtualBox virtual machine that has installed many applications (databases, OBIEE, Endeca, TimesTen, Essbase, and so on), and through the dashboard, Mobile Application Designer, using D3, the basic analysis technology is demonstrated in analysis visualization by using ADF and JavaScript.

 

SampleApp is great, but it lacks the Automatic startup function of each service. We create and configure the startup script in the following steps to facilitate OBIEE management.

 

The OBIEE init. d Service script shown here can be used on any Linux where OBIEE is installed, or you can view the following download: https://github.com/RittmanMead/scripts/tree/master/obi/service

 

1. Preparations

Assume that we have completed the installation and configuration of VirtualBox VM.

 

●DownloadedThe28GB worth of zip files

● Unpacked them using 7zip

● Found 70 + GB of disc space freeand imported the OVF into VirtualBox

● Started up the VM

 

For details about sampleappinstallation, see sampleapp_quickdeploymentguide-406.pdf. You can find the SampleAppv406 download page:

Http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

2. Set automatic database startup

To enable Automatic startup of OBIEE, you must first ensure that the database must be started and set it as a service (init. d)

 

# Create startup/shutdownscript files

Mkdir-p/home/oracle/scripts

Chown oracle. oinstall/home/oracle/scripts

Cat>/home/oracle/scripts/startup. sh <EEOF

#! /Bin/bash

 

# Start Listener

Lsnrctl start

 

# Start Database

Sqlplus/as sysdba <EOF

STARTUP;

Alter pluggable database allopen;

EXIT;

EOF

EEOF

 

Cat>/home/oracle/scripts/shutdown. sh <EEOF

#! /Bin/bash

 

# Stop Database

Sqlplus/as sysdba <EOF

Alter pluggable database allclose immediate;

Shutdown immediate;

EXIT;

EOF

 

# Stop Listener

Lsnrctl stop

EEOF

 

# Make them executable

Chmod u + x/home/oracle/scripts/startup. sh/home/oracle/scripts/shutdown. sh

Chown oracle. oinstall/home/oracle/scripts/startup. sh/home/oracle/scripts/shutdown. sh

 

# Create service script

Cat>/tmp/dbora <EOF

#! /Bin/sh

# Chkconfig: 345 90 25

# Description: Oracle autostart-stop script.

#

# Set ORA_OWNER to the user idof the owner of

# Oracle database software.

 

ORA_OWNER = oracle

 

Case "\ $1" in

'Start ')

# Start the Oracle databases:

# The following command assumes thatthe oracle login

# Will not prompt the user for anyvalues

Su-\ $ ORA_OWNER-c "/home/oracle/scripts/startup. sh>/home/oracle/scripts/startup_shutdown.log 2> & 1"

Touch/var/lock/subsys/dbora

;;

'Stop ')

# Stop the Oracle databases:

# The following command assumes thatthe oracle login

# Will not prompt the user for any values

Su-\ $ ORA_OWNER-c "/home/oracle/scripts/shutdown. sh>/home/oracle/scripts/startup_shutdown.log 2> & 1"

Rm-f/var/lock/subsys/dbora

;;

Esac

EOF

Sudo mv/tmp/dbora/etc/init. d/dbora

Sudo chown root./etc/init. d/dbora

 

# Make the service scriptexecutable

Sudo chmod 750/etc/init. d/dbora

 

# Associate the dbora servicewith the appropriate run levels and set it to auto-start using the followingcommand.

Sudo chkconfig -- add dbora

 

In SampleApp v406, there is an Oracle12c container database (CDB), which has two "pluggable" databases (PDB ). Assuming that you have not started the database, attempting to connect to the RCU mode of PDBS will fail:

 

[Oracle @ demo ~] $ SqlplusBIEE_BIPLATFORM/Oracle123 @ localhost: 1521/pdborcl

 

SQL * Plus: Release 12.1.0.1.0Production on Tue Jun 17 03:03:51 2014

 

Copyright (c) 1982,201 3, Oracle. All rights reserved.

 

ERROR:

ORA-12541: TNS: no listener

 

Start the service now:

Sudo service dbora start

 

Check the status again:

[Oracle @ demo ~] $ SqlplusBIEE_BIPLATFORM/Oracle123 @ localhost: 1521/pdborcl

 

SQL * Plus: Release 12.1.0.1.0Production on Tue Jun 17 03:06:12 2014

 

Copyright (c) 1982,201 3, Oracle. All rights reserved.

 

Last Successful login time: TueJun 17 2014 03:02:09-

 

Connected:

Oracle Database 12c EnterpriseEdition Release 12.1.0.1.0-64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

 

SQL>

 

 

3. Configure to automatically start OBIEE

Now, we can set the service that OBIEE automatically starts when the system starts. Install two scripts for Environment path and dependency change in SampleApp v406. Github public script Library:

Https://github.com/RittmanMead/scripts/tree/master/obi/service

 

 

# Lsof is used in the scriptand isn't installed by default, so let's install it:

Sudo yum-y install lsof

 

# Now fetch the init. d scriptitself and configuration file

Sudo wget -- no-check-certificate https://raw.githubusercontent.com/RittmanMead/scripts/master/obi/service/init.d/obiee-O/etc/init. d/obiee

Sudo wget -- no-check-certificatehttps: // raw.githubusercontent.com/RittmanMead/scripts/master/obi/service/sysconfig/obiee-O/etc/sysconfig/obiee

 

# Update the FMW_HOME path inthe script

# If you're doing thismanually, you just neeed to change the line

# "FMW_HOME =" and putin the FMW_HOME path for your installation.

# In the case of SampleApp v406it is/app/oracle/biee

Sudo sed-I-e's/FMW_HOME =. * $/FMW_HOME =\/ app \/oracle \/biee/G'/etc/sysconfig/obiee

 

# Make the script executable

Sudo chmod 750/etc/init. d/obiee

 

Run the following command to check the running status of OBIEE:

Sudo service obiee status

 

 

 

Start OBIEE:

Sudo service obiee start

 

If the service fails to be started at the first time, run the command again to start the service.

 

Disable OBIEE:

Sudo service obiee stop

 

Set to automatically start OBIEE when the system is running:

Sudo chkconfig -- add obiee

 

Now you can restart the system and check whether the settings are valid.

Sudo shutdown-r now

 

Refer:

SampleAppv406 Automatic startup configuration:

Http://www.rittmanmead.com/2014/06/sampleapp-v406-automatic-startup-of-obiee/

SampleAppv406 Virtual Machine installation Configuration:

Http://www.slideshare.net/lravikumarvsp/step-by-step-deployment-of-sample-appv406