好长时间没有来更新博客了,在没有完全完成一项工作时也不知道如何去将中间出现的问题整理出来,因为太多了,还有时间缘故,来不及整理,想赶紧做完。花了有一两个月了吧,终于在今天早上成功安装好rac,材料正在整理中。。。
问题1:安装好后想赶紧来个切换服务的测试:
关掉第一个节点后:
SQL> select instance_number instance#,instance_name,host_name,status from v$instance;
INSTANCE# INSTANCE_NAME HOST_NAME STATUS
---------- ---------------- ---------- ------------
2 devdb2 rac2 OPEN
SQL> select failover_type,failover_method,failed_over from v$session where username='SYSTEM';
FAILOVER_TYPE FAILOVER_M FAI
------------- ---------- ---
SELECT BASIC YES
节点二启动了服务,恢复 devdb1 之后,CRM 服务不会自动重新定位到首选实例。您必须手动将服务重新定位到 devdb1
SQL> startup
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1219160 bytes
Variable Size 146802088 bytes
Database Buffers 163577856 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> show parameter service
NAME TYPE VALUE
------------------------------ ----------- ------------------------
service_names string devdb
从这里看出,CRM没有在devdb1上
SQL> conn system/oracle@devdb2
Connected.
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string devdb, CRM
从这里看到,目前CRM挂接在devdb2上
另外打开一个窗口,以oracle用户执行下面语句,切换服务CRM到devdb1上
rac1-> srvctl relocate service -d devdb -s crm -i devdb2 -t devdb1
/u01/oracle/product/10.2.0/db_1/jdk/jre/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
注释掉vi /u01/oracle/product/10.2.0/db_1/bin/srvctl的 LD_ASSUME_KERNEL
[oracle@rac1 bin]$ srvctl relocate service -d devdb -s crm -i devdb2 -t devdb1
[oracle@rac1 bin]$
[oracle@rac1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 25 15:13:41 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string devdb, CRM
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25323853/viewspace-705783/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25323853/viewspace-705783/