How to migrate from 10g to 12c via data pump on same server?
High level steps are as follows:
For 10.2.0.2 to 12c is via data pump on same server, (assuming database is low in size) following are the steps I can think of at this moment
Pre-Migration Steps:
- Download 12c on the database server
- Extract 12c software
- Create directory for 12c home
- Install 12c on new database home
- Create a new database in 12c
- Get all tablespace and their sizes from 10g database
- Create all tablespace with the appropriate sizes in 12c database that you just created.
- Get a downtime
Migration (during downtime):
- Stop listener
- Shutdown database
- Startup restrict
- Take full export via data pump from 10g
- Import via data pump in 12c
- While import is going on, copy the contents from old listener.ora to new 12c listener.ora file
- While import is going on, copy the contents from old tnsnames.ora to new 12c tnsnames.ora file
- When import is done, run utlrp.sql
