Weblogic -- BI Publisher 12.2.1.3 -- Error running config.sh - java.lang.IllegalArgumentException: ONS configuration failed / oracle.ons.NoServersAvailable: Subscription time out

I want to share a solution for a problem that was recently encountered  in one of our client environments.

The problem was on config.sh.. That is, config.sh was encountering ONS errors.. This was a fresh install and it wasn't expected to be that challenging.

Anyways there were multiple errors recorded in the flow.. 

The first one was ;

oracle.ons.NoServersAvailable: Subscription time out -> 

 java.lang.IllegalArgumentException: ONS configuration failed

BARMedataPlugin related errors were following it;

problem encountered when cleaning up SI using plugin: 

oracle.bi.servicelcm.metadata.BARMetadataPlugin[[java.lang.NullPointerException at sun.nio.fs.UnixFileSystem.getPath(UnixFileSystem.java:272)

UnixFileSystem.getPath and UnixFileSystem.java were foundational. I checked their source code.. But! these were the results actually.

So the config.sh encountered a problem related with the ONS and then it understood that it has failed but continued and tried to clean the mess but can't find the mess / a specific file that it expected to be present in the filesystem.. Probably.. So that error in UnixFileSystem.java was a result of that. 

I like interpreting the logs this way :) They tell me the story  when I read them correctly :) They also give me the execution flow, so that I can guess the internal parts of the execution.

Anyways, I was already familiar with that ONS problem, so I revisited one my earlier posts ->  https://ermanarslan.blogspot.com/2017/09/problem-installing-oracle-fusion.html

I tried that workround documented in that post.. (After all It saved my day earlier..)

The workaround for this was, to supply an argument in the config_internal.sh. (config.sh indirectly executes config_internal.sh) -> oracle.jdbc.fanEnabled=false

However; suprisingly this time it didn't work.. config.sh was still getting those ONS errors in the next runs.

So this time I implemented a fix and here I 'am writing this blog post for it..

The fix was a patch actually..

Patch 26045997: ENABLING DRIVER FAN WITHOUT RUNNING ONS DAEMONS CAUSES CONNECT REQUEST ERROR

So, we applied it to the WLS and then run config.sh without a problem..

Ofcourse these things are based on the DB layer configuration and if that ONS configuration was compatible with the expectations of config.sh, we wouldn't get any errors in the first place.. 

Continuing the life without ONS configuration have some disadvantages, but as far as I see, in most of the clients they are acceptable.. So that patch is the key to save the day :)

Stay tuned..

GTECH -- Summer School 2021 -- Oracle Database & Cloud & Big Data & EBS - Training For Newly Graduates!

Favorite days for my trainer mode :) a quick but efficient training for new engineers who are interested in our subjects. Summer School 2021-- Oracle Database & Cloud & Big Data & EBS - Training For Newly Graduates!

Once in a year, we as GTech provide training for newly graduated engineers.

In this training, we teach Sql, PL/SQL, Oracle Database & Cloud, EBS, OBIEE, BigData, ETL and more.

This year was the fourth time, that I was the lecturer for "Database and Cloud".

See the following blog posts for 2020, 2019 and 2018 Summer Schools ->

https://ermanarslan.blogspot.com/2020/08/gtech-summer-school-2020-oracle.html
https://ermanarslan.blogspot.com/2019/07/gtech-summer-school-2019-oracle.html
https://ermanarslan.blogspot.com/2018/07/summer-school-introduction-to-oracle.html

As usual, the students of the class were so curios about databases and actually Oracle in general..

I tried to shed a light on the important topics like Oracle Database Server Architecture, Oracle Database Process Architecture, background processes, High availability configurations, Cloud Computing (Oracle Cloud Infrastructure + Google Cloud Platform /GCP) , Big Data, NoSQL databases and so on..

The list of topics covered in the training was as follows;

• Introduction to RDBMS
• Introduction to Oracle
• Architecture (Oracle)
• Installation (Oracle) & workshop
• DBA role & DBA tools
• Cloud Computing
• Big Data & NoSQL
• APPS DBA role & EBS System Administration (EBS 12.2)

Speaking at Google-IDC Webinar / Database Modernization -- Google Cloud, Oracle BMS, Cloud SQL , Spanner and more

Speaking at the event, IDC - Google. My topic will be about Database Modernization.
I will explain running Oracle Databases on GCP - Bare Metal, Cloud SQL(Postgresql, MS SQL and MYSQL) and some Google specific database solutions like Spanner.
I will give the motivation and the need for database modernization and will look to the process of obtaining a modern database environment and put some light on the benefits of it.
The event is in Turkey and the presetation will be in Turkish. If you want to join, we will happy to see you among us in the event. Stay tuned!

Registration Link:

--Webinar'a kayıt olmak isteyen arkadaşlar için kayıt linkini aşağıda paylaşıyorum:

https://www.idc.com/mea/events/69019-gercek-zamanl-analitik-ile-bugunden-gelecegi-yaratmak