| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.1 -> 7.3 migration
Sandy Thrasher (sandra.thrasher_at_MCI2000.com) wrote:
: I've ugraded recently from 7.1 to 7.3 and had no major problems. Here is
: the basic steps:
: 1. Export your entire DB - perform a FULL export to get all data.
: 2. Delete your entire DB.
: 3. Install the new version of Oracle.
: 4. Recreate your DB.
: 5. Import your saved data - perform a FULL import to get all your data.
Why?!! Why not database migration? Start 7.3-orainst with 7.1-environment ($ORACLE_HOME, $ORACLE_SID, etc) and with your db-files. Look at $ORACLE_HOME/rdbms/install/rdbms/*.sql scripts for manual upgrade.
: We only had to change some of our Apps. The new Oralce Precompiler on the
: HP 10.20 had us make some minor mods.
: We had to change the way we implemented Database Links. These were done
: with OPS$ accounts and did not specify a user/password. However, 7.3 did
: not seem to support this, so, we changed to specifiying an account in our DB
: link definition.
Strange! Our Oracle 7.3 supports OPS$ accounts.
: Also, SQLDBA gets replaced with SVRMGR so we had to modify all or our DBA
: scripts to use the new code. No changes were required to the actual code
: however.
Well, orainst will remove sqldba and install svrmgrl and svrmgrm, but sqldba from 7.1 with DB 7.3 runs fun after it restoring!
: Sandy
Regards!
 |
 |