Volker, I don't know what the situation is now, but, this was the note
passed to me by support when we had 10.2 running, additionally since you
have change to a multibyte character code, which pretty much means
backing up and restoring the db into a new db (at least our dba's felt
that was the easiest) you are best off moving to Oracle 10, as it will I
suspect become something they require later anyway.
---------------------------------------------------
Oh yes - there are ways to make this happen on a Oracle 10g2 server - but please read to the end:
This problem only started in 10GR2 because 10.2 reduces the Connect role's privileges to one, the CREATE SESSION privilege. Users granted the Connect role will no longer have CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE CLUSTER, CREATE SYNONYM, CREATE DATBASE LINK, CREATE SEQUENCE, ALTER SESSION privileges granted to them.
Presumably these changes for Oracle 10gR2 also include updates to the JDBC driver and Oracle client software shipped with our product. At least it is not clear at this time whether the 10.1.x drivers shipped with our current versions are fully compatible with 10gR2. Thus we cannot officially support 10gR2 at this time, nor can we recommend to clients to work around the above privilege limitation. Anything they do in this direction would be fully at their own risk.
That said, here's what it takes to make the 7.x installer work on 10gR2. These changes would need to be made before running the installer.
* the first option is to grant the necessary privileges explicitly. I frankly don't know which of the privileges that CONNECT traditionally entailed are really needed by our app, but at minimum you'd need to GRANT CREATE VIEW TO BB_BB60; and GRANT CREATE TABLE TO BB_BB60; as well as GRANT CREATE SEQUENCE TO BB_BB60 (and similarly for the other users, of course). You should also include GRANT ALTER SESSION TO BB_BB60; so that one can within this role troubleshoot performance problems by altering init parameters on a per-session basis and see alternative explain plans.
* Starting with 10g Release 2 (10.2), Oracle provides a script called rstrconn.sql located in the $ORACLE_HOME/rdbms/admin directory. After a database upgrade or new database creation, this script can be used to grant back the privileges removed from the CONNECT role in Oracle Database 10g Release 2 (10.2). Log in AS SYSDBA on the DB server itself and execute: @?/rdbms/admin/rstrconn
I really would like to say; go for it but I cannot: you will be out of support
and there are several untested areas that we cannot know how Blackboard would react.
Hence the answer is, please downgrade Oracle 10g1
------------------------------------------------
So me, I'd avoid anything they arent entirely happy with.
Regards
Jim
Volker Kleinschmidt wrote:
> No, you don't need Oracle 10g, you can use 9.2.0.8 just fine with
> Blackboard R7, 7.1, and 7.2 and it is fully supported. Also, Oracle
> 10gR2 is actually not broken, it just requires running
> @?/rdbms/admin/rstrconn.sql (while logged in AS SYSDBA on the
> DB-server itself, from a shell into which you're logged as oracle
> user) before installing Blackboard, so that the CONNECT role has the
> same privileges it used to have in earlier Oracle versions. Without
> doing this, the database users created by the installer won't have
> sufficient privileges to create tables, views, etc. Note that Oracle
> 10gR2 is supported only with Bb 7.1SP1 and higher.
>
> --Volker
>
> On 10/16/06, Jim Boone <[log in to unmask]> wrote:
>
>> A challenge indeed, and learn from our mistake, not Oracle 10g, Oracle
>> 10.1.x, no don't get clever and think that 10.2 sounds like a good idea,
>> because it isn't, it's very broken, your dba may tell you that 10.2 is a
>> better product which clears up some important issues from 10.1 but
>> ignore them, BB won't work, and you'll just end up destroying the
>> database, reinstalling it, and re-running your import, and hiding from
>> your users.....
>>
>> Regards
>>
>> Jim
>>
>> Mark Gamble wrote:
>>
>> >We've just gone through this process and I have to tell you it's been
>> ><ahem> a challenge. When are you planning to go live? You will need
>> >Oracle 10g - and it will need patching - and you must ensure you have
>> >the latest version of Java. By all means contact me off list. My best
>> >advice would be get your Oracle dba on the phone with your TSM. And
>> plan
>> >for a long lead-in.... next AY?
>> >
>> >__
>> >Regards
>> >Mark
>> >
>> >Mark Gamble
>> >Head of Learning Technology
>> >University of Bedfordshire
>> >Tel (+44)1582 489260 Fax (+44)1582 489259
>> >Mob 077 200 686 05 Mobex 6360 Int ext 2260
>> >
>> >[log in to unmask]
>> >
>> >
>> >
>> >
>> >>>>[log in to unmask] 13/10/2006 15:33 >>>
>> >>>>
>> >>>>
>> >Hi all
>> >
>> >Here at GCNS we are moving from Blackboard 7 Basic to Enterprise
>> >Edition
>> >of Blackboard. We have now heard from Blackboard the Oracle database
>> >that
>> >comes bundled with Basic is not good enough for Enterprise and we will
>> >
>> >need to purchase an Enterprise licence of Oracle as well. Does anyone
>> >else
>> >use Oracle Enterprise Edition and is there an academic licence
>> >available
>> >at a lower cost.
>> >
>> >
>> >
>> >
>>
>>
>> --
>> Jim Boone
>> --------------------------------------------
>> Buckinghamshire Chilterns University College
>> R&D Manager - Information and Communication Technologies
>> Tel: 01494 522141 ext 3569
>>
>> The myth that Bill Gates has appeared like a knight in shining armor
>> to lead all customers out of a mire of technological chaos neatly
>> ignores the fact that it was he who, by peddling second-rate
>> technology, led them into it in the first place, and continues to do
>> so today.
>>
>> ~Douglas Adams~
>>
>
>
--
Jim Boone
--------------------------------------------
Buckinghamshire Chilterns University College
R&D Manager - Information and Communication Technologies
Tel: 01494 522141 ext 3569
The myth that Bill Gates has appeared like a knight in shining armor to lead all customers out of a mire of technological chaos neatly ignores the fact that it was he who, by peddling second-rate technology, led them into it in the first place, and continues to do so today.
~Douglas Adams~
|