1 2 Previous Next 18 Replies Latest reply: Jan 6, 2013 11:12 PM by $phinx19 RSS

    RFS process not starting in dataguard.

    $phinx19
      Hi All,

      OS:Solaris
      DB:10.2.0.4

      I am creating a standby database on the same box. I am able to bring the DR in mount stage by using
      alter database mount standby database;
      I am using a password file for the primary and DR and they both have the same oracle home.
      Following are the init file fr both:

      Primary Init File:

      *.DB_BLOCK_SIZE=8192
      *.OPEN_CURSORS=300
      *.CURSOR_SHARING=FORCE
      *.BACKGROUND_DUMP_DEST='/11g/oradata/admin/ettest/bdump'
      *.CORE_DUMP_DEST='/11g/oradata/admin/ettest/cdump'
      *.USER_DUMP_DEST='/11g/oradata/admin/ettest/udump'
      *.CONTROL_FILES=("/11g/oradata/admin/data/controlfiles/control01.ctl","/11g/oradata/admin/data/controlfiles/control02.ctl")
      *.DB_NAME=ettest
      *.PROCESSES=150
      *.UNDO_MANAGEMENT=AUTO
      *.UNDO_TABLESPACE=undotbs
      *.compatible='10.2.0.1.0'
      *.STANDBY_FILE_MANAGEMENT='AUTO'
      *.LOG_ARCHIVE_DEST_1='Location=/11g/oradata/archives/'
      *.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
      *.DB_FILE_NAME_CONVERT='/11g/oradata/admin/data/datafiles/','/11g/oradata_dr/ettestdr/datafiles/'
      *.LOG_FILE_NAME_CONVERT='/11g/oradata/admin/data/logfiles/','/11g/oradata_dr/ettestdr/redologs/'
      *.STANDBY_ARCHIVE_DEST='/11g/oradata_dr/ettestdr/dr_archives/ettestdr'
      *.LOG_ARCHIVE_DEST_2='Service=ettestdr'
      *.FAL_SERVER='ettestdr'
      *.FAL_CLIENT='ettest'
      *.REMOTE_LOGIN_PASSWORDFILE=shared

      DR Init file:

      *.DB_BLOCK_SIZE=8192
      *.DB_UNIQUE_NAME=ettestdr
      *.OPEN_CURSORS=300
      *.CURSOR_SHARING=FORCE
      *.BACKGROUND_DUMP_DEST='/11g/oradata_dr/ettestdr/admin/bdump'
      *.CORE_DUMP_DEST='/11g/oradata_dr/ettestdr/admin/cdump'
      *.USER_DUMP_DEST='/11g/oradata_dr/ettestdr/admin/udump'
      *.CONTROL_FILES=("/11g/oradata_dr/ettestdr/controlfiles/standbycontrolfile.ctl")
      *.DB_NAME=ettest
      *.PROCESSES=150
      *.UNDO_MANAGEMENT=AUTO
      *.UNDO_TABLESPACE=undotbs
      *.compatible='10.2.0.1.0'
      *.FAL_SERVER='ettest'
      *.FAL_CLIENT='ettestdr'
      *.STANDBY_FILE_MANAGEMENT='AUTO'
      *.LOG_ARCHIVE_DEST_1='Location=/11g/oradata_dr/ettestdr/dr_archives/ettestdr'
      *.STANDBY_ARCHIVE_DEST='/11g/oradata_dr/ettestdr/dr_archives/prim_archives'
      *.LOG_ARCHIVE_DEST_2='SERVICE=ettest'
      *.LOG_ARCHIVE_DEST_STATE_2='DEFER'
      *.DB_FILE_NAME_CONVERT='/11g/oradata_dr/ettestdr/datafiles/','/11g/oradata/admin/data/datafiles/'
      *.LOG_FILE_NAME_CONVERT='/11g/oradata_dr/ettestdr/redologs/','/11g/oradata/admin/data/logfiles/'
      *.REMOTE_LOGIN_PASSWORDFILE=shared

      I have brought the DR in mount stage using
      alter database mount standby database;
      and the output of the the below command:
      select process, status from v$managed_standby;
      PROCESS STATUS
      --------- ------------
      ARCH CONNECTED
      ARCH CONNECTED

      As you can see there is no RFS process in the above output. Moreover, i am constantly getting the below error in the alert of the Primary database

      ORA-04063: package body "SYS.DBMS_HA_ALERTS_PRVT" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_HA_ALERTS_PRVT"
      ORA-06512: at line 1
      Wed Dec 12 21:29:35 2012
      Errors in file /11g/oradata/admin/ettest/bdump/ettest_mmon_17762.trc:
      ORA-04063: package body "SYS.DBMS_HA_ALERTS_PRVT" has errors
      ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_HA_ALERTS_PRVT"
      ORA-06512: at line 1
      Wed Dec 12 21:30:33 2012
      Errors in file /11g/oradata/admin/ettest/bdump/ettest_arc0_17777.trc:
      ORA-01017: invalid username/password; logon denied
      Wed Dec 12 21:30:33 2012
      Error 1017 received logging on to the standby
      ------------------------------------------------------------
      Check that the primary and standby are using a password file
      and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
      and that the SYS password is same in the password files.
      returning error ORA-16191
      ------------------------------------------------------------
      Wed Dec 12 21:30:33 2012
      Errors in file /11g/oradata/admin/ettest/bdump/ettest_arc0_17777.trc:
      ORA-16191: Primary log shipping client not logged on standby
      PING[ARC0]: Heartbeat failed to connect to standby 'ettestdr'. Error is 16191.


      BR
      Sphinx

      Edited by: $phinx19 on Dec 12, 2012 8:08 AM
        1 2 Previous Next