OBIEE SampleAppv406 自己主动启动配置

时间:2023-12-16 18:19:08

SampleApp 一个简短的引论:

SampleApp这是一个一站式服务,几乎证明OBIEE不管顶的特征可想而知。

它安装了大量的应用(数据库,OBIEE,的Endeca。TimesTen的。Essbase的,等等)的VirtualBox虚拟机,并通过对仪表盘,移动应用程序设计师,使用D3,ADF,JavaScript。分析可视化演示了基本分析技术等等。

OBIEE SampleAppv406 自己主动启动配置

watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvbGljaGFuZ3phaQ==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/Center" alt="">

SampleApp是很棒的。但缺少各个服务的自己主动启动功能,我们通过以下的步骤创建和配置启动脚本,方便管理OBIEE。

这里展示的OBIEE init.d服务脚本能够在不论什么安装OBIEE的Linux上使用。也能够以下的地方查看下载:https://github.com/RittmanMead/scripts/tree/master/obi/service

1. 准备工作

如果之前我们已经完毕VirtualBox VM的安装和配置

●  downloaded the28GB
worth of zip files

●  Unpacked them using 7zip

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

●  Started up the VM

完整的SampleApp安装指南见SampleApp_QuickDeploymentGuide–406.pdf,能够SampleAppv406下载页找到:

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

2.   设置数据库自己主动启动

为了使OBIEE自己主动启动,首先要确保数据库先要启动,通过设置它作为一个服务(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 the

# 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

在SampleApp v406中,有一个Oracle12c的容器数据库(CDB),在它其中有两个“可插拔”数据库(PDB)。如果你没有启动数据库。尝试连接到PDBS的RCU模式将会失败:

[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, 2013,Oracle.  All rights reserved.

ERROR:

ORA-12541: TNS:no listener

如今启动服务:

sudo service dbora start

再次检查状态:

[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, 2013,Oracle.  All rights reserved.

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

Connected to:

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.   配置自己主动启动OBIEE

如今。我们能够设置OBIEE在系统启动时自己主动启动的服务。在SampleApp v406安装须要两个对环境的路径和依存关系变化的脚本。github共公的脚本库:

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

执行以下命令查看OBIEE的执行状态:

sudo service obiee status

OBIEE SampleAppv406 自己主动启动配置

启动OBIEE:

sudo service obiee start

OBIEE SampleAppv406 自己主动启动配置

假设第一次启动时有启动失败的服务,能够再次执行命令启动

OBIEE SampleAppv406 自己主动启动配置

关闭OBIEE:

sudo service obiee stop

设置系统执行时自己主动启动OBIEE:

sudo chkconfig --add obiee

如今能够又一次启动系统。检查设置是否有效

sudo shutdown -r now

參考:

SampleAppv406自己主动启动配置:

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

SampleAppv406虚拟机安装配置:

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