Log files Location/directory in OBIEE 12c / OAS

OBIEE 12c Log Locations:

First We should know our fusion middleware home or oracle BI Home directory location and then search in the relevant folder/directory for logs.

• AdminServer logs – <FMW_HOME>/user_projects/domains/bi/servers/AdminServer/logs
• bi_server1 logs – <FMW_HOME>/user_projects/domains/bi/servers/bi_server1/logs
• Presentation Server logs – <FMW_HOME>/user_projects/domains/bi/servers/obips1/logs
• JavaHost logs – <FMW_HOME>/user_projects/domains/bi/servers/obijh1/logs
• Cluster Components logs – <FMW_HOME>/user_projects/domains/bi/servers/obiccs1/logs
• Scheduler Server logs – <FMW_HOME>/user_projects/domains/bi/servers/obisch1/logs

If it is 2 Node Servers, then 

Presentation Server logs 2nd Node – <FMW_HOME>/user_projects/domains/bi/servers/obips2/logs

Scheduler Server logs For 2nd Node– <FMW_HOME>/user_projects/domains/bi/servers/obisch2/logs

OBIEE 11g Locations:

• Upgrade logs – Middleware\Oracle_BI1\upgrade\logs
• Admin Server logs – <FMW_HOME>\user_projects\domains\bifoundation_domain\servers\AdminServer\logs
• Managed Server logs – <FMW_HOME>\user_projects\domains\bifoundation_domain\servers\bi_server1\logs
• BI Server logs – <FMW_HOME>\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1
• Presentation Server logs – <FMW_HOME>\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1

Cheers!

Bose

[nQSError: 13042] Repository password is wrong in OBIEE 12c

Issue;

On Oracle Business Intelligence Enterprise Edition (OBIEE) 12c, Below error occurs while uploading RPD in OBIEE 12c environment, even though RPD password is correct and can be opened with same password in offline mode.

[nQSError: 13042] Repository password is wrong

Issue 1. After uploading the RPD, if we download and try to open offline, we will get the same issue of 'Repository Password is Wrong'

Issue 2. If we are validating with validaterpd.sh command then also, we will get the same issue and will not be able to open the RPD.

Issue 3. obieerpdpwdchange utility also would not help in resetting or opening the rpd.

Issue 4. We would be able to open the RPD online but the same wouldnot be able to open if we download and try to open offline.

(Doc ID 2721582.1)

After uploading new rpd, Unable to open a downloaded rpd in offline mode in admin client tool

"Logon Failed" message is displayed and following error shown in the admin log:

----NQSAdminTool.log -------------------------

[OBIS] [NOTIFICATION:1] Opening call for File=C:\xxx\xxx\xxx.rpd, LogicalName: OfflineRepository
[OBIS] [ERROR:1] [tid: xxx]  [nQSError: 13042] Repository password is wrong. [[
file: server\objectmodel\Src\SOPersistRp.cpp; line: 672

Cause:

This issue is due to known internal Bug: Bug 29376866 - RFA : WRONG PASSWORD ERROR IN ADMIN TOOL AFTER DOWNLOADRPD

SOLUTION:

Follow the steps to fix the issue:

Step1: Open the RPD in online Mode and save the RPD suing copy as option to have working repository copy.

Step 2: Login to EM->Weblogic Domain->Security->Credentials->oracle.bi.enterprise->metadata.encryption->Edit->password =>update the same password.

Step 3: Upload the working version of RPD and then Download.

Step 3: Try opening the RPD in offline mode.

Cheers! Bose

Installing JDK-8u271in Windows

 Here is step by step by Guide for JDK Version 271. Download JDK from This Link

jdk-8u271-windows-x64.exe file will be downloaded. Just double click the download .exe file to start the Java Installation. When It prompt for permission, just click 'Allow' to start the installation.

Installer will start the Installation with the below screen. Just Click 'Next'

Installer is preparing the installation

Here is the actual first step of Installation starts.  If you are having your own directory to install Java then click 'Change' and choose the directory. Otherwise Just click 'Next'

Then JDK 8 installation is extracting to install

With the below screen, Again you could change the destination folder where Java should be installed. If you do not want to change the default folder, then Just click 'Next'

Installer window will progress and took few few minutes to complete the installation.

Once It is installed successfully, screen will prompt the below screen. Just click 'Close' to complete the installation.

You can confirm the version installed in our windows by running the "java -version" in command prompt.

Cheers!

Bose

OAS (Oracle Analytics Server) and OAC - The Next Gen OBIEE is Here

After OBIEE 12c release, Oracle is keenly looking for cloud solutions and released OAS and OAC.

OAS is more like a in-place installation OBIEE Version which is available for download and can be installed in in-place servers or cloud server.

Otherwise, We could go for Oracle based Cloud version (OAC) of OBIEE.

Here is you can download OAS:

https://www.oracle.com/solutions/business-analytics/analytics-server/analytics-server.html

Step by step guide by Rittman-Mead:

https://www.rittmanmead.com/blog/2020/02/oracle-analytics-server-step-by-step-installation/

Here is a Oracle Blog for OAS Installation;

https://docs.oracle.com/en/middleware/bi/analytics-server/install-config-oas/installing-product-software.html#GUID-D5AFD830-8A7D-42CC-8C22-CE68C452CF4A

Oracle Business Intelligence Applications (OBIA) 11.1.1.10.3 is available for Download

Oracle has released the latest version of OBIA - Oracle Business Intelligence (BI) Applications 11.1.1.10.3.

What's New:

BI Applications with OBIEE 12c

ODI 12c

Look Oracle Blog Here for More Details

Upgrade Overview

Cheers!

Bose

Oracle Database 12c Step by Step Installation in Windows.

With this post, I am sharing oracle database 12c Release 2 installation in windows. I have downloaded Oracle Database 12c software which is around 2.8GB from oracle Site.

File Name: winx64_12201_database

Extract the software zip file and go to the extracted folder and double click on setup.exe file to start the DB installation.

Oracle Universal Installer checks the system prerequisite and will start the installation window. 

Uncheck 'My oracle Support' and click 'Next'

When it prompts the below window, Click 'Yes'

Select 'Create and configure a database' and click 'Next'

I have selected 'Server class' and clicked 'Next'.

Since I want to check all the feature of this database 12c, I installed with 'Server Class'. We could go with 'Desktop Class' which is light and easy. Server class is heavy and takes 6 GB disk space.

Select 'Single instance database installation' and click 'Next'

Select 'Typical Install' and click 'Next'

Select the Oracle Base folder if you have your folder to install Oracle DB 12c. I have 'DB12c' in D drive. If we select the base path, all the other path will be loaded automatically.

In this step, enter database password and remember it.

Check 'Create as container Database' and Keep pluggable DB. because pluggable DB is required for all our RCU installation required for OBIEE later.

Finally Click 'Next'

Installer will run the prerequisite checks..

With this step, We could save the response file which could be used to silent install for other environments.

Click 'Install'

It would take some time to complete the installation. 

Oracle DB installation is in progress....

Oracle DB 12c is successfully installed. Just click 'Close' to complete the installation.

Now check all the services and connect to DB. Ready to rock an roll :)

Cheers! Bose

Automating the BAR Backup in a script file in OBIEE 12c

Following script will be put into exportarchive.sh files and added to the cronjob in linux server to run and export archive file everyday for backup.

exportarchive.sh

================================================

#!/bin/bash

folderName= `date +%Y%m%d`

export SCRIPT_PATH=/obiee12c/scripts

export DOMAIN_PATH=/obiee12c/user_projects/domains/bi/bitools/bin

export EXPORT_DIR=/obishare/barbackup/migration

MAIL_TO=bose.obiee@gmail.com,xyz@gmail.com,abc@gmail.com

#MAIL_TO=bose.obiee@gmail.com,xyz@gmail.com,abc@gmail.com

mkdir -p $EXPORT_DIR/$folderName

echo "Running the export archive script"

echo "Exporting............................."

$DOMAIN_PATH/exportarchive.sh ssi $EXPORT_DIR/$folderName encryptionpassword=admin123 >> $EXPORT_DIR/$folderName/export.log

SUCCESS_COUNT=`grep "Export archive completed successfully" $EXPORT_DIR/$folderName/export.log | wc -l`

if  [ "${SUCCESS_COUNT}" -eq "l" ]

then

echo -e "Hi Team, \nThe export of BAR in `hostname` is completed and the export is available in ${EXPORT_DIR} \n\nThanks" | mail -s "BAR export is completed successfully in `hostname`" ${MAIL_TO}

else

echo -e "Hi Team, \nThe export of BAR in `hostname` is  not completed and the export log is available in ${EXPORT_DIR} \n\nThanks" | mail -s "BAR export has failed in `hostname`" ${MAIL_TO} -a $EXPORT_DIR/$folderName/export.log  ${MAIL_TO}

exit

fi

#Cleaning BAR files which are older than 7 days

find ${EXPORT_DIR} -name "20*" -type d  -mtime +7 -exec rm rf  {} \;

==========================================