XX省系統問題總結:
1.RAC的CRS安裝過程執行root.sh時隻有一個節點可以通過,另外一個節點提示錯誤:
2009-02-15 23:16:53.309: [ OCRCONF][2644501648]ocrconfig starts...
2009-02-15 23:16:53.310: [ OCRCONF][2644501648]Upgrading OCR data
2009-02-15 23:17:46.892: [ OCRRAW][2644501648]propriogid:1: INVALID FORMAT
2009-02-15 23:17:46.892: [ OCRRAW][2644501648]propriogid:1: INVALID FORMAT
解決辦法:
問題是由于主機名是大寫的Oracle無法翻譯導緻的
主機名修改成小寫的
2.RACDB安裝的過程中碰見使用的檔案系統不是共享檔案系統
解決辦法:
問題是由于裸裝置裡沒有給定pfile和pwdfile導緻的
是以共享檔案系統的中要留出pfile和pwdfile的,或者做成共享的裸裝置
3.RAC中的vg是共享的,如果要修改lv的話必須要單向激活再修改:
vgchange -a n /dev/crmvg03 --node1上執行
vgchange -a n /dev/crmvg03 --node2上執行
vgchange -c n /dev/crmvg03 --node1上執行
vgchange -a y /dev/crmvg03 --node1上執行
lvchange。。。。。。。
vgchange -a n /dev/crmvg03 --node1上執行
rm -rf /tmp/aaa.map --node1上執行
vgexport -v -s -p -m /tmp/aaa.map /dev/crmvg03 --node1上執行
cp...
vgexport crmvg03 --node2上執行
vgimport -v -s -m /tmp/aaa.map /dev/crmvg03 --node2上執行
vgchange -c y -S y crmvg03 ---node1或者node2上執行都可以
vgchange -a s crmvg03 /dev/crmvg03 --node1和node2上分别執行
例子:
[h1011101]:[/]#vgdisplay crmvg03
--- Volume groups ---
VG Name /dev/crmvg03
VG Write Access read/write
VG Status available, shared, client
Max LV 2047
Cur LV 251
Open LV 251
Max PV 2048
Cur PV 32
Act PV 32
Max PE per PV 32768
VGDA 64
PE Size (Mbytes) 32
Total PE 30976
Alloc PE 30912
Free PE 64
Total PVG 0
Total Spare PVs 0
Total Spare PVs in use 0
VG Version 2.1
VG Max Size 1t
VG Max Extents 32768
[h1011101]:[/]#
[h1011101]:[/]#
[h1011101]:[/]#vgchange -a n /dev/crmvg03
Deactivated volume group in Shared Mode.
Volume group "/dev/crmvg03" has been successfully changed.
[h1011101]:[/]#
[h1011101]:[/]#vgchange -c n /dev/crmvg03
Configuration change completed.
Volume group "/dev/crmvg03" has been successfully changed.
[h1011101]:[/]#vgchange -a y /dev/crmvg03
Activated volume group.
Volume group "/dev/crmvg03" has been successfully changed.
[h1011101]:[/]#
[h1011101]:[/]#
[h1011101]:[/]#lvcreate -i 32 -I 128 -n spfile -L 512 /dev/crmvg03
lvcreate -i 32 -I 128 -n pwdfile -L 512 /dev/crmvg03Warning: rounding up logical volume size to extent boundary at
size "1024" MB for striping.
Logical volume "/dev/crmvg03/spfile" has been successfully created with
character device "/dev/crmvg03/rspfile".
Logical volume "/dev/crmvg03/spfile" has been successfully extended.
Volume Group configuration for /dev/crmvg03 has been saved in /etc/lvmconf/crmvg03.conf
[h1011101]:[/]#lvcreate -i 32 -I 128 -n pwdfile -L 512 /dev/crmvg03
Warning: rounding up logical volume size to extent boundary at
size "1024" MB for striping.
Logical volume "/dev/crmvg03/pwdfile" has been successfully created with
character device "/dev/crmvg03/rpwdfile".
Logical volume "/dev/crmvg03/pwdfile" has been successfully extended.
Volume Group configuration for /dev/crmvg03 has been saved in /etc/lvmconf/crmvg03.conf
[h1011101]:[/]#
[h1011101]:[/]#
[h1011101]:[/]#vgchange -a n /dev/crmvg03
Volume group "/dev/crmvg03" has been successfully changed.
[h1011101]:[/]#rm -rf /tmp/aaa.map
[h1011101]:[/]#vgexport -v -s -p -m /tmp/aaa.map /dev/crmvg03
Beginning the export process on Volume Group "/dev/crmvg03".
/dev/dsk/c11t6d0
/dev/dsk/c11t6d1
.
.
.
.
.
/dev/dsk/c9t9d7
vgexport: Preview of vgexport on volume group "/dev/crmvg03" succeeded.
[h1011101]:[/]#ftp 130.84.201.4
Connected to 130.84.201.4.
220 h1011102 FTP server (Revision 4.0 Version wuftpd-2.6.1 Wed Jun 18 07:11:14 GMT 2008) ready.
Name (130.84.201.4:root): root
331 Password required for root.
Password:
230 User root logged in.
Remote system type is UNIX.
Using binary mode to transfer files.
ftp> cd /tmp
250 CWD command successful.
ftp> ls
200 PORT command successful.
150 Opening ASCII mode data connection for /usr/bin/ls.
總數 512
drwx------ 2 root root 96 2月16日 15:48 .AgentSockets
-rw-rw-rw- 1 root root 141 2月16日 15:48 .kc.trace
drwxrwxrwt 2 root sys 8192 2月16日 13:53 .oracle
srwxrwxrwx 1 sfmdb users 0 2月16日 20:43 .s.PGSQL.10864
-rw------- 1 sfmdb users 26 2月16日 20:43 .s.PGSQL.10864.lock
-rw-r--r-- 1 root sys 0 2月12日 20:53 1111io_listener.log
-rw-r--r-- 1 root sys 0 2月12日 20:52 ACL.log
drwxrwxr-- 3 oracrm dba 8192 2月15日 19:39 CVU_10.2.0.1.0.1_dba
drwxrwxrwx 8 oracrm dba 8192 2月15日 20:23 OraInstall2009-02-15_07-55-11PM
drwxrwxrwx 5 oracrm dba 96 2月15日 20:57 OraInstall2009-02-15_08-55-48PM
drwxrwxrwx 8 oracrm dba 8192 2月15日 22:26 OraInstall2009-02-15_10-18-54PM
drwxrwxrwx 5 oracrm dba 96 2月16日 16:57 OraInstall2009-02-16_04-55-09PM
drwxrwxrwx 5 oracrm dba 8192 2月16日 10:31 OraInstall2009-02-16_10-29-52AM
drwxrwxrwx 8 oracrm dba 8192 2月16日 10:49 OraInstall2009-02-16_10-41-54AM
drwxrwxrwx 5 oracrm dba 96 2月16日 11:01 OraInstall2009-02-16_11-00-07AM
drwxrwxrwx 8 oracrm dba 8192 2月16日 11:27 OraInstall2009-02-16_11-21-38AM
drwxrwxrwx 5 oracrm dba 96 2月16日 12:02 OraInstall2009-02-16_12-00-28PM
-rw-r--r-- 1 root sys 4116 2月16日 15:00 aaa.map
-rw-rw-rw- 1 root sys 3842 2月16日 09:27 crmvg04_16.map
-rw-rw-rw- 1 oracrm dba 152 2月15日 22:34 crsctl.2512
-rw-r--r-- 1 root sys 30 2月12日 20:13 emc_app_data_path
-rw-r--r-- 1 root sys 30 2月12日 20:13 emc_app_path
-rw-r--r-- 1 root sys 215 2月12日 20:13 emc_installed_found
drwxrwxrwx 4 root sys 8192 2月15日 22:29 hp
-r--r--r-- 1 root sys 1257 2月13日 12:19 install.vars
-rw-r--r-- 1 root sys 32123 2月14日 10:44 iotreeip.trc
-rw-r--r-- 1 root root 0 2月16日 15:48 ipv6agt.crashlog
-r--r--r-- 1 root root 0 2月15日 18:40 llbdbase.dat
drwxr-xr-x 2 root root 96 2月13日 12:16 lost+found
-rw-rw-rw- 1 root sys 4012 2月16日 10:28 mapfile
-rw-rw-rw- 1 root sys 1259 2月16日 20:34 ncweb_nicinfo.log
-rw-rw-rw- 1 root sys 54260 1月 6日 18:05 pfF49957231003.su227-04.txt
-rw------- 1 root root 364 2月15日 17:50 portmap.file
-rw------- 1 root root 1724 2月15日 17:50 rpcbind.file
226 Transfer complete.
ftp> del aaa.map
250 DELE command successful.
ftp> ascii
200 Type set to A.
ftp> put /tmp/aaa.tmp
/tmp/aaa.tmp: No such file or directory
ftp> put /tmp/aaa.map
200 PORT command successful.
150 Opening ASCII mode data connection for /tmp/aaa.map.
226 Transfer complete.
4394 bytes sent in 0.00 seconds (54316.66 Kbytes/s)
ftp> bye
221-You have transferred 4139 bytes in 1 files.
221-Total traffic for this session was 7546 bytes in 2 transfers.
221-Thank you for using the FTP service on h1011102.
221 Goodbye.
——————————————————————————————————————————————————————————————————
——————————————————————————————————————————————————————————————————
注意從這裡切換到另外一個節點操作
執行
vgexport crmvg03
vgimport -v -s -m /tmp/aaa.map /dev/crmvg03
——————————————————————————————————————————————————————————————————
——————————————————————————————————————————————————————————————————
[h1011101]:[/]#vgchange -c y -S y crmvg03
Activated volume group in Shared Mode.
[h1011101]:[/]#vgchange -a s crmvg03 /dev/crmvg03
Activated volume group in Shared Mode.
This node is a Client.
Volume group "crmvg03" has been successfully changed.
Volume group "/dev/crmvg03" is already active in requested mode.
[h1011101]:[/dev/crmvg03]#vgdisplay crmvg03
--- Volume groups ---
VG Name /dev/crmvg03
VG Write Access read/write
VG Status available, shared, client
Max LV 2047
Cur LV 253
Open LV 253
Max PV 2048
Cur PV 32
Act PV 32
Max PE per PV 32768
VGDA 64
PE Size (Mbytes) 32
Total PE 30976
Alloc PE 30976
Free PE 0
Total PVG 0
Total Spare PVs 0
Total Spare PVs in use 0
VG Version 2.1
VG Max Size 1t
VG Max Extents 32768
4.work使用者配置好之後執行sqlplus 報錯:
------------------------------------------------------------------------------
$ ./sqlplus
/usr/lib/hpux64/dld.so: Unable to find library 'libclntsh.so.10.1'.
Killed
------------------------------------------------------------------------------
原因:
由于安裝資料庫之前設定了oracle使用者的umask值=022
解決辦法:
root使用者登陸系統
把$ORACLE_HOME的權限修改成:chmod a+rx
注意以後不要設定,或者是設定成002,或者是安裝資料庫之後再設定
5.監聽和資料庫都啟動之後卻還是無法登陸
原因:
由于我們使用了service技術,service沒有啟動的情況下監聽無法對外服務
6.AIX 主機上執行cpio -idmv< 10gr2_aix5l64_database.cpio 提示cpio: 0511-903 Out of phase!錯誤
加上一個參數解壓cpio -idcmv <10gr2_aix5l64_database.cpio
7. AIX 主機上無法啟動監聽
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 21-FEB-2009 22:21:03
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /arrayora/app/product/10204/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
System parameter file is /arrayora/app/product/10204/network/admin/listener.ora
Log messages written to /arrayora/app/product/10204/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=H1010108)(PORT=8888)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=H1010108)(PORT=8888)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 79: Connection refused
原因: /etc/hosts 裡配置資訊如下:
**.**.**.** H1010108 H1010108
解決辦法修改為:
**.**.**.** H1010108 localhost
9.CRM庫運作了一段時間之後出現如下情況:
drop user table 等都無法删除,提示錯誤資訊如下:
SQL> drop user test;
drop user test
*
μú 1 DD3???′í?ó:
ORA-00604: μY1é SQL ??±e 1 3???′í?ó
ORA-01008: 2¢·??ùóD±?á???ò?°ó?¨
ORA-06512: ?ú line 21
解決辦法:
alter system set cursor_sharing='EXACT' scope=both;
10.RAC的資料源裡連接配接串的寫法:
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =IP1)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST =IP2)(PORT = 1521))(LOAD_BALANCE = YES)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = SERVICE_NAME)))
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/598601/viewspace-608071/,如需轉載,請注明出處,否則将追究法律責任。
轉載于:http://blog.itpub.net/598601/viewspace-608071/