rman创建dataguard出错

foxmile

把主从机的tnsnames.ora贴出来。

lhlzjx

我记得好像连接rman的用户必须是sysdba用户，你把system换成sys试一下呢

另外在主库机器上执行sqlplus [email=sys/xxx@lsnode2]sys/xxx@lsnode2[/email] as sysdba能连接到备库上吗？

lwtianxie

备库的listener.ora
# listener.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )

备库的tnsnames.ora

# tnsnames.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LSNODE2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.246)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dgdemo)
    )
  )

LSNODE1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.245)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dgdemo)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )

Hero--008

原帖由 lwtianxie 于 2008-3-14 10:48 发表
备库的listener.ora
# listener.ora Network Configuration File: /home/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
备库上的
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )
主库上的
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
(SID_DESC =
   (GLOBAL_DBNAME = dgdemo)
   (ORACLE_HOME = /home/oracle/product/10.2.0/db_1)
   (SID_NAME = dgdemo)
  )

建议重新配置下备库上的监听把相应的数据库服务加上再试下