Recovering an Oracle Database from Unexpected Failure
Oracle Database Introduction I’ve been a user, developer, and administrator of SQL Server databases many times over the years. I’m really comfortable with that product and how to fix things when they break. Oracle Database on the other hand, I’ve only ever really been a consumer of information. Someone who writes queries to the data. As I’ve worked to expand my horizons in my lab, Oracle Databases are one of the things that I found very interesting. One things about Oracle Databases that I found surprising is that they do not do well in unexpected shutdowns at all. So, to help those that have an Oracle Database server that really don’t know that much (like me!), I’ve compiled a list of things that have helped me get my system back up and running if I have an unexpected shutdown. Getting Connected in SQL*Plus First, if you have more than one Oracle SID on your server, you need to set ORACLE_SID to the SID you want to work on. This should be simple, unless you are like
Hyperion EPM Week In Review: September 14, 2016
Welcome to another later edition of the Hyperion EPM Week In Review. I actually waited a little later this week as it was a really, really slow week. No PBCS updates, no FCCS updates, no on-prem updates. Hyperion EPM Patches and Updates: While this isn’t a patch or an update, the new Profitability and Cost Management Cloud Service has popped up on the Oracle Cloud website. There is a video, some screenshots, and no pricing information. This looks promising… Hyperion EPM Blog Posts: Celvin dug into the new 16.09 patch for PBCS and discovered a major change to the backup process. He also shows off some new Smart View functionality. Glenn has a quick post highlighting the differences in security for PBCS (and Planning) and FCCS. Basically, all of the dimensions are secured by default. Dayalan gives us a peek behind the Essbase covers while taking a look at the Essbase Web Services. Pretty geeky stuff…I love it! Sibin had not one, not two, but three posts this week. First he takes a look at exporting
Hyperion EPM Week In Review: September 8, 2016
Welcome to a really late Hyperion week in review…but hey there was a holiday. This week we have a broken Essbase patch along with a lot of great blogging content. Hyperion EPM Patches and Updates: First off, Essbase 11.1.2.4.012 has been released. Sadly, if you use encrypted MaxL commands…they broke this. So stay away from this patch if you require that functionality! Hyperion EPM Blog Posts: Eric helps everyone get ready for Oracle Open World which is coming up in just over a week. He has a great summary of all of the Hyperion EPM and Oracle BI related sessions that you might find interesting. Cameron has a great post from his guest blogger Igor Slutskiy. He covers using Cell Text data from Planning in OBIEE. This involves some relational wizardry including use of my favorite relational database: The Planning Repository. Cameron also has his own post about a Smart View survey. Do you use it?! He also has a post about his (and Tim’s) meetup at Oracle Open World. I’m a regular attendee at his (and Natalie’s) Kscope
Hyperion EPM Week In Review: August 29, 2016
Monday! I got this done for Monday! Hyperion EPM Patches and Updates: No on-prem updates this week…but we have updates for the cloud! First up, PBCS and EPBCS has a pretty good list of updates. The activity report is at the top of the list. This will show your users, how long their requests are taking, and general usage information. There are a bunch of other updates, but I’ll let you check out the PDF here. I will note that Workspace is dead…long live the simplified interface. Unless of course you are developing, in which case I recommend picking up a torch and pitchfork and going after Oracle due to the insane number of additional clicks required… Next up, FCCS has some of the same updates, like the new activity report. I’m specifically interested in the new Sample Application. More on that later. Both patches will be applied starting this Friday, September 2, 2016. Production patches will start hitting Friday, September 16, 2016. Hyperion EPM Blog Posts: Celvin shows us how to tell which version of
Hyperion EPM Week In Review: August 24, 2016
So…it’s technically Wednesday. Next week I’m totally shooting for Monday! Hyperion EPM Patches and Updates: No updates… Hyperion EPM Blog Posts: Tim has an extremely technical (and awesome) post on maintaining aggregate views after adding a dimension to an ASO cube. This is great for those of you adding a dimension and ties in nicely with his last post. Jason has a pair of posts this week. His first novel post is about Dodeca’s dynamic grouping functionality with relational data. And while he is on the topic of relational data, he has another post about his Virtual Essbase JDBC driver (Vess) and Dodeca for the purpose of subvar management. Lot’s of great content. Tim has a great post on using some of the often overlooked functionality of MDX. He focuses on dimension properties and the PROPERTY_EXPR function. Harry has a new version of his cubeSavvy tool…in Russian. His post is also in Russian. I had to translate the post to make sure it was what I was expecting… Sibin has a pair of posts this
Hyperion EPM Week In Review: August 16, 2016
Welcome to an extremely late edition of the Hyperion EPM Week in Review. Let’s get right to it. Hyperion EPM Patches and Updates: Shared Services 11.1.2.4.004 is now available. Looks like a few bug fixes. Hyperion EPM Blog Posts: Sarah has a post about calculations in Data Viz and playing with the settings to make sure you get the right answer. Celvin has a tip for those of us that switch between Oracle Cloud instances. If you ever accidentally hit the button to save the domain when logging into Smart View, this will help you out. John Goodwin has an excellent post on using the new EPM Automate replay functionality. I love load testing. So does John…and here is part 2. Neha shows us how to use calculation manager variables with Essbase calc scripts. Pretty cool stuff including a CDF. Vijay shows us some sample code for streamlining exports with some cool shell calls with MaxL. Will shows us how to reduce the size of the run time prompts in Planning. This is great for those