怎么在win7安裝oracle11g 補(bǔ)丁

1.

創(chuàng)新互聯(lián)公司是創(chuàng)新、創(chuàng)意、研發(fā)型一體的綜合型網(wǎng)站建設(shè)公司，自成立以來(lái)公司不斷探索創(chuàng)新，始終堅(jiān)持為客戶提供滿意周到的服務(wù)，在本地打下了良好的口碑，在過(guò)去的10年時(shí)間我們累計(jì)服務(wù)了上千家以及全國(guó)政企客戶，如混凝土攪拌機(jī)等企業(yè)單位，完善的項(xiàng)目管理流程，嚴(yán)格把控項(xiàng)目進(jìn)度與質(zhì)量監(jiān)控加上過(guò)硬的技術(shù)實(shí)力獲得客戶的一致稱譽(yù)。

首先先下載好Oracle安裝包（這個(gè)就不用說(shuō)了，上Oracle官網(wǎng)自己找下載入口），將下載好后的兩個(gè)壓縮文件解壓至同一文件夾下，該文件夾為database；

2.

解壓完畢后，在該目錄下打開setup.exe,執(zhí)行安裝程序后會(huì)出現(xiàn)啟動(dòng)安裝的命令提示符，進(jìn)入安裝；

3.

稍等一會(huì)兒，就會(huì)出現(xiàn)以下安裝步驟，取消復(fù)選框勾選，點(diǎn)擊下一步繼續(xù)，并單擊“是”繼續(xù)

4.

之后出現(xiàn)以下安裝框，默認(rèn)點(diǎn)擊“下一步”繼續(xù)，

5.

選擇安裝“桌面類”和“服務(wù)器類”，當(dāng)然服務(wù)器類是安裝的在Windows

server上的，Win7就選擇“桌面類”安裝即可

6.

接下來(lái)進(jìn)入安裝配置，密碼口令為大小寫數(shù)字拼成的口令，否則，就會(huì)提示警告

7.

點(diǎn)擊下一步，在執(zhí)行先決條件檢查時(shí)，我們選擇全部忽略即可

8.

下一步，點(diǎn)擊完成按鈕即開始安裝了

9.

安裝畫面如下

10.

進(jìn)度條到達(dá)100時(shí)則會(huì)出現(xiàn)以下對(duì)話框，并等待其配置完成

11.

配置完成后，會(huì)再?gòu)棾鰧?duì)話框點(diǎn)擊“確定”即可。

求oracle 10.2.0.2的補(bǔ)丁

下面是個(gè)版本升級(jí)補(bǔ)丁的號(hào)碼，可供大家參考。還是很有用的。

9.2.0.4 = 3095277

9.2.0.5 = 3501955

9.2.0.6 = 3948480

9.2.0.7 = 4163445

9.2.0.8 = 4547809（9i最終）

10.1.0.3 = 3761843

10.1.0.4 = 4163362

10.1.0.5 = 4505133

10.2.0.2 = 4547817

10.2.0.3 = 5337014

10.2.0.4 = 沒(méi)有發(fā)布

下載補(bǔ)丁時(shí)，可進(jìn)入cmd，使用ftp命令直接登錄網(wǎng)站下載。相同版本，針對(duì)不同的操作系統(tǒng)，會(huì)有不

同的補(bǔ)丁。每個(gè)補(bǔ)丁大小約在500MB~1.3GB之間。下面以oracle 10.2.0.2 補(bǔ)丁為例：

ftp updates.oracle.com

user metalib_user 輸入密碼

cd 4547817

dir

p4547817_10202_AIX64-5L.zip

p4547817_10202_HP64.zip

p4547817_10202_HPUX-IA64.zip

p4547817_10202_LINUX.zip

p4547817_10202_Linux-IA64.zip

p4547817_10202_Linux-x86-64.zip

p4547817_10202_MVS.zip

p4547817_10202_SOLARIS.zip

p4547817_10202_SOLARIS64.zip

p4547817_10202_WINNT.zip

p4547817_10202_WINNT64.zip

使用mget命令下載即可。

結(jié)合迅雷,可以取得事半功倍的效果,鏈接如下：

oracle 9206 patchset:

oracle 9207patch set:

(無(wú))

oracle 9208patch:

oracle 10.2.0.2

10.2.0.3

oracle打補(bǔ)丁問(wèn)題

更換一個(gè)目錄試一下

把patch 安裝文件放在/tmp 文件下，在嘗試一下安裝

oracle ha端和dg端怎么安裝補(bǔ)丁

這個(gè)得看你需求了，如果只是要求單獨(dú)的做個(gè)備份一般就用DG，如果要求HA，一般用RAC，也可以用RHCS做，HP的小機(jī)MC/SG可以做。。

oracle 11.2.0.2.3補(bǔ)丁怎么打

oracle手動(dòng)升級(jí)有兩種方式，一種在安裝oracle軟件之后，安裝升級(jí)包，然后創(chuàng)建數(shù)據(jù)庫(kù)；另一種在oracle數(shù)據(jù)庫(kù)創(chuàng)建以后，進(jìn)行升級(jí)。

下面主要介紹oracle數(shù)據(jù)庫(kù)創(chuàng)建后進(jìn)行的數(shù)據(jù)庫(kù)升級(jí)(10.2.0.1-10.2.0.4)，代碼如下：

SQL --查看當(dāng)前數(shù)據(jù)庫(kù)版本

SQL select * from v$version;

SQL --給用戶scott解鎖

SQL alter user scott account unlock;

SQL --查看表空間

SQL select * from dba_tablespaces;

SQL --查看數(shù)據(jù)文件存放位置

SQL select * from dba_data_files;

SQL --創(chuàng)建測(cè)試表空間

SQL create tablespace ts_upgrade datafile '/u02/oradata/data/orcl/ts_upgrade01.dbf' size 5m autoextend on maxsize 30g;

SQL --創(chuàng)建用戶

SQL create user u_upgrade identified by "123456" default tablespace ts_upgrade temporary tablespace temp;

SQL --為用戶賦權(quán)

SQL grant connect,resource to u_upgrade;

SQL --創(chuàng)建測(cè)試表

SQL create table u_upgrade.dept as select * from scott.dept;

SQL select * from u_upgrade.dept;

[oracle@feegle ~]$ #停止em

[oracle@feegle ~]$ emctl stop dbconsole

[oracle@feegle ~]$ #停止sql*plus

[oracle@feegle ~]$ isqlplusctl stop

[oracle@feegle ~]$ #停止監(jiān)聽(tīng)

[oracle@feegle ~]$ lsnrctl stop

[oracle@feegle ~]$ #安裝升級(jí)包（p6810189_10204_Linux-x86-64.zip）

[oracle@feegle ~]$ #手動(dòng)升級(jí)數(shù)據(jù)庫(kù)

[oracle@feegle ~]$ sqlplus /nolog

SQL conn /as sysdba

SQL --以升級(jí)模式啟動(dòng)數(shù)據(jù)庫(kù)

SQL startup upgrade;

SQL --重建數(shù)據(jù)字典（建議關(guān)閉數(shù)據(jù)庫(kù)歸檔）

SQL spool upgrade.log

SQL @$ORACLE_HOME/rdbms/admin/catupgrd.sql

#####重建數(shù)據(jù)字典部分截圖#####

Oracle Database 10.2 Upgrade Status Utility 06-15-2012 18:27:56

.

Component Status Version HH:MM:SS

Oracle Database Server VALID 10.2.0.4.0 00:12:04

JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:04:58

Oracle XDK VALID 10.2.0.4.0 00:00:32

Oracle Database Java Packages VALID 10.2.0.4.0 00:00:28

Oracle Text VALID 10.2.0.4.0 00:00:25

Oracle XML Database VALID 10.2.0.4.0 00:02:25

Oracle Workspace Manager VALID 10.2.0.4.3 00:00:43

Oracle Data Mining VALID 10.2.0.4.0 00:00:21

OLAP Analytic Workspace VALID 10.2.0.4.0 00:00:23

OLAP Catalog VALID 10.2.0.4.0 00:01:02

Oracle OLAP API VALID 10.2.0.4.0 00:00:53

Oracle interMedia VALID 10.2.0.4.0 00:03:52

Spatial VALID 10.2.0.4.0 00:01:37

Oracle Expression Filter VALID 10.2.0.4.0 00:00:12

Oracle Enterprise Manager VALID 10.2.0.4.0 00:01:18

Oracle Rule Manager VALID 10.2.0.4.0 00:00:10

.

Total Upgrade Time: 00:31:30

DOC#######################################################################

DOC#######################################################################

DOC

DOC The above PL/SQL lists the SERVER components in the upgraded

DOC database, along with their current version and status.

DOC

DOC Please review the status and version columns and look for

DOC any errors in the spool log file. If there are errors in the spool

DOC file, or any components are not VALID or not the current version,

DOC consult the Oracle Database Upgrade Guide for troubleshooting

DOC recommendations.

DOC

DOC Next shutdown immediate, restart for normal operation, and then

DOC run utlrp.sql to recompile any invalid application objects.

DOC

DOC#######################################################################

DOC#######################################################################

DOC#

SQL

#####重建數(shù)據(jù)字典部分截圖#####

SQL spool off

SQL --關(guān)閉數(shù)據(jù)庫(kù)

SQL shutdown immediate;

SQL --啟動(dòng)數(shù)據(jù)庫(kù)

SQL startup;

SQL --編譯無(wú)效對(duì)象

SQL @$ORACLE_HOME/rdbms/admin/utlrp.sql

#####編譯無(wú)效對(duì)象部分截圖#####

DOC 1. Query showing jobs created by UTL_RECOMP

DOC SELECT job_name FROM dba_scheduler_jobs

DOC WHERE job_name like 'UTL_RECOMP_SLAVE_%';

DOC

DOC 2. Query showing UTL_RECOMP jobs that are running

DOC SELECT job_name FROM dba_scheduler_running_jobs

DOC WHERE job_name like 'UTL_RECOMP_SLAVE_%';

DOC#

TIMESTAMP

--------------------------------------------------------------------------------

COMP_TIMESTAMP UTLRP_END 2012-06-15 18:45:01

DOC The following query reports the number of objects that have compiled

DOC with errors (objects that compile with errors have status set to 3 in

DOC obj$). If the number is higher than expected, please examine the error

DOC messages reported with each object (using SHOW ERRORS) to see if they

DOC point to system misconfiguration or resource constraints that must be

DOC fixed before attempting to recompile these objects.

DOC#

OBJECTS WITH ERRORS

-------------------

DOC The following query reports the number of errors caught during

DOC recompilation. If this number is non-zero, please query the error

DOC messages in the table UTL_RECOMP_ERRORS to see if any of these errors

DOC are due to misconfiguration or resource constraints that must be

DOC fixed before objects can compile successfully.

DOC#

ERRORS DURING RECOMPILATION

---------------------------

SQL

#####編譯無(wú)效對(duì)象部分截圖#####

SQL 驗(yàn)證升級(jí)

SQL --查看組件狀態(tài)

SQL --status=VALID

SQL select comp_name, version, status from sys.dba_registry;

SQL --查看表空間狀態(tài)

SQL select tablespace_name,status from dba_tablespaces;

SQL --查看用戶

SQL select username from dba_users;

SQL --查看用戶對(duì)象

SQL select object_name from dba_objects where owner='SCOTT';

SQL select object_name from dba_objects where owner='U_UPGRADE';

SQL select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

[oracle@feegle ~]$ #啟動(dòng)監(jiān)聽(tīng)

[oracle@feegle ~]$ lsnrctl start

[oracle@feegle ~]$ #啟動(dòng)EM

[oracle@feegle ~]$ emctl start dbconsole

[oracle@feegle ~]$ #啟動(dòng)SQL*PLUS

[oracle@feegle ~]$ isqlplusctl start

當(dāng)前標(biāo)題：oracle補(bǔ)丁怎么用,oracle官網(wǎng)怎么下載補(bǔ)丁
網(wǎng)頁(yè)URL：http://m.2m8n56k.cn/article2/hojcoc.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供定制開發(fā)、靜態(tài)網(wǎng)站、App開發(fā)、外貿(mào)網(wǎng)站建設(shè)、網(wǎng)站設(shè)計(jì)、網(wǎng)站營(yíng)銷

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：[email protected]。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)