Oracle Switch TP1996-9.2.2.1A Manuel D’Utilisation

 

You
perf

à 

se to be upgraded, you should know the following: 

our

 

urce and destination Oracle Homes, if necessary. 

à 

Validate the TNS entries of the source and destination databases. 

On a command line, change ORACLE_HOME to point to the Oracle Home of the source 
database, then try to connect to it. Repeat this procedure for the destination database. 

à 

Make sure the destination database user is empty and does not contain any schema objects in 
its schema. 

This does not apply if your source database will also be your destination 

 should validate the source and destination databases to ensure a successful upgrade by 

orming the following checks: 

à 

Run the latest averify script on the source database and fix any errors. 

For each databa

y 

S

ce and destination database user and password 

y 

Destination system user and password 

y 

TNS configuration for source and destination database on the respective database 
systems 

y 

Paths to the Oracle Homes 

Map the so

à

database. 

à 

Make sure the source and destination database users have the same roles and privileges. 

à 

Make sure the Agile tablespaces in the destination and source databases match. Also, the 
destination database should have unlimited tablespace. 

à 

Verify that the tablespace size in the destination database is more than that of the source 
database. 

 

viii 

Database Upgrade Guide