Error during Migration BFC V7.5 To V10 SP16

[Former Member]

Hello,

I trie to migrate my oracle dabase from BFC V7.5 to BFC V10 but i've got the message :

Migration failed on data source EXPLOIT_QLT.

Failed to initialize server configured on machine GRW2BFC-QLT.

Failed to initialize structure.

Failed to load one or more objects of type 'Reference table'.

Failed to load one or more objects of type 'Reference table' from the database.

Failed to run database query: 'SELECT DISTINCT a1.id, a2.id FROM ct_reftable a1 LEFT OUTER JOIN ct_period_month a2 ON (a1.id = a2.reftable) ORDER BY a1.id'.

ORA-00942: Table ou vue inexistante

My user have CONNECT and RESOURCE right.

If anyone have an idea...

Regards,

Rachid.

[sirine_belhadjrhouma · Accepted solution]

Hello Rachid,

There are several causes leading to the error ORA-00942:

1-The BFC user used in oracle have a lot of privileges :he must only have CONNECT and RESOURCES as privileges.

2-The BFC user not have the privilege UNLIMITED QUOTA in the tablespace used. You must grant this role to this user

3-You should run the following query before the migration

:

DELETE FROM ct_identifier_pool;

DELETE FROM

ct_recycled_identifier;

COMMIT;

4-You should also check the disk space available on the server and the space allocated on the database. If required,  you should run

the following Oracle query to allocate the required space:

ALTER TABLESPACE <TABLESPACE_NAME> ADD DATAFILE '

<NEW_FILE_NAME>' SIZE <FILE_SIZE>M;

5-You should check that the  tablespace UNDO (is a tablespace system in oracle )is not saturated.

Regards

Sirine.

[Former Member · Accepted solution]

Hello Sirine, here my upload :

1-The BFC user used in oracle have a lot of privileges :he must only have CONNECT and RESOURCES as privileges.

15:33:51 BCATTEAU@QFINX2I1_EXA2DB07> select granted_role from dba_role_privs where grantee='BFC' ;

GRANTED_ROLE

------------------------------------------------------------------------------------------

RESOURCE

CONNECT

2-The BFC user not have the privilege UNLIMITED QUOTA in the tablespace used. You must grant this role to this user

15:35:47 BCATTEAU@QFINX2I1_EXA2DB07> select * from DBA_TS_QUOTAS where username = 'BFC';

TABLESPACE_NAME USERNAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS DROPPED

------------------------------ ---------- --------------- --------- --------- ---------- ---------

BFC_DATA BFC 94094688256 -1 11486168 -1 NO

1 row selected.

3-You should run the following query before the migration

:

DELETE FROM ct_identifier_pool;

DELETE FROM

ct_recycled_identifier;

COMMIT;

--> OK

4-You should also check the disk space available on the server and the space allocated on the database.

5-You should check that the tablespace UNDO (is a tablespace system in oracle )is not saturated.

  1 SELECT tablespace_name,

  2 size_mb,

  3 free_mb,

  4 max_size_mb,

  5 max_free_mb,

  6 ROUND(max_free_mb/1024,2) max_free_gb,

  7 TRUNC((max_free_mb/max_size_mb) * 100) AS free_pct,

  8 RPAD(' '|| RPAD('X',ROUND((max_size_mb-max_free_mb)/max_size_mb*10,0), 'X'),11,'-') AS used_pct

  9 FROM (

10 SELECT a.tablespace_name,

11 b.size_mb,

12 a.free_mb,

13 b.max_size_mb,

14 a.free_mb + (b.max_size_mb - b.size_mb) AS max_free_mb

15 FROM (SELECT tablespace_name,

16 TRUNC(SUM(bytes)/1024/1024) AS free_mb

17 FROM dba_free_space

18 GROUP BY tablespace_name) a,

19 (SELECT tablespace_name,

20 TRUNC(SUM(bytes)/1024/1024) AS size_mb,

21 TRUNC(SUM(GREATEST(bytes,maxbytes))/1024/1024) AS max_size_mb

22 FROM dba_data_files

23 GROUP BY tablespace_name) b

24 WHERE a.tablespace_name = b.tablespace_name

25 )

26* ORDER BY 6 DESC,tablespace_name

15:36:50 BCATTEAU@QFINX2I1_EXA2DB07> /

TABLESPACE_NAME SIZE_MB FREE_MB MAX_SIZE_MB MAX_FREE_MB MAX_FREE_GB FREE_PCT USED_PCT

------------------------------ --------- --------- ----------- ----------- ----------- --------- -----------

AUDIT_DATA 1024 1022 32767 32765 32 99 ----------

SYSDBA1 100 98 32767 32765 32 99 ----------

USERS 5 4 32767 32766 32 99 ----------

BFC_COPY_DATA 108544 18146 122880 32482 31,72 26 XXXXXXX---

SYSTEM 880 173 32767 32060 31,31 97 ----------

BFC_DATA 97792 6276 122880 31364 30,63 25 XXXXXXX---

UNDOTBS2 1615 4 32767 31156 30,43 95 ----------

CONTRAT_LEGI_DATA 512 114 30720 30322 29,61 98 ----------

UNDOTBS1 6935 4199 32767 30031 29,33 91 X---------

SYSAUX 5050 241 32767 27958 27,3 85 X---------

10 rows selected.

But still the same message :

Migration failed on data source EXPLOIT_QLT.

Failed to initialize server configured on machine GRW2BFC-QLT.

Failed to initialize structure.

Failed to load one or more objects of type 'Reference table'.

Failed to load one or more objects of type 'Reference table' from the database.

Failed to run database query: 'SELECT DISTINCT a1.id, a2.id FROM ct_reftable a1 LEFT OUTER JOIN ct_period_month a2 ON (a1.id = a2.reftable) ORDER BY a1.id'.

ORA-00942: Table ou vue inexistante

Regards,

Rachid.

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

CLOSED!