My Oracle Fusion Middleware Experiments

Namaste!! Welcome to 'My   OFMW   Experiments' blog!, Here in this post, I would like to explore more deeper about CLI tools available on Bi platform.  Earlier in OBIEE there were multiple catalog files together can be deployed with BAR files. Now in OAS we have to use runcat.sh or runct.cmd script. that is present in the BI domain/bitools/bin directory. Deploying Web Catalog on OBIEE/OAS domain Help of runcat command The following is the OBIEE 12.2.1.4 Environment with the -help options. # Command : -help Catalog Manager understands commands in the following areas: Development To Production createFolder Creates folder in the catalog delete Deletes the given path from the catalog maintenanceMode Puts the catalog into or out of Maintenance Mode (aka ReadOnly) rehash Rehashes /users in the catalog rename Renames an item in the catalog report Generates a report on the conten...

You are not alone if you feel so this post is for you. Many people don't have time or experstis That's why we started in first place. Typical understanding on the WLST/python coding I started exploring on that same idea to configure the OAS domain. But the OAS is much more sofisticated and provides you silent mode option and also once you complete the configuration of OAS domain all our OAS services will be started automatically.  Note that Vagrant based Oracle Linux installed Oracle VirtualBoxes are hosting Database and OAS. The system prerequisites ignore options that don't solve the LD_LIBRARY_PATH missing libraries. Since it is a simpler model I took couple of trials on the same VM. Learnings with different experiments:  JDK installed with tar.gz file gives raise to LD_LIBRARY_PATH issues unresolved even though error-out libraries installed in the same OL7 repo. Another issue encountered while starting the bi_server1 ( Managed server on the OASDomain ) Let's get s...

Namaste!! Welcome to My  " OFMW Experiments" blog! In this COVID-19 Pandemic, (the Year 2020)critical time keeping myself busy in the new learnings and that too helpful in my workplace as well, here I've chosen topics as  'Oracle Analytics Server' (OAS) administering - RPD deployment.  The  following diagram developed to understand the process of the Oracle Data Modeler,  how it works on the BI platforms (OAS/OBIEE ) or on the OAC Cloud service as well. How RPD works on Oracle BI Platforms In this post would like to share the learning experiments which you can do as lab exercise as given examples. Uploading RPD files to BI platform Listing Connection pool of an RPD Update Connection pool of an existing RPD Download RPD File from existing BI server let's start working on these  Upload RPD Files This task is common for Oracle BI servers and Oracle Analytics services ./datamodel.sh u...

Namste!!! 🙏Welcome to My FMW Experiments blog!!! This is the "Learning OracleAnalyticsServer Administering series -3". If you are first time visitor please have a look on the series posts: Oracle Database 19c Install & Configure on Vagrant VirtualBox Oracle Analytics Server Silent mode Installation In this post, I would like to share the run RCU against Oracle Analytics Server. The creation of a Repository using rcu utility made much flexible and easier than ever before. Generally, the rcu works in two options GUI mode and command line silent mode. Automations required the second option that is the silent mode, Prerequisites Oracle Database (19c used in this experiemnt) SYSDBA Role user created to run the RCU Assumption: Oracle database is started and ready to use, that is service which is used for this experiment is PDB that is ON status. 1. Creating OAS Repositories a. Create a DB User for OAS RCU execution Creation of DBA user t...

Namaste !! dear MyOFMWExperiments followers and new fans warm welcome!!! Here I came with a new Oracle product which I've explored very recently and it is too good. Earlier with 12c product list, it was OBIEE that is specially designed for Business Intelligence. Now the latest trending BI tool from Oracle is Oracle Analytics Server. In this post, we will be learning about step by step process for Installing Oracle Analytics Server 5.5 on an Oracle Linux box. My always favorite composition of Vagrantfile to bring up 'Oracle Linux 7'. The same steps will work on all Linux favors. Prerequisites > Install Oracle VM VirtualBox > Install Vagrant Regular download and install them if you don't have on your system. Assumption:  You can have Oracle Linux 7 VM or Docker container or Vagrant Oracle Linux/7 Box is up and running. What we do in this experiment? 1. Install JDK 8 (latest stable version) 2. Silent Install FMW Infrastructure 12.2.1.4.0 3. OPatch installation...