在现有RAC环境中,添加一个rac one node实例,安装界面中输入的实例名为orcl,但安装后实际的名字为orcl_1.
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
2、RAC和rac one node状态信息(均可查询)
[grid@lkdbr2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE lkdbr1
ONLINE ONLINE lkdbr2
ora.DATA.dg
ONLINE ONLINE lkdbr1
ONLINE ONLINE lkdbr2
ora.FRA.dg
ONLINE ONLINE lkdbr1
ONLINE ONLINE lkdbr2
ora.LISTENER.lsnr
ONLINE ONLINE lkdbr1
ONLINE ONLINE lkdbr2
ora.asm
ONLINE ONLINE lkdbr1 Started
ONLINE ONLINE lkdbr2 Started
ora.gsd
OFFLINE OFFLINE lkdbr1
OFFLINE OFFLINE lkdbr2
ora.net1.network
ONLINE ONLINE lkdbr1
ONLINE ONLINE lkdbr2
ora.ons
ONLINE ONLINE lkdbr1
ONLINE ONLINE lkdbr2
ora.registry.acfs
ONLINE ONLINE lkdbr1
ONLINE ONLINE lkdbr2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE lkdbr2
ora.cvu
1 ONLINE ONLINE lkdbr2
ora.oc4j
1 ONLINE ONLINE lkdbr2
ora.orcl.db
1 ONLINE ONLINE lkdbr1 Open ---rac one node
ora.orcl.orcl1.svc ---service_name为输入的orcl1
1 ONLINE ONLINE lkdbr1
ora.scan1.vip
1 ONLINE ONLINE lkdbr2
ora.lkdbnew.db
1 ONLINE ONLINE lkdbr1 Open ---原RAC两节点db(lkdbnew)
2 ONLINE ONLINE lkdbr2 Open
ora.lkdbr1.vip
1 ONLINE ONLINE lkdbr1
ora.lkdbr2.vip
1 ONLINE ONLINE lkdbr2
[oracle@lkdbr1 ~]$ ps -ef |grep ora_
oracle 2657 1 0 13:26 ? 00:00:00 ora_pz99_lkdbnew1
oracle 4998 1 22 13:28 ? 00:00:03 ora_j000_orcl_1
oracle 5000 1 0 13:28 ? 00:00:00 ora_j001_orcl_1
oracle 5114 141081 0 13:28 pts/0 00:00:00 grep ora_
oracle 6562 1 0 Mar29 ? 00:00:08 ora_pmon_lkdbnew1
oracle 6564 1 0 Mar29 ? 00:00:06 ora_psp0_lkdbnew1
oracle 6566 1 0 Mar29 ? 00:09:16 ora_vktm_lkdbnew1
oracle 6570 1 0 Mar29 ? 00:00:01 ora_gen0_lkdbnew1
oracle 6572 1 0 Mar29 ? 00:00:23 ora_diag_lkdbnew1
oracle 6574 1 0 Mar29 ? 00:00:04 ora_dbrm_lkdbnew1
oracle 6576 1 0 Mar29 ? 00:00:02 ora_ping_lkdbnew1
oracle 6578 1 0 Mar29 ? 00:00:00 ora_acms_lkdbnew1
oracle 6580 1 0 Mar29 ? 00:03:16 ora_dia0_lkdbnew1
oracle 6582 1 0 Mar29 ? 00:01:35 ora_lmon_lkdbnew1
oracle 6584 1 0 Mar29 ? 00:00:35 ora_lmd0_lkdbnew1
oracle 6586 1 0 Mar29 ? 00:01:27 ora_lms0_lkdbnew1
oracle 6590 1 0 Mar29 ? 00:01:27 ora_lms1_lkdbnew1
oracle 6594 1 0 Mar29 ? 00:01:27 ora_lms2_lkdbnew1
oracle 6598 1 0 Mar29 ? 00:00:00 ora_rms0_lkdbnew1
oracle 6600 1 0 Mar29 ? 00:00:01 ora_lmhb_lkdbnew1
oracle 6602 1 0 Mar29 ? 00:00:02 ora_mman_lkdbnew1
oracle 6604 1 0 Mar29 ? 00:00:02 ora_dbw0_lkdbnew1
oracle 6606 1 0 Mar29 ? 00:00:01 ora_dbw1_lkdbnew1
oracle 6608 1 0 Mar29 ? 00:00:02 ora_dbw2_lkdbnew1
oracle 6610 1 0 Mar29 ? 00:00:02 ora_dbw3_lkdbnew1
oracle 6612 1 0 Mar29 ? 00:00:03 ora_lgwr_lkdbnew1
oracle 6614 1 0 Mar29 ? 00:00:12 ora_ckpt_lkdbnew1
oracle 6616 1 0 Mar29 ? 00:00:02 ora_smon_lkdbnew1
oracle 6618 1 0 Mar29 ? 00:00:00 ora_reco_lkdbnew1
oracle 6620 1 0 Mar29 ? 00:00:01 ora_rbal_lkdbnew1
oracle 6622 1 0 Mar29 ? 00:00:00 ora_asmb_lkdbnew1
oracle 6624 1 0 Mar29 ? 00:00:09 ora_mmon_lkdbnew1
oracle 6626 1 0 Mar29 ? 00:00:57 ora_mmnl_lkdbnew1
oracle 6630 1 0 Mar29 ? 00:00:00 ora_d000_lkdbnew1
oracle 6632 1 0 Mar29 ? 00:00:00 ora_s000_lkdbnew1
oracle 6634 1 0 Mar29 ? 00:00:01 ora_mark_lkdbnew1
oracle 6640 1 0 Mar29 ? 00:00:19 ora_lck0_lkdbnew1
oracle 6642 1 0 Mar29 ? 00:00:01 ora_rsmn_lkdbnew1
oracle 6681 1 0 Mar29 ? 00:00:00 ora_arc0_lkdbnew1
oracle 6683 1 0 Mar29 ? 00:00:01 ora_arc1_lkdbnew1
oracle 6685 1 0 Mar29 ? 00:00:00 ora_arc2_lkdbnew1
oracle 6687 1 0 Mar29 ? 00:00:00 ora_arc3_lkdbnew1
oracle 6725 1 0 Mar29 ? 00:00:00 ora_gtx0_lkdbnew1
oracle 6727 1 0 Mar29 ? 00:00:02 ora_rcbg_lkdbnew1
oracle 6733 1 0 Mar29 ? 00:00:01 ora_qmnc_lkdbnew1
oracle 6814 1 0 Mar29 ? 00:00:05 ora_cjq0_lkdbnew1
oracle 6841 1 0 Mar29 ? 00:00:00 ora_q000_lkdbnew1
oracle 8993 1 0 Mar29 ? 00:00:01 ora_smco_lkdbnew1
oracle 24464 1 0 Mar29 ? 00:00:31 ora_o000_lkdbnew1
oracle 121091 1 0 12:19 ? 00:00:00 ora_q002_lkdbnew1
oracle 143138 1 0 13:24 ? 00:00:00 ora_w000_lkdbnew1
oracle 143141 1 0 13:24 ? 00:00:00 ora_pmon_orcl_1 ----rac one node instance name(orcl_1)
oracle 143143 1 0 13:24 ? 00:00:00 ora_psp0_orcl_1
oracle 143149 1 0 13:24 ? 00:00:01 ora_vktm_orcl_1
oracle 143153 1 0 13:24 ? 00:00:00 ora_gen0_orcl_1
oracle 143155 1 0 13:24 ? 00:00:00 ora_diag_orcl_1
oracle 143157 1 0 13:24 ? 00:00:00 ora_dbrm_orcl_1
oracle 143159 1 0 13:24 ? 00:00:00 ora_ping_orcl_1
oracle 143161 1 0 13:24 ? 00:00:00 ora_acms_orcl_1
oracle 143163 1 0 13:24 ? 00:00:00 ora_dia0_orcl_1
oracle 143165 1 0 13:24 ? 00:00:00 ora_lmon_orcl_1
oracle 143167 1 0 13:24 ? 00:00:00 ora_lmd0_orcl_1
oracle 143169 1 0 13:24 ? 00:00:00 ora_lms0_orcl_1
oracle 143173 1 0 13:24 ? 00:00:00 ora_lms1_orcl_1
oracle 143177 1 0 13:24 ? 00:00:00 ora_lms2_orcl_1
oracle 143181 1 0 13:24 ? 00:00:00 ora_rms0_orcl_1
oracle 143183 1 0 13:24 ? 00:00:00 ora_lmhb_orcl_1
oracle 143185 1 0 13:24 ? 00:00:01 ora_mman_orcl_1
oracle 143187 1 0 13:24 ? 00:00:00 ora_dbw0_orcl_1
oracle 143189 1 0 13:24 ? 00:00:00 ora_dbw1_orcl_1
oracle 143191 1 0 13:24 ? 00:00:00 ora_dbw2_orcl_1
oracle 143193 1 0 13:24 ? 00:00:00 ora_dbw3_orcl_1
oracle 143195 1 0 13:24 ? 00:00:00 ora_lgwr_orcl_1
oracle 143197 1 0 13:24 ? 00:00:00 ora_ckpt_orcl_1
oracle 143199 1 0 13:24 ? 00:00:00 ora_smon_orcl_1
oracle 143201 1 0 13:24 ? 00:00:00 ora_reco_orcl_1
oracle 143203 1 0 13:24 ? 00:00:00 ora_mmon_orcl_1
oracle 143205 1 0 13:24 ? 00:00:00 ora_mmnl_orcl_1
oracle 143207 1 0 13:24 ? 00:00:00 ora_d000_orcl_1
oracle 143209 1 0 13:24 ? 00:00:00 ora_s000_orcl_1
oracle 143211 1 0 13:24 ? 00:00:00 ora_lck0_orcl_1
oracle 143213 1 0 13:24 ? 00:00:00 ora_rsmn_orcl_1
oracle 143230 1 0 13:24 ? 00:00:00 ora_arc0_orcl_1
oracle 143232 1 0 13:24 ? 00:00:00 ora_arc1_orcl_1
oracle 143234 1 0 13:24 ? 00:00:00 ora_arc2_orcl_1
oracle 143236 1 0 13:24 ? 00:00:00 ora_arc3_orcl_1
oracle 143238 1 0 13:24 ? 00:00:00 ora_gtx0_orcl_1
oracle 143240 1 0 13:24 ? 00:00:00 ora_rcbg_orcl_1
oracle 143245 1 0 13:24 ? 00:00:00 ora_qmnc_orcl_1
oracle 143285 1 0 13:24 ? 00:00:00 ora_cjq0_orcl_1
oracle 143537 1 0 13:25 ? 00:00:00 ora_q000_orcl_1
oracle 143539 1 0 13:25 ? 00:00:00 ora_q001_orcl_1
oracle 143625 1 0 13:25 ? 00:00:00 ora_smco_orcl_1
oracle 143688 1 0 13:25 ? 00:00:00 ora_w000_orcl_1
[oracle@lkdbr1 ~]$
3、验证实例名为orcl_1
[oracle@lkdbr1 ~]$ export ORACLE_SID=orcl
[oracle@lkdbr1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 30 13:28:42 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> exit
Disconnected
[oracle@lkdbr1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 30 13:28:49 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> show parameter inst
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
active_instance_count integer
cluster_database_instances integer 2
instance_groups string
instance_name string orcl_1
instance_number integer 1
instance_type string RDBMS
instant_restore boolean FALSE
open_links_per_instance integer 4
parallel_instance_group string
parallel_server_instances integer 2
SQL>
4、RAC one node节点数据文件位置信息
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/lkdbdata/orcl/system01.dbf
/lkdbdata/orcl/sysaux01.dbf
/lkdbdata/orcl/undotbs01.dbf
/lkdbdata/orcl/users01.dbf
[oracle@lkdbr1 orcl]$ pwd
/lkdbdata/orcl
[oracle@lkdbr1 orcl]$ ll
total 1768396
-rw-r----- 1 oracle asmadmin 18497536 Mar 30 13:29 control01.ctl
-rw-r----- 1 oracle asmadmin 18497536 Mar 30 13:29 control02.ctl
-rw-r----- 1 oracle oinstall 1536 Mar 30 13:23 orapworcl
-rw-r----- 1 oracle asmadmin 104858112 Mar 30 13:28 redo01.log
-rw-r----- 1 oracle asmadmin 104858112 Mar 30 13:29 redo02.log
-rw-r----- 1 oracle asmadmin 104858112 Mar 30 13:24 redo03.log
-rw-r----- 1 oracle asmadmin 2560 Mar 30 13:25 spfileorcl.ora
-rw-r----- 1 oracle asmadmin 545267712 Mar 30 13:26 sysaux01.dbf
-rw-r----- 1 oracle asmadmin 786440192 Mar 30 13:24 system01.dbf
-rw-r----- 1 oracle asmadmin 30416896 Mar 30 13:26 temp01.dbf
-rw-r----- 1 oracle asmadmin 120594432 Mar 30 13:27 undotbs01.dbf
-rw-r----- 1 oracle asmadmin 5251072 Mar 30 13:24 users01.dbf