This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 6, 2013 9:12 PM by $phinx19 RSS

RFS process not starting in dataguard.

$phinx19 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points