High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Physical Standby throwing ora-12514

I am on 11.2.03 with EBS R12.1.3.  I am testing a physical standby and created the instances. On my Physical standby alert log, I see the following error messages:

TNS-12564: TNS:connection refused

    ns secondary err code: 0

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

Error 12514 received logging on to the standby

PING[ARC2]: Heartbeat failed to connect to standby 'STBY_TSTDR'. Error is 12514.

-------

                              Primary                                                                Standby site

db_name                TSTDR                                                                  TSTDR

Unique_name          TSTDR                                                                 STBY_TSTDR

server                        primary                                                                 dev    

log.._dest_1          LOCATION=/u03/TSTDR/ARCHIVELOGS           

                         VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

                         DB_UNIQUE_NAME=TSTDR  MANDATORY

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center