Data Guard


Subscription to Fast Application Notification failed


Hi, I'm running a single instance DB 12.1.0.2 configured with Data Guard, using and configured correctly DGBroker.  I've got each configured in Oracle Restart as PRIMARY and PHYSICAL_STANDBY, policy=AUTOMATIC, respectively.  I have matching service names for each.   We're using ODP.Net, "HA Events=true" is configured in the connection string.   Data Source=GDP; User ID=SYSTEM;Password=xxxxx;Pooling=True;Min Pool Size=0;Max Pool Size=5;Incr Pool Size=1;Decr Pool Size=1;Connection Timeout=60;Connection Lifetime=180;Self Tuning=True;HA Events=true; Our tnsnames.ora looks like GDP = (DESCRIPTION_LIST=  (LOAD_BALANCE = OFF)  (FAILOVER = ON)  (DESCRIPTION = (CONNECT_TIMEOUT = 5)(TRANSPORT_CONNECT_TIMEOUT = 3)(RETRY_COUNT = 3)    (ADDRESS_LIST =      (LOAD_BALANCE = OFF)       (ADDRESS = (PROTOCOL = TCP)(HOST = 786192-oracle1)(PORT = 1522)))    (CONNECT_DATA = (SERVICE_NAME = GDP_STAGING)))  (DESCRIPTION = (CONNECT_TIMEOUT = 5)(TRANSPORT_CONNECT_TIMEOUT = 3)(RETRY_COUNT = 3)    (ADDRESS_LIST =      (LOAD_BALANCE = OFF)            (ADDRESS = (PROTOCOL = TCP)(HOST = 799913-dgnode)(PORT=1522)))    (CONNECT_DATA=(SERVICE_NAME = GDP_STAGING)  ) )) This is the error we receive connecting: Oracle.DataAccess.Client.OracleException (0x80004005): ORA-24919: subscription to Fast Application Notification failed at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src, OracleLogicalTransaction m_oracleLogicalTransaction) at Oracle.DataAccess.Client.OracleConnection.Open() at Oracle.DataAccess.Client.OracleConnection.Open() at ASP.monitor_aspx.Page_Load(Object sender, EventArgs e) Logfiles on our client show TIME:2016/11/23-07:14:49:494 TID:3c54 (VERSION) (4.121.2.0)TIME:2016/11/23-07:14:49:494 TID:3c54 (.NET) (4.0.30319.42000)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (DllPath : c:\oracle\home1\bin)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (TraceFileName : c:\oracle\tracefile.txt)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (TraceLevel : 63)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (TraceOption : 1)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (BindByName : False)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (CheckConStatus : True)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (UdtCacheSize : 4096)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (StatementCacheSize : 0)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (DynamicEnlist : False)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (FetchSize : 131072)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (OCI_EVENTS : False)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (StatementCacheWithUdts : True)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (MetadataPooling : True)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (DBNotificationPort : -1)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (ThreadPoolMaxSize : -1)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (DBNotificationRegInterval : 0)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (DemandOraclePermission : False)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (SelfTuning : True)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (MaxStatementCacheSize : 100)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (AppEdition : )TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (MetaDataXml : )TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (RevertBatchUpdateErrorHandling : False)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (FetchArrayPooling : True)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (PerformanceCounters : None)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (PSPE : 1)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (PSPESupport : False)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY) (LegacyEntireLOBFetch : False)TIME:2016/11/23-07:14:49:494 TID:3c54 (REGISTRY/ENVIRONMENT) (MTS) useoramtsmanaged : FalseTIME:2016/11/23-07:14:49:510 TID:3c54 (%s) (ThreadPoolMaxSize : %s [Original: %s; Set: %s; Post-Set: %s])TIME:2016/11/23-07:14:49:510 TID:3c54 (ENTRY) OracleConnection::OracleConnection(2)TIME:2016/11/23-07:14:49:541 TID:3c54 (EXIT) OracleConnection::OracleConnection(2)TIME:2016/11/23-07:14:49:557 TID:3c54 (ENTRY) OracleConnection::Open()TIME:2016/11/23-07:14:49:557 TID:3c54 (ENTRY) OpsConAllocValCtx()TIME:2016/11/23-07:14:49:557 TID:3c54 (EXIT) OpsConAllocValCtx(): Alloc=1896077584 RetCode=0 Line=450TIME:2016/11/23-07:14:49:650 TID:3c54 (MTS) DTCImpl..cctor() DTC Implementation is using OraMTS TIME:2016/11/23-07:14:49:650 TID:3c54 (ENTRY) OpsConOpen()TIME:2016/11/23-07:14:49:650 TID:3c54 (HA) OpsConOpen(): OciEvents=0 Line=2041TIME:2016/11/23-07:14:50:009 TID:3c54 (ENTRY) OpsConAddRef(): (7730efb0)=1999695792TIME:2016/11/23-07:14:50:009 TID:3c54 (EXIT) OpsConAddRef(): RefCount=1 RetCode=0 Line=3948 (7730efb0)=1999695792TIME:2016/11/23-07:14:50:009 TID:3c54 (ENTRY) OpsErrAllocCtx(): (7730efb0)=1999695792TIME:2016/11/23-07:14:50:009 TID:3c54 (EXIT) OpsErrAllocCtx(): RetCode=0 Line=210 (7730efb0)=1999695792TIME:2016/11/23-07:14:50:009 TID:3c54 (EXIT) OpsConOpen(): RetCode=0 Line=2787 (7730efb0)=1999695792TIME:2016/11/23-07:14:50:009 TID:3c54 (ENTRY) OpsConIsOCIAutoTuningEnabled()TIME:2016/11/23-07:14:50:009 TID:3c54 (EXIT) OpsConIsOCIAutoTuningEnabled()TIME:2016/11/23-07:14:50:009 TID:3c54 (GRID) (NON-RLB) (DISP) (inst=gdpstg)TIME:2016/11/23-07:14:50:025 TID:3c54 (ENTRY) OpsConInitSubscrEnv()TIME:2016/11/23-07:14:50:025 TID:3c54 (EXIT) OpsConInitSubscrEnv(): RetCode=0 Line=4236TIME:2016/11/23-07:14:50:025 TID:3c54 (ENTRY) OpsConAllocValCtx()TIME:2016/11/23-07:14:50:025 TID:3c54 (EXIT) OpsConAllocValCtx(): Alloc=1896077792 RetCode=0 Line=450TIME:2016/11/23-07:14:50:025 TID:3c54 (ENTRY) OpsConRegisterCallbacks()TIME:2016/11/23-07:14:50:025 TID:3c54 (ENTRY) OpsConOpen()TIME:2016/11/23-07:15:00:414 TID:3c54 (ENTRY) OpsConAddRef(): (7730e740)=1999693632TIME:2016/11/23-07:15:00:414 TID:3c54 (EXIT) OpsConAddRef(): RefCount=1 RetCode=0 Line=3948 (7730e740)=1999693632TIME:2016/11/23-07:15:00:414 TID:3c54 (ENTRY) OpsErrAllocCtx(): (7730e740)=1999693632TIME:2016/11/23-07:15:00:414 TID:3c54 (EXIT) OpsErrAllocCtx(): RetCode=0 Line=210 (7730e740)=1999693632TIME:2016/11/23-07:15:00:414 TID:3c54 (EXIT) OpsConOpen(): RetCode=0 Line=2787 (7730e740)=1999693632TIME:2016/11/23-07:15:10:430 TID:3c54 (HA) CreateSubscription(): RetCode=-1 Line=4328TIME:2016/11/23-07:15:10:430 TID:3c54 (EXIT) OpsConRegisterCallbacks(): RetCode=-1 Line=4496TIME:2016/11/23-07:15:10:430 TID:3c54 (ENTRY) OpsConClose(): (7730e740)=1999693632TIME:2016/11/23-07:15:10:476 TID:3c54 (ENTRY) OpsConRelRef(): (7730e740)=1999693632TIME:2016/11/23-07:15:10:476 TID:3c54 (ENTRY) OpsErrFreeCtx()TIME:2016/11/23-07:15:10:476 TID:3c54 (EXIT) OpsErrFreeCtx(): RetCode=0 Line=237TIME:2016/11/23-07:15:10:476 TID:3c54 (EXIT) OpsConRelRef(): RefCount=0 RetCode=0 Line=4135 (0)=0TIME:2016/11/23-07:15:10:476 TID:3c54 (EXIT) OpsConClose(): RetCode=0 Line=1496 (7730e740)=1999693632TIME:2016/11/23-07:15:10:476 TID:3c54 (ENTRY) OpsConDispose(): (0)=0TIME:2016/11/23-07:15:10:476 TID:3c54 (EXIT) OpsConDispose(): RetCode=0 Line=1575TIME:2016/11/23-07:15:10:492 TID:3c54 (ENTRY) OpsErrGetOraMesg()TIME:2016/11/23-07:15:10:492 TID:3c54 (EXIT) OpsErrGetOraMesg(): RetCode=0 Line=323TIME:2016/11/23-07:15:10:492 TID:3c54 (ERR) Oracle.DataAccess.Client.OracleException (0x80004005): ORA-24919: subscription to Fast Application Notification failed  at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)TIME:2016/11/23-07:15:10:508 TID:3c54 (ENTRY) OracleConnection::Dispose()TIME:2016/11/23-07:15:10:508 TID:3c54 (ENTRY) OpsConFreeValCtx() Free=1896077584TIME:2016/11/23-07:15:10:508 TID:3c54 (EXIT) OpsConFreeValCtx(): RetCode=0 Line=1522TIME:2016/11/23-07:15:10:508 TID:3c54 (EXIT) OracleConnection::Dispose() I've enabled and started ONS in Oracle Restart. Removing "HA Events" from the connection string, with this tnsnames, we can connect without errors to our Primary DB on 786192-oracle1. I feel I've checked all the boxes on this end for this to work.  I don't think the issue is we're not running RAC, is it?  Viewing the docs that I have,  I'm not finding a ton on ORA-24919 through a Google search, or Oracle Support.   I'd appreciate any thoughts/help anyone has to offer.Thanks! Message was edited by: Doug Chase
Hello; It might not be an Oracle issue. I might search for "ASP.monitor aspx.Page_Load" https://msdn.microsoft.com/en-us/library/aa479007.aspx Other than this I don't see anything anywhere on this: https://docs.oracle.com/database/121/ERRMG/ORA-24280.htm#ERRMG-GUID-7B2814DB-F946-4EB1-80B5-219B256E90C0 Best Regards mseberg
Hi Doug, ORA-24919: subscription to Fast Application Notification failed Cause: An error occurred while subscribing to Fast Application Notification.This could be due to problems in the Oracle clusterware configuration.Action: Look at the client trace files for additional information.Ensure that the Oracle clusterware is properly configured.
Hi Doug, Did you try connecting through any other tool like sqlplus or sql deverloper? What is the result when you connecting through those tools? Thanks,Ann Edmund
I'm able to connect using TNS, so I don't feel that's where the problem is.  My gut tells me its something in my service configuration with srvctl, but I don't know what it would be.  I've created an SR so I'll see what they come back with.

Related Links

Creating two physical standby databases
Failed to perform the primary and standby database in oracle 11g (11.2.0.4)
network bandwith and network latency
Redo archival process for MAX PERFORMANCE in 11g
Failed to configure Physical Standby using RMAN DUPLICATE FROM ACTIVE DATABASE
How to configure single-instance database for High Availability and Disaster Tolerance
abmr and nologging ops
12c dataguard installation
Does standby data guard between (Source site) 11.2.0.3.0 and (Target site) 11.2.0.4.0 supported?
log_file_name_convert parameter in multiplexed redo environment
Data Guard - Licensing and other basic questions before configure it.
ORA-38743: Time/SCN is in the future of the database.
Archivelog not deleting From Primary
Setup Oracle DataGuard on single Node
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
Dataguard

Categories

ORACLE DEV
Database
Java - JDBC Archive
Communications and Media
Learning Management
Real-Time Collaboratio...
SyncML
Data Guard
Berkeley DB Java Edition
SOA Suite
Korean
Database (Korean)
Proc (Korean)
XML (Korean)
Essbase
Hyperion Developer Net...
Data Sourcing
Process and Integration
QAZone e-TEST suite Fo...
SOA Governance
Business Intelligence ...
weblogic.developer.int...
weblogic.developer.int...
JRockit Newsgroups
AquaLogic BPM Newsgroups
aqualogic.bpm.development
BEA SALT 2.0 Beta
aqualogic.bpm.runtime
Local Portal API (on p...
Portlets
liquid.developer.inter...
Primavera Contractor U...
JDBC & Transaction (Ch...
WebLogic Server - Diag...
ORDS, SODA & JSON in t...
Servers
Java Applet Development
Monitoring, Management...
Java Advanced Imaging ...
Systems Management Tas...
General Java Mobile Qu...
Sun Servers Archived F...
Java System Portal Ser...
Java Enterprise System...
テクノロジー
エンタープライズ管理
Java (Japanese)
他のミドルウェア製品
EPM System Infrastructure
Primavera Unifier User...
Audit Vault and Databa...
Fusion Applications
Oracle User Group Comm...
About the Community
Enterprise Metadata Ma...
Portuguese
Friday Fun
Eloqua Users with Sale...
Oracle Marketing Cloud...
Bulk API
Spotlight on Success W...
Ohio & Kentucky Eloqua...
CX Central
Eloqua 9 Clients
Seed Your Success
Eloqua Users with Orac...
OTN América Latina Tou...
JDBC & UCP
Java Community Process
OMC - Industry Solutio...
Oracle Business Intell...
Global Trade Management
Digital Learning
Discussion - Accenture...
Oracle IoT Cloud Service
Base de Datos Discusió...
DOAG
Oracle Cloud Machine
Containers
Bare Metal Cloud Servi...
Order Management
IA 64 Beta Program
Communications Converg...
Administration
Primavera P6 EPPM User...
Java Compiler (Develop...
Patterns & OO Design
RTSJ (Real-Time Specif...
コミュニティ
Business Questions
Oracle Java Cloud Service
Customizations, Extens...
Oracle Mobile Applicat...
Duke's Choice Awards

Resources

Encrypt Message



code
soft
python
ios
c
html
jquery
cloud
mobile