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 –

Oracle Database 11g Underground Advice for Database Administrators






2 Responses to About

  1. Don Thaler says:

    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)

  2. aprilcsims says:


    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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s