最近一次性安装了一批ADG,每一套出现的问题都不一样,现将各种文件总结记录一下:
(1)操作系统检查 rhel5.4不支持
解决方法:
[root@localhost ~]# vi etc/redhat-release
Red Hat Enterprise Linux Server release 5.11 (Tikanga)
将当前的 release 版本修改成为已经测试通过的 release 版本号
redhat-4
原因是:缺少支持打印的图形化动态链接库libXp.so.6
解决方法:
需要安装的软件包如下:
libXau-devel-1.0.1-3.1.i386.rpm
libXp-1.0.0-8.1.el5.i386.rpm
libXp-devel-1.0.0-8.1.el5.i386.rpm
(3)如果安装ASM,oracleasm无法启动

如果版本与内核版本不一致,在执行/usr/sbin/oracleasm configure的时候会报FAILD
Initializing the Oracle ASMLib driver: [FAILED]
看一下日志:
[root@digdeep oracle]# cat var/log/oracleasm
Creating dev/oracleasm mount point: dev/oracleasm
Loading module "oracleasm": failed
Unable to load module "oracleasm"
Loading module "oracleasm": failed
Unable to load module "oracleasm"
... ...
加载oracleasm这个 module 失败。
解决方法:从Oralce提供下载地址下载相关包
https://yum.oracle.com/repo/OracleLinux/OL5/11/base/x86_64/index.html
该地址下可以选择对应的版本:
https://yum.oracle.com/oracle-linux-5.html
(1)环境变量问题
环境变量路径设置不对,找不到netca命令,--bash什么balabala提示,设置环境变量到ORACLE_HOME/bin
(2)无法显示图形界面
比较容易解决,用root用户执行xhost +命令,切到Oracle用户下再次执行
如果依旧不行,查看是不是缺少libXp这个rpm包
此错误的错误提示有java.awt等
java.lang.NullPointerException
at oracle.ewt.lwAWT.BufferedApplet.<init>(Unknown Source)
at oracle.net.ca.NetCA.<init>(Unknown Source)
at oracle.net.ca.NetCA.main(Unknown Source)
Oracle Net Services configuration failed. The exit code is -1
Exception in thread "main" java.lang.UnsatisfiedLinkError: ora/app/oracle/db10g/jdk/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1586)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1503)
at java.lang.Runtime.loadLibrary0(Runtime.java:788)
at java.lang.System.loadLibrary(System.java:834)
at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:50)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(NativeLibLoader.java:38)
at sun.awt.DebugHelper.<clinit>(DebugHelper.java:29)
at java.awt.Component.<clinit>(Component.java:506)
(3)权限问题
确定oracle用户和root用户分别什么用,重新把ORACLE_HOME赋权给oracle
错误提示
java.io.FileNotFoundException:/u01/cfgtoollogs/netca/netca_OraDb11g_home1_0809062PM5029.log(Permission denied)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:102)
at oracle.net.ca.NetCA.main(Unknown Source)
Oracle Net Services configuration failed. The exit code is -1
(4)主机名错误
错误提示:
Oracle Net Services Configuration:
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0x004f0ab3, pid=19917, tid=3086797008
#
# Java VM: Java HotSpot(TM) Client VM (1.4.2_14-b05 mixed mode)
# Problematic frame:
# C [libc.so.6+0x6fab3] index+0x63
#
# An error report file with more information is saved as hs_err_pid19917.log
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
#
/u01/app/oracle/product/10.2.0/db_1/bin/netca: line 190: 19917 Aborted
$JRE -mx64m $SRVM_PROPERTY_DEFS -Dsun.java2d.font.DisableAlgorithmicStyles=true -classpath
由于默认主机名错误导致,修改配置文件/etc/hosts,修改
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost 你的主机名

错误提示说:需要平台ID为212的,但是我提供的PSU包的平台ID是226
但是我又查了,我的oracle的平台ID确实是226的

解决方法:
最后发现是环境变量我从AIX系统直接复制过来的,里面设置了PLATFORM_ID=212 

一个环境变量困扰了我一夜。

RMAN-06136:oracle error from auxiliary database:
ora-01180:can not create datafile 1
ora-01110:data file 1 “xxxxx”

错误原因:
oracle10g 不支持直接 DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK;
如果要使用duplicate,需要先备份数据库
解决办法:

MOS上也有这个问题的佐证:(文档 ID 1265151.1)


<未完待续>




