Oracle10201升级10204windows 平台.docx
- 文档编号:29947597
- 上传时间:2023-08-03
- 格式:DOCX
- 页数:14
- 大小:897.38KB
Oracle10201升级10204windows 平台.docx
《Oracle10201升级10204windows 平台.docx》由会员分享,可在线阅读,更多相关《Oracle10201升级10204windows 平台.docx(14页珍藏版)》请在冰豆网上搜索。
Oracle10201升级10204windows平台
ORACLE数据库升级
1.Oracle软件升级
1.1升级官方步骤
1ShutdownallservicesintheOraclehomethatmightbeaccessingadatabase,forexampleOracleEnterpriseManagerDatabaseControloriSQL*Plus:
SetORACLE_SID=orcl
1.C:
\>ORACLE_BASE\ORACLE_HOME\bin\emctlstopdbconsole
2.C:
\>ORACLE_BASE\ORACLE_HOME\bin\isqlplusctlstop
2ShutdownalllistenersrunningintheOraclehomedirectory,whereyouneedtoinstallthepatchset:
C:
\>lsnrctlstop
UsetheControlPaneltostopthelistenerserviceOracleHOME_NAMETNSListenerLISTENER_nodename.
3SetthevaluesforORACLE_HOMEandORACLE_SIDandthenshutdownalldatabaseinstancesrunningintheOraclehomedirectory,whereyouneedtoinstallthepatchsetbyenteringthefollowingcommand:
1.C:
\>sqlplus/NOLOG
2.SQL>CONNECTSYSASSYSDBA
3.Enterpassword:
SYS_Password
4.SQL>SHUTDOWN
4点击p6810189_10204_Win32\Disk1\setup.exe进行升级
1.LogonasamemberoftheAdministratorsgrouptothecomputeronwhichyouaregoingtoinstallOraclecomponents.IfyouareinstallingonaPrimaryDomainControlleroraBackupDomainController,logonasamemberoftheDomainAdministratorsgroup.
2.StartOracleUniversalInstallerlocatedintheunzippedareaofthepatchset.Forexample,Oracle_patch\setup.exe.
3.OntheWelcomescreen,clickNext.
4.IntheSpecifyHomeDetailsscreen,selectthenameoftheOraclehomethatyouwanttoupdate,orselectthePaththatyouwanttoupdatefromthelist,thenclickNext
1.2实际升级界面
点击下一步
点击下一步
检查都是成功的,点击下一步
点击下一步
点击安装,弹出如下界面,进行升级
安装完成后界面如下
点击退出,Oracle软件升级结束。
2.Oracle数据库升级
2.1升级官方步骤
1.Loginwithadministratorprivileges.
2.SetthevaluesfortheenvironmentvariablesORACLE_HOME,ORACLE_SIDandPATH.
3.Forsingle-instanceinstallations,ifyouareusingAutomaticStorageManagement,starttheAutomaticStorageManagementinstance.
4.ForOraclesingle-instanceinstallations,startthelistenerasfollows:
5.C:
\>lsnrctlstart
6.EnsuretheOracleRACdatabaseisupbeforerunningOracleDatabaseUpgradeAssistantbyenteringthefollowingcommand:
7.C:
\>ORACLE_BASE\ORACLE_HOME\bin\srvctlstartdatabase-ddb_name-omount
8.EnsurethatdbconsoleserviceisstoppedandservicecontrolpanelisclosedonallthenodesbeforerunningOracleDatabaseUpgradeAssistant.
9.RunOracleDatabaseUpgradeAssistanteitherintheinteractiveornoninteractivemode:
Interactivemode:
StarttheOracleDatabaseUpgradeAssistant:
FromtheStartmenu,selectPrograms,thenOracle-HOME_NAME,thenConfigurationandMigrationToolsandthenDatabaseUpgradeAssistanttostarttheOracleDatabaseUpgradeAssistant.
CompletethefollowingstepsdisplayedintheOracleDatabaseUpgradeAssistantscreen:
a.OntheWelcomescreen,clickNext.
b.OntheDatabasesscreen,selectthenameoftheOracleDatabasethatyouwanttoupdate,thenclickNext.
Note:
ForOracleRAC,entertheSYSpasswordtodotheupgrade.
c.OntheRecompileinvalidobjectsscreen,selecttheRecompiletheinvalidobjectsattheendofupgradeoption,thenclickNext.
d.Ifyouhavenottakenthebackupofthedatabaseearlier,ontheBackupscreen,selecttheIwouldliketotakethistooltobackupthedatabaseoption,mentionthePath,thenclickNext.
e.OntheSummaryscreen,checkthesummary,thenclickFinish.
f.OntheEndofUpgradescreen,clickExit,thenclickYestoexitfromOracleDatabaseUpgradeAssistant.
Noninteractivemode:
EnterthefollowingcommandtoupgradeOracleDatabaseusingOracleDatabaseUpgradeAssistantinnoninteractivemode:
C:
\>ORACLE_BASE\ORACLE_HOME\dbua-silent-dbnameORACLE_SID-oracleHome
ORACLE_HOME-sysDBAUserNameUserName-sysDBAPasswordSYS_password
-recompile_invalid_objectstrue
10.IfyouareusingtheOracleRecoveryManagercatalog,enterthefollowingcommand:
11.C:
\>rmancatalogusername/password@alias
12.RMAN>UPGRADECATALOG;
13.ForOracleRACinstallations,startanydatabaseservicesthatyouwanttousebyenteringthefollowingcommand:
14.C:
\>ORACLE_BASE\ORACLE_HOME\bin\srvctlstartservice-ddb_name-sservice_name
2.2实际升级步骤
打开DatabaseUpgradeAssistant
单击红色的部分。
弹出如下界面:
点击下一步
下一步
等待,弹出如下界面:
点击下一步
点击下一步
选择下面创建备份,点击下一步
点击下一步
点击完成,开始备份数据库和升级数据库操作。
等待安装结束
升级完成后的界面,点击确定。
升级数据库完成。
最后一步,验证数据库升级是否成功
C:
\oracle\product\10.2.0\db_1\BIN>sqlplus/assysdba
SQL*Plus:
Release10.2.0.4.0-Productionon星期四1月2417:
11:
232013
Copyright(c)1982,2007,Oracle.AllRightsReserved.
连接到:
OracleDatabase10gEnterpriseEditionRelease10.2.0.4.0-Production
WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions
SQL>selectstatusfromv$instance;
STATUS
------------
OPEN
SQL>showparameterservice
NAMETYPEVALUE
-----------------------------------------------------------------------------
service_namesstringorcl
SQL>shutdownimmediate;
数据库已经关闭。
已经卸载数据库。
ORACLE例程已经关闭。
SQL>startup
ORACLE例程已经启动。
TotalSystemGlobalArea167772160bytes
FixedSize1295632bytes
VariableSize117443312bytes
DatabaseBuffers46137344bytes
RedoBuffers2895872bytes
数据库装载完毕。
数据库已经打开。
SQL>showparameterservice
NAMETYPEVALUE
-----------------------------------------------------------------------------
service_namesstringorcl
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle10201升级10204windows 平台 Oracle10201 升级 10204 windows