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> 











本文转自 z597011036 51CTO博客,原文链接:http://blog.51cto.com/tongcheng/1872206,如需转载请自行联系原作者
目录
相关文章
|
10天前
|
缓存 Linux 测试技术
安装【银河麒麟V10】linux系统--并挂载镜像
安装【银河麒麟V10】linux系统--并挂载镜像
61 0
|
10天前
|
Linux C语言
linux yum安装ffmpeg 图文详解
linux yum安装ffmpeg 图文详解
28 0
|
10天前
|
NoSQL Linux Redis
linux 下和win下安装redis 并添加开机自启 图文详解
linux 下和win下安装redis 并添加开机自启 图文详解
15 0
|
10天前
|
Linux
linux yum 安装rar和unrar
linux yum 安装rar和unrar
35 0
|
22天前
|
Java Linux Maven
Linux中安装MAVEN环境配置
Linux中安装MAVEN环境配置
50 3
|
23天前
|
存储 负载均衡 索引
linux7安装elasticsearch-7.4.0集群配置
linux7安装elasticsearch-7.4.0集群配置
109 0
|
27天前
|
Linux 数据安全/隐私保护 虚拟化
Linux技术基础(1)——操作系统的安装
本文是龙蜥操作系统(Anolis OS) 8.4 的安装指南,用户可以从[龙蜥社区下载页面](https://openanolis.cn/download)获取ISO镜像。安装方法包括物理机的光驱和USB闪存方式,以及虚拟机中的VMware Workstation Pro设置。安装过程涉及选择语言、配置安装目标、选择软件集合和内核,设置Root密码及创建新用户。安装完成后,可通过文本模式或图形化界面验证系统版本,如Anolis OS 8.4,标志着安装成功。
|
23天前
|
消息中间件 Java Linux
Linux下RabbitMQ安装与使用
Linux下RabbitMQ安装与使用
32 1
|
3天前
|
关系型数据库 MySQL Linux
Linux联网安装MySQL Server
Linux联网安装MySQL Server
13 0
|
10天前
|
Java Linux 开发工具
linux jdk的安装
linux jdk的安装
16 0