LPAR stands for Logical Partitioning and it's a feature of IBM's operating system AIX (Also available in Linux). By abstracting all the physical devices in a system, LPAR creates a virtualized computing environment.
In a server; the processor, memory, and storage are divided into multiple sets. Each set in a server consist of resources like processor, memory and storage. Each set is called as LPAR.
One server can have many LPARs operating at the same time. These LPARs communicate with each other as if they are on separate machines.
What is DLPAR?
DLPAR stands for Dynamic Logical Partitioning and with DLPAR the LPARs can be configured dynamically without restart. With DLPAR, memory, CPU and storage can be moved between LPARs on the fly.
What is HMC?
HMC stands for Hardware Management Console. The Hardware Management Console (HMC) is interface which is used to manage the LPARs. Its Java based and can be used to manage many systems.
If LPAR is in shared processor mode, without the following fix, LPAR may see excessive CPu usage:
APARs for WAITPROC IDLE LOOPING CONSUMES CPU:
IV01111 AIX 6.1 TL05 if before SP08 (fixed in SP08)
IV06197 AIX 6.1 TL06 if before SP07 (fixed in SP07)
IV10172 AIX 6.1 TL07 if before SP02 (fixed in SP02)
IV09133 AIX 7.1 TL00 if before SP05 (fixed in SP05)
IV10484 AIX 7.1 TL01 if before SP02 (fixed in SP02)
This problem can effect POWER7 systems running any level of Ax720 firmware prior to Ax720_101. But it is recommended to update to the latest available firmware. If required, AIX and Firmware fixes can be obtained from IBM Support Fix Central:
It is the best antidote to advertising you will ever find.
In their May 2015 issue, they analyze the "perils of pesticides" and offer a guide to fruits and vegetables. When you should buy organic? When might conventional be OK for you?
[or, as CR puts it, "Though we believe that organic is always the best choice because it promotes sustainable agriculture, getting plenty of fruits and vegetables - even if you can't obtain organic - takes precedence when it comes to your health.]
Here are the most important findings:
ALWAYS BUY ORGANIC
CR found that for these fruits and vegetables, you should always buy organic - the pesticide risk in conventional is too high.
Sweet Bell Peppers
Make sure all the recommended patches are in place as a part of the bundle patch. Your EBS 12.2 ADOP cycle could go unstable with out the database patches.
Mostly I've had it fairly easy in my career. When I worked in the UK, I just had the one time zone to work with. The only time things got complicated was when I was working at one of the power generation companies, and we had to make provision for the 23-hour and 25-hour days that go with Daylight Savings.
And in Australia we only have a handful of timezones, and when I start and finish work, it is the same day for any part of Australia. I did work on one system where the database clock was set to UTC, but dates weren't important on that application.
Now it is different. I'm dealing with events that happen all over the world. Again the database clock is UTC, with the odd effect that TRUNC(SYSDATE) 'flips over' around lunchtime. Now when I want to look at 'recent' entries (eg a log table) I've got into the habit of asking WHERE LOG_DATE > SYSDATE - INTERVAL '9' HOUR
And we also have columns that are TIMESTAMP WITH TIMEZONE. So I'm getting into the habit of selecting COL_TS AT TIME ZONE DBTIMEZONE . I could use sessiontimezone, but then the time component of DATE columns would be inconsistent. This becomes just a little more confusing this time of year as various places slip in and out of Daylight Savings.
Now things are getting even more complicated for me.
Again, during my career, I've been lucky enough to be pretty oblivious to character set issues. Most things have squeezed in to my databases without any significant trouble. Occasionally I've had to look for some accented characters in people's names, but that's been it.
In the past few months, I've been working with some European data where the issues have been more pronounced. Aside from a few issues in emails, I've been coping quite well (with a lot of help from Google Translate).
Now I get to work with some Japanese data. And things get complicated.
"The modern Japanese writing system is a combination of two character types: logographic kanji, which are adopted Chinese characters, and syllabic kana. Kana itself consists of a pair of syllabaries: hiragana, used for native or naturalised Japanese words and grammatical elements, and katakana, used for foreign words and names, loanwords, onomatopoeia, scientific names, and sometimes for emphasis. Almost all Japanese sentences contain a mixture of kanji and kana. Because of this mixture of scripts, in addition to a large inventory of kanji characters, the Japanese writing system is often considered to be the most complicated in use anywhere in the world."Japanese writing system
Firstly I hit katakana. With some tables, I can get syllables corresponding to the characters and work out something that I can eyeball and match up to some English data. As an extra complication, there are also half-width characters which are semantically equivalent but occupy different codepoints in Unicode. That has parallels to upper/lower case in English, but is a modern development that came about from trying to fit the previously squarish forms into print, typewriters and computer screens.
Kanji is a different order of shock. Primary school children in Japan learn the first 1000 or so characters. Another thousand plus get taught in high school. The character set is significantly larger in total.
I will have to see if the next few months cause my head to explode. In the mean time, I can recommend reading this article about the politics involved in getting characters (glyphs ? letters ?) into Unicode. I Can Text You A Pile of Poo, But I Can’t Write My Name
Oh, and I'm still trying to find the most useful character/font set I can have on my PC and use practically in SQL Developer. My current choice shows the Japanese characters when I click in the field in the dataset, but only little rectangles when I'm not in the field. The only one I've found that does show up all the time is really UGLY.
You are running adoafmctl.sh version 120.6.12000000.3
Starting OPMN managed OAFM OC4J instance ...
adoafmctl.sh: exiting with status 152
adoafmctl.sh: check the logfile
$INST_TOP/logs/appl/admin/log/adoafmctl.txt for more information
--> Process (index=1,uid=349189076,pid=15039)
time out while waiting for a managed process to start
07/31/09-09:14:28 :: adoafmctl.sh: exiting with status 152
07/31/09-09:14:40 :: adoafmctl.sh version 120.6.12000000.3
07/31/09-09:14:40 :: adoafmctl.sh: Checking the status of OPMN managed OAFM OC4J instance
Processes in Instance: SID_machine.machine.domain
ias-component | process-type | pid | status
default_group | oafm | N/A | Down
# ps -ef | grep
If one finds any, kill these processes.
# ls -lrt .opmndat
# rm .opmndat
5. Re-test the issue.
I think that the process of building a data mining scoring engine is similar to develop an application.
We have the requirement analysis, functional design, technical design, coding, testing, deployment, etc. phases.
By Debra Lilley, guest contributor
Debra Lilley (@debralilley), Oracle ACE Director and Vice President of Certus Cloud Services at Certus Solutions, offers her reflections on the PaaS4SaaS workshop that took place in January 2015 in London*.
I know this posting is a bit late, but at the end of January I took part in a proof of concept workshop for PaaS4SaaS, and it’s been a rollercoaster ride ever since.
When I was thinking about moving to Certus, one of the things that attracted me was their intent to write extensions for Oracle Cloud Applications using the just announced PaaS4SaaS solution.
I attended Oracle Open World with an open mind and tried to learn as much as I could about the solutions. The Larry Ellison (Oracle Executive Chairman and Chief Technology Officer) demo was really impressive but then Oracle has always been a brilliant marketing company.
I came back to the UK and set about validating what was available, some of the components Database and Java Cloud had been available for a while but I wanted or would want to also use the Process and Integration Cloud offerings.
As regular readers of my blog will know, I am an Oracle Applications User Experience advocate and am very committed to the user experience work that goes into Oracle Cloud Applications. Extensions delivered by Certus will have this same user experience, and I made this video on behalf of Certus.
Click here to watch Debra's YouTube video.
The user experience team has been given funding by Thomas Kurian, Oracle President, Product Development, who is personally committed to making PaaS4SaaS work, to carry out a number of proof of concept workshops with Oracle partners. The Oracle Applications UX team asked Certus to be part of this. Certus has not been a development company, and so in the same way customers come to us because we are the best at implementing cloud applications, we looked for a partner to help us with development. We selected eProseed who have the same commitment to UX as we do.
The workshop took place in London at the end of January with four people from each of Oracle Applications UX, eProseed, and Certus taking part. We worked through a use case taken from an existing application from one of our customers who is considering modernizing this and moving it to the cloud. In three days we were able to build a working application and prove to ourselves that when the customer says “go,” we will be able to deliver what they need.
Oracle Applications UX team have in their blog already covered the workshop and I have also written about it in the Oracle Fusion Middleware blog I am a guest author for. The following month I took part in the Partner SOA Community Forum in Budapest when we had the opportunity to work with product management teams of both the Process and Integration Cloud offerings and further validate our approach, understanding the possibilities and the constraints. The Oracle Applications UX team also had a stand there.
Lonneke Dikmans (@lonnekedikmans) Managing Partner eProseed Nederland and Debra Lilley of Certus Solutions
I was very pleased on behalf of both Certus and eProseed to accept the first Community Cloud award. These awards are a bit like the Oscars and awarded to individuals Lonneke Dikmans from eProseed and myself, however we had a similar thank you to all those involved in our acceptance speech.
The Community Leader Jürgen Kress (@soacommunity) said:
“I awarded my first SOA Community Outstanding Contribution for Cloud to Debra Lilley of Certus Solutions and Lonneke Dikmans of eProseed because they not only took on board the messaging of PaaS4SaaS from the last Oracle Open World, but also their collaboration between an Applications partner and a Middleware partner, sought out answers and training and with Oracle Development giving feedback and validating their approach in this area. All good things but bringing that back to the community and sharing is the outstanding contribution.”
I have written a White Paper, which will be published for Collaborate in a few weeks and Certus along with Oracle Applications UX will be presenting this twice both for OAUG and Quest. I’ve also had an article published in this month’s Profit Magazine.
Thank you to the Oracle Applications UX team and the SOA Community. I’m still not technical enough to do this but I am technical enough to understand that PaaS4SaaS is a game changer and will continue to be seeing more and more in our community.
* This article was originally published here.
Since then, I tried to get information on this topic. After a few emails I got the info I needed.
I hope that this cools down the rumor mill a little bit.
Es sind noch ein paar Plätze frei - sollten Sie also Lust und Zeit haben, nach Berlin zu kommen und exklusives Wissen (nicht nur) über das Parallel Execution Feature der Oracle Datenbank zu erfahren, würde ich mich sehr freuen, Sie dort mit den anderen Teilnehmern begrüßen zu dürfen, um gemeinsam mit Ihnen eine gute und produktive Zeit zu verbringen!
Bei Interesse wenden Sie sich bitte an die Ansprechpartner der DOAG, die im Link angegeben sind - dort finden Sie auch eine genauere Beschreibung des Seminars.
Most of the time it's enough with SendMaster, but today I came through a problem that required an alternative. While testing an XML message with this tool against an HTTPS PeopleSoft installation, I got the following error message:
Error communicating with server: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
After checking in My Oracle Support, I've found the following resolution (doc 1634045.1):
1) Import the appropriate SSL certificate to the java kestore PS_HOME\jre\lib\security\cacerts or Integration Broker's keystore location i.e pskey file
2) Set sendmaster's preferences ( via File-Preferences-HTTP tab ) to point to the keystore with the appropriate SSL certificate
Unfortunately, I didn't have access to the appropriate SSL certificate, so I've decided to use curl, a pretty old (dating back to 1997 according to all knowing wikipedia) but still useful command line tool.
curl is a command line tool that can be used to test HTTP and HTTPS operations, including GET, PUT, POST and so on. One of the features of this tool is that it can run in "insecure" mode, eliminating the need of a client certificate to test URLs on HTTPS. Both in Linux and Mac OS, the option to run in insecure mode is -k. The command line to test my service operation then looked like:
curl -X POST -d @test.xml -k https://<server>/PSIGW/HttpListeningConnector
Please note that the @ option actually requests curl to take the data from the file following it. Instead of doing so, you can specify the data in the command line, but it is a bit more cumbersome.
Also, keep in mind that curl is not delivered with Windows out of the box, but you can download similar tools from several sources (for instance, this one).
I had a great time at APEX World in Rotterdam, it was a wonderful event. I could meet up with my friends and learn a few new tricks, too :).
Here are the slides from my presentation about the many smaller new features of Oracle APEX 5.0. And I could only cram like half of the good stuff that I found into this 45 min. session.
About 70 people attended the session and I sure hope they will use some of the features I presented.
Once I clean up my demo application, I will make it available, too.
Unfortunately, during the process, one rules package delivered in the Tax Update was not included within the Change Assistant steps, and therefore it was missed. Some days after, we reported the error to Oracle and they pointed out to the original zip file containing the PeopleSoft Release Patchset, which indeed contained the missing package.
We did not want to repeat the entire Change Package definition steps, as it would have required to restore a couple of backups. Instead, we decided to manually apply the rules package.
Not so fast...Unfortunately, within Update Manager the Rules Packages are not delivered in the usual format used to import, compare and copy them. Instead, specific steps are followed when Update Manager is used.
In the end, we managed to find a way to manually import the package, which is documented below.
Importing the Rules PackageThe rules packages in Update Manager are delivered using the Data Migration Workbench. The process to import them starts by defining the directories from which the Data Migration projects should be picked:
PeopleTools > Lifecycle Tools > Migrate Data > Manage File Locations
HP Mini T210 3F0 boot failure and System Rollback Data disk space issues with Roxio BackOnTrack / aswrvt.sys
If you have an HP Mini 210 or 100 and have had issues with disk running out of space, failures to boot, I feel for you. After a heap of hassle, I sorted my out problems without having to reinstall Windows, and so I'm sharing my experiences as I found many many people with the same issue, but no central resolution. The issues I've had are as follows
- Failure to boot: 3F0 Harddisk does not exist
- Running out of space (see Roxio BackOnTrack)
- Black screen after attempting to uninstall Roxio BackOnTrack
IF you get a failure to startup, screen with 3F0 Harddisk does not exist:
- To access the BIOS, turn on the computer and immediately press the esc key to display the Startup Menu, and then press the F10 key.
- Press F9 to reset the BIOS defaults, and press Enter to confirm the action.
- Press F10 to save the change and exit the BIOS, and then press Enter to confirm.
Hopefully now the computer will restart.Low disk space - "System Rollback Data" hidden secret directory
This netbook came preinstalled with Roxio BackOnTrack, which is the primary source of my woes. Recently I found I was running out of disk space and after deleting a heap of data, then finding I was running out again I installed WinDirStat to check what was going on. On inspection I found a super secret hidden folder System Rollback Data, which is not even visible with "show system files" switched on. Note this is not to be confused with Microsoft Windows System Restore. This folder contained 160Gb out of my 250Gb SSD !!
So after reading I found many pointers for Roxio BackOnTrack being the culprit of the System Restore Data directory size. Note that it seems Roxio BackOnTrack and this super secret directory may have a hook into the boot loader. So beware!
Anyway, without further ado here's what I hit and how to fix it.
- Uninstall Roxio BackOnTrack from the Programs & Features or similar. Note this may take a long time if the backup store is large. I didn't wait, and end task'ed the uninstall process. That may have been a bad idea.
- After killing the uninstall and rebooting I got the dreaded 3F0 hard disk does not exist, fix as per above.
- After fixing 3F0 issue, Windows would not boot, I tried safe mode, command prompt, last known good configuration, all that happened was a black screen after the initial Windows splash. On logging I found Windows load stopped at aswrvt.sys, no further progress. After a lot of searching I found a post that mentioned to delete the file delete the syscow32.sys file in WINDOWS/system32/drivers folder. The next issue was trying to get a utility running so I could get access to the C:\ Drive.
- As the HP Mini 210 doesn't have a CD/DVD drive I decided to run a USB Boot program, after trying Windows restore disk, which didn't boot, I decided to use EaseUS Todo Back Emergency Disk, so I did the following:
- Installed EaseUS Todo Backup Free to another computer and ran it.
- Tools > Create Emergency disk, then created USB bootable drive
- Put that in the HP Mini and changed boot options to move USB to top of the list
- When EaseUS started up went to Tools > Windows Command Prompt and ran commands along the lines of the following and found I only had syscow32x.sys, so backed up and deleted that:
c: cd windows\system32\drivers copy syscow32x.sys c:\temp del syscow32x.sys exit
- Closed EaseUS Todo Backup
- Rebooted - filesystem check kicked in, and Windows booted successfully !
- Get rid of Roxio BackOnTrack - run uninstallapp.exe from C:\Program Files\Roxio ... takes a long time (10's of minutes dependeing on data size), watch the disk space free up as it runs :-)
- Remove Roxio BackOnTrack via Control Panel - Programs and Features
After all that, my machine is running sweetly again. Hopefully this post saves someone from throwing a perfectly fine HP Mini 100 / 210 out the window !!
- Helpful Pointer to uninstall Roxio BackOnTrack.
- Key identification of problematic syscow32.sys file.
- HP forum with other people's woes.
Since some time I have been adding
WHERE 1=1 to all my queries.
I get queries like this:
SELECT * FROM emp e WHERE 1=1 AND e.ename LIKE 'A%' AND e.deptno = 20
Lots of people ask me what’s the use of this
You know I like to type as little as possible but here I am typing a lot of extra characters. And yet, it makes my development life a lot easier.
If my query has a lot of predicates and I want to see what happens then I usually comment those predicates out by using — (two dashes). I use my own CommentLine plug-in for this. This is easy for the second and higher predicates. But if I want to comment out the first predicate, then it get a bit harder. Well, not harder, but more work.
If I didn’t use the
WHERE 1=1 and I wanted to comment out the ename predicate then I would have to do something like this:
SELECT * FROM emp e WHERE /*e.ename LIKE 'A%' AND */e.deptno = 20
I agree, it’s not hard to do, but I think it’s a lot more work than just adding — (two dashes) in front of a line:
SELECT * FROM emp e WHERE 1 = 1 -- AND e.ename LIKE 'A%' AND e.deptno = 20
And, as I don’t like typing or at least, I want to make it as easy for me as possible, I am using another one of my plug-ins, Template, where I defined a template
w1 which results in
WHERE 1 = 1 AND
making it easy for me to write the queries.
I think adding this extra predicate has no (or hardly any) influence on the execution time of the query. I think the optimizer ignores this predicate completely.
I hope this explains a bit why I write my queries like this.
However, the initial install of the Update Image will only have the English language enabled. If you are using PeopleSoft Update Manager, once you upload the target environment and define the change package, the application will automatically install the languages you have in place in your own environment. However, if you just want to install the Update Image and you do not have a target environment to upload, this approach is not feasible.
Below I describe the steps to follow in order to install additional languages into an Update Image without having a target environment.
1.- Launch the Update Image.
3.- Connect to the database using SQL Developer and run the following command:
To enable tunneling for use with Discoverer Plus, use this workflow:
- Launch Enterprise Manager using something like: http://server.domain.com:7002/em
- Enter your Username and Password. Username is typically Weblogic
- Under Farm, on left-hand side, expand Discoverer and Discoverer(11.1.1.x.0)
- In the Components window, highlight Discoverer Plus then click the Configure button
- In the Communication Protocols window, click the Tunneling radio button (see below)
- Click the Apply button
- Shut Down the Discoverer service from the top link by clicking on Discoverer | Control | Shut Down - confirm the action
- Restart the Discoverer service from the top link by clicking on Discoverer | Control | Start Up - confirm the action (sometimes you have to do this twice)