10+ Years Oracle DBA
Oracle Certified Professional 8i, 9i, 10g
Presenter : IOUG COLLABORATE 2008, 2009, 2010,2011
SOBIT UTAH 2003 SETA West 2003, 2004, 2005, 2006, 2007
VOUG presenter 2008
Oracle OpenWorld Presenter 2002, 2004, 2009
SCT/SunGardHE Summit
SETA WEST Track Chair 2004, 2005, 2006 SETA WEST Program Chair 2007,
SETA Presenter – San Antonio, TX 2010, Portsmouth, VA 2010.
Contributor to SANs book “Oracle Security-Step by Step”
Executive Editor for IOUG “SELECT” Journal
Book Author -
para 10 in the migrating to al32utf8, says you will save time by using the test instance, but then it goes on to say you have to recompile the c, and cobol and forms. If they were already compiled in the banner 8 test home whats the purpose of compiling them again ? why wouldn’t you import your banner 7 db, and then do the banner 8 upgrades that effect the db only, skipping the compiles ?
when you use the oracle product that changes the db name, won’t you now have two database’s with the same name (your banner7 version and the newly configured banner 8)
Don,
I didn’t mean recompile at that point. Yes, you are correct everything is already recompiled. I fixed the wording.
Second question- yes you have two databases with the same name. In case the Banner 8 database upgrade fails you can go back to the Banner 7 version.
It would mean changing the entries in /etc/oratab on Unix or recreating the service on Windows.
Renaming using NID is not a requirement but you will have to change a lot of other things (App Server settings, tnsnames.ora) to get all of the clients to recognize the new Banner 8 database with a different name.