1.ORA-00845: MEMORY_TARGET not supported on this system
MEMORY_MAX_TARGET 的设置不能超过 /dev/shm 的大小
memory_max_target=4404019200
解决方法:mount -o remount,size=5G /dev/shm
查看df -h | grep shm
2.sqlplus可以登录,pl/sql Development 报ORA-01017:invalid username/password;logon denied
--重新执行一遍密码设置
alter user XXX identified by 123456;
3.Oracle 11gR2 RAC ohasd failed to start
CRS-4124: Oracle High Availability Services startup failed.
CRS-4000: Command Start failed, or completed with errors.
ohasd failed to start: Inappropriate ioctl for device
ohasd failed to start at/u01/app/11.2.0/grid/crs/install/rootcrs.pl line 443.
第一次安装11gR2 RAC的时候就遇到了这个11.0.2.1的经典问题,上网一查才知道这是个bug,解决办法也很简单,
就是在执行root.sh之前执行以下命令/bin/dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1
如果出现
/bin/dd: opening`/var/tmp/.oracle/npohasd': No such file or directory
的时候文件还没生成就继续执行,直到能执行为止,一般出现Adding daemon to inittab这条信息的时候执行dd命令。
另外还有一种解决方法就是更改文件权限
chown root:oinstall /var/tmp/.oracle/npohasd
重新执行root.sh之前别忘了删除配置:/u01/app/11.2.0/grid/crs/install/roothas.pl -deconfig -force -verbose
4.ORA-00245: control file backup failed; target is likely on a local file system
检查快照控制文件位置
RMAN> show snapshot controlfile name;
配置snapshot controlfile 到共享位置
RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '<shared_disk>/snapcf_<DBNAME>.f';
如果使用了ASM,就指定到对应的ASM disk group:
RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '+<DiskGroup>/snapcf_<DBNAME>.f';