Decode360's Blog

          業(yè)精于勤而荒于嬉 QQ:150355677 MSN:decode360@hotmail.com

            BlogJava :: 首頁(yè) :: 新隨筆 :: 聯(lián)系 ::  :: 管理 ::
            302 隨筆 :: 26 文章 :: 82 評(píng)論 :: 0 Trackbacks
          一、掛載光盤(pán)拷貝Oracle
          ?
          ??? 將Oracle10g_linux裝入虛擬光驅(qū),并將光盤(pán)掛載
          ??? # mount /mnt/cdrom
          ?
          ??? 注:關(guān)于光盤(pán)掛載的操作,見(jiàn)“ Linux的mount命令簡(jiǎn)介
          ?
          ??? 然后將Oracle拷貝到硬盤(pán)中:
          ??? # cp -r -b /mnt/cdrom/* /tmp/ora10
          ?
          ??? 注:Oracle安裝必須要將拷到硬盤(pán)上,否則將提示:
          ??? Error: OUI cannot be launched because the current working directory is set on the CD-ROM mount point. Launching OUI from this directory will make it difficult to unmount the disk later in the installation. Please change the working directory and relaunch OUI.
          ?
          ?
          二、安裝Oracle
          ?
          ??? 用oracle用戶(hù)登錄一個(gè)視窗界面(必須),然后執(zhí)行安裝
          ??? $ /tmp/ora10g/runInstaller -ignoreSysPrereqs
          ?
          ??? 注:-ignoreSysPrereqs 是為了跳過(guò)安裝時(shí)的系統(tǒng)版本檢測(cè)。因?yàn)镺racle安裝時(shí)會(huì)進(jìn)行操作系統(tǒng)檢測(cè),不在其指定操作系統(tǒng)列表之中則無(wú)法安裝。 也可以修改linux的系統(tǒng)參數(shù)/etc/redhat-release來(lái)做,但是比較麻煩。
          ?
          ??? 之后進(jìn)入安裝界面,跟Windows下沒(méi)有什么區(qū)別。
          ?
          ??? 在開(kāi)始使用中文界面 安裝時(shí)發(fā)現(xiàn)出現(xiàn)亂碼,搞了半天沒(méi)解決,最后直接把操作系統(tǒng)改成英文了,英文界面下安裝還比較方便一些。
          ?
          ?
          ??? 安裝時(shí)會(huì)兩次彈出提示框,需要手動(dòng)執(zhí)行某個(gè)指定的shell
          ??? 需要切換到root用戶(hù)下,執(zhí)行文件中的某個(gè)shell
          ?
          ??? $ su root
          ??? # ./xxxx.sh
          ?
          ??? 關(guān)于shell的使用方法,可以參見(jiàn)“Linux shell程序設(shè)計(jì)
          ?
          ??? 注:此次安裝只配置了256M內(nèi)存,但依然安裝成功,可見(jiàn)并不是非要1G內(nèi)存不可。不過(guò)安裝之后機(jī)子超慢,但至少這不是技術(shù)限制。
          ?
          ?
          三、配置Oracle
          ?
          ?
          1、修改listener.ora

          LISTENER =
          ??? (DESCRIPTION_LIST =
          ??????? (DESCRIPTION =
          ??????????? (ADDRESS_LIST =
          ??????????????? (ADDRESS = (PROTOCOL = TCP)(HOST =?192.168.0.3)(PORT = 1521))
          ??????????? )
          ??????????? (ADDRESS_LIST =
          ??????????????? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
          ??????????? )
          ??????? )
          ??? )
          SID_LIST_LISTENER =
          ??? (SID_LIST =
          ??????? (SID_DESC =
          ??????????? (SID_NAME = PlsExtProc)
          ??????????? (ORACLE_HOME = /opt/ora10g/product/10.2.0/db_1)
          ??????????? (PROGRAM = extproc)
          ??????? )
          ??????? (SID_DESC =
          ??????????? (GLOBAL_DBNAME =?dodo)
          ??????????? (ORACLE_HOME = /opt/ora10g/product/10.2.0/db_1)
          ??????????? (SID_NAME =?dodo)

          ??????? )
          ??? )

          2、修改tnsnames.ora

          DODO?=
          ??? (DESCRIPTION =
          ??????? (ADDRESS_LIST =
          ??????????? (ADDRESS = (PROTOCOL = TCP)(HOST =?192.168.0.3)(PORT = 1521))
          ??????? )
          ??????? (CONNECT_DATA =
          ??????????? (SERVER = DEDICATED)
          ??????????? (SERVICE_NAME =?dodo)
          ??????? )
          ??? )

          3、增加dbstart 到rc.local

          $ vi /opt/ora10g/product/10.2.0/db_1/bin/dbstart_self

          ORACLE_SID=dodo
          sqlplus /nolog <<!
          connect / as sysdba
          startup
          !
          lsnrctl start

          $ chmod +577 dbstart_self
          $?su root
          # vi /etc/rc.local

          su - oracle 'dbstart_self' >>/var/log/dbstart_self.log
          ?
          ?
          ??? 以上配置完成后重啟系統(tǒng)后即可遠(yuǎn)程連接。
          ?
          ?
          四、查看進(jìn)程
          ?
          ??? Linux下的進(jìn)程操作方法見(jiàn)“Linux 進(jìn)程管理
          ?
          # ps -aef | grep oracle
          oracle??? 1982???? 1? 0 09:09 ???????? 00:00:01 ora_pmon_dodo
          oracle??? 1984???? 1? 0 09:09 ???????? 00:00:00 ora_mman_dodo
          oracle??? 1986???? 1? 0 09:09 ???????? 00:00:01 ora_dbw0_dodo
          oracle??? 1988???? 1? 0 09:09 ???????? 00:00:00 ora_lgwr_dodo
          oracle??? 1990???? 1? 0 09:09 ???????? 00:00:02 ora_ckpt_dodo
          oracle??? 1992???? 1? 0 09:09 ???????? 00:00:01 ora_smon_dodo
          oracle??? 1994???? 1? 0 09:09 ???????? 00:00:00 ora_reco_dodo
          oracle??? 1996???? 1? 0 09:10 ???????? 00:00:01 ora_cjq0_dodo
          oracle??? 1998???? 1? 0 09:10 ???????? 00:00:00 ora_d000_dodo
          oracle??? 2000???? 1? 0 09:10 ???????? 00:00:00 ora_s000_dodo
          oracle??? 2010???? 1? 0 09:10 ???????? 00:00:00 ora_qmnc_dodo
          oracle??? 2012???? 1? 0 09:10 ???????? 00:00:03 ora_mmon_dodo
          oracle??? 2014???? 1? 0 09:10 ???????? 00:00:01 ora_mmnl_dodo
          oracle??? 2017???? 1? 0 09:10 ???????? 00:00:00 /opt/ora10g/product/10.2.0/db_1/bin/tnslsnr LISTENER -inherit
          oracle??? 2599? 2343? 0 09:10 ???????? 00:00:00 /opt/ora10g/product/10.2.0/db_1/bin/ocssd.bin
          oracle??? 2799? 2798? 0 09:13 pts/1??? 00:00:00 -bash
          oracle??? 2817? 2799? 0 09:13 pts/1??? 00:00:00 sqlplus??????
          oracle??? 2821???? 1? 0 09:14 ???????? 00:00:00 oracledodo (LOCAL=NO)
          oracle??? 2825???? 1? 0 09:16 ???????? 00:00:00 oracledodo (LOCAL=NO)
          ?
          ??? 需要注意的是linux下的進(jìn)程/線(xiàn)程的啟動(dòng)機(jī)制與windows是有區(qū)別的。
          ?
          ?
          ?




          -The End-

          posted on 2009-01-16 23:45 decode360-3 閱讀(652) 評(píng)論(0)  編輯  收藏 所屬分類(lèi): Oracle
          主站蜘蛛池模板: 曲阳县| 讷河市| 吴旗县| 民勤县| 青河县| 南乐县| 鄂尔多斯市| 绥宁县| 长兴县| 永安市| 壤塘县| 友谊县| 象州县| 陇西县| 清涧县| 晋城| 策勒县| 巴林左旗| 安陆市| 宁化县| 海安县| 太仆寺旗| 浦东新区| 桦南县| 馆陶县| 叙永县| 大田县| 志丹县| 内黄县| 屯门区| 娄底市| 兴和县| 汉中市| 华安县| 工布江达县| 大方县| 竹北市| 扬中市| 萝北县| 广昌县| 北安市|