Somebody will pat me , somebody will envy on me , somebody will congrats me , somebody will ignore me ….. That’s life ! From LinkedIn +200 Million members my profile viewed in top 1% list … ! Thanks LinkedIn for capturing every moments …
Below are the step by step guide to do clean start-up and shut-down of OBIEE 11g services. As we all know 11g is beast compared to its ancestor so we need to be careful doing the things in the right way.
Here I have demonstrated the steps how to do that in Linux/Unix platform and the idea is to kick-off below commands from the user having admin roles and in my case dba groups .This user is same I have used to do installation. If you have any other local user better to avoid it for services start-up as this could cause several locks into Java OPSS security files and will be causing problem to start Admin and Managed server of weblogic in bootstrap process.
In below steps I am running all the processes in nohup mode in background of unix session so that it will continue to run even if you have exit from the current running session.
1) Start-up Admin Server:
[orabi@obiappl11g-xxx ~]$ nohup sh /u00/app/MiddlewareHome/user_projects/domains/bifoundation_domain/bin/startWebLogic.sh -Dweblogic.management.username=weblogic -Dweblogic.management.password=xxx > wls_start.log &
Find the below lines in log files which will make sure clear start of Admin Server.
<Apr 28, 2014 10:05:56 PM CDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>
<Apr 28, 2014 10:05:56 PM CDT> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
2) Start-up Node Manager:
[orabi@obiappl11g-xxx ~]$ nohup sh /u00/app/MiddlewareHome/wlserver_10.3/server/bin/startNodeManager.sh > nodem_start.log &
Find the below lines in log files to confirm start-up:
<Apr 28, 2014 10:07:03 PM> <INFO> <Secure socket listener started on port 9556>
Apr 28, 2014 10:07:03 PM weblogic.nodemanager.server.SSLListener run
INFO: Secure socket listener started on port 9556
3) Start-up Managed Server:
[orabi@obiappl11g-xxx ~]$ nohup sh /u00/app/MiddlewareHome/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.sh bi_server1 http://obiappl11g-xxx:7001 > start_bi_server1.log &
Look for below lines in log files to confirm Managed Server start-up:
WebLogic Managed Server “bi_server1″ for domain “bifoundation_domain” running in Production Mode>
<Apr 28, 2014 10:53:14 PM CDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>
<Apr 28, 2014 10:53:14 PM CDT> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
Note: In above steps http://obiappl11g-xxx:7001 is my Admin URL where obiappl11g-xxx is server name.
Make sure you have added WLS_USER and WLS_PWD in below file before start-up so you don’t need to pass that in command line parameters:
You can start-up this from WLS Console or Fusion Middleware Control also.
4) Start OPMN managed services:
[orabi@obiappl11g-xxx ~]$ /u00/app/MiddlewareHome/instances/instance1/bin/opmnctl startall
enter and wait until command prompt comeback
Check the status:
[orabi@obiappl11g-xxx ~]$ /u00/app/MiddlewareHome/instances/instance1/bin/opmnctl status
It should be look like this:
Processes in Instance: instance1
ias-component | process-type | pid | status
coreapplication_obiccs1 | OracleBIClusterCo~ | 5467 | Alive
coreapplication_obisch1 | OracleBIScheduler~ | 5801 | Alive
coreapplication_obijh1 | OracleBIJavaHostC~ | 5465 | Alive
coreapplication_obips1 | OracleBIPresentat~ | 5463 | Alive
coreapplication_obis1 | OracleBIServerCom~ | 5464 | Alive
Now Voila…. After all services started up in good health :)
Note: You can see background processes from top -u serid> command:
[orabi@obiappl11g-xxx ~]$ top -u orabi
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5065 orabi 20 0 5983m 1.1g 42m S 1.0 2.3 2:20.89 java
7117 orabi 20 0 19452 1352 948 R 0.7 0.0 0:00.19 top
2643 orabi 20 0 6100m 1.2g 48m S 0.3 2.6 3:01.12 java
2841 orabi 20 0 2095m 129m 19m S 0.3 0.3 0:05.34 java
5464 orabi 20 0 4538m 121m 47m S 0.3 0.3 0:04.26 nqsserver
5465 orabi 20 0 3980m 232m 16m S 0.3 0.5 0:07.90 java
2448 orabi 20 0 105m 1936 1492 S 0.0 0.0 0:00.24 bash
2578 orabi 20 0 103m 1432 1120 S 0.0 0.0 0:00.03 sh
2809 orabi 20 0 103m 1364 1108 S 0.0 0.0 0:00.01 sh
5011 orabi 20 0 103m 1264 1092 S 0.0 0.0 0:00.00 sh
5012 orabi 20 0 103m 1436 1120 S 0.0 0.0 0:00.02 startWebLogic.s
5440 orabi 20 0 68328 8424 5900 S 0.0 0.0 0:00.00 opmn
5441 orabi 20 0 1757m 17m 10m S 0.0 0.0 0:06.68 opmn
5463 orabi 20 0 4172m 271m 72m S 0.0 0.6 0:03.49 sawserver
5467 orabi 20 0 1481m 24m 15m S 0.0 0.1 0:00.70 nqsclustercontr
5801 orabi 20 0 1909m 78m 51m S 0.0 0.2 0:01.66 nqscheduler
or else you can see them from running job list:
[orabi@obiappl11g-xxx ~]$ jobs
 Running nohup sh /u00/app/MiddlewareHome/user_projects/domains/bifoundation_domain/bin/startWebLogic.sh -Dweblogic.management.username=weblogic -Dweblogic.management.password=xxx> wls_start.log &
- Running nohup sh /u00/app/MiddlewareHome/wlserver_10.3/server/bin/startNodeManager.sh > nodem_start.log &
+ Running nohup sh /u00/app/MiddlewareHome/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.sh bi_server1 http://obiappl11g-t1.gain.tcprod.local:7001 > start_bi_server1.log &
Make sure you follow the same rule during shutdown…
Leave it for you guys to explore how to do that ;) :P
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
About 55,000 tourists visit Liechtenstein every year. This blog was viewed about 210,000 times in 2012. If it were Liechtenstein, it would take about 4 years for that many people to see it. Your blog had more visits than a small country in Europe!
OBIEE 11g upgrade has a lot of issues and among couple of them common is on Conditional Formatting . This emphasis that even if the Catalog upgrade is successful there are some of the problem still persists in XML conversion engine of the Upgrade Assistant(UA) leading though several catalog defects due to malformed XML . This is another example as my upgraded 11g charts failing to show its conditional formatting which is was working perfectly in 10g ….
Lets deep dive on whats the issue …
Below is the conditional format definition in 11g which is aligned with 10g:
So ideally it should show Chart bars (which is generated from Combined request Pivoted Graph) and see the below comparison:
To understand the reason of why 11g chart not showing the conditional format I went through the full XML from Advanced tab of 11g and find the below discrepancies:
This is malformed XML generated by UA during the upgrade of 10g code .If we look into 10g Advanced XML this is actually decimal but for some reason UA failed to put correct literal against it .
So the fix is replace all the instances of string “untypedLiteral” with “decimal’ like below:
Now after applying the XML the 11g chart output like :
And voila …. the problem is fixed … There could be another workaround to copy your 10g entire XML to 11g and yes it should work :) :)
Enjoy ..till next time…
I thought to post this thread long time back during 22.214.171.124 version but just waited for 11g new release .5 and upcoming edition assuming Oracle might include this demanding features soon and still surprised there is no OOB feature included while we are in .6 now.
I know the couple of fellow bloggers already tried that and everybody could have different approach . So lets put what I had experimented in last year in .3 release which is still valid in .6 . And this approach and implementation still valid in 10g.
Its simple to have column header freeze adding some scripting with embedded content . I took a simple dimension and simple fact to create one Tabular report and one Pivot report in two different tab where I have applied same logic but just want to show that the feature still feasible in both view.
So lets see how it will look like after Tabular column freeze (I would rather say it is kind of floating column header attributes)
Now I have scrolled at the right pane and watch the year attributes. Now you can see that the column header retains.
Now see the implementation:
I have added Text and Embedded content in the dashboard page:
The text properties(HTML Markup checked): I can’t put it like text for your copy paste as the tag is restricted to use in wordpress and sorry for that :( Hence click on the image to get the detail view.
Embedded Content URL:
So I have created a simple tabular report with the above columns and saved it under my folder and referred that in the URL .
That’s it and you are done …
Now if you try to implement the same, you will see some alignment issue and in that case you need to adjust the Width and height and other parameters of HTML content to get the cropped column list . Note that in above implementation I just remove my title view from report .
Though the above design has a lot of other restrictions (Downloading , Column sort ) but there could be possible workaround for that. At-least you can get something which is better than nothing. :D
Similar way I did it in Pivot view :
In this case my Embedded URL is different: (note the Viewname param at the end which only pull the compoundView2 which is my pivot table)
Refer this same URL under the HTML content defined in above image as Text HTML Markup properties.
Let the soul of the above approach rest in peace once Oracle implements this as OOB functionality in upcoming releases !!! :)
And we expect this to be sooner than later …. Catch you again ..till then ….
Since(Oct 2011) I had started working on OBIEE 11g (126.96.36.199) for four different projects in parallel to up-grade the 10g to 11g lot of challenges have been faced specially with the Catalog and Environment issues. (You can see the already reported RPD issues under: https://debaatobiee.wordpress.com/2012/01/26/obiee-11g-up-gradation-rpd-gotchas-and-glitches/ )
I could report all of them in below threads with the possible resolution but as I am writing this blog now (actually I am bit late posting this thread L ) some of them already taken care of in 188.8.131.52 version however not all and bit surprised that though Oracle agreed to release the patch in .6 version and file the bug report they didn’t work out yet on those mentioned issues reported during .5 up-grade.
Worth to see the link here for possible changes in BI reports due to new features before taking the assumption that it is a bug.
As par my latest up-gradation from 10g to 184.108.40.206 is concerned it went well but still some of the defects which are already noticed in .5 not fixed yet, some of them appeared new and some of them totally ridiculous and critical too as per business perspective and some of them not reported yet to Oracle and hence no relevant information found in Support.
I am happy to categorizing them into two different areas below: (I have used .5 and .6 interchangeably to mean 220.127.116.11 and 18.104.22.168)
Running prerequisite checks…
Prerequisite check “CheckActiveFilesAndExecutables” failed.
The details are:
Following files are active :
ApplySession failed during prerequisite checks: Prerequisite check “CheckActiveFilesAndExecutables” failed.
System intact, OPatch will not attempt to restore the system
OPatch failed with error code = 74
Resolution is to change the Privilege of “C:\Program Files\Oracle\Inventory” directory from read-only to Read-Write with Full-Control . However that was never documented in Oracle OPatch Readme.
“Exceeded configured maximum number of allowed input records” onclick=”SAWMoreInfo(event)
Error Codes: EKMT3FK5
Hello friends, after long time , I am again back on track … I was quite busy with couple of my mandatory schedules for last couple of weeks!
So today my topic is what are the Performance tuning key measures useful while doing report Performance testing. There are lots and I just tried to pull most of them and cover the highlights which would be very helpful while doing the Report Performance testing. Actually this could be separated across several areas like sometime it would be from DB perspective, sometime Environment parameters and sometime it would be the Repository design perspective. However the target objective is same but we need to work well to understand the performance bottleneck from which angles! This will definitely come with the experience and the different challenging environment and every places different rules needs to be applied.
<!– Remove from the cache everything older than N minutes –>
<!– AbsoluteMaxEntries is the enforced maximum number of entries. When this maximum is reached –>
<!– subsequent queries will fail until the maximum is no longer exceeded. –>
<!– CruiseEntries is amount of entries the OracleBI Presentation server tries to maintain in its cache. –>
<!– Forces the cache to attempt to remove an old entry when MaxEntries is exceeded. –>
<!– Cleanup this cache every N minutes. –>
•Bitmap Join Indexes
•Gathering Stats 30%