środa, 29 maja 2013

Oracle linux silent install , unattended, kickstart

http://www.oracle-base.com/articles/linux/kickstart.php
https://linux.oracle.com/documentation/EL6/Red_Hat_Enterprise_Linux-6-Installation_Guide-en-US.pdf

Kickstart - Automated Installations of RHEL and Oracle Linux

Kickstart installations provide an automated alternative to the normal interactive installations of RHEL and Oracle Linux. The automation of installation and post installation configuration steps represents a considerable time saving in situations where many similar installations are performed.
A kickstart installation requires a kickstart file that contains the answers to every question asked during an interactive installation. Kickstart files can be created in one of three ways:

wtorek, 21 maja 2013

ERROR: runcat sawjniapi643r.dll: Can't find dependent libraries


Problem solved ;)

Client tool's installer does not provide all the required libraries, so the message: "sawjniapi643r.dll: Can't find dependent libraries".

After doing a standard OBIEE_Client_Tools installation, you have to provide the missing files.
In version 11.1.1.7.0 missing files are:
- SAWAUDITWRAPPER643R.DLL or SAWAUDITWRAPPER3R.DLL (32-bit)
- SAWFAVORITES643R.DLL or SAWFAVORITES3R.DLL (32-bit)
- SAWHEADLINEVIEW643R.DLL or SAWHEADLINEVIEW3R.DLL (32-bit)
- SAWORACOREFACADE643R.DLL or SAWORACOREFACADE3R.DLL (32-bit)
- SAWTREEMAPVIEW643R.DLL or SAWTREEMAPVIEW3R.DLL (32-bit)
- SAWTRELLISVIEW643R.DLL or SAWTRELLISVIEW3R.DLL (32-bit)
In 11.1.1.6.x there are other files missing. Nevermind

poniedziałek, 13 maja 2013

Load testing of OBIEE with JMeter


http://www.mkietzke.de/?p=44

Load testing of OBIEE

I looked for a possibility to test an OBIEE system regarding performance. Therefore I want to simulate user behavior and query reports to exeute requests. I found Apache JMeter, an open-source application for load testing. Following I describe my easy setup scenario.
First I downloaded the current Apache JMeter release 2.8 for windows. After extracting I executed \bin\jmeterw.cmd and got an application window.

środa, 8 maja 2013

OBIEE 11G 64-Bit - Microsoft Windows 2003 R2 SP2 X64 Server

http://obiscraps.blogspot.com/2011/04/obiee-11g-64-bit-microsoft-windows-2003.html


Installation

Guys
This is the detailed installation of OBIEE11G on a 64bit Machine. This is my first post, so let me know of any suggestions or questions.

Server Configuration
OS: Microsoft Windows 2003 R2 SP2 X64
Database: Oracle 11gR2 X64 (11.2.0.1)
Java JDK: Java JDK 6u24 X64 Windows and JRE 6u24 X64 Windows
Weblogic Server: WLS 10.3.3 X64 (Generic Version)
RCU: OFM RCU WIN 32 11.1.1.3.3 (available only in 32 bit)
OBIEE 11G: OBIEE 11g R1 x86-64 (11.1.1.3) - Software only install
OBIEE 11G Client Tools Install: OBIEE 11G client Tools Installation 32bit (It doesn’t have Catalog Manager)
image001
****Install Microsoft Visual C++ 2005 SP1 Redistributable Package (x64) prior to the installation of Oracle BI on Microsoft Windows X64.
Java JDK 6u24 X64 Windows and JRE 6u24 X64 Windows installation steps
JDK and JRE are available at http://www.oracle.com/technetwork/java/javase/downloads/index.html
Run jre-6u24-windows-x64.exe
Choose the destination folder if required. After the successful completion of the installation close the window.
image002
Now, Run jdk-6u24-windows-x64.exe
image003
Click Next ....
image004
If JDK comes with JRE, then no need of doing the first step. All the above shown features will be installed.
Change the destination folder for Java JDK (if necessary). Click Next.....
image005
Click finish to complete the Java JDK installation. Also add the Java path in Environment Variables.
image006
After the installation, you should have them available at the specified location on the drive as shown above.
Weblogic Server 10.3.3 X64 (Generic Version) installation steps
Product available at: http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html
Use Generic Version for 64-bit JVM support and is the supported installation for OBIEE 11
Prerequisite: For 64 bit operating systems, the Weblogic installation program does not install a JDK. Filenames for these installation programs end in .jar. To run these .jar programs, you must have appropriate version of JDK installed on your system, and include bin directory of JDK at the beginning of the PATH variable definition.

Before Starting the Installation:
Create a Middleware_Home directory which holds all the weblogic server components along with the OBIEE components.
- The installation program uses the Temporary directory into which it extracts files that are needed to install the software on the Target System. By Default, installer uses the directory that is referenced by the TMP variable. If you do not have enough space to run the installation program you need to set the Temporary directory as described in Tale 2-2 of the Oracle Fusion Middleware Weblogic Server Installation Documentation.
URL: http://download.oracle.com/docs/cd/E14571_01/doc.1111/e14142/prepare.htm#i1183981
- Do not include any spaces in the name of Middleware Home directory.
Weblogic Server Installation - Graphical mode
Run wls1033_generic.jar to start the installation
image007
image008
Click next on the Welcome Screen...
image009
Select the new Middleware Home Directory (C:’MW_HOME)and Click Next.....
Click next to continue to next screen..........
image011
Choose Typical Installation by default (or Custom installation for specific products) and click next.....
image012
In this screen, as we are using Generic version where JDK and JRE are not bundled Browse for the Local JDK and select as shown above and click next...................
image013
Choose product installation directories and click next.....
Note: It is recommended to have all the products within the Middleware home directory.
image014
Select the All Users option and Click Next......
image015
Review the Summary screen and Click Next..........
image016
Installation progress screen.................
image017
This completes the installation of Weblogic server. Check Run Quick start if you want to see some sample domains and online documentation.
OFMRCU WIN 32 11.1.1.3.3 installation steps
Run RCU from Windows 32-bit client for OBIEE 11G 64-bit installations
Open rcuHome -> bin -> rcu.bat file from 32-bit Windows Client
image018
Double click to run it or open it from Command prompt
image019
Click Next…..
image020
Select CREATE and click Next…..
image021
Provide the Database connection details for the server and Click Next…..
image022
The screen above will provide the pre-requisite check and after its ‘operation completed’ dialogue click OK….
image023
Select the prefix (default DEV) - MARBI
Select the Schemas that need to be deployed on the database (MDS and BIPLATFORM) as shown above.
The given prefix will be added to the Schemas as shown above.
Then Click Next……
image024
Complete the Pre-Requisites checker and click ok…….
image025
Provide the passwords for the schemas. It is recommended to have same password for both the schemas…. Click Next for Manage Table Spaces Screen…..
image026
Click Next to create table spaces and deploy these Schemas……….click ok for any warnings/pop-ups….
image027
Click OK to continue…….
image028
Review the summary screen and click ‘CREATE’ to create the schemas….image029
Progress Screen….
image030
This is the Summary Screen showing the completion of the creation of the Schemas on the database OBIEE. Click close to complete.
You can verify the schemas using the following command on server
SQL> SELECT username FROM all_users ORDER BY username;
image031
Here we have the schemas MARBI_MDS and MARBI_BIPLATFORM.
OBIEE 11g R1 x86-64 (11.1.1.3) - Software only install Steps
Extract the whole OBIEE 11G 64bit Package to a location where the path doesn’t have any spaces as shown below
image032
After Extracting the Zip files to a directory, Go to
$$BI11G$$’bi_windows_x86_111130_64_disk1_1of2’bishiphome’Disk1
and double click on Setup.exe to start the Universal installer.
image033
This will bring the following screen.........
image034
Welcome Screen....
image035
Click Next to continue.......
image036
On the Select Installation Type Screen Select "SOFTWARE ONLY INSTALL" Type and click Next........
image037
On the above Pre-requisite checks screen, make sure everything passed without any errors. If an error message appears it is recommended to try to fix the error before proceeding further with the installation.
Note: Your Installation might not function properly if you continue the pre-requisite check screen errors or warning messages without resolving them......
image038
Select the Oracle Middleware Home same as the Middle ware home where the weblogic server was installed and select the name for Oracle Home Directory for Oracle _BI installation.
By default Oracle Home Directory will be Oracle_Bi1, which was changed in the above installation to Oracle_MARBI. The Middleware Home is selected same as weblogic server home C:’MW_HOME.
Then Click Next.....image039
Specify My Oracle Account support account for security updates...
image040
On the Summary screen, verify the details and save the response file (optional) and click Next to start the installation...
image041
On the installation Progress screen, monitor the installation process and if you need to stop the installation, click Cancel.
image042
Note: Provide the path for Disk 2,3,4 (disk1_2 of 2) location to continue with the install as shown below till ’stage ’. or it is always good to have all the discks copied into a single directory which doesn’t have any spaces.
Path: $BI11G$’bi_windows_x86_111130_64_disk1_2of 2’bishiphome’Disk2’stage
image043
and do it for disk 3, disk 4 and continue with the installation...image044
image045
image046
After completing the SOFTWAR ONLY INSTALL....Click Next to continue for completion summary screen.........image047
Click Finish to Exit OBI11G installer and complete the installation.
This Completes the installation, and now we need to perform the Post installation tasks related to the Software only Install.
After Installation
image048
Post - Installation Tasks:
Configuring Oracle Business Intelligence with Configuration Script
With Oracle Business Intelligence configuration script you can configure BI software that was installed through software only install.
Limitation: You cannot extend the domain using the OFM Configuration Wizard. You cannot add more OBI components to a existing BI domain using this Wizard. And also you cannot add OBI components to an existing domain created by Weblogic server or any other product.
****Pre-Reqs: 
It is strongly recommended to use static IP address on the server. Check for these before starting the Configuration Wizard from Command Prompt:
nslookup hostname
nslookup hostname.domainname
nslookup IPaddress
Running Configuration Script:
Start the script from
ORACLE _HOME (BI HOME): ’’MW_HOME’Oracle_MARBI (Oracle_bi1)’bin
Run Config.bat command
image049 
image050
Welcome screen for the Configuration Wizard..........Click Next....
image051
Complete the pre-requisite check and click next......
image052
On Create or Scale out BI system screen, click create new BI System and enter the
username: MARBI
Password: *****
Domain Name: MAR_bifoundation_domain
Note: Make sure no BI domain of the same name already exists.
as shown above and click next to continue........
image053
On the Specify Installation Location Screen, All the values will be by default, (optionally Change them),
Instance Home: c:’MW_HOME’instances’MARBI
Instance name: MARBI (default: instance1)
image054
On Configure Components Screen, Select the components that you want to be installed.
After you make selections.......click next........
image055
On the Database details screen, Enter the database connection details as shown above.
Connect String format: Host:Port:Service_name
Enter the BIPLATFORM Schema username with prefix that you declared while setting up schemas and password. Click Next to continue...........
image056
Configuration script automatically configures the ports, unless you want them to be configured manually using a configuration file such asStaticports.ini. Configuration Wizard automatically assigns Node Manager Port 9556 by default, unless specified.
Note: If configuring OBI in a shared Middleware where Node Manager is installed, OBI script uses the existing Node Manager and its Port Number.
image057
Review the summary screen and save the file (optional). Click Configure to run the Configuration Script.
image058
Monitor the Configuration process and check for any errors or warnings....
Click Abort to stop the configuration process.
image059
ion of image060
This Screen Shows the completion of the Configuration process without any errors.
image061
Complete Screen, Gives the details of the installed products and also the Configured components. Save this file for future review.
Go to the URL, Specified in the Configure components section above for Business Intelligence Enterprise Edition
http://Hostname:Port/analytics
image062
Login with the Credentials that you entered earlier while setting up the Configuration Wizard for Username and Password. This will bring the following screen
image063
Client Tools Installation
As we have noticed we don’t have any Client tools available with this installed BI System. Please refer to the Other document for the instructions on the installation of Client tools.
After the installation of the client tools either on the server or on the client (as the mater release of client tools package is made compatible with 64bit systems also) we need to create system DSN for the OBI server as follows
image064
Click Add to add the data System DSN for server.
image065
Select "Oracle BI server 1" and click finish. This opens a wizard to configure the DSN as follows.
image066
Assign the values as given while doing the installation of the OBI server.
image067
Choose relevant options. Make sure you provide the correct port number as available from the Configuration wizard details screen. (or saved file).
image068
Here you have the option to select the default subject area, language, and regional settings and database. Select appropriate values. Click finish to complete the creation of system DSN.
Administration Tool:
Open the administration tool from Start -> Oracle Business Intelligence Enterprise Edition Plus Client -> BI Administration
image069
Admin Toolimage070
Provide the details for
Repository Password: Admin123 (default - for sampleAppLite)
User: MARBI (Admin User)
Password: Admin pass
image071
Here we can see the Admin tool with online RPD for SampleAppLite.rpd.
Note: Please see the Client tools Document for the details regarding DSN changes that may need to be made for 64-bit systems and other client tool related topics.
This completes the installation of OBIEE 11G on Microsoft Windows 2003 X64 system.
****NOTE: you can install multiple OBIEE installs on a single server (into separate Oracle Homes). You just have to make sure the ports do not conflict and you have the appropriate OS resources (cpu/memory) and there are no port conflicts
Two ways to avoid port conflicts are:
Option1: Have env 1 running and when installing env 2 use autoport. It will detect used ports and increment
or option 2: use staticports.ini to manually configure ports


Additional Screenshots
ORACLE WEBLOGIC ADMIN CONSOLE
URL: http://venkat-62e03a94:7001/console
image072
image073



ORACLE BI Enterprise Manger
URL: http://Hostname:7001/em
image074



image075 

Ginekolog dr n. med. Piotr Siwek

Gabinet ginekologiczny specjalista ginekolog - położnik dr n. med. Piotr Siwek