6 Replies Latest reply: Sep 7, 2011 9:52 AM by BPeaslandDBA RSS

    DataGuard Broker DGMGRL configuration ORA-01031 error

    811197
      Hi,

      I'm new on this forum and it's to talk about a not really simple subject which is high availability.

      I'm creating a standby database to replicate in real time the modification in the primary one. I set up the SID on both machines and put different unique names for both.

      I configured also the different listener and TNS name to be able to connect remotly via sql plus to each machine.

      On DGMGRL I tried this sequence to initialize:

      DGMGRL
      connect sys/xxxx
      Connected.
      DGMGRL
      CREATE CONFIGURATION 'confDR'
      AS
      PRIMARY DATABASE IS 'orcl_pri'
      CONNECT IDENTIFIER IS 'orcl_pri'
      ;
      Configuration "confDR" created with primary database "orcl_pri"

      DGMGRL
      add database
      'orcl_bac'
      as
      connect identifier is 'orcl_bac'
      ;
      Error: ORA-01031: insufficient privileges

      I don't understand why it doesn't work (obviously I miss privileges but I don't really know where)
      I created password files on both machines with the same password.

      SQL
      select * from v$pwfile_users;
      USERNAME SYSDB SYSOP SYSAS
      SYS TRUE TRUE FALSE
      SYSTEM TRUE TRUE FALSE

      Thanks for your support,

      X.

      Edited by: 808194 on Nov 8, 2010 1:43 AM