一、数据库热备
1、使用exp命令导出数据表结构export user objects到J:\oracle_bak\20181218.sql;导出表数据export tables到J:\oracle_bak\20181218.dmp;
2、使用expdp命令导出表
开始运行cmd
sqlplus / as sysdba
create directory dir_dp as 'J:\oracle_bak\dir_dp';
Grant read,write on directory dir_dp to user;
quit
expdp user/user@orcl schemas=user directory=dir_dp dumpfile =user20181218.dmp logfile=user20181218.log
3、使用exp命令导出数据表结构export user objects到J:\oracle_bak\20181218user.sql;导出表数据export tables到J:\oracle_bak\20181218user.dmp;
4、停止oracle服务,oracle冷备份
拷贝E:\app文件夹为J:\oracle_bak\app
拷贝C:\Program Files\Oracle为J:\oracle_bak\oracle
5、卸载oracle
a、双击运行E:\app\Administrator\product\11.2.0\dbhome_1\deinstall\deinstall.bat开始卸载
b、输入监听:LISTENER
c、输入实例名:orcl
具体执行过程如下:
Checking for required files and bootstrapping ...
Please wait ...
已复制 1 个文件。
已复制 1 个文件。
日志的位置 C:\Users\Administrator\logs\
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################### CHECK OPERATION START #########################
## [开始] 安装检查配置 ##
检查 Oracle 主目录位置是否存在 E:\app\Administrator\product\11.2.0\dbhome_1
选定进行卸载的 Oracle 主目录类型为:Oracle 单实例数据库
选定进行卸载的 Oracle 基目录为:E:\app\Administrator
检查主产品清单位置是否存在 C:\Program Files\Oracle\Inventory
## [结束] 安装检查配置 ##
## [开始] 检查 Windows 和 .NET 产品配置 ##
以下 Windows 和 .NET 产品将从 Oracle 主目录取消配置:asp.net,ode.net,odp.net,ntol
edb,oramts
## [结束] 检查 Windows 和 .NET 产品配置 ##
网络配置检查配置开始
网络取消配置跟踪文件位置: C:\Users\Administrator\logs\netdc_check2018-12-18_10-1
7-44-PM.log
指定要取消配置的所有单实例监听程序 [LISTENER]:LISTENER
网络配置检查配置结束
数据库检查配置开始
数据库取消配置跟踪文件位置: C:\Users\Administrator\logs\databasedc_check2018-12-
18_10-17-56-PM.log
指定值列表作为输入时使用逗号作为分隔符
指定在此 Oracle 主目录中配置的数据库名的列表 [orcl]: orcl
###### 对于数据库 'ftoais' ######
单实例数据库
数据库的诊断目标位置: E:\APP\ADMINISTRATOR\diag\rdbms\orcl
数据库使用的存储类型: FS
数据库文件位置: E:\APP\ADMINISTRATOR\ORADATA\FTOAIS,E:\APP\ADMINISTRATOR\FAST_RE
COVERY_AREA\ORCL
快速恢复区位置: E:\app\Administrator\fast_recovery_area\ORCL
数据库 spfile 位置: E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILE
ORCL.ORA
已自动搜索到数据库ftoais的详细信息。是否仍要修改orcl数据库的详细信息? [n]:
数据库检查配置结束
Enterprise Manager Configuration Assistant START
EMCA 取消配置跟踪文件位置: C:\Users\Administrator\logs\emcadc_check2018-12-18_10
-24-18-PM.log
检查数据库 orcl的配置
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM 检查日志文件位置: C:\Users\Administrator\logs\\ocm_check2428.log
Oracle Configuration Manager check END
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
选定进行卸载的 Oracle 主目录为:E:\app\Administrator\product\11.2.0\dbhome_1
Oracle 主目录注册到的产品清单位置为: C:\Program Files\Oracle\Inventory
以下 Windows 和 .NET 产品将从 Oracle 主目录取消配置:asp.net,ode.net,odp.net,ntol
edb,oramts
将取消配置以下单实例监听程序: LISTENER
已选中以下数据库来取消配置:orcl
数据库唯一名称: orcl
已用存储: FS
将为以下数据库更新 Enterprise Manager 配置: orcl
没有要更新的 Enterprise Manager ASM 目标
没有要移植的 Enterprise Manager 监听程序目标
检查 CCR 的配置状态
Oracle 主目录已存在且具有 CCR 目录, 但 CCR 未配置
CCR 检查已完成
是否要继续 (是 - 是, 否 - 否)? [否]: 是
此会话的日志将写入: 'C:\Users\Administrator\logs\deinstall_deconfig2018-12-18_10
-17-41-PM.out'
此会话的任何错误消息都将写入: 'C:\Users\Administrator\logs\deinstall_deconfig201
8-12-18_10-17-41-PM.err'
######################## CLEAN OPERATION START ########################
Enterprise Manager Configuration Assistant START
EMCA 取消配置跟踪文件位置: C:\Users\Administrator\logs\emcadc_clean2018-12-18_10
-24-18-PM.log
更新数据库 ftoais 的 Enterprise Manager Database Control 配置
更新 Enterprise Manager ASM 目标 (如果有)
更新 Enterprise Manager 监听程序目标 (如果有)
Enterprise Manager Configuration Assistant END
数据库取消配置跟踪文件位置: C:\Users\Administrator\logs\databasedc_clean2018-12-
18_10-24-59-PM.log
数据库清除配置开始 ftoais
此操作可能需要持续几分钟。
网络配置清除配置开始
网络取消配置跟踪文件位置: C:\Users\Administrator\logs\netdc_clean2018-12-18_10-2
6-58-PM.log
取消配置单实例监听程序: LISTENER
取消配置监听程序: LISTENER
停止监听程序: LISTENER
监听程序已成功停止。
删除监听程序: LISTENER
监听程序已成功删除。
监听程序已成功取消配置。
正在取消配置监听程序配置文件...
监听程序配置文件已成功取消配置。
正在取消配置命名方法配置文件...
命名方法配置文件已成功取消配置。
正在取消配置本地网络服务名配置文件...
本地网络服务名配置文件已成功取消配置。
正在取消配置备份文件...
备份文件已成功取消配置。
网络配置已成功清除。
网络配置清除配置结束
Oracle Configuration Manager clean START
OCM 清理日志文件位置: C:\Users\Administrator\logs\\ocm_clean2428.log
Oracle Configuration Manager clean END
## [开始] 删除 Windows 和 .NET 产品配置 ##
## [结束] 删除 Windows 和 .NET 产品配置 ##
Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer 清除开始
删除本地节点上的服务 'OracleOraDb11g_home1ClrAgent' : 完成
从本地节点上的主产品清单中分离 Oracle 主目录 'E:\app\Administrator\product\11.2.
0\dbhome_1' : 完成
无法删除文件 'E:\app\Administrator\product\11.2.0\dbhome_1\BIN\emagent.exe'。该
文件正在使用中。
无法删除文件 'E:\app\Administrator\product\11.2.0\dbhome_1\BIN\oci.dll'。该文件
正在使用中。
无法删除文件 'E:\app\Administrator\product\11.2.0\dbhome_1\BIN\oraasmclnt11.dll'
。该文件正在使用中。
。。。。。。。。。。。。。。
直至完成后自动关闭
e、清除注册表
打开注册表,依次展开HKEY_LOCAL_MACHINE\SOFTWARE,找到oracle,删除之
依次展开HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services中,删除所有oracle开头的项
依次展开HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application,删除所有oracle开头的项;
在HKEY_CLASSES_ROOT,删除以ora开头的项
重启电脑,删除oracle目录,删除Oracle的安装目录app等
4、删除E:\app\administrator文件夹。清除oracle相关环境变量。
以上全部卸载完成
5、安装Oracle,右键 E:\oracle-tools\oracle11g-51047948\database\setup.exe 以管理员身份运行,数据库安装路径
H:\app\Administrator,oracle_home路径H:\app\Administrator\product\11.2.0\dbhome_1
数据库实例名为ftoais,sys,system,sysdba的密码都是***,字符集为ZHS16gbk
数据库配置概要 全局数据库名: orcl 数据库配置类型: 单实例 SID: orcl 管理选项类型: Database Control 存储类型: 文件系统 内存配置类型: 自动共享内存管理
6、oralce 打opatch补丁
先停止oracle的各种服务,sqlplus ,plsql等
H:\app\Administrator\product\11.2.0\dbhome_1\BIN\OCI.DLL文件重名名为oci20181219.dll
a、备份H:\app\Administrator\product\11.2.0\dbhome_1\OPatch文件夹
b、将E:\oracle-tools\OPATCHP_2-20010777下的OPatch补丁拷贝到H:\app\Administrator\product\11.2.0\dbhome_1路径下
c、环境变量path路径下添加opatch路径:H:\app\Administrator\product\11.2.0\dbhome_1\OPatch,添加Oracle_home环境变量值为:H:\app\Administrator\product\11.2.0\dbhome_1
d、dos命令窗口中定位到E:\oracle-tools\opatch-21469106路径,然后执行H:\app\Administrator\product\11.2.0\dbhome_1\OPatch\opatch.bat apply即可打补丁。
C:\Users\Administrator>E:
E:\>cd E:\oracle-tools\opatch-21469106
E:\oracle-tools\opatch-21469106>H:\app\Administrator\product\11.2.0\dbhome_1\OPatch\opatch.bat apply
========================================================
GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY
========================================================
Oracle 中间补丁程序安装程序版本 11.2.0.3.7
版权所有 (c) 2013, Oracle Corporation。保留所有权利。
Oracle Home : H:\app\Administrator\product\11.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 11.2.0.3.7
OUI version : 11.2.0.4.0
Log file location : H:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollogs\opa
tch\21469106_Dec_18_2018_23_47_23\apply2018-12-18_23-47-23下午_1.log
Applying interim patch '21469106' to OH 'H:\app\Administrator\product\11.2.0\dbh
ome_1'
Verifying environment and performing prerequisite checks...
Patch 21469106: Optional component(s) missing : [ oracle.rdbms.tg4msql, 11.2.0.4
.0 ] , [ oracle.rdbms.tg4sybs, 11.2.0.4.0 ] , [ oracle.rdbms.tg4tera, 11.2.0.4.0
] , [ oracle.rdbms.tg4ifmx, 11.2.0.4.0 ] , [ oracle.rdbms.tg4db2, 11.2.0.4.0 ]
, [ oracle.rdbms.ic, 11.2.0.4.0 ] , [ oracle.has.cfs, 11.2.0.4.0 ] , [ oracle.ha
s.crs, 11.2.0.4.0 ] , [ oracle.has.cvu, 11.2.0.4.0 ] , [ oracle.usm, 11.2.0.4.0
]
All checks passed.
请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。
(Oracle 主目录 = 'H:\app\Administrator\product\11.2.0\dbhome_1')
本地系统是否已准备打补丁? [y|n]
Y
User Responded with: Y
Backing up files...
正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.ovm, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.oci, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
从 'E:\oracle-tools\opatch-21469106\files\bin\oraplp11.dll' 复制到 'H:\app\Admin
istrator\product\11.2.0\dbhome_1\bin\oraplp11.dll' 失败...
Please verify all applications associated with the Oracle Home 'H:\app\Administr
ator\product\11.2.0\dbhome_1' are shut down. If this is AIX, please perform solu
tion documented in Note 739963.1 on https://myoraclesupport.oracle.com.
Do you want to retry copying the file? [y|n]
Y
正在为组件 oracle.network.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.network.aso, 11.2.0.4.0 打补丁...
正在为组件 oracle.ntoledb, 11.2.0.4.0 打补丁...
正在为组件 oracle.ntoledb.odp_net_2, 11.2.0.4.0 打补丁...
正在为组件 oracle.ordim.client, 11.2.0.4.0 打补丁...
正在为组件 oracle.ordim.jai, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.has.common.cvu, 11.2.0.4.0 打补丁...
正在为组件 oracle.has.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.has.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.has.rsf, 11.2.0.4.0 打补丁...
Verifying the update...
.....直至执行完成
Patch 21469106 successfully applied
Log file location: H:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollogs\opat
ch\21469106_Dec_19_2018_11_07_34\apply2018-12-19_11-07-34上午_1.log
OPatch succeeded.
检查版本
E:\oracle-tools\opatch-21469106>h:
H:\>cd H:\app\Administrator\product\11.2.0\dbhome_1\OPatch
H:\app\Administrator\product\11.2.0\dbhome_1\OPatch>opatch lsinventory
========================================================
GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY
========================================================
Oracle 中间补丁程序安装程序版本 11.2.0.3.7
版权所有 (c) 2013, Oracle Corporation。保留所有权利。
Oracle Home : H:\app\Administrator\product\11.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 11.2.0.3.7
OUI version : 11.2.0.4.0
Log file location : H:\app\Administrator\product\11.2.0\dbhome_1\cfgtoollogs\opa
tch\opatch2018-12-19_11-18-23上午_1.log
Lsinventory Output file location : H:\app\Administrator\product\11.2.0\dbhome_1\
cfgtoollogs\opatch\lsinv\lsinventory2018-12-19_11-18-23上午.txt
--------------------------------------------------------------------------------
已安装的顶级产品 (1):
Oracle Database 11g 11.2.0.4.0
此 Oracle 主目录中已安装 1 个产品。
中间补丁程序 (1) :
Patch 21469106 : applied on Wed Dec 19 11:10:42 CST 2018
Unique Patch ID: 19230508
Patch description: "WINDOWS DB BUNDLE PATCH 11.2.0.4.18:(21469106)"
Created on 10 Aug 2015, 08:28:32 hrs
Bugs fixed:
16809786, 17716305, 17348614, 16382883, 18125929, 18246045, 17835048
17545847, 16042673, 18096714, 16543190, 17258090, 17214497, 17618819
17610798, 16954950, 19358317, 18098207, 16731148, 17006570, 14764840
14458319, 18191542, 19359219, 19168690, 16878635, 16571443, 17215306
17842825, 18441944, 13955826, 19188927, 19500064, 18084625, 17336871
17201159, 17001914, 16685417, 17311728, 18262334, 18729166, 16194160
18182018, 16494615, 14046443, 16434236, 17927204, 14354737, 11883252
18282562, 16903536, 18842982, 19126146, 19532017, 17238511, 17602269
17936109, 20014326, 19181525, 17080436, 17265217, 17912217, 20127071
17359610, 19455741, 18419770, 17925209, 17838476, 18331812, 16399083
18966843, 17853355, 13498382, 17493764, 18034737, 14146298, 19220183
18091059, 18092127, 9670413, 17987366, 19393542, 16187992, 17156148
17336898, 18689530, 20110156, 17313525, 19558324, 18464784, 20245930
16281493, 10231702, 20527770, 14285317, 15832129, 18199537, 17401353
17484712, 19949371, 20032370, 17344412, 13949321, 15986647, 21191575
18681683, 16384983, 14034426, 10052729, 20194181, 16870214, 18633374
17332343, 16863422, 18134680, 16613232, 18673304, 20825533, 18111216
16206997, 17394950, 17785632, 17186905, 17397545, 17325413, 16832076
19479503, 17258083, 17764053, 17202639, 17089344, 13991403, 16542886
18766012, 17159489, 20294666, 18893947, 16901385, 17564992, 17754782
18191164, 19606562, 14761365, 18160822, 18084873, 16545319, 16579084
17174582, 18641461, 18306996, 16994839, 16043574, 14378120, 17752995
12608451, 18199185, 17865671, 16594015, 18520351, 17587063, 20074391
13829543, 18232462, 17570606, 17877323, 20613398, 17231779, 17086446
17019086, 17238586, 18261183, 16633319, 16956380, 17651484, 16770590
19690653, 16470836, 17824637, 18328509, 12905058, 18767554, 17921190
18331850, 16943198, 18663316, 17898325, 17640316, 12758971, 16198143
18765602, 16343493, 18554871, 18189036, 14693336, 18143836, 17551261
17501491, 17591148, 18277454, 16875449, 16863642, 17614134, 17775506
17296856, 14255128, 17155238, 16249829, 19211724, 17164243, 18244962
17947785, 20400092, 17082983, 18235390, 14320415, 18674465, 14602788
20583364, 14657740, 16657901, 15913355, 17430165, 17282229, 18428146
17165204, 14044260, 16410570, 17622427, 17501296, 17172091, 16315398
18409441, 18000422, 14678924, 18472224, 19896336, 18868646, 18399991
17896018, 19051460, 12897813, 16683112, 14133975, 17336889, 17721778
17798953, 12646133, 17031322, 12928592, 18841764, 16538760, 18241194
18325460, 19478594, 18024745, 17532816, 13609098, 15861775, 18456514
16360112, 19784663, 18362222, 18709496, 17851160, 17046460, 16422541
18384391, 20502905, 18272135, 12611721, 17242746, 14525998, 18999857
17781991, 17694209, 16833527, 18846036, 17227277, 18886413, 19201866
19540182, 20560611, 18964939, 8886629, 17510275, 20331945, 17068448
17357979, 19245018, 18819257, 20730170, 7533808, 17783588, 16296213
14275161, 12747740, 17393683, 16069901, 17405605, 19601228, 17449815
17389192, 17786518, 19403858, 20105012, 18352846, 18316692, 18317531
18673342, 17649265, 18334586, 19152705, 17232014, 16818892, 19955755
17889549, 19559495, 17883081, 20898010, 16721594, 17387214, 18088509
17722664, 19703301, 17284817, 17040527, 17059927, 16989407, 18414137
18353141, 17390160, 18296772, 16314254, 17572525, 19438874, 16668584
20949558, 20777150, 16613964, 19012893, 16989630, 16702217, 17936349
18231837, 18193833, 18348155, 18024089, 18430495, 19289642, 17785870
20412068, 17811789, 14015842, 13744436, 14692762, 17908541, 19879746
17546973, 17452841, 18436647, 14503359, 13077335, 19241857, 17889583
14106803, 20544696, 19006849, 17799716, 18685209, 17993995, 17363999
18691080, 17025461, 18641451, 18273830, 16394467, 17767676, 16524926
18888066, 14368995, 18405517, 15993436, 17465741, 20724902, 14280240
17892268, 19885321, 17890099, 18051556, 18961101, 17391726, 19915271
16285691, 17037130, 19269405, 16299727, 16837274, 18264060, 17489922
16188701, 16075609, 20043415, 18724012, 17446237, 18436307, 18241710
18946768, 17336884, 16450169, 17551674, 17726838, 16268425, 17922254
17518652, 17441661, 17684143, 17634921, 17546761, 20315294, 18053580
17435488, 17852463, 9756271, 17040764, 14010183, 16837842, 17588480
16228604, 17237521, 17042658, 17346671, 18202441, 15986311, 20235486
17805316, 18247991, 19791273, 17848897, 18641419, 18828868, 19192715
17577218, 18730542, 17208934, 16919631, 17570240, 17648596, 17352230
17736165, 20114174, 18890385, 19441649, 18346135, 17299889, 17306264
18554763, 18482502, 16698971, 17655634, 14764829, 17611362, 19488514
19000463, 16206882, 14851828, 16934803, 20657441, 18704244, 18120545
17551699, 17621643, 17279227, 19461687, 17483479, 20558005, 20246071
17945983, 16199543, 17402822, 17308789, 18417036, 19128723, 16344544
18673325, 19835650, 20844426, 16618694, 17741995, 17006183, 11733603
18339044, 13651346, 14054676, 17644091, 18665660, 16491477, 21059919
17617815, 18135678, 19267095, 17376318, 18061914, 17088068, 18280356
20141091, 18779636, 16692232, 16850630, 19689979, 14580303, 18471685
18223971, 20340620, 18068871, 18260550, 18508861, 16345970, 17443671
19727057, 14392595, 18296644, 17957017, 15990359, 16403344, 19615136
16759171, 14231204, 18006980, 16595641, 17816865, 13364795, 18856999
17365043, 17617807, 18009564, 20067212, 19543439, 16472716, 18948524
13944971, 13853126, 17291347, 18315328, 17531342, 16849620, 17205719
19361710, 18180390, 20073979, 18440047, 17267114, 17951124, 13984192
14176370, 17082359, 18700935, 18962892, 18154779, 17019356, 19000876
14000767, 17787259, 13645875, 20218012, 18146463, 18384537, 20194732
18304693, 17184721, 16943711, 17612828, 17375354, 19197175, 17393915
16667538, 17955615, 16980342, 16825679, 17571306, 17477958, 19472320
19205169, 18230522, 14084247, 19524384, 17019345, 12578873, 18674047
18280813, 18614717, 18080511, 14565184, 17389314, 17279525, 18226143
17614227, 18094246, 19873377, 18018515, 20398963, 17762296, 17405302
18228645, 17583959, 20004087, 16306373, 18493178, 18762750, 21091518
18336452, 17288409, 18747196, 19049453, 18155762, 17984331, 17571039
14338435, 16180763, 17011832, 20228093, 17597748, 17346091, 19625472
18317074, 16992075, 17927970, 13724904, 18053631, 19013183, 20121313
19291380, 19507904, 16392068, 17982555, 17761775, 18619917, 20334344
12716670, 14460384, 15894143, 16305657, 20263424, 17050888, 13073613
17481314, 19165892, 14497275, 13866822, 19309466, 14671408, 17197081
20140148, 17951233, 19680952, 17721717, 16810361, 17600719, 16777840
17071721, 18416368, 16929165, 18326617, 14373152, 19550902, 16804061
17036973, 17273020, 4189542, 14852021, 19713693, 21201481, 18614015
18265482, 18723434, 18620694, 16785708, 19879144, 17343514, 16284825
12982566, 17831758, 19152115, 17891943, 19442102, 17705023, 17255538
19780701, 19827973, 17224314, 17341326, 18485835, 20539715, 21469106
19730508, 18075666, 18996843, 20856290, 18293054, 17827250, 16876500
18783224, 20531190, 18904062, 17853456, 17332800, 13498243, 17853498
18674024, 17292250, 17376015, 14245531, 14843189, 18069285, 19487147
19827030, 19613828, 17897511, 17973658, 16867761, 12816846, 17274537
17586955, 10136473, 16902031, 18069723, 14458214, 17691313, 21235427
20004021, 17468141, 21067387, 17273003, 17250794, 18035463, 18590877
19319357, 16855292, 17239687, 17079301, 18867023, 17217593, 16976121
19888492, 17235750, 16819962, 16359751, 20355502, 18418934, 18744838
19146626, 17478145, 19651773, 16091637, 12364061, 17835627, 17596908
18718696, 20365005, 18607546, 17500165, 18187697, 13960236, 13951456
16454223, 17891946, 16247011, 17360606, 18356166, 17209410, 14500654
20186278, 18973907, 19384686, 20017509, 18875012, 19835133, 14076173
13558557, 18073821, 16596890, 12928658, 18759589, 18352845, 17672719
18034871, 16912439, 17385178, 19699191, 16317771, 18940497, 16220077
17016369, 17215560, 18115594, 17786278, 18876528, 17027426, 16346413
17901041, 15979965, 17752121, 14829250, 17818075, 17590813, 20833831
17381384, 17390431, 13837378, 20513382, 17323222, 17297939
--------------------------------------------------------------------------------
OPatch succeeded.
H:\app\Administrator\product\11.2.0\dbhome_1\OPatch>
7、更改oci20181219.dll为oci.dll,启动oracle服务
将不需要启动的oracle服务设置为手动方式,需要启动服务和监听设置为自动模式,启动服务和监听
8、创建表空间表用户
Microsoft Windows [版本 6.0.6001]
版权所有 (C) 2006 Microsoft Corporation。保留所有权利。
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期三 12月 19 11:23:57 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>

1417

被折叠的 条评论
为什么被折叠?



