September 29, 2011
My Blog Has Been Broken
It's true, I lost a couple entries due to some file permission problems, then tried to repost them, then the whole thing went South. I'm hoping this will show up where it's supposed to.
Posted by rossm at 8:28 AM | Comments (0)
September 20, 2011
Dewey and 11g Update
The other day I got a bit of time and decided to create the DAD necessary to test PL/SQL from the 11g test database on Dewey. This required getting up early and restarting the webserver, but all went well and now I've got a Dewey DAD to use for testing PL/SQL.
So far, it does appear that the fine grained access control is not active on the 11g upgraded database. This is really good news as it allows for "only" the upgrade to be done at one time, then we can apply the fine grained access control at a separate time. The upgrade process itself will require most of a night to complete.
We need further testing on the FGA control, then I need to get my notes together and document all the things that require special attention before and after the upgrade. Things such as .dbf file location, Mike Huber's "special" items in the listener - and in the old Oracle Home, backup folder locations, database links, directory objects, and so on. The upgrade process tends to leave a lot of things in the 10g Oracle Home, so I want them all moved over under the 11g Oracle Home to keep it all nice and neat.
Posted by rossm at 3:17 PM | Comments (0)
Astra 7.4 Ready for Testing
After many hours on the phone with Astra support, we have finally gotten the 7.4 test verion operational. And, it will import Banner section data. The next step is to connect the accounting software (nightmare) ObjAcct to the test instance so that the WUC events folks can begin working with it.
Also, the Library folks have been looking over the 7.4 version, and like some of its new features. So, we will be scheduling an upgrade of our 7.3 production instance once they become a bit more familiar with the new version.
Posted by rossm at 2:47 PM | Comments (0)