Category Archives: Study

Step by Step – Oracle database physical migrate

中文版:http://www.ioracle.org/archives/241

由于特殊原因,顺便写了此英文版,较中文版更简略。

On source database:
1.    Use the following scripts to trace control file.

SELECT    d.VALUE
 || '/'
 || LOWER (RTRIM (i.INSTANCE, CHR (0)))
 || '_ora_'
 || p.spid
 || '.trc' trace_file_name
 FROM (SELECT p.spid
 FROM v$mystat m, v$session s, v$process p
 WHERE m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p,
 (SELECT t.INSTANCE
 FROM v$thread t, v$parameter v
 WHERE v.NAME = 'thread'
 AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i,
 (SELECT VALUE
 FROM v$parameter
 WHERE NAME = 'user_dump_dest') d
/

2.    Collect source database information
—Character Set

col parameter for a50
col value for a50
select * from nls_database_parameters;

—Block

show parameter block

—Export Control File read more »

Install 64 bit VirtualBox

安装64bit VirtualBox时应注意如下一句:

The package architecture has to match the Linux kernel architecture, that is, if you are running a 64-bit  kernel, install the appropriate AMD64 package (it does not matter if you have an Intel or an AMD CPU).

所以,如果是64位版本,不管是Intel or AMD,下载AMD版本就好:

Red Hat Enterprise Linux 5 (“RHEL5″) / Oracle Linux 5 (“OL5″) / CentOS 5 i386 | AMD64

执行如下命令安装成功: read more »

The VMware Authorization Service is not running提示

启动虚拟机时候出现The VMware Authorization Service is not running提示,第一想法竟然还是重装虚拟机,不过很快打消,决定解决下这个问题。

解决方法很简单:

在Windows服务中,启动VMware Authorization Service服务即可。

或者在管理员模式下启动CMD,执行:

net start VMAuthdService

Cluster Time Synchronization(RAC中节点间时间同步问题)

同样,在AIX上装RAC时遇到时间同步问题。使用imp导入数据时节点2宕掉,告警日志如下。

节点2:

2010-05-10 14:38:20.599
[ctssd(5243264)]CRS-2404:The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time. Details in /oracle/app/11.2.0/grid/log/jzdbiufo/ctssd/octssd.log.
2010-05-10 14:38:20.599
[ctssd(5243264)]CRS-2408:The clock on host jzdbiufo has been updated by the Cluster Time Synchronization Service to be synchronous with the mean cluster time.
2010-05-10 15:11:25.818
[ctssd(5243264)]CRS-2404:The Cluster Time Synchronization Service detects that the local time is significantly different from the mean cluster time. Details in /oracle/app/11.2.0/grid/log/jzdbiufo/ctssd/octssd.log.
2010-05-10 15:11:25.818
[ctssd(5243264)]CRS-2408:The clock on host jzdbiufo has been updated by the Cluster Time Synchronization Service to be synchronous with the mean cluster time.
2010-05-10 15:21:46.319
[cssd(4259964)]CRS-1612:Network communication with node jzdbnc (1) missing for 50% of timeout interval. Removal of this node from cluster in 14.926 seconds
2010-05-10 15:21:54.322
[cssd(4259964)]CRS-1611:Network communication with node jzdbnc (1) missing for 75% of timeout interval. Removal of this node from cluster in 6.923 seconds
2010-05-10 15:21:58.348
[cssd(4259964)]CRS-1610:Network communication with node jzdbnc (1) missing for 90% of timeout interval. Removal of this node from cluster in 2.897 seconds
2010-05-10 15:22:01.253
[cssd(4259964)]CRS-1609:This node is unable to communicate with other nodes in the cluster and is going down to preserve cluster integrity; details at (:CSSNM00008:) in /oracle/app/11.2.0/grid/log/jzdbiufo/cssd/ocssd.log.
2010-05-10 15:22:01.254
[cssd(4259964)]CRS-1656:The CSS daemon is terminating due to a fatal error; Details at (:CSSSC00012:) in /oracle/app/11.2.0/grid/log/jzdbiufo/cssd/ocssd.log
2010-05-10 15:22:01.339
[cssd(4259964)]CRS-1652:Starting clean up of CRSD resources.
2010-05-10 15:22:01.927
[cssd(4259964)]CRS-1608:This node was evicted by node 1, jzdbnc; details at (:CSSNM00005:) in /oracle/app/11.2.0/grid/log/jzdbiufo/cssd/ocssd.log.

可以看到,在15:22:03.111,节点2被节点1驱逐出集群,在这之前,节点2本地时间与the mean cluster time相差很大,所以一直在更新此节点时间。从之前的告警中也可以看到,一直在报类似的问题。

再去看节点1的告警:

read more »

AIX上配置SSH Connectivity遇到Existence check failed for /bin/bash错误

在AIX上安装RAC,会自动配置SSH Connectivity,这与Linux下的用户对等一致。本来很容易的地方却遇到了Existence check failed for /bin/bash on node: dbserver1错误。

配置系统时会执行以下部分,以防止安装过程中出现错误:

ln -s /etc/ssh /usr/local/etc
ln -s /usr/bin /usr/local/bin
ln -s /usr/bin/ksh /bin/bash
mkdir -p /usr/local/bin
ln -s /usr/bin/ssh-keygen /usr/local/bin/ssh-keygen

其中,配置bash是因为:

“在配置对等性时,OUI会使用/bin/bash,而AIX默认是没有bash的,因此需要将ksh软链接到bash(当然你也可以安装bash包)。
同样,OUI会使用/usr/local/bin/ssh-keygen产生对等性密钥,而AIX中在安装了OpenSSH以后,ssh-keygen命令默认是存储在/usr/bin中,因此也需要做link。”

通过查询,这部分配置都没有问题,不论是软链接还是权限。

read more »

普人特福的博客cnzz&51la for wordpress,cnzz for wordpress,51la for wordpress