i’ve just migrate the old repository DataBase From Oracle 8 to Oracle 9I.
i’ve this mistake when i try to create new repository with new DB oracle 9I connection:
create table OBJ_M_ACTOR (M_ACTOR_N_ID NUMBER(10) not null, M_ACTOR_N_TYPE NUMBER(10) not null, M_ACTOR_N_LEVEL NUMBER(10) not null, M_ACTOR_C_NAME VARCHAR2(70) not null, M_ACTOR_C_PASSWORD VARCHAR2(70), M_ACTOR_N_AUTID NUMBER(10) not null, M_ACTOR_N_LAD NUMBER(10) not null, M_ACTOR_N_LAT NUMBER(10) not null, M_ACTOR_N_STATUS NUMBER(10) not null, M_ACTOR_N_ENDING NUMBER(10), M_ACTOR_N_CNTDOWN NUMBER(10))
MasterRepository () function fail:
SQL.MASTER.Create.Table.Actor
N/A:ORA-00955: Ce nom d'objet existe déjà
Création du domaine sécurité impossible. (ADW0020)
why? i cant use old repository and must use a new dataBase?
right, i’ve chosen default installation, in fact, i must choose repare old installation to migrate repository but i’ve an error too !
i’m just following the BO step describe in their documentation.
1/ i’ve migrated DB repository from oracle 8 to oracle 9I
2/ i’ve installed BO 6.5
3/ i’ve created a new bomain.key in launching supervisor and clicked Admin.
4/ then i’ve chosen “repare an installation” and it was allright!
5/ now i’m connect with SUPERVISOR so i tell me to migrate repository from BO5 to BO 6.5. I click OK
6/ then i’ve this error message :
(it’s a translation! )
[LILOO voice] HELP, PLEAAAAASE........HELP
Preparation to update the number of version, and to add or abolish tables if necessary.
Check on domain world " DomUnv " connection in domain world failed. (UX0038)
Error during the updating. (ADM0169)
Hi,
In your migration you have to taken care of your database migration and also repository.So as a safest measure.
1.First you migrate your v5 Database in oracle8i to oracle9i.Then reconfigure the bomain key to v5 with oracle9i.
2.Then you install the BO6.5 in that system and then upgrade it to 6.5.
Actually i did the migration from 5.1.3 to 6.5.1.From db2 to sqlserver.
what do you means with “reconfigure the bomain key”?
i’ve created a new bomain.key, in launching supervisor and clicking Admin, with connection on migrated Oracle9I DataBase
it just says it doesn’t find Univers Domain ‘DomUnv’ when it try to upgrade repository to v6.5…
when i launch SUPERVISOR it just tell me it will migrate repository yo version 6.5 then it stops and give me an error! it doesn’t find the univers domain.
i don’t understand!
the 3 domains(security,univers and document) are in the same DataBase i’ve migrated to ORACLE 9I and i’ve used to create the BOMAIN.key…
so, normally, it could migrate the repository…but no!
my problems were the univers and document domains migrations!
in fact, when i’v tried to migrate Repository, BO has changed security domain connection string, but it hasn’t changed the universe and document domains so the new repository searched these 2 domains in the old DataBase!
fine!
so the procedure is :
1/ copy DataBase
2/ connect DB with SUPERVISOR 5.0 and change connexions strings to unviers and document domains.
3/ migrate DB to Oracle 9I
4/ migrate Repository to BO v5.1.7
5/ migrate Repository to BO v6.5.1
our repository sits on DB1 wwhich is in Oracle 8
our universes point at DB2 which is on orace 9i
AND I need to upgrade from version 8 to 9 on oracle before I do anything
Are these steps correct for the repository migrationa
DATABASE SIDE
i) copy database DB1 from oracles 8 on DB1 to oracle 9i DB3
2) launch supervisor 5.1.9 and regenerate the BOMain.key file , change the document and universe connections now
3) distribute this bomainkey file to users
CLIENT SIDE
Install Superviosr 6.5.2 on my machine
Launch supervisor 6.5.2 and run the upgrade utility
cnahge the connections on universe and document domains.