Install Oracle BIEE 10g in suse 10

 

Install Oracle BIEE 10g in suse 10

System Environment:

SUSE Linux Enterprise Server 10 (i586)

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod

Biee_linux_x86_SUSE_101342

Download BIEE installation software:

You can download biee_linux_x86_SUSE_101342 from the oralce official website.

Hardware:

Minimum configuration: 1 GHz CPU, 2 GBRAM, GB free disk installation space, 2 G-4 g disk swap space.

Preparations before installation:

1. Create a user:

Create oraclebi/oraclebi as the root user and join oracle and dba groups.

# Useradd oraclebi

# Passwd oraclebi

# Usermod-a-G oracle, dba oraclebi

You can run the following command to view the group to which oraclebi belongs:

# Groups oraclebi

2. Install JDK 1.6 or a later version. (JDK 1.6 is installed here, which is described in)

Run the $ java-version command to check whether a java environment exists in the environment. skip this step if a jdk1.5 or later version is available. (Note that if the jdk is installed by root or another user, you need to grant read and write permissions to oraclebi users, such as # chmod 777/opt/java/jdk1.6.0 _ 18) -- My JDK installation directory. Download the jdk_1_5_0_8-linux-i586.bin (or a later version) at java.sun.com)

 

$ Chmod + x jdk-6u18-linux-i586.bin

$./Jdk-6u18-linux-i586.bin

Edit the/etc/profile file and put the following code at the beginning:

JAVA_HOME =/opt/java/jdk1.6.0 _ 18/

CLASSPATH =.: $ JAVA_HOME/lib/tools. jar:/lib. dt. jar

PATH = $ JAVA_HOME/bin: $ PATH

ExportJAVA_HOME CLASSPATH PATH

ExportLANG = _ SU

After you log on again, check whether the jdk is normal:

$ Java-version

Java version "1.6.0 _ 18"

Java (TM) SE Runtime Environment (build 1.6.0 _ 18-b07)

JavaHotSpot (TM) Client VM (build 16.0-b13, mixed mode, sharing)

3. Install the oracle client

For specific installation instructions, see the relevant documentation to install it in the/opt/oracle directory.

4. Set Environment Variables

Add the following code to the/etc/profile/oracle. sh file:

ORACLE_BASE =/opt/oracle

ORACLE_HOME = $ ORACLE_BASE/product/10.2/db_1

ORACLEBI_HOME =/opt/oraclebi

ORACLE_SID = orcl

NLS_LANG = "Simplified Chinese_china". ZHS16GBK

PATH = $ PATH: $ ORACLE_HOME/bin:/opt/java/jdk1.6.0 _ 18/bin: $ HOME/bin

Export ORACLE_SID

Export ORACLE_BASE

Export ORACLE_HOME

Export ORACLEBI_HOME

Export PATH

5. Set the installation environment:

The following operations are performed under oraclebi users.

Upload the downloaded biee_linux_x86_suse_101342.zip file to the/home/share directory of the server. The path is usually shared with my files. Unpack the file:

$ Cd/home/share/

$ Unzip biee_linux_x86_SUSE_101342.zip

After unpacking, you can see the/home/share directory. You can see the following two files in this directory:

Server Server_Ancillary

The Server folder contains the Installation File of BIEE's main Server. Server_Ancillary is the BIEE desktop components BIOFFICE and BI Publisher. It can be used for desktop office collaboration and advanced report generation.

Create the installation directory (run as root ):

# Mkdir/opt/oraclebi

# Mkdir/opt/oraclebidata

# Chown oraclebi: users/opt/oraclebi

# Chown oraclebi: users/opt/oraclebidata

Check:

Go to the directory and run UnixChk. sh to check the installation environment (executed by oraclebi ):

$ Cd/home/share/Server/Oracle_Business_Intelligence

$./UnixChk. sh/opt/oraclebi

SUCCESS !! -This machine is configured for Oracle bi ee 10.1.3.4 -- (correct)

The environment configuration is correct and can be installed.

My prompt information is as follows:

CHECKFAILED-Unsupported version SUSE Linux Enterprise Server 10 (i586)

VERSION = 10 for Oracle bi ee 10.1.3.4

SupportedSuSE Linux versions:

Suse linux Enterprise Server 9

Locale: Cannot set LC_CTYPE to default locale: No such file or directory

Locale: Cannot set LC_MESSAGES to default locale: No such file or directory

Locale: Cannot set LC_COLLATE to default locale: No such file or directory

CHECKFAILED-ulimit-n shoshould be at least 10240 or unlimited

FAILURE !! -This machine is NOT configured for Oracle bi ee 10.1.3.4

However, continue with the following operations.

 

Start installation:

1. Install

Follow these steps ).

Run

$ Cd/opt/oraclebi

$./Oraclebi_enable_jdk_home_permissions.sh

Install biee

$ Cd/home/share/Server/Oracle_Business_Intelligence

$./Setup. sh-console

Next, follow the prompts to install it step by step.

Pay attention to the Installation path. The Data paths of Installation Localtion and Data Localtion are/opt/oraclebi and/opt/oraclebidata respectively. Therefore, you can press enter directly. The Installation tips are as follows, note the following:

......

Select the installation type: Enter 1 and select Basic. Note that if Advanced is selected, you need to install applicationserver in advance.

Next select the installation type: Enter 1 and select complete

Enter the jdk path as prompted.

Enter the oc4jadmin Password

Select the installation language, enter 8, and select english

Next, follow the prompts to start the installation.

If the installation is accidentally terminated, You need to delete the/opt/oraclebi and/opt/oraclebidata directories under the root user, and restart the machine before re-installation.

After a dozen minutes of waiting, after the installation is complete, the system will prompt the following information:

2. Configuration after installation

Modify the user. sh File

$ Cd/opt/oraclebi/setup

$ Vi user. sh

In Linux: Oracle BI 32 bit mode, remove the notes and modify them as follows:

######################################## #######################

# Linux: Oracle BI 32 bit mode

######################################## ########################

Set + u

# Oracle Parameters

#---------------------------

# Make sure that Oracle DB 32 bit Client is installed

ORACLE_HOME =/export/home/oracle/10g

Export ORACLE_HOME

TNS_ADMIN = $ ORACLE_HOME/network/admin

Export TNS_ADMIN

PATH = $ ORACLE_HOME/bin:/opt/bin: $ PATH

Export PATH

LD_LIBRARY_PATH = $ ORACLE_HOME/lib: $ LD_LIBRARY_PATH

Export LD_LIBRARY_PATH

3. Check whether the BI process is normal:

$ Cd/opt/oraclebi/setup

/Run-sa.sh start

Startup process: Oracle Business Intelligence Server process

/Run-saw.shstart

Startup process: OracleBusiness Intelligence Presentation Services process and Oracle Business Intelligence Javahost process

/Run-sch.shstart

Startup process: Oracle Business Intelligence Scheduler process

An error occurs when starting Scheduler process. If you do not care about it for the time being, continue to start Linux,

 

./Maid

Start the Linux Kernel

After you start enter http: // ip: 9704/analytics in the browser window address to log on to OBI. Here I Use http: // 192.168.1.110: 9704/analytics, both the user name and password are Administrator. If the user can log on to the system normally, the biee installation is normal.

Configure sheduler

Create database users: oraclebi/oraclebi,

Run the $/opt/oraclebi/server/Schema/SAJOBS. Oracle. SQL and SAACCT. Oracle. SQL scripts. The Code is as follows:

Log on to the user sysdba using pl/SQL tools

Create user oraclebi identified by oraclebi

Grant connect, resource to oraclebi;

 

Log on to oraclebi using pl/SQL tools

Extract the two/SAJOBS. Oracle. SQL and SAACCT. Oracle. SQL scripts and execute the script statements.

 

Configure tnsname:

See oralce installation documentation

 

Then modify the odbc. ini file:

$ ORACLEBI_HOME/setup

$ Vi odbc. ini

Modify the following parts:

[ODBC Data Sources]

AnalyticsWeb = OracleBI Server

Cluster = OracleBI Server

SSL_Sample = OracleBI Server

Orcl = libnqsdbgatewayoci10g. so

 

[Orcl]

Driver =/opt/oraclebi/server/Bin/libnqsdbgatewayoci10g. so

Description = OracleBI Server

ServerMachine = 192.168.1.110

DBCName = 192.168.1.110

Username = oraclebi

Password = oraclebi

Database = orcl

DefaultDatabase = orcl

 

Then execute:

 

$ ../Opt/oraclebi/setup/sa-init.sh

Run the following command:

$/Opt/oraclebi/server/Bin/schconfig

 

For example, in this step, the following error occurs:

./Schconfig: error while loading sharedlibraries: libnqutilitygeneric. so: cannot open shared object file: No such fileor directory

 

Solution: www.2cto.com

Cd/opt/oraclebi/setup, run./common. sh, and enter

ExportLD_LIBRARY_PATH = $ LD_LIBRARY_PATH:/opt/oraclebi/server/Bin

/Sa-init.shstart

 

Cd/opt/oraclebi/server/Bin, run

ExportSAROOTDIR =/opt/oraclebi

ExportSAWROOTDIR =/opt/oraclebi/web

ExportSADATADIR =/opt/oraclebidata

ExportSATEMPDIR =/opt/oraclebidata/tmp

From Shadow sporadic

 

Run the following command:

$/Opt/oraclebi/server/Bin/schconfig

Otherwise, run the following command:

Select 1-Configure Scheduler in the Delivers Configuration Menu item as prompted

Then select 1-Database for Scheduler Configuration

Then select 3-Data Source Name in Scheduler Database Configuration as follows:

>>> Enter Choice: 3

Enter Data Source Name []: charge

Save and exit.

In the following order: 1, press enter, 1, press enter, 3, press enter, enter "charge", Press enter, 0, press enter, enter "y", Press enter, 0, press enter, 0. Press enter to complete the operation.

 

/Opt/oraclebi/setup, run./common. sh, and enter

/Run-sch.sh start

 

Then execute the following script:

$ Cd/opt/oraclebi/setup

$./Run-sch.sh start

Oracle