Archive for the 'Oracle' Category

安装oracle rac时出现crs-1006和crs-0215错误

在安装clusterware时为避免运行root.sh时出现错误,需在第二个节点运行VIPCA,当运行VIPCA时,就出现了如下错误:

crs-1006:No more members to consider
crs-0215:Could not start resource ‘ora.node2.vip’

搜索发现为配置的网关主机不能PING通导致,立即接入一台笔记本,然后将笔记本IP设置为网关IP。点击[retry],故障排除。

创建ASM磁盘时出现错误:Marking disk “VOL1″ as an ASM disk: [FAILED]

安装oracle rac(redhat平台)时,创建asm磁盘时出现failed错误,如下:

[root@node1 /]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdc1
Marking disk “VOL2″ as an ASM disk: [FAILED]

首先查看了asm的状态,如下,状态正常。

[root@node1 /]# /etc/init.d/oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes

接着查看asm的日志,如下:

[root@node1 /]# less /var/log/oracleasm
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module “oracleasm”: oracleasm
Mounting ASMlib driver filesystem: /dev/oracleasm
Reloading disk partitions: done
Cleaning any stale ASM disks…
Scanning system for ASM disks…
oracleasm-read-label: Unable to open device “/dev/sdb1″: No such file or directory
Disk “VOL1″ does not exist or is not instantiated
Instantiating disk “VOL1″
Disk “VOL2″ does not exist or is not instantiated
Instantiating disk “VOL2″
Disk “VOL1″ is a valid ASM disk
Disk “VOL2″ is a valid ASM disk
Device “/dev/sdb1″ is already labeled for ASM disk “VOL1″
Reloading disk partitions: done
Cleaning any stale ASM disks…
Validating disk “VOL1″
Validating disk “VOL2″
Scanning system for ASM disks…
oracleasm-read-label: Unable to open device “/dev/sdb1″: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Disk “VOL1″ is a valid ASM disk
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Disk “VOL2″ is a valid ASM disk
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Disk “VOL1″ is a valid ASM disk
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Disk “VOL2″ is a valid ASM disk
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Device “/dev/sdb1″ is already labeled for ASM disk “VOL1″
Device “/dev/sdc1″ is already labeled for ASM disk “VOL2″

显示为VOL1和VOL2已经存在,所以当我再次创建时就出现了问题。马上把当时创建的这两个ASM删除,如下操作:

[root@node1 /]# /etc/init.d/oracleasm deletedisk VOL1
Removing ASM disk “VOL1″: [ OK ]
[root@node1 /]# /etc/init.d/oracleasm deletedisk VOL2
Removing ASM disk “VOL2″: [ OK ]

然后再次运行创建命令,可以创建了。

[root@node1 /]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdb1
Marking disk “VOL1″ as an ASM disk: [ OK ]
[root@node1 /]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdc1
Marking disk “VOL2″ as an ASM disk: [ OK ]
[root@node1 /]# /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks: [ OK ]
[root@node1 /]# /etc/init.d/oracleasm listdisks
VOL1
VOL2

Oracle 10g RAC for AS 4.8 for x64开启归档日志

环境说明:需要在这个RAC环境中布置NBU备份,ORACLE数据库没启归档所以不能用NBU。只能手工启用归档,并将节点1和节点2的归档放置相应文件夹中。本次配置时NBU客户端安装在节点2上,NBU通过节点2来备份这个RAC数据库。

在节点2上操作查看归档是否启用:

su – oracle
sqlplus /nolog
connect / as sysdba;
archive log list;

数据库日志模式             非存档模式
自动存档             禁用
存档终点            USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列     1
当前日志序列           3

查看后发现未启用归档,进行如下操作可以启用归档:

在节点2上操作:

mkdir /arch1
mkdir /arch2
chown -R oracle:oinstall /arch1
chown -R oracle:oinstall /arch2
chmod -R 777 /arch1
chmod -R 777 /arch2

在节点1上操作:

mkdir /arch1
chown -R oracle:oinstall /arch1
chmod -R 777 /arch1

在节点2上操作(设置归档路径):

su – oracle
sqlplus /nolog
connect / as sysdba;
alter system set log_archive_dest_1=”location=/arch1″ scope=spfile sid=’sid1′;
alter system set log_archive_dest_1=”location=/arch2″ scope=spfile sid=’sid2′;

 在节点2上操作(停止集群中的数据库,然后MOUNT数据库,开始启用归档):

srvctl stop database -d sid
su – oracle
startup mount
alter database archivelog;
alter database open;
srvctl start database -d sid

在节点2上操作(强制生成归档,来查看归档启用是否成功):

su – oracle
sqlplus /nolog
connect / as sysdba;
alter system switch logfile;

然后进/arch2,查看目录是否生成了归档日志文件

接下来需要将节点1上的/arch1通过NFS映射给节点2上的/arch1目录。因为NBU备份客户端只装在节点2上,当NBU开始备份/arch1下的归档文件时,会因为目录下没有文件而出错,所以这里要求将节点1上的/arch1目录映射给节点2上的/arch1目录,操作如下:

在节点1上开NFS:
首先查看是否安装:

rpm -qa | grep nfs
rpm -qa | grep portmap

若没有安装,需安装相应包:

rpm -ivh nfs*
rpm -ivh portmap

配置NFS:

vi /etc/exports

添加如下一行:

/arch1 *(rw)


添加完后保存退出

启动NFS:

service portmap start
service nfs start

在节点2上操作,挂载节点1上的/arch1目录:

mount -t nfs -o rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0 10.10.10.1:/arch1 /arch1