Tips for upgrading Oracle10g from Oracle9i (1)

I have posted an article about upgrading Oracle9i to Oracle10g on the Internet. I will share it with you here. A simple version of transport tablespace was upgraded to Oracle10g. Of course there will be more ways to upgrade Oracle10g. The following is a simple explanation.

How to upgrade Oracle10g:

1. First create a mongouard database for the master database (which can be done online)

2. Install 10g software on the javasuard Library (which can be done online)

3. sort out some things that cannot be done through transport tablespace, such as sequence, synonyms, grants ......

4. Stop all write applications in the master database and provide the read Service (stop writing and query)

5. Forcibly archive the redo log of the master database and upload it to mongouard for recovery (the write is stopped and query is provided)

6. Use transport tablespace to convert the database version and create sequencee, synonyms, grants and so on (stop writing and provide query ).

7. Verify the new environment. If any problem is found during the verification process, you can switch to the original system (stop writing and provide query ).

8. Switch the application to a 10 Gb database to provide services)

Amadeus completed, and in 10 minutes during the drill and successfully switched the system. Considering their database busy and huge database capacity, this was a great achievement. We can learn from their methods in the future database version upgrade process.

Verify that transport tablespace can be used for version upgrade.

Create a test tablespace in the 9i Database

 
 

  
  
create tablespace test  
  
  
datafile '/opt/oracle/test.dbf' size 10m   
  
  
extent management local autoallocate; 
 
 

Create a table in the test tablespace

 
 

  
  
create table test1(a number) tablespace test;  
  
  
insert into test1 values(1);  
  
  
commit;  
  
  
SQL 9i>select * from test1;  
  
  
         A  
  
  
----------  
  
  
         1  
  
  
 
 
 

Set the test tablespace to read only.

 
 

  
  
alter tablespace test read only;  
 
 

Metadata of test tablespace everywhere