本文共 4102 字，大约阅读时间需要 13 分钟。
1.初使化asm自动存储驱动出错,找不到模块
[root@rac10g01 Desktop]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: yy
Invalid response: yy
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [FAILED]
[root@rac10g01 ~]# tailf /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"
解决方法:
[root@rac10g01 Desktop]# find / -name oracleasm.ko
/lib/modules/2.6.9-89.35.1.EL/kernel/drivers/addon/oracleasm/oracleasm.ko
[root@rac10g01 Desktop]# insmod /lib/modules/2.6.9-89.35.1.EL/kernel/drivers/addon/oracleasm/oracleasm.ko --手动加载模块
[root@rac10g01 Desktop]#
2.在rac节点2找不到asm磁盘
[root@rac10g01 ~]# /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks: [ OK ]
[root@rac10g01 ~]# /etc/init.d/oracleasm listdisks
[root@rac10g01 ~]#
解决方法:
(1).关闭Selinux
(2).检查两个节点的磁盘顺序,根据磁盘的空间大小和磁盘设备号.两边的顺序必须一至,否则节点2检查不到asm磁盘
3.主机名与IP地址没有解析
Checking Network Configuration requirements ...
Check complete. The overall result of this check is: Not executed <<<<
Recommendation: Oracle supports installations on systems with DHCP-assigned public IP addresses. However, the primary network
interface on the system should be configured with a static IP address in order for the Oracle Software to function properly.
See the Installation Guide for more details on installing the software on systems configured with DHCP.
=======================================================================
Validating ORACLE_BASE location (if set) ...
Check complete. The overall result of this check is: Passed
=======================================================================
解决方法:
[root@rac10g01 ~]# vim /etc/hosts
192.168.3.30 localhost.localdomain localhost --添加这行(两个节点各自写自己的IP地址)
[root@rac10g01 ~]#
4.使用系统认证不能登陆(sqlplus / as sysdba)
[oracle@rac10g02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 13 12:02:27 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
解决方法:
[oracle@rac10g02 ~]$ echo $ORACLE_SID
[oracle@rac10g02 ~]$ vi /home/oracle/.bash_profile --添加ORACLE_SID变量
$ORACLE_SID=rac10g2
[oracle@rac10g02 ~]$ . /home/oracle/.bash_profile
[oracle@rac10g02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 13 12:06:53 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
[oracle@rac10g02 ~]$
5.数据库的sid有错误,创建数据库写入的sid与系统不一至
[oracle@rac10g01 database]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 13 12:36:02 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-29760: instance_number parameter not specified
SQL> exit
Disconnected
[oracle@rac10g01 database]$ export ORACLE_SID=rac10g1
[oracle@rac10g01 database]$ echo $ORACLE_SID
rac10g1
[oracle@rac10g01 database]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Nov 13 12:37:08 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL>