Banner/Oracle User Conference

Yesterday I attended a Banner/Oracle user conference at Wellesley College. This annual, one-day event of largely peer presentations was a great opportunity for networking and knowledge exchange. Here are some of the take-homes I got out of this conference in no particular order. These are just my observations and opinions and pertain to the scope of our institution and environment.

Oracle Database

Marc Kelberman, Oracle pre-sales engineer for higher-ed gave a presentation on RAC/Grid control and SQL Developer.

Very few have moved from 9i to 10g. Those who have, or will soon, are going straight to 10gR2.

It is important to go to the latest patchset for 10gR2.

Oracle’s RAC/Grid technology is very cool, but it is unlikely it would offer much to our small (6,000 student) university. Larger universities may benefit from it.

Grid/RAC requires a shared storage architecture.

It would take a great effort between systems, networking and database administrators to implement RAC/Grid.

Around 75% of the institutions I spoke to were running Oracle on Sun Solaris.

None of the institutions I spoke to were running Oracle on Linux.

None of the institutions I spoke to were running clustering/RAC/Grid Control.

Several institutions are running some type of network attached storage (NAS) to store their data files.

One institution (I believe this was the host institution, Wellesley) is running their Oracle home directories on network attached storage. This allows them to maintain only one oracle home per database version saving hours of work per upgrade.

Most institutions are still relying on cold backups as their primary backup method.

Only a couple institutions I talked to have adopted Oracle RMAN for backups.

Oracle SQL Developer

Marc did a good demonstration of SQL Developer, but this product is hard to appreciate until you’ve used it. Thankfully it’s free, so there’s no good reason not to test drive it.

Identity Management

Dan Sterling, Chief Technology Architect for SunGard Higher Education presented on SunGard HE’s plans for identity management. It looks like they will focus on integrating with third party tools via open standards.

Banner Student Information System

One university mentioned that when a user asks for a modification to their student information system they require that the user submit a request for product enhancement with the vendor before a local modification is made. This seems like a good policy.

Final thoughts

The relatively small number of attendees made this conference great for networking. It’s very interesting to interact with universities of different sizes. Some of the universities in attendance had one administrator for their Oracle databases, application servers and application support, while others have a large staff and highly individualized positions.

Though this conference happens near the end of the academic year it was a nice diversion from summer planning. Beyond the networking, the take-homes are more than worth the day out of work.

oracle, banner, sungard he, summit, conference, higher education, database, database administration, database development

4 thoughts on “Banner/Oracle User Conference”

  1. I am an Oracle databaseDeveloper and an accountant and i am workong on the finance modele in banner system
    id like to know how far i could use my knowlege to improve the use of banner
    for example can i desing forms that meets my use or chenge or add in afunction to the exiting form ?? same in the reporte , how fare is banner open sourse
    another Q
    is banner finance modele is one of the besiness tools of oracle or is it a pure sungarde designe?

  2. Alaa,

    First, in the interest of full disclosure, I currently work for SunGard Higher Education, the makers of Banner. I was not working for them when I wrote this article, but I am now.

    Yes, you can use your knowledge to change or extend the functionality of Banner. SGHE even offers a course which will teach you how to develop forms and functions in a way which will be compatible with the existing environment.

    I would warn you, as I do all clients who ask about modifications, that anything you develop will require extensive testing and possible future modification, so it’s best to keep modifications to a minimum.

    If you’re interested in the course offerings you should talk to your Banner account manager or project manager. We have some outstanding trainers and the courses are really invaluable. If you learn well from books and have the time you can learn everything you need to from the docs, but a couple classes could save you months of discovery.

    To the best of my knowledge the Banner finance module was written entirely for Banner.

    Hope this helps.

  3. Hi,
    are you still working with Banner? My client is using Banner system and i really don’t have much idea on this. Maybe you can point me to some docs, and URL’s that may enhance my understanding on Banner and improve my skills. By the way I’m an Oracle DBA/Developer.

    Was there a great job demand for banner System? Thanks.

  4. Tripti,

    Most of the Banner documentation is only available to clients through SunGard Higher Education’s UDC support site. Employees of Banner institutions should be able to obtain a login, but if you’re contracting with an institution that may be different.

    There is a strong and consistent demand for folks who know Banner, but since it is used primarily in higher education the jobs are often in odd locations rather than being centered around major metropolitan areas.

    Good luck.

Leave a Reply

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