Error "ora-01031: insufficient privilege" when connecting as SYSDBA to database in 'Upgrade' mode (4302679)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error "ora-01031: insufficient privilege" when connecting as SYSDBA to database in 'Upgrade' mode
Description

Error "ora-01031: insufficient privilige" when connecting as SYSDBA to database in 'Upgrade' mode
Cause

This is an Oracle limitation. When a database is in 'Upgrade' mode it is only possible to connect on the server itself with the sql*plus. If connecting remotely via sql*plus or Toad, the above error will result.
Resolution

The database must be mounted and in 'Open' mode in order to connect remotely via Toad or sql*plus.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title