Hello All,
I configured single physical standby database for RAC production servers (4 node) but i get above error (FAL[client, USER]: Error 12154 connecting to oracle for fetching gap sequence) in standby alert_log.file after I run (alter database recover managed standby database disconnect from session;)
-primary ---> ORACLE
-standby---->ORACLEDRS
#### that's my test connection between primary and standby
# from primary
[oracle@dbn-prod-4 ~]$ tnsping oracledrs
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oracledrs.sigma-capital.com)(PORT = 1521)) (LOAD_BALANCE = yes)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORACLEDRS)))
OK (0 msec)
[oracle@dbn-prod-4 ~]$ sqlplus system/********@oracledrs
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
oracledrs
SQL> exit
# from standby
[oracle@oracledrs bin]$ tnsping prim
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sigma-scan.sigma-capital.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORACLE)))
OK (0 msec)
[oracle@oracledrs bin]$ sqlplus feed/feed@prim
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> select instance_name from v$instance;
INSTANCE_NAME
----------------
ORACLE3
Please I need help about this issue
Thanks in advance,