好久不維護(hù)啦
posted @ 2006-03-07 23:41 周斌 閱讀(210) | 評論 (0) | 編輯 收藏
我的JAVA從頭來
隨筆 - 19, 文章 - 0, 評論 - 6, 引用 - 0
|
AIX安裝ORACLE(三)------安裝1.開始安裝使用如下命令掛接CDROM: # mount -rv cdrfs /dev/cd0 /cdrom
root運(yùn)行 rootpre.sh 腳本。 # /cdrom/rootpre.sh #su - oracle % cd /tmp % /cdrom/runInstaller 選y 如果事先沒有運(yùn)行rootpre.sh腳本,會有提示:以root運(yùn)行rootpre.sh,之后選y,進(jìn)行正常安裝; 會有提示運(yùn)行orainstRoot.sh腳本,到link結(jié)束的時(shí)候會提示運(yùn)行root.sh腳本,按要求完成即可。 打開一個(gè)命令操作窗口(dtterm窗口); 在運(yùn)行runInstaller后會提示以root運(yùn)行rootpre.sh,之后選y,進(jìn)行正常安裝; 2.建庫用dbca工具建庫(ora9)。 3.?dāng)?shù)據(jù)庫啟動(dòng)關(guān)閉. 數(shù)據(jù)庫的啟動(dòng): 登錄到oracle運(yùn)行如下命令: #su - oracle $export ORACLE_SID=ora9 $ sqlplus /nolog sql>connect / as sysdba; sql>startup; . 數(shù)據(jù)庫的關(guān)閉 登錄到oracle運(yùn)行如下命令: #su - oracle $export ORACLE_SID=ora9 $ sqlplus /nolog sql>connect / as sysdba; sql>shutdown immediate; 10.3. 監(jiān)聽服務(wù)的啟動(dòng) 登錄到oracle運(yùn)行如下命令: $ lsnrctl start ora9 10.4. 監(jiān)聽服務(wù)的關(guān)閉 登錄到oracle運(yùn)行如下命令: $ lsnrctl stop ora9
posted @ 2005-11-16 21:55 周斌 閱讀(905) | 評論 (0) | 編輯 收藏 AIX安裝ORACLE(二)-------安裝準(zhǔn)備安裝準(zhǔn)備1.添加Oracle用戶和dba組用root用戶完成下面的操作。 2.創(chuàng)建軟件安裝點(diǎn)
3.確保Asynchronous Input Output (AIO) 可用# lsdev -Cc aio
如果輸出是"Available"則沒問題,如果是"Defined"的話,通過使用 # smit chaio
把"STATE to be configured at system restart"更改為"Available" 4.確定math library已經(jīng)安裝在系統(tǒng)中
bos.adt.base,bos.adt.lib,bos.adt.libm, bos.perf.perfstat 使用如下命令; # lslpp -l bos.adt.libm
如果沒安裝的話,你還要使用下面的命令安裝 bos.adt.libm fileset: # smit install_latest
AIX # lslpp -l bos.perf.perfstat # lslpp bos.perf.libperfstat
5. 安裝JDK
6.設(shè)置環(huán)境變量
設(shè)置以下環(huán)境變量到oracle用戶的”.profile”文件中: ORACLE_BASE=/oracle/app; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/ ORACLE_SID=ora9; export ORACLE_SID ORACLE_TERM=vt100; export ORACLE_TERM TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN #NLS_LANG= SIMPLIFIED CHINESE.ZHS16GBK; export NLS_LANG ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33 LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib ;export LIBPATH ORA_DB=$ORACLE_HOME/dbs;export ORA_DB CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib CLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/JRE/lib/rt.jar:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;export CLASSPATH PATH=$ORACLE_HOME/bin:$PATH; export PATH export DISPLAY= 127.0.0.1:0.0 posted @ 2005-11-16 21:43 周斌 閱讀(1037) | 評論 (0) | 編輯 收藏 AIX安裝ORACLE(一)-----環(huán)境準(zhǔn)備環(huán)境準(zhǔn)備 1.系統(tǒng)資源
· /tmp(或可用做臨時(shí)空間的Disk)要有 500 MB以上的空間 · 256 MB以上的物理內(nèi)存 · 至少兩倍物理內(nèi)存的交換空間 2.操作系統(tǒng)· 查看主機(jī)名 $ uname -a
· 是否64位的操作系統(tǒng): #bootinfo -y
或者 #bootinfo -K 注意:因?yàn)?SPAN lang=EN-US>ORACLE 9I為64位,所以安裝的AIX平臺也必須是64位。如果不是必須要重新安裝或使用連接庫函數(shù)將其改為64位 此外,AIX上面安裝Oracle無需修改核心參數(shù)。 3.安裝介質(zhì)# lsdev -Cc cdrom cd0 Available 10-60-00-4, mount CDROM $ cd /ora_data/install $ mkdir Disk1 $ cd Disk1 $ cp -r /cdrom/* . posted @ 2005-11-16 21:15 周斌 閱讀(1283) | 評論 (1) | 編輯 收藏 HACMP配置(-)
HACMP的配置(-)
Hacmp(High Availability Cluster Multi-Processing)雙機(jī)熱備份軟件的主要功能是提高客戶計(jì)算機(jī)系統(tǒng)及其應(yīng)用的可靠性,而不是單臺主機(jī)的可靠性。 HACMP的工作原理是利用LAN來監(jiān)控主機(jī)及網(wǎng)絡(luò)、網(wǎng)卡的狀態(tài)。在一個(gè)HACMP環(huán)境中有TCP/IP網(wǎng)絡(luò)和非TCP/IP網(wǎng)絡(luò)。TCP/IP網(wǎng)絡(luò)即應(yīng)用客戶端訪問的公共網(wǎng),該網(wǎng)可以是大多數(shù)AIX所支持的網(wǎng)絡(luò),如Ethernet,T.R.,FDDI,ATM,SOCC,SLIP,等等。 非TCP/IP網(wǎng)絡(luò)用來為HACMP對HA環(huán)境(Cluster)中的各節(jié)點(diǎn)進(jìn)行監(jiān)控而提供的一個(gè)替代TCP/IP的通訊路徑,它可以是用RS232串口線將各節(jié)點(diǎn)連接起來,也可以是將各節(jié)點(diǎn)的SCSI卡或SSA卡設(shè)置成Target Mode方式。
一、在兩臺服務(wù)器上分別安裝HACMP軟件 #smit installp 二、分別檢查兩臺主機(jī)上安裝的軟件是否成功 #/usr/sbin/cluster/diag/clverify software cluster clverify>software Valid Options are: lpp clverify.software> lpp 若沒有error出現(xiàn)則安裝成功 三、分別配置兩臺服務(wù)器的boot IP地址和Standby IP地址,保證boot 網(wǎng)和Standby網(wǎng)能ping通(用smit tcpip命令) 用netstat命令檢查配置是否正確: #netstat -i 四、利用smit tty在兩臺主機(jī)上增加一個(gè)TTY接口,配置心跳線(RS232): #smitty tty Type or select values in entry fields. Press Enter AFTER making all desired changes. [TOP] [Entry Fields] TTY tty0 TTY type tty TTY interface rs232 Description Asynchronous Terminal Status Available Location Parent adapter sa0 PORT number [0] + Enable LOGIN disable + BAUD rate [38400] + PARITY [none] + BITS per character [8] + Number of STOP BITS [1] + TIME before advancing to next port setting [0] + TERMINAL type [dumb] FLOW CONTROL to be used [xon] + OPEN DISCIPLINE to be used [dtropen] + 用lsdev –Cc tty查看tty是否配置好 #lsdev –Cc tty 在兩臺上分別輸入如下命令: erp# cat /etc/hosts >/dev/tty0 erpdata# cat 如果在erpdata能接收到信息,則表明心跳線已經(jīng)配置好 五、在erp上運(yùn)行smit hacmp,然后按照下面的步驟進(jìn)行配置: #smit hacmp 配置Cluster Name [erpcluster] 配置Configure Nodes,增加兩個(gè)Node * Node Names [erp] * Node Names [erpdata] 配置Configure Adapters,分別配置兩臺機(jī)的service地址,boot地址,standby地址及tty(erp_svc、erpdata_svc、erp_en1、erpdata_en1、erp_en2、erpdata_en2,erp_tty0_01,erpdata_tty0_01) 修改/etc/hosts及/.rhosts文件,如: 修改/etc/hosts文件,增加以下內(nèi)容: 192.168.112.11 erpdata_en2 192.168.113.11 erpdata_en1 10.80.14.11 erpdata_svc 192.168.112.12 erp_en2 192.168.113.12 erp_en1 10.80.14.12 erp_svc
配置完畢顯示狀態(tài)為 COMMAND STATUS Command: OK stdout: yes stderr: no Before command completion, additional instructions may appear below. [TOP] Cluster Name: erpcluster Cluster Connection Authentication Mode: Standard Cluster Message Authentication Mode: None Cluster Message Encryption: None Use Persistent Labels for Communication: No There are 2 node(s) and 2 network(s) defined NODE erp: Network net_ether_01 erp_svc 10.80.14.12 erpdata_svc 10.80.14.11 erp_en1 192.168.113.12 erp_en2 192.168.112.12 Network net_rs232_01 erp_tty0_01 /dev/tty0 NODE erpdata: Network net_ether_01 erp_svc 10.80.14.12 erpdata_svc 10.80.14.11 erpdata_en1 192.168.113.11 erpdata_en2 192.168.112.11 Network net_rs232_01 erpdata_tty0_01 /dev/tty0 Resource Group dbrg Startup Policy Online On Home Node Only Fallover Policy Fallover To Next Priority Node In The List Fallback Policy Fallback To Higher Priority Node In The List Participating Nodes erpdata erp Service IP Label erpdata_svc Resource Group apprg Startup Policy Online On Home Node Only Fallover Policy Fallover To Next Priority Node In The List Fallback Policy Fallback To Higher Priority Node In The List Participating Nodes erp erpdata Service IP Label erp_svc 六、同步cluster 在進(jìn)行同步的時(shí)候可以先進(jìn)行模擬(Emulate)同步,當(dāng)模擬同步 OK后再進(jìn)行實(shí)際(actual)同步 Synchronize Cluster Topology posted @ 2005-11-01 22:59 周斌 閱讀(1138) | 評論 (0) | 編輯 收藏 ORACLE歸檔模式下恢復(fù)----UNDO,數(shù)據(jù)文件損壞有個(gè)同學(xué)在MSN和我聊起ORACLE維護(hù)的事,他對歸檔文件的概念不是很熟。我就叫他看書,他講看書暈糊糊,叫我做個(gè)實(shí)例給他看。我就在MSN上一步步的示范,順便貼出來。不過,我記得好像我以前也是看別人的,不要鄙視我哦?。?BR>他很仰慕哦,我回答:“無它,手熟耳!” SEQ NAME LOC SEQ NAME LOC 看警告日志D:\oracle\admin\a00215\bdump\alert_test.log,
數(shù)據(jù)庫已更改。 SQL> select * from zb.family; SEQ NAME LOC OK SEQ NAME LOC posted @ 2005-08-30 21:30 周斌 閱讀(1922) | 評論 (0) | 編輯 收藏 IBM小機(jī)設(shè)備信息(2)
lsdev
L2cache0 Available L2 Cache aio0 Defined Asynchronous I/O (Legacy) cd0 Available 03-08-00 IDE DVD-ROM Drive dac0 Available 05-08-02 1722-600 (600) Disk Array Controller dac1 Available 0A-08-02 1722-600 (600) Disk Array Controller dar0 Available 1722-600 (600) Disk Array Router datavg Defined Volume group en0 Defined 08-08 Standard Ethernet Network Interface en1 Available 08-09 Standard Ethernet Network Interface en2 Available 0B-08 Standard Ethernet Network Interface ent0 Available 08-08 2-Port 10/100/1000 Base-TX PCI-X Adapter (141 08902) ent1 Available 08-09 2-Port 10/100/1000 Base-TX PCI-X Adapter (141 08902) ent2 Available 0B-08 10/100/1000 Base-TX PCI-X Adapter (14106902) et0 Defined 08-08 IEEE 802.3 Ethernet Network Interface et1 Defined 08-09 IEEE 802.3 Ethernet Network Interface et2 Defined 0B-08 IEEE 802.3 Ethernet Network Interface fcnet0 Defined 05-08-01 Fibre Channel Network Protocol Device fcnet1 Defined 0A-08-01 Fibre Channel Network Protocol Device fcs0 Available 05-08 FC Adapter fcs1 Available 0A-08 FC Adapter fscsi0 Available 05-08-02 FC SCSI I/O Controller Protocol Device fscsi1 Available 0A-08-02 FC SCSI I/O Controller Protocol Device fslv00 Available Logical volume fwdump Defined Logical volume hd1 Defined Logical volume hd2 Defined Logical volume hd3 Defined Logical volume hd4 Defined Logical volume hd5 Defined Logical volume hd6 Defined Logical volume hd8 Defined Logical volume hd10opt Defined Logical volume hd9var Defined Logical volume hdisk0 Available 09-08-00-5,0 16 Bit LVD SCSI Disk Drive hdisk1 Available 09-08-00-8,0 16 Bit LVD SCSI Disk Drive hdisk2 Available 05-08-02 1722-600 (600) Disk Array Device hdisk3 Available 0A-08-02 1722-600 (600) Disk Array Device ide0 Available 03-08 ATA/IDE Controller Device inet0 Available Internet Network Extension iscsi0 Available iSCSI Protocol Device kbd0 Available 1.1 USB keyboard kbd1 Defined 0.1 USB keyboard lai0 Available 07-00 GXT135P Graphics Adapter lft0 Available Low Function Terminal Subsystem lg_dumplv Defined Logical volume lo0 Available Loopback Network Interface loglv00 Available Logical volume lvdd Available LVM Device Driver mem0 Available Memory mouse0 Available 1.1 USB mouse mouse1 Defined 0.1 USB mouse nampd0 Available N/A pci0 Available PCI Bus pci1 Available PCI Bus pci2 Available 00-12 PCI Bus pci3 Available 00-13 PCI Bus pci4 Available 00-10 PCI Bus pci5 Available 00-14 PCI Bus pci6 Available 00-16 PCI Bus pci7 Available 06-08 PCI Bus pci8 Available 01-12 PCI Bus pci9 Available 01-14 PCI Bus pci10 Available 01-10 PCI Bus pci11 Available 01-16 PCI Bus posix_aio0 Defined Posix Asynchronous I/O proc0 Available 00-00 Processor proc2 Available 00-02 Processor proc4 Available 00-04 Processor proc6 Available 00-06 Processor pty0 Available Asynchronous Pseudo-Terminal rcm0 Available Rendering Context Manager Subsystem rmt0 Available 09-08-00-0,0 LVD SCSI 4mm Tape Drive rootvg Defined Volume group sa0 Available 04-08 IBM 8-Port EIA-232/RS-422A (PCI) Adapter scsi0 Available 09-08-00 PCI-X Dual Channel Ultra320 SCSI Adapter bus scsi1 Available 09-08-01 PCI-X Dual Channel Ultra320 SCSI Adapter bus ses0 Available 09-08-00-15,0 SCSI Enclosure Services Device sisscsia0 Available 09-08 PCI-X Dual Channel Ultra320 SCSI Adapter sys0 Available System Object sysplanar0 Available System Planar tty0 Available 04-08-01-00 Asynchronous Terminal usb0 Available USB System Software usbhc0 Available 02-08 USB Host Controller (33103500) usbhc1 Available 02-09 USB Host Controller (33103500) vio0 Available Virtual I/O Bus vsa0 Available LPAR Virtual Serial Adapter vsa1 Available LPAR Virtual Serial Adapter vty0 Available Asynchronous Terminal vty1 Available Asynchronous Terminal posted @ 2005-08-29 22:13 周斌 閱讀(920) | 評論 (0) | 編輯 收藏 IBM小機(jī)的設(shè)備信息,看看erp # prtconf Network Information Paging Space Information Volume Groups Information datavg: INSTALLED RESOURCE LIST The following resources are installed on the machine. Model Architecture: chrp + sys0 posted @ 2005-08-29 22:11 周斌 閱讀(1351) | 評論 (1) | 編輯 收藏 正寫東西,還沒空學(xué)習(xí)
這幾天領(lǐng)導(dǎo)叫寫點(diǎn)東西,都沒空學(xué)習(xí),慚愧!!
posted @ 2005-08-29 22:07 周斌 閱讀(233) | 評論 (0) | 編輯 收藏 |
|