« AERO Doing Well | Main | ASTRA - Still Rolling »
May 7, 2008
10gR1 Instance - Clogged Files and Enterprise Manager
We have a second Oracle database instance, which is a 10gR1 version. It is used to run a dining application, and we are hoping to put Viking on it. So, we have been spending some time making it ready for Viking. It has some definite maintenance issues. Clayton just returned from vacation and was a big help in identifying and getting rid of a 31GB alert log file that had jammed up the works. This db has not been managed up to this point, and of course things don't tend to get better over time especially with regard to the ever growing log files.
We did finally get the HTTP server from our production instance to connect to this instance. Looking back, the setup was pretty straight forward - add a DAD that points to the 10gR1 instance, add in connect information to the tnsnames file, and presto! Since we weren't sure how to set everything up, it did require a lot of trial and error to get it all synched up. But it works now! That is sweet! We only need to have one Apache style web server this way.
The EM console would really be a great help for managing this instance, but what a mess that is. I've gotten as far as getting a repository created and the dbconsole running, but could not connect to the db. So, back to the drawing board, drop the repository and start all over. Unfortunately, this requires the db to be in "quiesce" mode, which messes with the users. Fortunately, there aren't a lot of users on this db. I'm hopeful that one more round of dropping and recreating the EM repository will get EM going to help mange this instance. In the mean time, it is being managed by hand which isn't nearly as good. I am a big fan of the new EM console, but it is a bear to get it set up correctly.
Posted by rossm at May 7, 2008 9:38 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)