配置data guard物理备库(2)

再next

再next

点finish完成

最后点OK开始安装, 完装完成点exit退出，也可以点去管理用户密码。

看oracle是否启动

[oracle@node1 arch]$ ps -ef 看以有这些进程

oracle 2850 1 0 23:23 ? 00:00:00 ora_pmon_dgdemo oracle 2852 1 0 23:23 ? 00:00:00 ora_psp0_dgdemo oracle 2854 1 0 23:23 ? 00:00:00 ora_mman_dgdemo oracle 2856 1 0 23:23 ? 00:00:00 ora_dbw0_dgdemo oracle 2858 1 0 23:23 ? 00:00:00 ora_lgwr_dgdemo oracle 2860 1 0 23:23 ? 00:00:00 ora_ckpt_dgdemo oracle 2862 1 0 23:23 ? 00:00:00 ora_smon_dgdemo oracle 2864 1 0 23:23 ? 00:00:00 ora_reco_dgdemo oracle 2866 1 0 23:23 ? 00:00:00 ora_cjq0_dgdemo oracle 2868 1 0 23:23 ? 00:00:00 ora_mmon_dgdemo oracle 2870 1 0 23:23 ? 00:00:00 ora_mmnl_dgdemo oracle 2872 1 0 23:23 ? 00:00:00 ora_d000_dgdemo oracle 2874 1 0 23:23 ? 00:00:00 ora_s000_dgdemo oracle 2878 1 0 23:24 ? 00:00:00 ora_arc0_dgdemo

Netca配置网络链接

主库和备库是通过网络链接通讯，以下开始建网络链接 [oracle@node1 arch]$ netca

先在node1配置\

再点Add -->Next

点tcp

默认1521

默认1521

选 择\只创建一个linstener, 先不要点next

这个listen就建完了, 建完了在/u01/oracle/network/admin/目录下创建一个文件listener.ora 这个文件10G R1 和R2有点小区别

[oracle@node1 arch]$ cd /u01/oracle/network/admin/ [oracle@node1 admin]$ ls

listener.ora samples shrept.lst

[oracle@node1 admin]$ vi listener.ora (这文件内容，也可以直接vi建一个) # listener.ora Network Configuration File: /u01/oracle/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER = (SID_LIST = (SID_DESC =

(SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/oracle) (PROGRAM = extproc) )

(SID_DESC =

(GLOBAL_DBNAME =uqn_node1) (ORACLE_HOME =/u01/oracle) (SID_NAME = dgdemo) ) )

LISTENER =

(DESCRIPTION_LIST = (DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )

创建tnsnames.ora

这时点next , 选 local Net Service Name configuration

点add

再输入SID名字 dgdemo