dataguard error

Posted by Roshan on Apr 20, 2018; 5:20am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/dataguard-error-tp5724.html

Oracle Database 12.1.0.2

Hi Erman,

please find below dataguard environment

Primary:
ORACLE_SID=orchestratio
db_name = orchestr
db_unique_name= orchestr

listener entries
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rhis-orch-db01.mtg.local)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME = /d01/ora12c/app/ora12c/product/12.1.0/dbhome_1)
      (SID_NAME =orchestr)
    )
    (SID_DESC =
      (ORACLE_HOME = /d01/ora12c/app/ora12c/product/12.1.0/dbhome_1)
      (SID_NAME = orcstby)
    )
  )


Standby:
ORACLE_SID = orcstby
db_name: orchestr
db_unique_name = ORCSTBY

listener entries:
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcstby)
      (ORACLE_HOME = /d01/ora12c/app/ora12c/product/12.1.0/dbhome_1)
      (SID_NAME = orcstby)
    )
    (SID_DESC =
      (ORACLE_HOME = /d01/ora12c/app/ora12c/product/12.1.0/dbhome_1)
      (SID_NAME = orchestratio)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = OTDR-DBGUARD-01.mtg.local)(PORT = 1525))
  )

I have create the password files on both primary and standby using
orapwd file=orapw$ORACLE_SID password=m force=y entries=5

. I am getting error below from alert log on primary

Error 1033 received logging on to the standby

Please advise.

Regards,