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/