月度归档:2011年06月

从11.1.0.7 32bit ASM OMF rman backup恢复数据到11.1.0.7 64bit filesystem OMF

 

准备工作
安装64bit软件
Install 11.1.0.6 db software
Upgrate to 11.1.0.7

复制rman备份到新机器
复制init.ora到新机器,修改相关路径如下

*.control_files=’/apps/oradata/DESTDB/controlfile/control01.ctl’
*.db_create_file_dest=’/apps/oradata’
*.db_create_online_log_dest_1=’/apps/oradata’

开始恢复
继续阅读

2011-06-22 6-1-7 Quantifiers

Quantifiers are used to describe the number or amount of something. Certain quantifiers are used with certain kinds of nouns.
The nouns on the left side are examples of countable nouns. They can follow “a” or “an” in the singular. Adding “s” or “es” makes them plural. The nouns on the right side are examples of uncountable nouns. They cannot follow “a” or “an” and cannot be made plural.  继续阅读

ASM ORA-01031: insufficient privileges.

when startup goldengate extract processes,  following errors showed in ggserr.log

2011-06-16 23:24:47  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, extgrp1.prm:  Establishing ASM session for login user SYS: (1031) ORA-01031: insufficient privileges.
2011-06-16 23:24:47  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extgrp1.prm:  PROCESS ABENDING.
2011-06-16 23:24:47  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, extgrp2.prm:  Establishing ASM session for login user SYS: (1031) ORA-01031: insufficient privileges.
2011-06-16 23:24:47  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extgrp2.prm:  PROCESS ABENDING.
2011-06-16 23:24:47  ERROR   OGG-00868  Oracle GoldenGate Capture for Oracle, extgrp3.prm:  Establishing ASM session for login user SYS: (1031) ORA-01031: insufficient privileges.
2011-06-16 23:24:47  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, extgrp3.prm:  PROCESS ABENDING.

继续阅读

PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option “-x” –

During ClusterWare installation , show following errors:

Network Time Protocol (NTP) – This task verifies cluster time synchronization on clusters that use Network Time Protocol (NTP). Error:

PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option “-x” – Cause: NTP daemon on one or more nodes lacked slewing option. – Action: Shut down and restart the NTP daemon after setting the slewing option as follows: For Linux, edit /etc/sysconfig/ntpd and add -x to the command line option. For SUSE Linux, edit /etc/sysconfig/ntp and add -x to the OPTIONS variable. For AIX, edit /etc/rc.tcpip and add -x to the command line option. For HP-UX, edit /etc/rc.config.d/netdaemons and add -x to the command line option. For Solaris, edit /etc/inet/ntp.conf and add ‘slewalways yes’ and ‘disable pll’ in ntp.conf. 继续阅读