Error Raised in grid Control After Switching to Archivelog Mode : Failed to Connect to Database Instance ORA-00257 Archiver Error (Doc ID 388186.1)

Last updated on MAY 20, 2015

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.1 to 11.1.0.1 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 19-Dec-2013

Symptoms

GRID keeps sending notification about an ORA-257  in the database after it went into ARCHIVELOG mode.
The message shown in Grid Control is :

Target Name=<dbname>

Target Type=Database Instance
Host=<hostname>

Metric=Status
Metric Value=0
Timestamp=<timestamp>

Severity=Critical
Message=Failed to connect to database instance: ORA-00257: archiver error.
Connect internal only, until freed. (DBD  ERROR: OCISessionBegin).
Notification Rule Name=Database Availability and Critical States
Notification Rule Owner=SYSMAN

+ Verified the issue by the Alert.log of the impacted target database :

ORACLE Instance <SID> - Can not allocate log, archival required
Tue Aug 15 11:55:20 2006
Thread 1 cannot allocate new log, sequence 22917
All online logs needed archiving

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms