|
|
Banner 7 Techical FAQ
Banner® 7 Techical FAQ
Another Year, Another Upgrade
Last Revise Date: 11/02/2006
As of January 2005, Banner® 7 has been released. This version is different in that it is the first one to NOT support Oracle Forms in a Client/Server Environment. Instead all forms will be served using Oracle iAS via Internet Native Banner.®
More information will be added here as it becomes available, but in the meantime, here are some technical specifications on the product.
| Oracle Database Version |
RDBMS 9i or 10g. For 9i, version
9.2.0.6 is required along with
Patches 4080972 and 4015165.
Both are available under Metalink Patch. |
| Oracle Application Server Version |
10g Version 10.1.2.0.2
*Note: 9.0.4.2 will be
desuppported on 12-31-2006 |
| Oracle Developer Version |
Forms 10g |
| Client Server Support |
No |
| Oracle Jinitiator Version |
1.3.1.21 Click here to download. |
| Optimizer Mode |
Rule |
Here's some issues that we've encountered so far.
1. The General 7.0 Upgrade will add a constraint on the GOREMAL Table .
The General 7.0 upgrade will add the following constraint to GOREMAL:
ALTER TABLE GOREMAL
ADD CONSTRAINT PK_GOREMAL
PRIMARY KEY (
GOREMAL_PIDM,
GOREMAL_EMAL_CODE,
GOREMAL_EMAIL_ADDRESS)
USING INDEX
STORAGE (INITIAL &MMEDINX_INITIAL_EXTENT
NEXT &MMEDINX_NEXT_EXTENT
MINEXTENTS &MMEDINX_MIN_EXTENTS
MAXEXTENTS &MMEDINX_MAX_EXTENTS
PCTINCREASE &MMEDINX_PCT_INCREASE)
TABLESPACE &MMEDINX_TABLESPACE_NAME
PCTFREE &MMEDINX_PCT_FREE
;
If your tables has duplicate values the upgrade will fail. Thus clean up the duplicate rows before running the upgrade. For a script that will clean up this table, click here.
2. The Enterprise Version of Oracle iAS 10g version will need to connect to Oracle Internet Directory during the install.
If you try to install the Enterprise version of Oracle iAS 10g the installer will attempt to register the install node into Oracle OID. This will occur regardless of whether you install the portal product. If you DO NOT have Oracle OID, the install will fail. To install the product as a standalone server, get the Oracle Application Server Forms & Reports Services 10g from Oracle Technet. This is a single CD installer and can be downloaded here.
In addition, all inhouse forms must be modified using Oracle Developer 10g Suite Release 2. This application can also be downloaded at the above URL.
3. The Banner® Security Form is now added to Banner® .
Previously, the Banner® Security Form, GSASECR, was always called separately from Banner. However, now it was been integrated and can be called from the main menu screen. The Security form can still be called separately, but you will see a 'FRM-40815:Variable GLOBAL_KEEP_ALIVE does not exist' error. This error can be ignored and the form will still function when the form is called outside of Banner® .
4. Forms must be compiled against the database that they will be run against. Also during the forms compile, you must set the parameter REMOTE_DEPENDENCIES_MODE=SIGNATURE in the initSID.ora file.
If these two things are not done, you will get an ORA-4062 error when attempting to submit jobs. It seems that during the compile, the database signature is getting stored somewhere in the *.PLX. This basically means that no two instances can share a forms codetree at this point.
5. All custom forms (FMBs) must be converted from Forms 6i to 9i sources.
Click here for information on how to perform this conversion.
6. Get to database version 9.2.0.6. Depending on whether you built your database on 9.2.0.4 or not, you may have to upgrade to 9.2.0.6 prior to starting the General 7.0 Upgrade. Get to 9.2.0.6 just to be safe.
7.  Current Patches for 9.2.0.6 that you should apply are the following:
| Bug Number |
Platforms |
Description |
|
#4080972 | HPUX 64-Bit/Solaris 64-Bit |
CONCATENATED INDEX WITH NULL DATE PRODUCES WRONG RESULTS WITH RBO |
|
#4015165
|
Win 32/HPUX 64-Bit/Linux X86/Solaris 32/64 Bit |
SCALAR VARCHAR2 IN BINDS WITH DIFFERENT SIZE RANDOMLY FAILS WITH ORA-06502 |
Each of these patches will require the Oracle OPatch utility. Click here for information on how to get and use opatch.
Note that Oracle's Security Patch Set for October 2005 will de-install patch 4080972. For a workaround to this, click here.
8. Macintosh Support
For Macs that run OSX, you will need to use the Software Update and
install Sun JDK 1.3
or higher. There is no jinitiator for this OS.
For Macs that run Classic (ie System 9) you will need to install the
Macintosh Runtime
Environment for Java (MRJ) which you can get at:
http://docs.info.apple.com/article.html?artnum=120209
this is the jinitiator for Classic Environments:
For both OSX and Classic the ONLY supported browser is IE 5.2.3
There are reports of
INB working on Safari, but this is currently
still not supported.
To download the latest (and last) version of Internet Explorer for Mac, click here.
9. Banner® 7 Help Files
The Online help for Banner® 7 is delivered in the form of a Web ARchive or *.war file.
To install this, you must use 'dcmctl'. For directions on how to do this,
click here.
10. 9.0.4.2 Migration
If you are running Oracle Application Server 10g version 9.0.x, you will need to migrate off this version soon, as support will end on 12/31/2006.
|
|
|
