[ Pobierz całość w formacie PDF ]
.7.Enter the ORACLE_SID for the database to be migrated at the prompt.8.Select the Migration Utility: ORACLE7 to ORACLE8 at the Software AssetManager screen and select the Install button.Upgrading and Migrating 5-13UpgradingThe Installer prompts you for the information necessary to invoke theMigration utility.Table 5 3 lists the prompts and provides additionalinformation about them.Table 5 3 Migration Utility PromptsPrompt InformationEnter sid Enter the instance name, or sid, of the database you aremigrating.Do you want to be Unless you are certain you can use all the default values,prompted for all answer Yes to this prompt.command options?Spool output? Spooling the output of the Migration utility gives you a recordof the actions taken in the migration.If you decline this option,output is sent only to standard output.Space-check only? This Migration utility has the ability to check for adequatespace in the SYSTEM tablespace.Accepting this prompt meansthat the utility will only check the space; it will not perform themigration.DB_NAME = sid? Specify if database name is the same as the sid (onsingle-instance systems they are generally the same).Changing database Indicate if you are changing the name of the database duringname? the migration.PFILE Enter the path and filename of the init.ora parameter file tobe used with the sid database.NLS_NCHAR If the value of the NLS_NCHAR is different from the value thatthe database was created with, enter the correct value forNLS_NCHARMULTIPLIER If the value for MULTIPLIER is different from the value that thedatabase was created with, enter the correct value forMULTIPLIER.Change character set? If you want to change the storage character set during themigration, enter the new character set (valid character sets arelisted in Appendix C,  National Language Support ).Skip space checking? If you are certain that the SYSTEM tablespace has enough spacefor the Oracle8 data structures, you can specify that theMigration utility not perform space calculations.5-14 Oracle Web Application Server Installation Guide for LINUXUpgradingTable 5 3 Migration Utility Prompts (Cont.)Prompt InformationInformation The Installer displays the full command it will use to invokethe Migration utility.If any part of the command isunsatisfactory, you can select the Back button and re-enteranswers to the prompts in this table.Last chance.Confirm or abort the migration.Despite the warning from theInstaller, it is still possible to abort the migration after thispoint.Issuing the ALTER DATABASE statement (page 5-16) isthe point beyond which you cannot halt the migration.Information The Installer reports whether the Migration utility hascompleted successfully.Information If there are additional databases under the ORACLE_HOMEdirectory, you can migrate them by returning to the SoftwareAsset Manager screen, then selecting the Migration utility andInstall button again.Rename or remove The Installer instructs you to rename or remove all control filescontrol files.used with the Oracle7 database.Run the root.sh script.You can ignore the prompt to run the root.sh script aftermigrating the database.Complete the Migration Perform the following steps to complete migrating the Oracle7database to Oracle8.See Also: Oracle8 Migration describes the Migration utility and itscommand options in detail.You should read Chapter 5 of Oracle8Migration, "After Migrating the Database."1.Move the conversion file convsid.dbf from the Oracle7 $ORACLE_HOME/dbsdirectory to the Oracle8 $ORACLE_HOME/dbs directory.If the Oracle8 sid isdifferent from the Oracle7 sid, rename the conversion file appropriately.Do notalter the conversion file in any other way.2.Verify that the CONTROL_FILES entry in the parameter file(s) points tolocations without control files.3.Convert the database:Upgrading and Migrating 5-15UpgradingSVRMGR> STARTUP NOMOUNTSVRMGR> ALTER DATABASE CONVERT:SVRMGR> ALTER DATABASE OPEN RESETLOGS:SVRMGR> @$ORACLE_HOME/rdbms/admin/cat8000.sql:WARNING: Converting the database is irreversible.You cannotmigrate from Oracle8 to Oracle7.Export/ImportCreate the New Database Because the Installer-created database is limited andintended primarily for testing purposes, Oracle Corporation recommends creatingthe database manually through Server Manager.See the Oracle8 Administrator sGuide for detailed information on creating a database.Import the Exported Files Use the Import utility provided with the target database toimport the files you previously exported.See Chapter 2, "Import", in Oracle8 Utilitiesfor detailed instructions on importing data into an Oracle8 Server.Note: If you are importing from a database on a differentoperating system, be sure to use the RECORDLENGTH parameterin the imp command.The record length must match the recordlength used during export.On Solaris 2.x, the default record lengthis 32,768 bytes.Upgrade Product Database ObjectsSome Oracle products use the database to store and manipulate information: OracleConText Option, for instance, stores its dictionary in a database table.The tables,indexes, and other objects created by Oracle products for internal use are calledproduct database objects, and they usually need to be upgraded when productsoftware is upgraded.When Not to Upgrade Product Database ObjectsAs a rule, product database objects do not need to be upgraded during a minorupgrade: between release 2.1.1 and 2.1.2, for instance.Major upgrades from 2.1 to2.2 or 3.0, for instance generally require any database objects to be upgraded.Products that do not follow this general rule include special instructions in theirupgrade notes, which are listed in Table 1 3,  Restrictions, Requirements, andInstallation Tasks for Server, Options, and Cartridges, on page 5 of Chapter 1.5-16 Oracle Web Application Server Installation Guide for LINUXUpgradingHow to Upgrade Product Database ObjectsTo upgrade product database objects, select the Create/Upgrade Database Objectsoption at the Installation Activity Choice screen.1.Start the Installer provided with the new Oracle8 release.2.Select the Create/Upgrade Database Objects option at the Installation ActivityChoice screen.3.Select the Upgrade Database Objects option at the Database Options screen.4.At the prompt, enter the location of the new ORACLE_HOME directory.5.At the prompt, enter the ORACLE_SID for the database to be upgraded.6.Select the products for which you want to upgrade database objects at theSoftware Asset Manager screen and select the Install button.7.Select the version of the database you are upgrading at the DB Upgrade screen.8.At the Database Action screen:If the product was not part of the old release and you are installing it for thefirst time, select the Create Product DB Objects option.If the product was part of the old release, select the Upgrade ExistingProduct DB Objects option.WARNING: Do not select the Create Product DB Objects option ifthe product was part of the old release [ Pobierz całość w formacie PDF ]