Sunday, December 15, 2013
Weekend Listening: Oracle ERP and EPM integration
While this isn't in the normal vein of posts, getting to listen to John O'Rourke VP of Product Marketing with Oracle making the point of how much work (and thought) they are putting into the integration between their ERP and EPM products is almost priceless. Not only does he share technical bits that most of us are concerned with, but he dives into the business processing point of view as well which sometimes we can easily miss while we're fighting fires. Worth the time to listen to this the next chance you have!
Saturday, December 14, 2013
Weekend Twitter - 12/14/13
Sure I could've waited until Thursday for this, but there are a LOT of announcements worthy of getting ahead of the game on the weekend!
Announcements:
Announcements:
https://twitter.com/oraclehardware/status/410772285940056064 - Oracle Exadata Database Machine X4-2 is officially released! Frits shares the data sheet for it too: https://twitter.com/fritshoogland/status/410778894636032001.
https://twitter.com/mfild/status/410836882251980800 - Speaking of Exadata, Marc Fielding is on the bleeding edge of 11.2.0.4.2 just being released!
https://twitter.com/thatjeffsmith/status/411135593566175233 - The official release of Oracle SQL Developer 4! Jeff Smith shares some reasons to upgrade https://twitter.com/thatjeffsmith/status/411135921946656768 and Rika Ng posts another release from Oracle on this topic https://twitter.com/rikang/status/411137923367849984.
https://twitter.com/yvelik/status/409077294268178432 - Yury shares a great interview response!
https://twitter.com/oraclecert/status/410510231295127552 - The Upgrade to Oracle 12c Administrator exam is now available!
https://twitter.com/oracle_ebs/status/410837660882984960 - Procurement RUP on top of R12.1.3.
https://twitter.com/oraclehardware/status/411088060294889472 - The newest version of Oracle Key Manager is now out!
Training/Free Stuff:
https://twitter.com/jloracle/status/409335966285828096 - Jonathan Lewis shares his presentation on HCC from UKOUG this year!
https://twitter.com/oraclehardware/status/409608311605321729 - Deep dive on Oracle VM.
https://twitter.com/oraclecloudzone/status/409608318324604929 - Cloud to on premise weekend reading.
https://twitter.com/dba_hba/status/409696029387132929 - Allan Robertson shares an Oracle whitepaper on Unstructured Data Management with 12c!
https://twitter.com/oracle_edu/status/410151090567782400 - Oracle Education is having WebLogic training.
https://twitter.com/thatjeffsmith/status/410483106307932160 -Jeff Smith will be having a webinar on Oracle SQL Developer!
https://twitter.com/msewtz/status/410503167067971584 - In the New York area? Get some training from NYOUG on Oracle SQL Developer.
https://twitter.com/oraclepress/status/410835357127942144 - Oracle Press shares another free chapter, this time "Using and Managing Large Databases".
https://twitter.com/enkitec/status/410886569289973760 - Only a few seats open for Enkitec's Exadata Optimization class.
https://twitter.com/oracleblogs/status/410898700161277952 - Get trained on the Sun ZFS Storage 7000 Appliance!
https://twitter.com/jloracle/status/411106006819540992 - The Jonathan and Maria double act from OpenWorld this year on the Optimizer.
https://twitter.com/otnarchbeat/status/411154187255578624 - Interested in a free book on WebLogic?
https://twitter.com/oraclemagazine/status/411206411574861825 - A Security webinar for 12c!
General News/Information:
https://twitter.com/yvelik/status/409077294268178432 - Yury shares a great interview response!
https://twitter.com/hdeiby/status/409886716216877056 - Deiby Gómez tells us more about ASM and REMOTE_LOGIN_PASSWORDFILE.
https://twitter.com/chrisantognini/status/409987591887675392 - Christian shares a tip that you need to know for a multitenant environment!
https://twitter.com/lucacanalidb/status/410100966667472896 - Luca Canali learned a new trick from MOS in dealing with AWR.
https://twitter.com/seth_m_miller/status/410235897108389888 - Seth Miller shares something that I've thought a LOT over the last few years!
https://twitter.com/jloracle/status/410439191697182720 - Jonathan shares some really good feedback that he got from the conference.
https://twitter.com/oraclealchemist/status/410487435747803136 - Steve Karam has a tweet that reflects a feeling I've seen a lot over the past few months from several people.
https://twitter.com/thatjeffsmith/status/410534657936347136 - Do you know how to get to the last row in an Oracle SQL Developer resultset?
Have you seen the #FiveWordTechHorrors? Here are some of the better ones I've seen:
https://twitter.com/oracle_ebs/status/410793618895818752 - MOS article on R12.1 asset workbench errors where you get ORA-20001/XLA-95103.
https://twitter.com/leight0nn/status/410825738493759488 - Leighton has run into an issue with EM agents crashing in 12c on RAC nodes due to memory leaks.
Andy Colvin has several new things to share about the new Exadata:
https://twitter.com/jarneil/status/411057674848333824 - It looks like Oracle Advanced Compression Option comes with some new licensing.
https://twitter.com/oracle_edu/status/411061036025151488 - Uwe Hesse has some detailed insight for the new Oracle Database.
https://twitter.com/dba_hba/status/411159578395439104 - More Exadata cores, more licensing?
https://twitter.com/enkitec/status/411214888535470080 - The last part in Kerry Osborne's series of answers on 12c Adaptive Optimization!
https://twitter.com/sql_handle/status/411492974967541760 - Good advice about your career!!
https://twitter.com/jloracle/status/411509606800560128 - Jonathan Lewis shares a explanation by Martin Priess of some pre 12c limitations on dynamic_sampling.
https://twitter.com/raysmithace/status/411525118670557184 - Ray Smith tells us not to bounce our DB, and why this post saved his life.
https://twitter.com/oracle_ebs/status/411534754652368898 - Certification and reference information for MS Office 2007 and 2010 for R11 and R12.
https://twitter.com/tanelpoder/status/411573919871946752 - Tanel shows us a bloom partition pruning post from Vishal Desai.
https://twitter.com/oracleblogs/status/411624116035530752 - Oracle Linux spotlight on Ksplice.
https://twitter.com/kahnan/status/411646553007198208 - A great endorsement for Jonathan Lewis' work!
Conference News:
https://twitter.com/pfierens/status/409288474513379328 - Some post UKOUG conference thoughts from Philippe Fierens.
Social Media/DevOps:
https://twitter.com/oracle/status/409062924842311680 - Members of the OracleACE program share their experiences with Oracle User Groups.
https://twitter.com/dba_hba/status/410151267692863489 - Allan shares 7 DevOps habits.
https://twitter.com/clicktips/status/410393600216674304 - Three tips on making your blog/website better.
https://twitter.com/clicktips/status/410813927811854336 - SEO tips for getting traffic from Google!
Friday, December 13, 2013
R12: ARCH wait on SENDREQ
Days after our R12 upgrade our wait event alert showed that "ARCH wait on SENDREQ" was quite high, so further investigation showed 9 different sessions in the wait event within gv$session with all of them having the program set like "oracle@server (ARC0)".
The next day, this is what our wait event alert looked like:
Waits Wait Time
gc buffer busy release 6515.7246
gc buffer busy acquire 6243.267722
ARCH wait on SENDREQ 4103.947898
Backup: MML write backup piece 3537.058172
log file sync 3190.876444
SQL*Net message from dblink 2942.456672
SQL*Net break/reset to client 1443.085918
gc current block busy 1434.390776
FAL archive wait 1 sec for REOPEN minimum 1156.983756
Referencing the official documentation again for the definition of "buffer busy waits" and "log file sync" helped us to pin not only the ARCH activity, but everything else going on the next day, down to the SLA conversion process that was still being running post-deployment. What we were seeing was the archiver and archive logs processing from the amount of redo/undo being created in the system, which was why gc (global cache) was so high in the system and the "FAL archive wait" was being generated.
The next day, this is what our wait event alert looked like:
Waits Wait Time
gc buffer busy release 6515.7246
gc buffer busy acquire 6243.267722
ARCH wait on SENDREQ 4103.947898
Backup: MML write backup piece 3537.058172
log file sync 3190.876444
SQL*Net message from dblink 2942.456672
SQL*Net break/reset to client 1443.085918
gc current block busy 1434.390776
FAL archive wait 1 sec for REOPEN minimum 1156.983756
Referencing the official documentation again for the definition of "buffer busy waits" and "log file sync" helped us to pin not only the ARCH activity, but everything else going on the next day, down to the SLA conversion process that was still being running post-deployment. What we were seeing was the archiver and archive logs processing from the amount of redo/undo being created in the system, which was why gc (global cache) was so high in the system and the "FAL archive wait" was being generated.
Thursday, December 12, 2013
Thursday Twitter - 12/12/13
I may have missed some tweets during the week, and may not have caught up entirely yet, but here's a lot of new stuff for you!
Announcements:
Announcements:
https://twitter.com/oracleblogs/status/408406878159659008 - A reminder that IE7 is no longer a supported browser.
https://twitter.com/pythianbabbey/status/409003586295955456 - Pythian is receiving an award from the Toronto Board of Trade. Pretty cool!
https://twitter.com/oraclecert/status/409037163511037952 - MySQL 5.6 beta test for only $50!
Training/Free Stuff:
https://twitter.com/oracleweblogic/status/408640779574599680 - WebLogic in practice, SSL configuration.
https://twitter.com/oracleotn/status/408663333429338113 - A webcast giving you five reasons to go to Oracle VM.
https://twitter.com/enkitec/status/408669106557030400 - Frits Hoogland's presentation on multiblock reads!
https://twitter.com/enkitec/status/408708598718414848 - Get training from Enkitec!
https://twitter.com/oracleblogs/status/408995794952658944 - Some Exadata training and resources from Oracle!
General News/Information:
https://twitter.com/oracle_ebs/status/408616771101659136 - Getting rid of additional HZ_PERSON_PROFILES data.
https://twitter.com/chrisantognini/status/408621424551936000 - Christian Antognini starts a good conversation about PDB logging.
https://twitter.com/oraclealchemist/status/408702334928027648 - Steve Karam starts a good conversation on DB compatibility options and you should visit the MOS note listed here: https://twitter.com/mihajlotekic/status/409003140634013696.
https://twitter.com/oracleblogs/status/408723416649580544 - Laptops turn 25!
https://twitter.com/grantunez/status/408801100372799489 - Rene Antunez shares a few quotes from Nelson Mandela and this one too https://twitter.com/grantunez/status/408801125802835968.
https://twitter.com/leight0nn/status/408972404275167234 - Leighton Nelson shares a good use of 12c.
https://twitter.com/ukoug/status/408988239748689921 - UKOUG shares their Tech13 conference.
https://twitter.com/dbakevlar/status/408995658549301248 - Kellyn makes a good point that bloggers everywhere should take to heart.
https://twitter.com/chrisantognini/status/409026459865341952 - Christian with another great point to make!
https://twitter.com/oracle_ebs/status/409035785112150016 - R12.1.3 AR Receipts form issues relating to Customer name.
https://twitter.com/grantunez/status/409057232332926977 - Rene asks why he is getting an ORA-01017 error message after changing the dbsnmp password.
Conference News:
A series of tweets about Collaborate14 this year:
Social Media/DevOps:
https://twitter.com/kelloggs_ville/status/408937687194693633 - Is it worth joining an OUG (Oracle User Group)?
Wednesday, December 11, 2013
Blog spotlight follow up: Tanel Poder
The last spotlight I did was on Tanel Poder, and even though it has just been a few months he's absolutely published some gems which are worth visiting.
Did you know that it is possible for the SGA to be larger than the amount of HugePages in Linux? It is possible and maybe you'll learn something about USE_LARGE_PAGES and SGA_MAX_SIZE too.
Tanel has introduced a new version of his ash_wait_chains script! Looking forward to using this, and to see what's in his next version of the script too.
Want to learn more about Oracle Parallel Execution? Click here for part one and here for part two of some very seriously in-depth articles on the topic!
Ever have to replace a hard drive for Exadata? Tanel breaks down exactly WHY the system believes the drive has failed in a very methodical way that will be easy to replicate the next time we have an issue. I've even picked up a few new tricks here to look at disks in a proactive manner! Also, a great reminder that he has some webinars lined up that I know are worth signing up for.
Here is an interesting post on the difference between "cell flash cache read hits" versus "cell writes to flash cache" metrics.
Did you know that it is possible for the SGA to be larger than the amount of HugePages in Linux? It is possible and maybe you'll learn something about USE_LARGE_PAGES and SGA_MAX_SIZE too.
Tanel has introduced a new version of his ash_wait_chains script! Looking forward to using this, and to see what's in his next version of the script too.
Want to learn more about Oracle Parallel Execution? Click here for part one and here for part two of some very seriously in-depth articles on the topic!
Ever have to replace a hard drive for Exadata? Tanel breaks down exactly WHY the system believes the drive has failed in a very methodical way that will be easy to replicate the next time we have an issue. I've even picked up a few new tricks here to look at disks in a proactive manner! Also, a great reminder that he has some webinars lined up that I know are worth signing up for.
Here is an interesting post on the difference between "cell flash cache read hits" versus "cell writes to flash cache" metrics.
Tuesday, December 10, 2013
Blog spotlight follow up: Oracle Support EBS blog
My second spotlight was on the Oracle Support EBS blog, so tonight we turn back to the blog for many a good update!
The EBS Techstack landing page for R12 has been redesigned.
I mentioned this before, but it needs repeating; there is a new Procurement Enhancement Request Community that is the future of how Oracle will be working with the customer.
September 2013 Recommended Patch Collections have been released.
Looking for Troubleshooting Assistants (old Search Helpers)?
WebADI has changed with R12.
Help for stuck payments in R12 has arrived!
The year end checklist for HCM users.
A new analyzer for iProcurement has been released.
General Data Fixes (GDFs) for Payables are now available.
The 1099 patches for 2013 are out!
Recommended patches for Procurement in R12.
The EBS Techstack landing page for R12 has been redesigned.
Procurement development is focusing on the Buyer Work Center, and here are the top Enhancement Requests for it.
I mentioned this before, but it needs repeating; there is a new Procurement Enhancement Request Community that is the future of how Oracle will be working with the customer.
September 2013 Recommended Patch Collections have been released.
Looking for Troubleshooting Assistants (old Search Helpers)?
WebADI has changed with R12.
Help for stuck payments in R12 has arrived!
The year end checklist for HCM users.
A new analyzer for iProcurement has been released.
General Data Fixes (GDFs) for Payables are now available.
The 1099 patches for 2013 are out!
Recommended patches for Procurement in R12.
Monday, December 9, 2013
Blog spotlight follow up: Steven Chan's EBS blog
Several months ago, I started a feature of spotlighting blogs and now I want to start a follow up feature so where else would I start but with Steven Chan's EBS blog?
First off, Steven and crew have added a lot of updates which I'll break down into several different categories:
Certifications:
Java 1.6.0_60, 1.6.0_65, 1.7.0_40 and Java 1.7.0_45 are now certified with EBS.
Now you can use Transportable Tablespaces on 10gR2, potentially saving you time in your upgrade processes.
IE10 on Windows 7 is now certified with EBS.
The Application Management Pack is now certified with the latest version of 12c and EBS Plug-in 12.1.0.2 is now available for EM 12c.
The initial release of 12c is certified with 11i and R12, while the terminal release of 11gR2 is certified as well and even more certifications are available for 11gR2.
Multiple versions of EBS client configurations are now certified on Windows 8.
Firefox ESR 24 is certified with multiple EBS clients.
Running EBS on SPARC? If so, 11i is now certified with 11gR2.
Did you know that Office 2010 64-bit is certified with EBS 12?
R12:
The R12.1 Consolidated Update Patch #2 is available, but is not required if you are already on R12.
Steven reminds us that if you're on R12.1.1 or R12.1.2, you're closer to being able to go to R12.1.3 than you think!
Are you unsure if you should go to R12.1.3 or R12.2? Steven has an answer for you.
Do you know about the new flexfield value set security feature in R12.2?
Are you using Oracle VM Templates? New templates are available for R12.2.2.
New Information:
An offer to help Oracle shape the future of the next generation of the EBS interface. I'll sign up, how about you?
Want to see a great reason to attend Oracle OpenWorld next year? How about getting support timeline updates direct from the source?
The CPU for October has been released.
Did you know that you are expected to be signing your JAR files?
A new white paper on best practices for gathering EBS statistics, while another paper is available on getting optimal performance from the EBS.
Oracle is sharing the presentations from OpenWorld 2013 for a few months!
Elke suggests a series of upgrade recommendations that are available now.
Can you use 3rd party tools to modify your DB? Steven has an answer on this one too.
First off, Steven and crew have added a lot of updates which I'll break down into several different categories:
Certifications:
Java 1.6.0_60, 1.6.0_65, 1.7.0_40 and Java 1.7.0_45 are now certified with EBS.
Now you can use Transportable Tablespaces on 10gR2, potentially saving you time in your upgrade processes.
IE10 on Windows 7 is now certified with EBS.
The Application Management Pack is now certified with the latest version of 12c and EBS Plug-in 12.1.0.2 is now available for EM 12c.
The initial release of 12c is certified with 11i and R12, while the terminal release of 11gR2 is certified as well and even more certifications are available for 11gR2.
Multiple versions of EBS client configurations are now certified on Windows 8.
Firefox ESR 24 is certified with multiple EBS clients.
Running EBS on SPARC? If so, 11i is now certified with 11gR2.
Did you know that Office 2010 64-bit is certified with EBS 12?
R12:
The R12.1 Consolidated Update Patch #2 is available, but is not required if you are already on R12.
Steven reminds us that if you're on R12.1.1 or R12.1.2, you're closer to being able to go to R12.1.3 than you think!
Are you unsure if you should go to R12.1.3 or R12.2? Steven has an answer for you.
Do you know about the new flexfield value set security feature in R12.2?
Are you using Oracle VM Templates? New templates are available for R12.2.2.
New Information:
An offer to help Oracle shape the future of the next generation of the EBS interface. I'll sign up, how about you?
Want to see a great reason to attend Oracle OpenWorld next year? How about getting support timeline updates direct from the source?
The CPU for October has been released.
Did you know that you are expected to be signing your JAR files?
A new white paper on best practices for gathering EBS statistics, while another paper is available on getting optimal performance from the EBS.
Oracle is sharing the presentations from OpenWorld 2013 for a few months!
Elke suggests a series of upgrade recommendations that are available now.
Can you use 3rd party tools to modify your DB? Steven has an answer on this one too.
Sunday, December 8, 2013
R12: MO Operating Unit
With changes in R12, it is possible to change your setup from using the profile option "MO: Operating Unit" to start using the profile option "MO: Default Operating Unit". While that isn't horrible, it does mean that you have to go through your entire system to scour out the old profile option from all responsibility setup and the hard coded details in reports. This is because if you do not complete this task it is entirely possible to miss something so when you try to run a report it errors out, or if you have some type of audit or alerts run based on MO: Operating Unit when run they will not give you the type of results you're expecting.
This is yet another small piece of advice for a running R12 checklist that I seem to have been building here over the last few months. :}
This is yet another small piece of advice for a running R12 checklist that I seem to have been building here over the last few months. :}
Saturday, December 7, 2013
R12: Invalidated workflow
After our upgrade, we kept a close eye on our monitoring alerts and noticed right away when one for workflow errors in the last day showed us this:
ORA-04061: existing state of has been invalidated
Reaching out to the team responsible for validating the release of the workflow, they weren't quite sure if this was a one off issue or a complete outage type of issue but upon further examination it was determined that the resolution to this was a bounce of the application tier. I was skeptical, but believed in what I was being told, and it just so happened we had an application tier bounce already lined up for another issue so the stars were aligned and the next day this error went away. I'm not quite sure what object was invalidated, as you can see that between of and has in the error message, there are 2 spaces as if the object name was not able to be reported up in the error stack.
ORA-04061: existing state of has been invalidated
Reaching out to the team responsible for validating the release of the workflow, they weren't quite sure if this was a one off issue or a complete outage type of issue but upon further examination it was determined that the resolution to this was a bounce of the application tier. I was skeptical, but believed in what I was being told, and it just so happened we had an application tier bounce already lined up for another issue so the stars were aligned and the next day this error went away. I'm not quite sure what object was invalidated, as you can see that between of and has in the error message, there are 2 spaces as if the object name was not able to be reported up in the error stack.
Friday, December 6, 2013
R12: Materialized Views
You will probably find this best as a "oh yeah" kind of reminder, but I learned a lesson during our R12 upgrade when we went live: treat MVs just like you treat your ETLs and not only test them prior, but validate after as well.
Obviously we did test, but sometimes in a huge project not all changes get propagated as they should so we have MVs without column modifications (especially for RA_CUSTOMERS). Additionally, we ran into this in our alert log:
ORA-12012: error on auto execute of job 93
ORA-12008: error in materialized view refresh path
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
Why did we encounter this? We didn't validate that the MV was in a VALID state before asking the system to run it as per the normal run schedule. This leads me to think of yet another alert to tell us when we have a MV go INVALID just in case it happens again and we aren't watching the alert log like hawks.
Obviously we did test, but sometimes in a huge project not all changes get propagated as they should so we have MVs without column modifications (especially for RA_CUSTOMERS). Additionally, we ran into this in our alert log:
ORA-12012: error on auto execute of job 93
ORA-12008: error in materialized view refresh path
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
Why did we encounter this? We didn't validate that the MV was in a VALID state before asking the system to run it as per the normal run schedule. This leads me to think of yet another alert to tell us when we have a MV go INVALID just in case it happens again and we aren't watching the alert log like hawks.
Thursday, December 5, 2013
Thursday Twitter - 12/05/13
It's about time that I actually do this post on time huh?
I've obviously missed a few weeks of my Twitter updates, so today you get a massive update following the same format as last time, and we'll see how it goes!
Announcements:
https://twitter.com/Oracle_EBS/status/406109000393318400 - The Quarterly EBS upgrade recommendations!
https://twitter.com/OTNArchBeat/status/407644367881764864 - Bob is looking for you to guest produce the OTN ArchBeat. That's an awesome deal!
https://twitter.com/oracleace/status/408030885834137600 & https://twitter.com/grantunez/status/408012239958851584 - New Oracle ACEs!!
https://twitter.com/OracleCert/status/408333092764413952 - Last chance to take Linux 5 & 6 SysAdmin Beta tests for $50!
Training/Free Stuff:
https://twitter.com/Oracle_EBS/status/406088866345783296 - Webinar on the R12 Financials Accounting Hub.
https://twitter.com/OracleDBsupport/status/406181984478961664 - Use Linux on System Z? Here's a webinar for you!
https://twitter.com/TanelPoder/status/406775536456069120 - Tanel shares a presentation from Connor McDonald about Oracle analytic functions.
https://twitter.com/OraclePress/status/406866616232984576 - Get Chapter 44 free for Java Stored Procedures from Oracle DB 12c: The Complete Reference.
https://twitter.com/oraclehardware/status/407539693556076545 - A webinar on OEM 12c storage tips and tricks for performance!
https://twitter.com/Enkitec/status/407546270937407488 - If you didn't attend Karen Morton's presentation on "Everyday Oracle Pro" do yourself a favor and visit the recording here.
https://twitter.com/OracleExalogic/status/407554786364776448 - Exalogic bootcamps are coming, register now!
https://twitter.com/Enkitec/status/407560217631547392 - Tanel is giving another troubleshooting and optimization course.
https://twitter.com/OraclePress/status/407631087763193856 - Free chapter of Oracle 12c New Features.
https://twitter.com/ahl/status/407872672941355008 - Presentation from UKOUG on ZFS for databases.
https://twitter.com/Oracle_Edu/status/407900605399592961 - Test your GoldenGate 11g knowledge with a question!
https://twitter.com/OraclePress/status/407963944322883585 - Another free chapter from Oracle Press, this time on ASM Health Check Monitors.
General News/Information:
https://twitter.com/Oracle_EBS/status/406068741290864640 - A MOS note for understanding FA mass additions, create, and troubleshooting.
https://twitter.com/Oracle_EBS/status/406088866345783296 - Learn how encumbrance accounting flows from PO to GL with another MOS note.
https://twitter.com/fritshoogland/status/406176781637394432 - Frits Hoogland with a more than average insight.
https://twitter.com/OracleBlogs/status/406231580282454016 - Great idea to get updates to this Exadata MOS note automatically!
https://twitter.com/TanelPoder/status/406413846514262016 - Tanel Poder shares with us a MOS note about testing Exadata and RAC.
https://twitter.com/OracleBlogs/status/406413928160567296 - Starting up 252 PDBs with Oracle Multitenant!
https://twitter.com/dba_hba/status/406429076769869827 - Allan Robertson shares a great post about triage and troubleshooting, with some very good take aways.
https://twitter.com/OracleBlogs/status/406926405138923521 - Trunc Aggregation and HA.
https://twitter.com/OracleBlogs/status/407122160495628288 - Detecting application entry points.
https://twitter.com/ChiefRobot/status/407472571035451392 - Amusing image about the take over of the Amazon drones!
https://twitter.com/Oracle_EBS/status/407523316397006848 - Automatic Receipts in R12 blog entry from the Oracle EBS team.
https://twitter.com/Oracle_EBS/status/407538422132142081 - What are the top FIVE ATG notes being viewed by customers?
https://twitter.com/mnorgaard/status/407791480833843200 - The start of the OakTable Network.
https://twitter.com/Oracle_EBS/status/407889491601682432 - The period close advisor and how to make it a concurrent program: https://twitter.com/Oracle_EBS/status/408234260949385217.
https://twitter.com/grantunez/status/408055170707095552 - A good reminder about Windows XP!
https://twitter.com/OracleAlchemist/status/408252030801547264 - Steve has a great point. Great point.
Conference News:
https://twitter.com/devops/status/406544421392760832 - The MountainWest DevOps 2014 conference call for papers is now open!
UKOUG: Again, we have a conference getting a section all to itself because of the volume coming out from it!
https://twitter.com/orcldoug/status/407161048287162369 - Slide from James Morle about throughput.
https://twitter.com/orastory/status/407180270283292672 - A fan of learning IO internals around direct path, IO submit, and IO slots from James Morle and Frits Hoogland.
https://twitter.com/mfild/status/407185511716257792 - Marc Fielding talks about Frits' multiblock reads magnum opus that took two years to complete.
https://twitter.com/brost/status/407443879710179328 - Learning about scalar subqueries.
https://twitter.com/UweHesse/status/407456371505119232 - Uwe tells us that Point In Time recovery for PDB requires a container at a remote site.
https://twitter.com/ahl/status/407456397199409152 - Speaking of PDBs, there is the opinion that they won't be used for a few years.
https://twitter.com/MarisElsins/status/407470248104067073 - Frits in action, and a comment that his presentation was so good that people couldn't tweet anything out during it. That's pretty good!
https://twitter.com/brost/status/407479360011374592 - IO latency heatmaps in action! Download link is here: https://twitter.com/tpresslie/status/407489834878767104.
https://twitter.com/oraclebase/status/407483277331537920 - How do you jump around PDBs like you do editions?
https://twitter.com/acolvin/status/407498202401607682 - Ever have an issue you block from your mind, and it comes back when talking about something else? Yeah, me too.
https://twitter.com/MarisElsins/status/407514163347746817 - Maris freaks out a bit about the size of his room, and that's likely what I'll get in March. :}
https://twitter.com/oraclebase/status/407526387919388672 - I don't know about witchcraft, or the witches that practice it, but I don't think we need to be going this far do we? :}
https://twitter.com/brost/status/407536008323137536 & https://twitter.com/OyvindIsene/status/407537346205458432 - The community seems to be really open to new people participating, which is great news for me!
https://twitter.com/LucaCanaliDB/status/407539849286385664 - A great snapshot and caption about DBAs!
https://twitter.com/MarisElsins/status/407565844450123776 - A lot like what I said from a few presentations at Hotsos 2012!
https://twitter.com/SQLMaria/status/407573549549768704 - Maria (and others) won awards at the conference!
https://twitter.com/MarisElsins/status/407682517865463808 - Downloading MOS patches with a script.
https://twitter.com/JLOracle/status/408162051819708416 - Jonathan shares his Basic CBO PDF.
https://twitter.com/UweHesse/status/408206268034473984 - Is your script using Exadata cells? Query v$cell and find out!
https://twitter.com/yvelik/status/408207015040020480 - Yury shares Maris' presentation on 10 ways to improve RMAN scripts.
https://twitter.com/mcox_IT/status/408263401329414144 - Great endorsement, and sounds like what I think about OAUGs Collaborate.
https://twitter.com/rluttikhuizen/status/408370107438493696 - WebLogic hackathon.
Social Media/DevOps:
https://twitter.com/ClickTips/status/405854969255174144 - Reducing "bounce rate" for your blogs.
https://twitter.com/devops/status/406272117425311744 - What is the problem with DevOps?
https://twitter.com/JLOracle/status/406346774119342080 - Not often that I get to see what other bloggers habits are, but Jonathan Lewis gives us some insight here on some of his "routine".
https://twitter.com/DBAKevlar/status/406529955648917504 - I'm filing this under Social Media because while I'm branching out, maybe I should be getting an about.me page too like Kellyn.
https://twitter.com/kylehhailey/status/407182726010515456 - Kyle Hailey shares a post about PLNs (personal learning network) and I have to say, the past few months have made me a believer.
https://twitter.com/devops/status/407631846802214913 - What is DevOps?
https://twitter.com/ClickTips/status/407862656100352001 - Getting more traffic with a "word cloud".
https://twitter.com/devops/status/407949327110516736 - I've heard of PMBOK, but SABOK?
I've obviously missed a few weeks of my Twitter updates, so today you get a massive update following the same format as last time, and we'll see how it goes!
Announcements:
https://twitter.com/Oracle_EBS/status/406109000393318400 - The Quarterly EBS upgrade recommendations!
https://twitter.com/OTNArchBeat/status/407644367881764864 - Bob is looking for you to guest produce the OTN ArchBeat. That's an awesome deal!
https://twitter.com/oracleace/status/408030885834137600 & https://twitter.com/grantunez/status/408012239958851584 - New Oracle ACEs!!
https://twitter.com/OracleCert/status/408333092764413952 - Last chance to take Linux 5 & 6 SysAdmin Beta tests for $50!
Training/Free Stuff:
https://twitter.com/Oracle_EBS/status/406088866345783296 - Webinar on the R12 Financials Accounting Hub.
https://twitter.com/OracleDBsupport/status/406181984478961664 - Use Linux on System Z? Here's a webinar for you!
https://twitter.com/TanelPoder/status/406775536456069120 - Tanel shares a presentation from Connor McDonald about Oracle analytic functions.
https://twitter.com/OraclePress/status/406866616232984576 - Get Chapter 44 free for Java Stored Procedures from Oracle DB 12c: The Complete Reference.
https://twitter.com/oraclehardware/status/407539693556076545 - A webinar on OEM 12c storage tips and tricks for performance!
https://twitter.com/Enkitec/status/407546270937407488 - If you didn't attend Karen Morton's presentation on "Everyday Oracle Pro" do yourself a favor and visit the recording here.
https://twitter.com/OracleExalogic/status/407554786364776448 - Exalogic bootcamps are coming, register now!
https://twitter.com/Enkitec/status/407560217631547392 - Tanel is giving another troubleshooting and optimization course.
https://twitter.com/OraclePress/status/407631087763193856 - Free chapter of Oracle 12c New Features.
https://twitter.com/ahl/status/407872672941355008 - Presentation from UKOUG on ZFS for databases.
https://twitter.com/Oracle_Edu/status/407900605399592961 - Test your GoldenGate 11g knowledge with a question!
https://twitter.com/OraclePress/status/407963944322883585 - Another free chapter from Oracle Press, this time on ASM Health Check Monitors.
General News/Information:
https://twitter.com/Oracle_EBS/status/406068741290864640 - A MOS note for understanding FA mass additions, create, and troubleshooting.
https://twitter.com/Oracle_EBS/status/406088866345783296 - Learn how encumbrance accounting flows from PO to GL with another MOS note.
https://twitter.com/fritshoogland/status/406176781637394432 - Frits Hoogland with a more than average insight.
https://twitter.com/OracleBlogs/status/406231580282454016 - Great idea to get updates to this Exadata MOS note automatically!
https://twitter.com/TanelPoder/status/406413846514262016 - Tanel Poder shares with us a MOS note about testing Exadata and RAC.
https://twitter.com/OracleBlogs/status/406413928160567296 - Starting up 252 PDBs with Oracle Multitenant!
https://twitter.com/dba_hba/status/406429076769869827 - Allan Robertson shares a great post about triage and troubleshooting, with some very good take aways.
https://twitter.com/OracleBlogs/status/406926405138923521 - Trunc Aggregation and HA.
https://twitter.com/OracleBlogs/status/407122160495628288 - Detecting application entry points.
https://twitter.com/ChiefRobot/status/407472571035451392 - Amusing image about the take over of the Amazon drones!
https://twitter.com/Oracle_EBS/status/407523316397006848 - Automatic Receipts in R12 blog entry from the Oracle EBS team.
https://twitter.com/Oracle_EBS/status/407538422132142081 - What are the top FIVE ATG notes being viewed by customers?
https://twitter.com/mnorgaard/status/407791480833843200 - The start of the OakTable Network.
https://twitter.com/Oracle_EBS/status/407889491601682432 - The period close advisor and how to make it a concurrent program: https://twitter.com/Oracle_EBS/status/408234260949385217.
https://twitter.com/grantunez/status/408055170707095552 - A good reminder about Windows XP!
https://twitter.com/OracleAlchemist/status/408252030801547264 - Steve has a great point. Great point.
Conference News:
https://twitter.com/devops/status/406544421392760832 - The MountainWest DevOps 2014 conference call for papers is now open!
UKOUG: Again, we have a conference getting a section all to itself because of the volume coming out from it!
https://twitter.com/orcldoug/status/407161048287162369 - Slide from James Morle about throughput.
https://twitter.com/orastory/status/407180270283292672 - A fan of learning IO internals around direct path, IO submit, and IO slots from James Morle and Frits Hoogland.
https://twitter.com/mfild/status/407185511716257792 - Marc Fielding talks about Frits' multiblock reads magnum opus that took two years to complete.
https://twitter.com/brost/status/407443879710179328 - Learning about scalar subqueries.
https://twitter.com/UweHesse/status/407456371505119232 - Uwe tells us that Point In Time recovery for PDB requires a container at a remote site.
https://twitter.com/ahl/status/407456397199409152 - Speaking of PDBs, there is the opinion that they won't be used for a few years.
https://twitter.com/MarisElsins/status/407470248104067073 - Frits in action, and a comment that his presentation was so good that people couldn't tweet anything out during it. That's pretty good!
https://twitter.com/brost/status/407479360011374592 - IO latency heatmaps in action! Download link is here: https://twitter.com/tpresslie/status/407489834878767104.
https://twitter.com/oraclebase/status/407483277331537920 - How do you jump around PDBs like you do editions?
https://twitter.com/acolvin/status/407498202401607682 - Ever have an issue you block from your mind, and it comes back when talking about something else? Yeah, me too.
https://twitter.com/MarisElsins/status/407514163347746817 - Maris freaks out a bit about the size of his room, and that's likely what I'll get in March. :}
https://twitter.com/oraclebase/status/407526387919388672 - I don't know about witchcraft, or the witches that practice it, but I don't think we need to be going this far do we? :}
https://twitter.com/brost/status/407536008323137536 & https://twitter.com/OyvindIsene/status/407537346205458432 - The community seems to be really open to new people participating, which is great news for me!
https://twitter.com/LucaCanaliDB/status/407539849286385664 - A great snapshot and caption about DBAs!
https://twitter.com/MarisElsins/status/407565844450123776 - A lot like what I said from a few presentations at Hotsos 2012!
https://twitter.com/SQLMaria/status/407573549549768704 - Maria (and others) won awards at the conference!
https://twitter.com/MarisElsins/status/407682517865463808 - Downloading MOS patches with a script.
https://twitter.com/JLOracle/status/408162051819708416 - Jonathan shares his Basic CBO PDF.
https://twitter.com/UweHesse/status/408206268034473984 - Is your script using Exadata cells? Query v$cell and find out!
https://twitter.com/yvelik/status/408207015040020480 - Yury shares Maris' presentation on 10 ways to improve RMAN scripts.
https://twitter.com/mcox_IT/status/408263401329414144 - Great endorsement, and sounds like what I think about OAUGs Collaborate.
https://twitter.com/rluttikhuizen/status/408370107438493696 - WebLogic hackathon.
Social Media/DevOps:
https://twitter.com/ClickTips/status/405854969255174144 - Reducing "bounce rate" for your blogs.
https://twitter.com/devops/status/406272117425311744 - What is the problem with DevOps?
https://twitter.com/JLOracle/status/406346774119342080 - Not often that I get to see what other bloggers habits are, but Jonathan Lewis gives us some insight here on some of his "routine".
https://twitter.com/DBAKevlar/status/406529955648917504 - I'm filing this under Social Media because while I'm branching out, maybe I should be getting an about.me page too like Kellyn.
https://twitter.com/kylehhailey/status/407182726010515456 - Kyle Hailey shares a post about PLNs (personal learning network) and I have to say, the past few months have made me a believer.
https://twitter.com/devops/status/407631846802214913 - What is DevOps?
https://twitter.com/ClickTips/status/407862656100352001 - Getting more traffic with a "word cloud".
https://twitter.com/devops/status/407949327110516736 - I've heard of PMBOK, but SABOK?
Wednesday, December 4, 2013
Random Oracle MOS Notes - 12/04/13
Today I want to share several random My Oracle Support notes that I've ran across over the past few months, that you may get some benefit out of reviewing yourself.
226738.1 - This note has a 60 page PDF on the batch creation of user accounts, which may come in handy for you if you have a homegrown "self-service" access application like we do.
731190.1 - If the title of this note doesn't get you interested, "Handy SQL for the Oracle Applications", I don't know what else I can say to do the trick!
235053.1 - A manual just shy of 150 pages on the implementation of Oracle SSWA (Self-Service Web Applications).
1516355.1 - This is another MOS note where the title says it all: "E-Business Applications Performance Basic Skills Cookbook".
226738.1 - This note has a 60 page PDF on the batch creation of user accounts, which may come in handy for you if you have a homegrown "self-service" access application like we do.
731190.1 - If the title of this note doesn't get you interested, "Handy SQL for the Oracle Applications", I don't know what else I can say to do the trick!
235053.1 - A manual just shy of 150 pages on the implementation of Oracle SSWA (Self-Service Web Applications).
1516355.1 - This is another MOS note where the title says it all: "E-Business Applications Performance Basic Skills Cookbook".
Tuesday, December 3, 2013
R12: HR report API error
When we were validating our application after going to R12, we received this curious error message when running a report which would go over database links to the PeopleSoft HR application:
DECLARE
*
ERROR at line 1:
ORA-20000: Error encountered -20000 ORA-20000: Error encountered -20001 ORA-20001: The HR object is invalid
Cause: The HR object which is attempted to be locked is inconsistent with the corresponding object in the HR Schema.
Action: Retry the action with the correct o
ORA-06512: at line 247
Was the problem on our side, in the HR schema locally, or in the PSHR application? A developer that looked into the problem commented this was a message from the API indicating that an update call validation failed due to the record being updated, as opposed to any actual object invalidation. While we had not received anything like that in 11i, we were in the brave new world of R12 and anything is possible!
We followed the recommendation to try again, and this time the report did not fail when it was run. Was the employee data on our side, or PSHR, no longer locked? Did a DBA recompile invalid objects in the interim? We will never know, but I want to share this one in the hopes that it may help you down the road when you are upgrading and to get feedback if you have encountered this behavior too.
DECLARE
*
ERROR at line 1:
ORA-20000: Error encountered -20000 ORA-20000: Error encountered -20001 ORA-20001: The HR object is invalid
Cause: The HR object which is attempted to be locked is inconsistent with the corresponding object in the HR Schema.
Action: Retry the action with the correct o
ORA-06512: at line 247
Was the problem on our side, in the HR schema locally, or in the PSHR application? A developer that looked into the problem commented this was a message from the API indicating that an update call validation failed due to the record being updated, as opposed to any actual object invalidation. While we had not received anything like that in 11i, we were in the brave new world of R12 and anything is possible!
We followed the recommendation to try again, and this time the report did not fail when it was run. Was the employee data on our side, or PSHR, no longer locked? Did a DBA recompile invalid objects in the interim? We will never know, but I want to share this one in the hopes that it may help you down the road when you are upgrading and to get feedback if you have encountered this behavior too.
Monday, December 2, 2013
R12: A Quantum Leap
As a fan of Scott Bakula and the show Quantum Leap, that's the first thing that leapt (pun intended) to mind when we encountered the following issue. :}
Our application servers started to alert because login transactions were failing off and on, so the DBAs took a look and found that several threads from our BPEL 10g middle-tier application were consuming a lot of resources as they appeared to be in ACTIVE status. What caught my eye, was there was no real reason for them to be caught up in the API call they were trying to work on, so I helped to take a look into this some more. Digging into this, the sessions were all marked in gv$session as being in the wait event "resmgr:cpu quantum" from the BPEL 10g machines but I've never EVER seen this wait event displayed. Neither had our DBAs so an SR was opened and out to MOS and the Internet we went, as the wait event encountered has to do with a feature called Resource Manager yet as the setting resource_manager_plan in GV$PARAMETER showed we weren't even supposed to have it running.
Our research on MOS yielded us a direct hit with note 949033.1, another possibility in note 1530676.1 and bug 15915949 about VKRM processes not running (but they were for us), and several blog posts such as this one and another from the same blog helped us look into this a bit further but we were really stuck. Based on the first note, our DBAs ran the following scripts:
execute dbms_scheduler.set_attribute('MONDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('TUESDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('WEDNESDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('THURSDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('FRIDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('SATURDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('SUNDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');
What doesn't make a lot of sense is, a. if we don't have Resource Manager set to run, why do we have to set windows for it and b. how was that going to change the session state of the processes coming in from the BPEL application? All of the threads for VKRM and the BPEL quantum wait state sessions remained in their states after this was run, so what next? Welllllll.....our DBAs wanted to refresh the BPEL connection pools to see what would happen. Nothing changed. Next, Oracle suggested that we should kill off the processes if it was okay but because we couldn't see EXACTLY what they were doing this was somewhat blind and typically killing off sessions will make them go away. :}
In the end, we're not sure what happened to create this condition and we're not sure that it is avoided entirely so I'm expecting that we'll see a part 2 to this post someday.
Our application servers started to alert because login transactions were failing off and on, so the DBAs took a look and found that several threads from our BPEL 10g middle-tier application were consuming a lot of resources as they appeared to be in ACTIVE status. What caught my eye, was there was no real reason for them to be caught up in the API call they were trying to work on, so I helped to take a look into this some more. Digging into this, the sessions were all marked in gv$session as being in the wait event "resmgr:cpu quantum" from the BPEL 10g machines but I've never EVER seen this wait event displayed. Neither had our DBAs so an SR was opened and out to MOS and the Internet we went, as the wait event encountered has to do with a feature called Resource Manager yet as the setting resource_manager_plan in GV$PARAMETER showed we weren't even supposed to have it running.
Our research on MOS yielded us a direct hit with note 949033.1, another possibility in note 1530676.1 and bug 15915949 about VKRM processes not running (but they were for us), and several blog posts such as this one and another from the same blog helped us look into this a bit further but we were really stuck. Based on the first note, our DBAs ran the following scripts:
execute dbms_scheduler.set_attribute('MONDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('TUESDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('WEDNESDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('THURSDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('FRIDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('SATURDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('SUNDAY_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','RESOURCE_PLAN','');
execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');
What doesn't make a lot of sense is, a. if we don't have Resource Manager set to run, why do we have to set windows for it and b. how was that going to change the session state of the processes coming in from the BPEL application? All of the threads for VKRM and the BPEL quantum wait state sessions remained in their states after this was run, so what next? Welllllll.....our DBAs wanted to refresh the BPEL connection pools to see what would happen. Nothing changed. Next, Oracle suggested that we should kill off the processes if it was okay but because we couldn't see EXACTLY what they were doing this was somewhat blind and typically killing off sessions will make them go away. :}
In the end, we're not sure what happened to create this condition and we're not sure that it is avoided entirely so I'm expecting that we'll see a part 2 to this post someday.
Sunday, December 1, 2013
Thursday Twitter (Turkey Leftovers) - 12/01/13
I've obviously missed a few weeks of my Twitter updates, so today you get a massive update following the same format as last time, and we'll see how it goes!
https://twitter.com/JonathanGennick/status/405760725391380480 - Going to skip Cyber Monday? If you like Apress/Alpha books, you might not want to.
https://twitter.com/OracleBlogs/status/405869112456663040 - The new EBS 1099 patches have been released!
Training/Free Stuff:
https://twitter.com/Oracle_EBS/status/401366502588567553 - The EBS team again comes through with a new analyzer for iProcurement items if you are on R12.
https://twitter.com/bobevansIT/status/401394584233590784 - Bob Evans shares with us that SalesForce is having some issues lately.
https://twitter.com/OCPrep/status/401841556979605504 - Do you know what order to take certifications from Oracle? Matthew Morris offers us a primer on it!
https://twitter.com/vjswami/status/402117374108639232 - A scary thought.....is Google what Skynet began as? :}
https://twitter.com/devops/status/402240592752951296 - A great bit on DevOps cycle on the humanity side of things.
https://twitter.com/OTNArchBeat/status/402493505647685632 - Where are you going with your career? Is an architect role in sight? This might be worth a read!
https://twitter.com/thatjeffsmith/status/402535834328387584 - All too often Jeff, all too often.
https://twitter.com/devops/status/402648530046951424 - There's a DevOps conference?!?!
https://twitter.com/ericries/status/402967122118443008 - I think this is a bit harsh, but having experienced the waterfall method a bit I can say I see his point.
https://twitter.com/oraclehardware/status/403129516463489024 - What does Oracle think availability best practices are?
https://twitter.com/dba_hba/status/403133092572831745 - Allan Robertson tell us that Facebook's VP of hardware thinks we are close to open source switches. That's pretty interesting.
https://twitter.com/leight0nn/status/403203127568261120 - Leighton Nelson is interested if you are running Exadata with a ZFS backup device.
https://twitter.com/dba_hba/status/403558860373229569 - Allan has a corrupted LOB to deal with, and found MOS notes 833635.1 & 253131.1 useful in identifying the issue which looked to be a ORA-1555 error initially but was actually an ORA-22924 error in the end.
https://twitter.com/Seth_M_Miller/status/403742348078632960 - Seth has a "problem" with Exadata, and you won't believe what it is!
https://twitter.com/S_Trallori/status/404385548225093632 - Great way to visually show the difference between object and relational databases.
https://twitter.com/fritshoogland/status/404728333466095616 - What does Frits Hoogland think when the wait interface is not good enough?
https://twitter.com/martinberx/status/404939120532672512 - Martin Berger asks a VERY thought provoking question, and with 30+ replies by some of the best in the game it's a good thread to read up on!
https://twitter.com/OAUG1/status/404986743168196608 - OAUG wants to help us learn from some failures on implementing R12.
https://twitter.com/RMOUG_ORG/status/405383027565395970 - This could fall in the announcements category, but I just thought it was interesting that Apple purchased this company.
https://twitter.com/Oracle_EBS/status/405744091746828289 - Did you know there was a Concurrent Analyzer for EBS? Grab it today!
DOAG: There was a LOT of information coming out of this conference, so it gets a section all to itself!
Announcements:
https://twitter.com/cwarticki/status/401353337796182017 - Larry Ellison inducted into the Business Hall of Fame, but the real "announcement" here is his tribute to Steve Jobs.
https://twitter.com/OracleBlogs/status/402869160679833600 - What are the recommended quarterly upgrades for the EBS system? Well, now you can find out!
https://twitter.com/OracleCert/status/404004307579592705 - Last chance to take the Exadata 11g Essentials exam!
https://twitter.com/Oracle/status/405019657796464640 - 25 MORE Twitter feeds that Oracle thinks we should be following, and while I'm not on there right now; I will be, I will be.
https://twitter.com/OracleBlogs/status/402869160679833600 - What are the recommended quarterly upgrades for the EBS system? Well, now you can find out!
https://twitter.com/OracleCert/status/404004307579592705 - Last chance to take the Exadata 11g Essentials exam!
https://twitter.com/Oracle/status/405019657796464640 - 25 MORE Twitter feeds that Oracle thinks we should be following, and while I'm not on there right now; I will be, I will be.
https://twitter.com/JonathanGennick/status/405760725391380480 - Going to skip Cyber Monday? If you like Apress/Alpha books, you might not want to.
https://twitter.com/OracleBlogs/status/405869112456663040 - The new EBS 1099 patches have been released!
Training/Free Stuff:
https://twitter.com/kylehhailey/status/401246600011317250 - Kyle Hailey shares a great way to absorb a lot of TED information in one gulp.
https://twitter.com/Oracle_Edu/status/401434403030581249 - Oracle University wants to help us learn more about EBS end user best practices.
https://twitter.com/oraclebase/status/402811650610188288 - Tim Hall clues us in on the free e-book Multitenant for Dummies from Oracle.
https://twitter.com/OraclePress/status/403563714814951424 - Oracle Press shares a free chapter of the R12 EBS book on Oracle Enterprise Repository.
https://twitter.com/stevefeuerstein/status/403979711354634240 - The Power of Names recorded by Steve Feuerstein for Dell.
https://twitter.com/oraclehardware/status/405003036449583104 - Want an introduction to the Oracle SuperCluster M6-32? Sign up for this webinar!
https://twitter.com/Oracle_EBS/status/405364087858941952 - EBS team lets us know that there are free webinars for R12.1 and R12.2 on how to upgrade.
https://twitter.com/DBAKevlar/status/405709613837713408 - There is going to be an Oracle Innovation Forum in Denver, which gives you a chance to pick Kellyn Pot'Vin's brain!
https://twitter.com/OracleDatabase/status/405788137156538368 - Did you miss the first DBaaS webinar? Well there's going to be another one on the 3rd, so go sign up.
https://twitter.com/oraclemagazine/status/405801388137267200 - A free subscription to the Oracle magazine!
https://twitter.com/Oracle_Edu/status/401434403030581249 - Oracle University wants to help us learn more about EBS end user best practices.
https://twitter.com/oraclebase/status/402811650610188288 - Tim Hall clues us in on the free e-book Multitenant for Dummies from Oracle.
https://twitter.com/OraclePress/status/403563714814951424 - Oracle Press shares a free chapter of the R12 EBS book on Oracle Enterprise Repository.
https://twitter.com/stevefeuerstein/status/403979711354634240 - The Power of Names recorded by Steve Feuerstein for Dell.
https://twitter.com/oraclehardware/status/405003036449583104 - Want an introduction to the Oracle SuperCluster M6-32? Sign up for this webinar!
https://twitter.com/Oracle_EBS/status/405364087858941952 - EBS team lets us know that there are free webinars for R12.1 and R12.2 on how to upgrade.
https://twitter.com/DBAKevlar/status/405709613837713408 - There is going to be an Oracle Innovation Forum in Denver, which gives you a chance to pick Kellyn Pot'Vin's brain!
https://twitter.com/OracleDatabase/status/405788137156538368 - Did you miss the first DBaaS webinar? Well there's going to be another one on the 3rd, so go sign up.
https://twitter.com/oraclemagazine/status/405801388137267200 - A free subscription to the Oracle magazine!
General News/Information:
https://twitter.com/Oracle_EBS/status/401346372756312065 - EBS team helps us learn about FSG Signal 11 errors.
https://twitter.com/Oracle_EBS/status/401366502588567553 - The EBS team again comes through with a new analyzer for iProcurement items if you are on R12.
https://twitter.com/bobevansIT/status/401394584233590784 - Bob Evans shares with us that SalesForce is having some issues lately.
https://twitter.com/OCPrep/status/401841556979605504 - Do you know what order to take certifications from Oracle? Matthew Morris offers us a primer on it!
https://twitter.com/vjswami/status/402117374108639232 - A scary thought.....is Google what Skynet began as? :}
https://twitter.com/devops/status/402240592752951296 - A great bit on DevOps cycle on the humanity side of things.
https://twitter.com/OTNArchBeat/status/402493505647685632 - Where are you going with your career? Is an architect role in sight? This might be worth a read!
https://twitter.com/thatjeffsmith/status/402535834328387584 - All too often Jeff, all too often.
https://twitter.com/devops/status/402648530046951424 - There's a DevOps conference?!?!
https://twitter.com/ericries/status/402967122118443008 - I think this is a bit harsh, but having experienced the waterfall method a bit I can say I see his point.
https://twitter.com/oraclehardware/status/403129516463489024 - What does Oracle think availability best practices are?
https://twitter.com/dba_hba/status/403133092572831745 - Allan Robertson tell us that Facebook's VP of hardware thinks we are close to open source switches. That's pretty interesting.
https://twitter.com/leight0nn/status/403203127568261120 - Leighton Nelson is interested if you are running Exadata with a ZFS backup device.
https://twitter.com/dba_hba/status/403558860373229569 - Allan has a corrupted LOB to deal with, and found MOS notes 833635.1 & 253131.1 useful in identifying the issue which looked to be a ORA-1555 error initially but was actually an ORA-22924 error in the end.
https://twitter.com/Seth_M_Miller/status/403742348078632960 - Seth has a "problem" with Exadata, and you won't believe what it is!
https://twitter.com/S_Trallori/status/404385548225093632 - Great way to visually show the difference between object and relational databases.
https://twitter.com/fritshoogland/status/404728333466095616 - What does Frits Hoogland think when the wait interface is not good enough?
https://twitter.com/martinberx/status/404939120532672512 - Martin Berger asks a VERY thought provoking question, and with 30+ replies by some of the best in the game it's a good thread to read up on!
https://twitter.com/OAUG1/status/404986743168196608 - OAUG wants to help us learn from some failures on implementing R12.
https://twitter.com/RMOUG_ORG/status/405383027565395970 - This could fall in the announcements category, but I just thought it was interesting that Apple purchased this company.
https://twitter.com/Oracle_EBS/status/405744091746828289 - Did you know there was a Concurrent Analyzer for EBS? Grab it today!
Conference News:
https://twitter.com/UKOUG/status/403179392874319872 - In or near Ireland? Well the call for papers for OUG Ireland 2014 closes on the 13th!
https://twitter.com/COLLAB_OAUG/status/403227880601042944 - 575 abstracts were selected by OAUG for COLLAB 14 and here https://twitter.com/COLLAB_OAUG/status/403981499386437632 is the lineup!
https://twitter.com/Enkitec/status/403271073052884992 - The E4 call for papers closes at the end of the year!
https://twitter.com/UKOUG/status/403179392874319872 - In or near Ireland? Well the call for papers for OUG Ireland 2014 closes on the 13th!
https://twitter.com/COLLAB_OAUG/status/403227880601042944 - 575 abstracts were selected by OAUG for COLLAB 14 and here https://twitter.com/COLLAB_OAUG/status/403981499386437632 is the lineup!
https://twitter.com/Enkitec/status/403271073052884992 - The E4 call for papers closes at the end of the year!
DOAG: There was a LOT of information coming out of this conference, so it gets a section all to itself!
https://twitter.com/uwehesse/status/402728736250167296 - Uwe Hesse shares words from Graham Wood about ELAPSED_TIME in v$sql, as does Benedikt Nahlovsky about ASH sample timing https://twitter.com/bnahlovsky/status/402729446752649216.
https://twitter.com/bnahlovsky/status/402778795943292930 - Benedikt also shares what Craig Shallahamer presented for wait events, which is worth some time absorbing.
https://twitter.com/db_inmemory/status/403069574213795840 - Maria Colgan let's us know that she's presenting the In-Memory and Bjoern Rost shows us https://twitter.com/brost/status/403131628106829825 how packed the room was for it!
https://twitter.com/UweHesse/status/403089649318785024 - Uwe tells us that PDB cloning will be available with a future patch, https://twitter.com/UweHesse/status/403095393778823168 a limit on memory consumption hasn't been reached yet, https://twitter.com/UweHesse/status/403096839626719232 that there is some hazy alert.log issues with PDB as well, and https://twitter.com/UweHesse/status/403470105742700544 that creating a PDB clone on ZFS is easy as pie.
https://twitter.com/bnahlovsky/status/403134768948477952 - Benedikt tells us that Maria shared a new column required in Oracle 12c.
https://twitter.com/UweHesse/status/403141180508364800 - Uwe shares with us that an 11g instance running on version 12 needs to be on at least one ASM instance.
https://twitter.com/UweHesse/status/403434903192502272 - Uwe also keys in on the new Backup, Logging and Recovery Appliance and that a full backup is taken only once and then incremental after that.
Social Media:
https://twitter.com/sql_handle/status/401235075200999425 - A way to map out your Twitter followers!
https://twitter.com/ClickTips/status/404959417952522240 - A good tip for bloggers, one I learned about a year in and I wish I had known sooner.
https://twitter.com/Oracle/status/405415164989538304 - Oracle shares The Power of Peer Networks.
https://twitter.com/ClickTips/status/405731473648386049 - Ten steps to successful blogging.
There are a few more days that I could add to this post, but I'll just make a promise instead to be a better blogger and give you a week's worth of Twitter this Thursday!
EDIT: I noticed a few of the hard returns didn't come out exactly right, so I've corrected that.
https://twitter.com/db_inmemory/status/403069574213795840 - Maria Colgan let's us know that she's presenting the In-Memory and Bjoern Rost shows us https://twitter.com/brost/status/403131628106829825 how packed the room was for it!
https://twitter.com/UweHesse/status/403089649318785024 - Uwe tells us that PDB cloning will be available with a future patch, https://twitter.com/UweHesse/status/403095393778823168 a limit on memory consumption hasn't been reached yet, https://twitter.com/UweHesse/status/403096839626719232 that there is some hazy alert.log issues with PDB as well, and https://twitter.com/UweHesse/status/403470105742700544 that creating a PDB clone on ZFS is easy as pie.
https://twitter.com/bnahlovsky/status/403134768948477952 - Benedikt tells us that Maria shared a new column required in Oracle 12c.
https://twitter.com/UweHesse/status/403141180508364800 - Uwe shares with us that an 11g instance running on version 12 needs to be on at least one ASM instance.
https://twitter.com/UweHesse/status/403434903192502272 - Uwe also keys in on the new Backup, Logging and Recovery Appliance and that a full backup is taken only once and then incremental after that.
Social Media:
https://twitter.com/sql_handle/status/401235075200999425 - A way to map out your Twitter followers!
https://twitter.com/ClickTips/status/404959417952522240 - A good tip for bloggers, one I learned about a year in and I wish I had known sooner.
https://twitter.com/Oracle/status/405415164989538304 - Oracle shares The Power of Peer Networks.
https://twitter.com/ClickTips/status/405731473648386049 - Ten steps to successful blogging.
There are a few more days that I could add to this post, but I'll just make a promise instead to be a better blogger and give you a week's worth of Twitter this Thursday!
EDIT: I noticed a few of the hard returns didn't come out exactly right, so I've corrected that.
Subscribe to:
Posts (Atom)