database upgrade

so for the past few days I have been playing with contentDB installation. It has been an eye opener. I am relatively new to Oracle (10 months now) and have little experience as a DBA. I have been a Unix admin, software developer, and system architect for a variety of companies. I was a Solaris expert from the early years and remember how difficult it was to install, configure, and upgrade Solaris (at the time called SunOS). I have played with Tomcat at a variety of jobs and even used the iPlanet/Sun Application Server. I am surprised to say that the Oracle suite of products suffers from the same problem that most public domain code and Linux installations suffer from; poor documentation and inadequate dependency checks.

I decided to install contentDB. To do this, I installed the database, version 10.2.0.1 which is the full image that can be downloaded. I got the install working, the os with the right packages, and the accounts and kernel parameters correctly configured. I download and unzip the soa suite and find out that I need to upgrade the database to at least 10.2.0.2. No problem, right? I didn’t initialize any data elements other than the sample database. The upgrade should go easy. WRONG! I downloaded the 800M+ bundle and unzipped it. I execute the runInstaller and watch as the messages go by. I assumed that it would halt the services and upgrade what was needed. It posts a message saying that I need to stop the services managed by the ORACLE_HOME that I have defined. It didn’t say what the processes were or how to see what was running. It just said that I needed to stop something and it was up to me to figure it out. I eventually figured out that I needed to stop the listener, the sql service, the enterprise manager, and the database. It seems like there would be a stopall command that would make this happen.

Once I got everything stopped, I started the upgrade package and it finishes without any warning. Since I only installed the demo tables I thought that I was finished and could connect to the database. WRONG! I forgot to upgrade the database once I upgraded the binary packages. It seems like the upgrade process should have done this for me or at least asked me if I wanted it done. It took me a few hours to figure this one out but I waded through the manuals and forums and got it working.

Now that I have the database upgraded to 10.2.0.3 and OEM reports that it is the right version and everything is properly running. I started the runInstaller for the soa suite. This comes up with a few questions and starts checking for dependencies. I appreciate this but the error message that comes up is of little or no help. Some required prerequisite checks have failed…… What prereqs? A little more detail here would be helpful. A link to a web page? A list of failures?

Am I off base asking for a little more detail here? In the early days of Solaris, these were common error messages. It almost harkens back to Windows messages. “Error: You can’t do anything now” with a Reboot button. Ok, I was a little harsh on the error message, I actually do get an error message in the universal installer screen. It seems like the error window should drop me into the reporting 1 error, 1 requirements to be verified screen that lists the error. The error appears to be easily fixed, gcc-c++ is not found. Fortunately, I had to upgrade the gcc installation for my version of Red Hat Enterprise 4 so I have the iso already mounted. Once I got the prereqs resolved, it complains that there isn’t a ORABPEL schema on the database that I am using. I guess it is back to the manuals to figure out the schema elements that I need to install and configure.

363 thoughts on “database upgrade”

  1. I enjoy you because of all of your efforts on this web page. My mother really loves carrying out internet research and it is obvious why. Almost all hear all of the dynamic tactic you create insightful tips and hints through the blog and even welcome participation from website visitors on this situation so our own girl is without question being taught so much. Take pleasure in the rest of the year. You are carrying out a superb job.

  2. I want to point out my gratitude for your kind-heartedness supporting visitors who actually need help with this particular area. Your personal commitment to getting the message all over turned out to be quite effective and have all the time permitted many people just like me to get to their goals. This interesting key points indicates this much to me and further more to my office colleagues. Thanks a ton; from each one of us.

  3. I precisely wanted to appreciate you once again. I’m not certain the things I would have implemented without the techniques shown by you concerning such a concern. It had become a real daunting concern in my position, nevertheless looking at your well-written style you solved it forced me to leap over joy. I am just grateful for the assistance and hope you comprehend what an amazing job you were putting in training men and women with the aid of your blog. More than likely you have never got to know any of us.

  4. I actually wanted to write down a small note so as to appreciate you for those pleasant tactics you are showing here. My extensive internet investigation has at the end been paid with good points to go over with my two friends. I would repeat that we website visitors actually are rather lucky to be in a really good place with many perfect people with insightful guidelines. I feel very much lucky to have come across your webpages and look forward to plenty of more fabulous moments reading here. Thanks a lot once again for all the details.

  5. I simply wanted to type a simple message in order to express gratitude to you for all of the nice ideas you are giving out here. My prolonged internet investigation has now been rewarded with extremely good knowledge to exchange with my friends and classmates. I ‘d believe that we visitors actually are unquestionably lucky to live in a remarkable website with so many outstanding people with interesting techniques. I feel very fortunate to have come across the weblog and look forward to so many more thrilling times reading here. Thanks once more for all the details.

  6. I simply wished to thank you so much again. I do not know what I might have handled without these hints revealed by you concerning such a question. It truly was an absolute terrifying case in my position, but taking note of this skilled form you solved the issue took me to leap for gladness. I am just thankful for the guidance and then have high hopes you recognize what a great job that you’re doing instructing some other people via a blog. I am sure you have never got to know all of us.

  7. I am just writing to let you understand what a impressive discovery my friend’s girl obtained checking your webblog. She learned such a lot of things, most notably what it is like to have a great teaching style to have the mediocre ones without difficulty thoroughly grasp specified advanced subject areas. You actually exceeded readers’ expected results. Thank you for distributing these useful, safe, edifying and in addition unique tips on your topic to Ethel.

  8. I simply wanted to thank you so much yet again. I do not know the things I would have gone through without the methods shared by you relating to such theme. It was actually a difficult scenario for me personally, nevertheless observing a well-written strategy you managed it made me to leap for fulfillment. Extremely happier for your guidance and in addition sincerely hope you really know what a great job you happen to be doing training men and women using your websites. I know that you have never met any of us.

  9. I enjoy you because of all your labor on this site. My mother take interest in engaging in research and it is obvious why. Most of us hear all concerning the lively means you produce worthwhile guidelines via your web blog and therefore increase contribution from other individuals about this subject then our child is understanding a lot of things. Have fun with the rest of the year. You’re carrying out a tremendous job.

  10. A lot of thanks for your own work on this web page. Kate enjoys carrying out research and it is obvious why. Almost all hear all of the lively form you offer vital techniques by means of this website and as well as increase contribution from visitors on this subject matter so our own simple princess is without question understanding a whole lot. Enjoy the remaining portion of the new year. You are performing a brilliant job.

  11. I must show my appreciation to this writer just for bailing me out of this matter. Because of searching throughout the internet and finding solutions which were not helpful, I thought my life was over. Existing without the solutions to the issues you have solved by means of your entire short article is a serious case, as well as the ones which might have adversely affected my entire career if I hadn’t noticed your web blog. Your own personal competence and kindness in taking care of all the stuff was important. I am not sure what I would have done if I hadn’t come upon such a stuff like this. I can at this time look ahead to my future. Thank you very much for this skilled and effective guide. I won’t hesitate to refer your blog post to any individual who would like direction about this situation.

Leave a Reply

Your email address will not be published. Required fields are marked *