This Blog is personal and independent.It does not reflect the position or policy of Oracle. It is my "external memory", that helps me remember solutions I used and links I need. Nothing more.
Monday, April 12, 2021
20-April, Python in Oracle, Free webinar in Hebrew
Thursday, March 18, 2021
Oracle Analytics Server (OAS) 5.9 is available
Oracle Analytics Server (OAS) 5.9 is available here for both Windows and Linux. DON'T download the Oracle WebLogic Server 14c (14.1.1.0) that is the default for Weblogic. this is better link for Weblogic that includes the desired 12.2.1.4 here.
If not sure about Weblogic server, it might be easier to download from edelivery here and search "Oracle Analytics Server 5.9". Edelivery on the other hand does not include links to required patches, JDK and Client.
See the list of new features here and post here.
See the documentation here.
The installation guide is here.
The migration/upgrade guide is here.
And thanks to Christian Berg for being always alert.
Sunday, March 14, 2021
OAC and Catalog Manager Tool in Online mode with and without GUI
The Catalog Manager tool is part of the few client tools available since the first OBIEE days. It has 2 possible modes, online and offline. With the tool we can do things beyond the scope of the web based Catalog Manager. When working with OAC we have no physical access to the server and can only work with the online mode.
We can use the catalog manger in both GUI mode and command line mode.
To connect in GUI mode, select Online and copy the server name + /analytics-ws, like this
if you forget the analytics-ws suffix, the tool will remind you:
Now you can do lots of action, including fun staff like opening 2 catalog manager windows and doing copy paste from one to the other.
In non GUI modem we would usually like to use it to create archives of the catalog (in a script?). To see full details please refer to Oracle Support note OAC: How To Use The Catalog Manager Command Line To Archive A Catalog Object In Online Mode In An Oracle Analytics Cloud Instance (Doc ID 2599867.1) (thank You Tovit for referring me to it).
The short version is:
runcat.cmd -cmd archive -online "https://servername.analytics.ocp.oraclecloud.com/analytics-ws/saw.dll" -credentials "C:/output/credentials_file.txt" -folder "/shared" -forceOutputFile "C:/output/archive_file"
When the credentials_file.txt is in the format:
login=<usermane>
pwd=<password>
For additional options, the documentation or online help (runcat.cmd -help) should assist.
To see additional capabilities of Catalog Manager for OAC, see the ateam blog Using Catalog Manager with Oracle Analytics Cloud
Thursday, December 31, 2020
כנס עיצוב מערכות אנאליטיות, UX/UI design ב26 לינואר
נסיים את 2020 עם הפנים לשנה הבאה.
ב26 לינואר נקיים כנס (בזום) בנושא עיצוב מערכות אנאליטיות.
בכנס נדבר על המלצות מעשיות וכללים לעיצוב ממשקים. כמו כן נדבר על כללים לבחירת תצוגות ונעבור על מגוון דוגמאות.
בשל הנסיון לשלב כמות גדולה של חומר, הכנס יהיה ארוך מהרגיל וימשך מעל 3 שעות.
https://oracle.zoom.us/webinar/register/2816087961719/WN_f9UqTKjVRA26iaByLzQ0Ig
הכנס יכלול הדגמות בכלי אורקל, אך לא יתמקד בהן ומיועד לקהל הכללי.
עדכון: אם פספסתם את הכנס או רוצים לצפות בו שוב, ניתן לעשות זאת מהקישור הזה לערוץ בעברית של oracle cloud.
![]() |
| https://oracle.zoom.us/webinar/register/2816087961719/WN_f9UqTKjVRA26iaByLzQ0Ig |
For our worldwide audience - the lectures will be in Hebrew.



