2. Upload the zip file with the patch p28609078 , unzip it and change directory to 28609078
In this directory, you can find the readme.txt, where all steps are described.
You have to check that OPatch version to be 220.127.116.11.2 or higher.
3. As pre-patch step you have to stop the running servers from the admin console of the WebLogic. Log to the WebLogic Administration Console and stop the managed server and AdminServer. http://IP.Address:Port/console
4. After all of the above is checked and prepared, we can proceed with applying the patch:
Oracle Interim Patch Installer version 18.104.22.168.3 Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/BIPublisher11g/Oracle_BI1 Central Inventory : /opt/oracle/oraInventory from : /opt/oracle/BIPublisher11g/Oracle_BI1/oraInst.loc OPatch version : 22.214.171.124.3 OUI version : 126.96.36.199.0 Log file location : /opt/oracle/BIPublisher11g/Oracle_BI1/cfgtoollogs/opatch/28609078_Nov_09_2018_07_42_42/apply2018-11-09_07-42-42AM_1.log
OPatch detects the Middleware Home as "/opt/oracle/BIPublisher11g"
Applying interim patch '28609078' to OH '/opt/oracle/BIPublisher11g/Oracle_BI1' Verifying environment and performing prerequisite checks... All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/opt/oracle/BIPublisher11g/Oracle_BI1')
Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files...
Now we can log in to the Administration Console http://IP.Address:Port/console and start from there Managed Node. After starting Managed Server we can see the below error in the log file of bipublisher.log which is located here:
This error is related to missing permissions in System Policies. You can accesshttp://IP.Address:Port/xmlpserver but you are not able to open reports. In order to fix this issue, you have to log in to the Enterprise Manager: http://IP.Address:Port/em Right click on the domain which in our case is bifoundation_domain -> Security -> System Policies
On type choose Codebase, Name -> Includes -> bipublisher -> search. Then click on create or create like from one of the existing and add:
When you mark the file that just created below you will find the window below with Permission for Codebase. For all of the Resource Names, the Permission Actions should be with * for all. Only the last one can be set to read as it is shown on the above picture. You can make that changes when click on the codebase that you have just added and click on edit.
When the changes are applied you can have problems with accessing http://IP.Address:Port/xmlpserver/servlet/catalog or http://IP.Address:Port/xmlpserver/servlet/admin
The problem might be related with browser caching, so you have to clear your browser cached data and try to open it again. The issue will be fixed.
I can give you another hint if you cannot log in or access xmlpserver is to remove tmp anc cache folders from the OS which are located here:
hmm, this is totally different post, its look like that to be Oracle DBA is not only database but as well other challenges like Oracle BI :)
This is very useful post due to the fact that in order to consider adding here you maybe you have spend a lot of time.
this is great for the community
#Oracle #OracleBI #BI #DBA