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

MOSC Banner

Error 12154 received logging on to the standby FAL[client, USER]: Error 12154 connecting to PGS_1,PG

alert log :

Error 12154 received logging on to the standby

FAL[client, USER]: Error 12154 connecting to PGS_1,PGS_2 for fetching gap sequence

RAC 11.2.0.4 to one node Active DataGuard

standby:

SQL> show parameter fal

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

fal_client                           string      PGSADG

fal_server                           string      PGS_1,PGS_2

$ sqlplus sys/oracle@PGS_1 as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 5 10:05:00 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> exit

$ sqlplus sys/oracle@PGS_2 as sysdba

Tagged:

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