Дек 212015
 

Выполнение операции switchover в Data Guard Broker’е выдает ошибку ORA-12514:

DGMGRL> switchover to exampledb02;
Performing switchover NOW, please wait...
Operation requires a connection to instance "exampledb" on database "exampledb02"
Connecting to instance "exampledb"...
Connected.
New primary database "exampledb02" is opening...
Operation requires startup of instance "exampledb" on database "exampledb"
Starting instance "exampledb"...
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Failed.
Warning: You are no longer connected to ORACLE.

Please complete the following steps to finish switchover:
        start up instance "exampledb" of database "exampledb"

Для того, чтобы автоматический запуск базы данных через DGMGRL работал, необходимо, чтобы сервис сервис

<unique_name>_DGMGRL.<domain>

был статически зарегестирован в LISTENER’е:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = <unique_name>_DGMGRL.<domain>)
      (SID_NAME = <oracle_sid>)
      (ORACLE_HOME = <oracle_home>)
    )
  )

К примеру:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = exampledb)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
       (SID_NAME = exampledb)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = exampledb_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = exampledb)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)