My Oracle Fusion Middleware Experiments

Purpose This blog post is intended for all the Oracle Analytics Server Administrators, Developers, Data Model designers, DW architects. Prerequisites Installation of  Oracle Analytics Client Tools  5.5.0 on Windows 64bit Download the OAS Client Tool Step 1: Uncompress the downloaded zip file  OAS-5.5.0-bi_client-win64.zip use any unzip tool which runs on a Windows machine. Step 2 : Open a new CMD and 'Run as Administrator' enter the .exe file hit ENTER key C:\work\data>OAS-5.5.0-bi_client-win64.exe Step 3: Launches install wizard Wizard step 2 Wizard step 3 Wizard Step 4 Wizard Step 5 Wizard Step 6 (Development of RPD or online RPD connections required this configuraiton) Wizard Optional Step "Add" ODBC configuration Select "Oracle BI Server DSN Configuration" is specific to your Datasource to which you have target to use, stored as Data.Source.. (This step is must for Design Data Model and Develop new RPD files) Troubleshooting If you run the installer f...

Installing R and R Packages on OAS 5.5.0 The main objective of this post is to give step-by-step "Installing of R and R-Packages" in an Oracle Analytics Server (OAS) 5.5.0. Similar steps were followed earlier on OBIEE environments as well. Here I have the target installing platform is "Oracle Linux" same steps will work for all RHEL flavors. What is R? R is open-source programming language and it is specially designed as scripting environment for statistical computing and Visualization graphics. R programming evolving since 1994, as an alternative to SAS, SPSS, and other proprietary Statistical environments.  R Environments with a rich set of packages to enhance productivity in businesses such as :  Spatial Statistics  Financial Market analysis  Bioinformatics  Social Network analysis What is the purpose of this installation? In the data Analytics, there is huge scope for external Logical SQL functions such as "EVALUATE_SCRIPT", "FORECAST...

Namaste!! Welcome back to My Oracle Fusion Middleware Experiments blog. This post is for Novice OAS domain users, who just started working on the OAS domain. You might face this issue when you have an OAS domain running which was configured by someone and you have newly joined the team, and due to some reason the Linux box rebooted!  Contents Introduction Prerequisites/Assumptions Control Flow Start, Stop, and Status of BI server Alternate Options Checking Status Troubleshooting: status STARTING forever Check WebLogic Server PID, JAVA_OPTION Summary Introduction OAS (Oracle Analytics Services) Domain is a WebLogic domain, that consists of AdminServer and bi_server as managed server which associated with five Business Intelligence (BI) components (OBIPS, OBIJH, OBICCS, OBISCH, OBIS). Arrangement of the components are shown in the image below.  Prerequisites/Assumptions Oracle Analytics Server installed or OBIEE (legacy) Connected database up and running Control Flow Starting an...