oracle linux 4.8安裝oracl 10g rac錯誤解決

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>