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

Last updated on JULY 05, 2017

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)
Checked for relevance on 22-Jun-2017


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

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