2009-10-29 12:06:23| 分类: oracle RAC技术 | 标签: |举报 |字号大中小 订阅
创建新的服务CRM:
rac1-> dbca
-------------------------------------------
启动失败的实例:
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 100665588 bytes
Database Buffers 62914560 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
SQL> select instance_name from
2 v$instance ;
INSTANCE_NAME
----------------
devdb1
SQL> run
1 select instance_name from
2* v$instance
INSTANCE_NAME
----------------
devdb2
SQL> run
1 select instance_name from
2* v$instance
INSTANCE_NAME
----------------
devdb2
[oracle@rac1 admin]$ sqlplus system/oracle@crm
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 8 11:41:05 2008
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 Da
SQL> select instance_name from
2 v$instance ;
INSTANCE_NAME
----------------
devdb1
SQL>
关闭该实例:
[oracle@rac1 ~]$ sqlplus '/ as sysdba '
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 8 11:42:27 2008
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 Da
SQL> shutdown abort
ORACLE instance shut down.
SQL>
测试TAF:
SQL> select instance_name from
2 v$instance ;
INSTANCE_NAME
----------------
devdb1
SQL> run
1 select instance_name from
2* v$instance
INSTANCE_NAME
----------------
devdb2
SQL> run
1 select instance_name from
2* v$instance
INSTANCE_NAME
----------------
devdb2
CRM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip.wanmo.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip.wanmo.com)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DA
(SERVER = DEDICATED)
(SERVICE_NAME = crm)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
评论