Discussion :

[agdid04]

Bonjour,

J'essaie de migrer une base 10.2.0.4 sur 11.2.0.3 (sur Linux):
J'ai ce message:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
SELECT TO_NUMBER('MUST_HAVE_RUN_PRE-UPGRADE_TOOL_FOR_TIMEZONE')
                *
ERROR at line 1:
ORA-01722: invalid number

Qd je lance: utlu112i.sql sur la base en 10g:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
******************************************************
Recommendations
******************************************************
Oracle recommends gathering dictionary statistics prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
 
    EXECUTE dbms_stats.gather_dictionary_stats;
 
******************************************************
Oracle recommends reviewing any defined events prior to upgrading.
 
To view existing non-default events execute the following commands
while connected AS SYSDBA:
  Events:
    SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
      WHERE  UPPER(name) ='EVENT' AND  isdefault='FALSE'
 
  Trace Events:
    SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
      WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'
 
Changes will need to be made in the init.ora or spfile.
 
*****************************************************
SQL> SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
  2  WHERE  UPPER(name) ='EVENT' AND  isdefault='FALSE'
  3  ;
SQL> SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
  2  WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE';
SQL> EXECUTE dbms_stats.gather_dictionary_stats;

Dans le fichier init, y a plus de parametre caché (_***).
Merci.

[agdid04]

Relance de catupgrd après utlu112i est passée:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
SQL> REM END OF CATUPGRD.SQL
SQL>
SQL> REM bug 12337546 - Exit current sqlplus session at end of catupgrd.sql.
SQL> REM                This forces user to start a new sqlplus session in order

@+