Forum Stats

  • 3,837,697 Users
  • 2,262,286 Discussions
  • 7,900,365 Comments

Discussions

Standby Database Creation Issue

Raghav_DBA
Raghav_DBA Member Posts: 96 Red Ribbon
edited Jun 23, 2022 6:32AM in General Database Discussions

I created standby database on same server on which primary exists. I am getting TNS issue for Standby TNS due to that FAL failed to request gap sequence.


In Primary log file


Fatal NI connect error 12520, connecting to:

 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=catovmcl01-ld8z0-scan.prodexacssubnet.catoprvcn.oraclevcn.com)(PORT=1528))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PFLEXRPT.prodexacssubnet.catoprvcn.oraclevcn.com)(CID=(PROGRAM=oracle)(HOST=catovmcl01-ld8z01)(USER=oracle))))


Primary TNS


PFLEXCDB_PRI=

  (DESCRIPTION=

   (ADDRESS=

    (PROTOCOL= TCP)

    (HOST= Scan_NAME)

    (PORT= 1528))

   (CONNECT_DATA=

    (SERVER= DEDICATED)

    (SERVICE_NAME= PFLEXCDB_PRI.prodexacssubnet.catoprvcn.oraclevcn.com)))


In Standby Log file


PR00 (PID:188039): FAL: Failed to request gap sequence

PR00 (PID:188039): GAP - thread 1 sequence 24-24

PR00 (PID:188039): DBID 2573059216 branch 1106383893

PR00 (PID:188039): FAL: All defined FAL servers have been attempted


Standby TNS


PFLEXRPT=

  (DESCRIPTION=

   (ADDRESS=

    (PROTOCOL= TCP)

    (HOST= Scan_NAME)

    (PORT= 1528))

   (CONNECT_DATA=

    (SERVER= DEDICATED)

    (SERVICE_NAME= PFLEXRPT.prodexacssubnet.catoprvcn.oraclevcn.com)))




on Primary 


log_archive_dest_3          string   LOCATION=+RECOC1 VALID_FOR=(AL

                         L_LOGFILES,ALL_ROLES) DB_UNIQU

                         E_NAME=PFLEXCDB_PRI


log_archive_dest_4          string   SERVICE=PFLEXRPT LGWR ASYNC VA

                         LID_FOR=(ONLINE_LOGFILES,PRIMA

                         RY_ROLE) DB_UNIQUE_NAME=PFLEXR

                         PT

On Standby


log_archive_dest_3          string   LOCATION=+RECOC1 VALID_FOR=(AL

                         L_LOGFILES,ALL_ROLES) DB_UNIQU

                         E_NAME=PFLEXRPT

log_archive_dest_4          string   SERVICE=PFLEXCDB_PRI LGWR ASYN

                         C VALID_FOR=(ONLINE_LOGFILES,P

                         RIMARY_ROLE) DB_UNIQUE_NAME=PF

                         LEXCDB_PRI


LOG_ARCHIVE_DEST_4

ORA-12520: TNS:listener could not find available handler for

requested type of server

This error I am getting in primary database for log_archive_dest_4


DB Name = PFLEXCDB

Primary Unique Name= PFLEXCDB_PRI

Standby Unique Name = PFLEXRPT

Tagged: