upgrade from Oracle 8.1.6 to Oracle 8.1.7.2.1

[mike73]

I have a little doubt on how this going to work and here is the scenarios.

I will upgrade my database to ORacle 8.1.7 and I need to migrate my database two 8.1.7. I will have two Oracle Home on my server b/c some of the database I need to leave them running on 8.1.6.

The questions I have is what do I need to do with the init.ora for those database upgraded to 8.1.7 ???

please help me to clear this issue.


Thanks

[reydp]

If your o.s. is NT then I discourage not to do so, you might end up loosing your other DB as well.

If it is unix, try to bear in mind the ff:
1. be sure to source the environment applicable for the new oracle installation and db like ORACLE_SID, ORACLE_HOME, ORACLE_BASE.
2. Never use directories that is utilized by previous oracle setup.
3. Edit initSID.ora parameter DB_NAME, control_files, log_archive_dest and dump file destinations.

backup your db before any changes to be made.

[aarroyob]

Hi Mike73,

If you make the upgrade with export/import or the migration utility, after upgrade you need to configure your $ORACLE_HOME_8.1.7/database/init_sid.ora to point to the actual init or change it to other location, putting something like this

IFILE='/home/oracle/config/init_sid.ora'

I always put the init.ora out of software and only have a pointer to the the init.ora.

Hope this helps

[mike73]

Aarroyob,

Can you tell me a little about the IFILE???

What do you mean by IFILE='/home/oracle/config/init_sid.ora' ???

Is that where the '/home/oracle/config/init_sid.ora' your old init.ora from 8.1.6 database.

I am a little confused and thanks for your help

[edsperez]

Another way of doing this upgrade is

1. Install the oracle 8.1.7 in the new home
2. make a cold backup of your existing database (8.1.6)
datafile,controlfile,logfile, init. ora file
3. Copy it to a different location.
4. set up your environment for the new oracle home
5. mount the new database.
6. rename the data file, log file to reflect the new location.
7. run the upgrade script (go to metalink and get the script that you need to run)