|
|
ERP system migration
about change the IP and host change the following files
1 . /etc/hosts
2. /etc/nodename
3. /etc/net/ticlts/hosts , /etc/net/ticots/hosts,/etc/net/ticotsord
B system setup steps:
1. tar the oracle home to B system
2. tar the application to B system
3. tar the user home to B system
3. copy /etc/passwd, shadow, group to B system
4. copy the listener.ora, tnsnames.ora, oratab, dbhome ... to B system
5. copy the cold backup data file to B system layout the new mount point
6. prepare the alter datafile rename scripts(first get file list from A system)
about the datafile rename refer to the database administration
ALTER DATABASE <dbname> rename file '<device>:[<directory>]<filename>' to '<device>:[<directory>]<filename>';
7. start the database mount ,excute the rename datafile scripts
SQL> connect internal
SQL> @rename_file.sql
SQL> alter database open
8. Back up the controlfile to trace
9. shutdown the database with normal or immediate
10.Go through the .profile, .cshrc, .login, oratab, tnsnames.ora ,listener, and redefine the ORACLE_SID environment variable to a new value.
11..mv control to new file
12.change the directory to "dbs", change the initialoldsid.ora to initialnewsid.ora and make sure the control_file does not point the
old file name,change the DB_NAME to the new name
13.Edit the dump file created in Step 8, detail Metalink: Note:61590.1
14.open the database : SQL>alter databse open resetlog
I only do the ERP migrate to another system last years, maybe some steps
omit.this procedure only for reference . about the application change, I think need more pay attention to .I will update this next week. |
|
楼主: remen
IP卡
狗仔卡
楼主
显身卡
发表于 2004-11-17 11:02
