Fedora 14 x86-64 install oracle 10g 64 bit

lnwxzyp發表於2011-08-22
     前不久機器新加了一個4G的記憶體,現在記憶體達到了6個G,做一些虛擬機器之類的應該就很輕鬆了,剛開始裝了一個Fedora 15 x86-64位版,發現gnome 3的變化很大,仔細琢磨,應該還是為16:9的系統量身打造的系統介面,而且15的系統驅動做的很不錯,我的機器nvs 3100的顯示卡直接可以識別到,不過我這可是16:10的經典寬屏比例,所以等以後換用16:9的螢幕之後再來玩gnome 3吧。 由於是64位的系統所以資料庫肯定也要裝64位的,sqldeveloper沒有找到專門標註64位的,實際上我下載下來試用之後在64位系統下一樣可以跑的很歡。還有64位的SecureCRT,雖然只是試用,不過比起系統自帶的ssh還是要好用不少阿。 好了閒話少敘述,現在來說一下,在這個系統下安裝oracle10g 的經歷,由於www.oracle-base.com上面對類似的這些安裝有非常詳細的介紹,但是從Fedora 11 之後作者似乎在從事oracle 11g的資料庫工作了,所以對10g也就沒有介紹,實際上從網上搜尋了一圈下來對64位的安裝講的很少,於是把自己這次的安裝進行一下記錄。
       有過相關經驗的朋友應該都知道,實際上在Fedora包括ubunut這些系統下安裝,主要是不知道需要安裝那些包,只要這一步解決了其他的都很簡單,因此來看看我安裝前所安裝的rpm有哪些:
yum install binutils
yum install compat-libstdc++-33
yum install compat-libstdc++-33.i686
yum install elfutils-libelf
yum install elfutils-libelf-devel
yum install gcc
yum install gcc-c++
yum install glibc
yum install glibc.i686
yum install glibc-common
yum install glibc-devel
yum install glibc-devel.i686
yum install glibc-headers
yum install ksh
yum install libaio
yum install libaio.i686
yum install libaio-devel
yum install libaio-devel.i686
yum install libgcc
yum install libgcc.i686
yum install libstdc++
yum install libstdc++.i686
yum install libstdc++-devel
yum install make
yum install numactl-devel
yum install sysstat
yum install unixODBC
yum install unixODBC.i686
yum install unixODBC-devel
yum install unixODBC-devel.i686
yum install compat-gcc-34-3.4.6
yum install compat-gcc-34-c++-3.4.6
yum install libXext.so.6
yum install libXt.so.6
yum install libXtst.so.6
yum install libXp
yum install libXp.i686
這些安裝完成之後,修改/etc/redhat-release 其餘的步驟就省略了,這裡就參考了http://www.oracle-base.com/articles/11g/OracleDB11gR2InstallationOnFedora14.php的文章,沒有什麼好說的,不過要注意的是這老兄有一個地方有個問題,至少是不適用於10g的:
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
這裡rmem_max 和 wmem_max的值和default保持一致(262144)就可以了,不然後面還會遇到錯誤。做完之後開始./runInstaller  安裝,因為我要在建庫前就打上10.2.0.5.0的補丁集,因此我選擇的install software only選項,結果在83%的時候遇到了錯誤 Error in invoking target 'collector' of makefile '/u01/app/oracle/product/10.2.0/db_1/sysman/lib/lis_emdb.mk';
google之後沒有找到解決辦法,最後在support.oracle.com 上面看到一篇在suse下也遇到同樣的文章,說這個是一個Bug:8993720,解決辦法是忽略該錯誤即可,然後解壓10205的補丁之後安裝,結果一直提示不是認證的系統,我明明已經將/etc/redhat-ralease改成了redhat-4,解決辦法是加一個忽略  ./runInstaller -ignoresysprereqs 就可以了, 然後這一步也是在安裝到最後的時候出現剛才遇到的錯誤,直接忽略掉,最後執行root.sh就可以了, 由於10205的oem還是有bug(oracle的bug雜就那麼多呢。。。) 於是先從support.oracle.com下載適合OPatch的最新版本p6880880_102000_Linux-x86-64.zip,然後下載關鍵補丁,補丁號:8350262,然後將原來$ORACLE_HOME/OPatch 改名後將新的OPatch移動到ORACLE home目錄,另外還要在.bash_profile當中將OPatch的路徑加入到PATH當中
OPATCH=/u01/app/oracle/product/10.2.0/db_1/OPatch; export OPATCH
PATH=$ORACLE_HOME/bin:$OPATCH:$PATH; export PATH
生效: source ~/.bash_profile
然後解壓8350262的補丁,進入到同名目錄8350262,執行 opatch apply 詳細如下:
oracle@lnwxzyp [/home/oracle/Downloads/8350262] opatch apply
Invoking OPatch 10.2.0.5.1

Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.5.0
OUI location      : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2011-08-22_23-21-17PM.log

Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch '8350262' to OH '/u01/app/oracle/product/10.2.0/db_1'

Running prerequisite checks...
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: 

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '8350262' for restore. This might take a while...
Backing up files affected by the patch '8350262' for rollback. This might take a while...

Patching component oracle.sysman.agent.core, 10.2.0.5.0a...
Updating jar file "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/sec/util/SecConstants.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/fsc/FSWalletUtil.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/rep/RepWalletUtil.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/util/RootCert.class"
Updating jar file "/u01/app/oracle/product/10.2.0/db_1/sysman/jlib/emd_java.jar" with "/sysman/jlib/emd_java.jar/oracle/sysman/eml/sec/util/SecConstants.class"
ApplySession adding interim patch '8350262' to inventory

Verifying the update...
Inventory check OK: Patch ID 8350262 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8350262 are present in Oracle Home.

OPatch succeeded.

--------------------------------------------------------------------------------
Installed Top-level Products (2): 

Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4                            10.2.0.5.0
There are 2 products installed in this Oracle Home.


Interim patches (1) :

Patch  8350262      : applied on Mon Aug 22 23:21:42 CST 2011
Unique Patch ID:  13011832
   Created on 13 Sep 2010, 14:09:12 hrs GMT
   Bugs fixed:
     8350262



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

OPatch succeeded.
然後執行dbca來建庫,但奇怪的是組後建庫OEM部分還是報錯,可能跟我使用了DHCP有關,由於時間關係,明天再去解決。 完成字後不要忘了把/etc/redhat-release裡面的內容改為Fedora release 14 (Laughlin)。
今天重建了一下EM,問題得到解決
[oracle@lnwxzyp ~]$ emca -repos drop

STARTED EMCA at Aug 24, 2011 10:20:25 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle. All rights reserved.

Enter the following information:
Database SID: demo
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: y
Aug 24, 2011 10:22:47 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/demo/emca_2011-08-24_10-20-25-PM.log.
Aug 24, 2011 10:22:47 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Aug 24, 2011 10:22:47 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Aug 24, 2011 10:24:24 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 24, 2011 10:24:24 PM

[oracle@lnwxzyp ~]$ emca -repos create

STARTED EMCA at Aug 24, 2011 10:27:28 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle. All rights reserved.

Enter the following information:
Database SID: demo
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: y
Aug 24, 2011 10:27:41 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/demo/emca_2011-08-24_10-27-28-PM.log.
Aug 24, 2011 10:27:42 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Aug 24, 2011 10:29:49 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 24, 2011 10:29:49 PM
[oracle@lnwxzyp ~]$ emca -config dbcontrol db

STARTED EMCA at Aug 24, 2011 10:30:41 PM
EM Configuration Assistant, Version 10.2.0.5.0 Production
Copyright (c) 2003, 2009, Oracle. All rights reserved.

Enter the following information:
Database SID: demo
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/10.2.0/db_1

Local hostname ................ lnwxzyp
Listener port number ................ 1521
Database SID ................ demo
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Aug 24, 2011 10:31:08 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/demo/emca_2011-08-24_10-30-41-PM.log.
Aug 24, 2011 10:31:13 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Aug 24, 2011 10:31:33 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Aug 24, 2011 10:31:33 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Aug 24, 2011 10:33:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Aug 24, 2011 10:33:09 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://lnwxzyp:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Aug 24, 2011 10:33:09 PM


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12216142/viewspace-705547/,如需轉載,請註明出處,否則將追究法律責任。

相關文章