My Oracle Support Banner

ODBC Driver Connect As "Sys As Sysdba" Fails With Ora-3114 (Doc ID 279664.1)

Last updated on FEBRUARY 23, 2025

Applies to:

Oracle ODBC Driver - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Microsoft Windows (32-bit)

Symptoms

Unable to query database after connecting as sys as sysdba
and odbc when the database is started up in Mount only mode
Any attempt at query causes the error ORA-3114 not connected to ORACLE

However whilst in mount mode you should be able to still query some restricted views.
eg.
"SELECT * FROM V$INSTANCE"

This feature works for SQL*Plus.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.