Posted by Mohammed Mawla on Feb 7, 2012
So HP Cloud is finally yielding for some beta rain since their announcement late Sep.
It started late September when I signed up for private beta testing. They sent me this when I signed up
Thanks for your interest in HP Cloud Services. We will be sure to follow up with you when access becomes available. Since we’re only accepting a limited number of customers for our private beta based on customer profiles, we cannot guarantee that every request will be accepted.
However, we will review your submission and follow-up with you directly.
Two weeks ago, I got invited to join the beta and start testing the platform. Read the rest of this entry . . .
Posted by goswami on Feb 6, 2012
Today we have an alert from one of the client server about blocking, I have immediately start looking at it using below statement
SELECT * FROM
MASTER..SYSPROCESSES
WHERE BLOCKED != 0;
Read the rest of this entry . . .
Posted by Yury Velikanov on Feb 1, 2012
If you are wondering why anyone would possibly need to Install Oracle VM Manager in such an unsupported way, please read my previous Oracle VM 3 related blog post.
In this post, I will share with you my experience installing OVMM 3.0.3 under OVM 3.0.3 Dom0 host, including:
- A short and sweet action plan to get it up and running ASAP
- A detailed explanation with error messages and solutions
- Clean run output
Read the rest of this entry . . .
Posted by Marc Fielding on Jan 26, 2012
The end is nigh for Adobe Flash at My Oracle Support. The first step will happen during this weekend’s planned maintenance of My Oracle support, when all of MOS will be down for 5 hours starting at midnight eastern, Saturday January 28. Once it comes back up, the unadvertised non-Flash supporthtml.oracle.com will come up as a quasi-user acceptance test of the new application, while the flash-based support.oracle.com stays as-is. And once the bugs get worked out (“in the coming months”), the flash-based support.oracle.com will cease to exist and point to the new HTML-based site.
Read the rest of this entry . . .
Posted by Maryanne Birksted on Jan 25, 2012
Pythian is very excited to return to the much-awaited RMOUG 12 held in Denver, Colorado from February 14-16, 2012. Keep your eyes open for Alex Gorbachev, Marc Fielding, Don Seiler and Gwen Shapira in attendance. We have a fantastic line-up of speakers this year featuring a total of seven papers presented by Alex, Marc, Don and Gwen. If you have any feedback on our sessions, please send your comments directly to the speaker or to Vanessa Simmons, Pythian Director of Marketing. Please also follow this link to sign up to receive notice of future speaking engagements, webinars or Pythian news.
Be sure to stop by our booth (#3,6,7,10) to say hello to our friends from the OakTable Network, and enter our draw to win the new Amazon Kindle with software provided by Cary Millsap (MR-Trace, MR-Tools & Method-R Profiler) and a pack of digital e-book downloads courtesy of Apress. Also slated is the RAC Attack workshop, which was first offered at Oracle Open World and UKOUG, and is now in its second year at RMOUG. Pythian is co-sponsoring this event with Apress and it’s a fun and informative way to learn from our experts how and when to properly build a RAC environment.
Read the rest of this entry . . .
Posted by Mohammed Mawla on Jan 24, 2012
A frequent inquiry concerning databases’ security is to retrieve the database role(s) associated with each user for auditing or troubleshooting purposes.
Each database user (principal) can be retrieved from sys.database_principals and the associated database roles can be retrieved from sys.database_role_members
The following code runs against ALL the databases using SP_MSForeachdb and all roles for one principal is concatenated in one row Read the rest of this entry . . .
Posted by Marc Fielding on Jan 16, 2012
The 2012 edition of RMOUG Training Days in Denver less than a month away, running February 15 and 16 at the Colorado Convention Center in Denver. Although it’s only two days, there’s a lot of technical content there, and a refreshing reduction in marketing-oriented presentations from “product managers”. It’s not too late to register, and it’s a pretty nice excuse to get to the Rockies in ski season. I’ll be doing two presentations, and am polishing up whitepapers and presentations for the submission deadline tomorrow:
They’re right after each other in the grid, but I do get a short break for the dedicated exhibit hall time and paid vendor presentations (yes there are still a few; they have to pay the bills somehow).
Read the rest of this entry . . .
Posted by Suresh Kuna on Jan 10, 2012
A few days ago, we faced a Duplicate entry problem in the mysqld server on one of our customer’s slave after cold backup. We do regular data sync checks for all of our customer’s as daily reports and check for data discrepancies between master and slave server’s, if any got picked up by our checks to investigate, and there was no issues for the particular server and with the report. When checked the entry details, there is a row with the same data in the table that was mentioned by Slave status Last_error entity.
Quick check on the error log showed that the slave was started after cold back’s and immediately stopped with a duplicate entry error and the mysqld server version is 5.0.77-log Source distribution. From the analysis of the below statements, we found that the slave SQL thread was stopped with the error at a position backwards than the SQL thread initialized after cold backup’s. Read the rest of this entry . . .
Posted by Maris Elsins on Jan 9, 2012
One of the hot topics at the UKOUG 2011 Technology and E-Business Suite Conference last December was the upcoming release of Oracle e-Business Suite R12.2. The new release will bring us lots of new features, usability improvements and new versions of technology stack components (Oracle Database 11g R2 and Oracle Fusion Middleware 11g R1 as the application server), but the most important and impressive new feature of course will be online patching. Online patching is supposed to change the game completely. All owners of E-Business Suite environments know that patching requires downtime. Although it can be reduced with various techniques (e.g. staged APPL_TOP), some downtime is still required to apply a number of changes. Online patching will not eliminate downtime completely, but will reduce it significantly by using “Edition Based Redefinition” (EBR) at the database level and using a secondary applications file system for online patching. In fact, all patching activity will be an online operation; downtime will be required only to switch from one version to another. Read the rest of this entry . . .
Posted by Marc Fielding on Jan 5, 2012
Hot on the heels of 11.2.0.3 coming out for Exadata, there’s yet another Exadata patch schedule out: the Quarterly Database Patch for Exadata (QDPE). They’re designed to being some of the predictability of Oracle’s quarterly critical patch updates (CPU) to the Exadata world. Behind the new naming, it looks like these are ordinary Exadata bundle patches, and even have BP numbers, but will have the predictable quarterly release schedule, synchronized with the CPU schedule (quarterly Tuesday nearest to 17th of the month it appears). Ordinary bundle patches aren’t going away quite yet though: there’s still a need to get patches out more frequently, and will still come out monthly or bimonthly on top of the quarterly patches. Oracle’s patching recommendations have changed too: QDPE patches are recommended, but other bundle patches are recommended only if experiencing issues resolved by them. From My Oracle Support note 888828.1, the following patches for Oracle 11.2.0.3 are planned:
Read the rest of this entry . . .
