ORA-39710: the database mode conflicts with the connection type

Hi,

Sometimes You can get ” ORA-39710: the database mode conflicts with the connection type ” error.

Details of error are as follows.

ORA-39710: the database mode conflicts with the connection type

DBUA upgrade to 12.2 fails with  below error which can be seen in  catupgrd0.log file

get_instance_status_and_name: unexpected error in exec_DB_script
output produced in exec_DB_script [
SQL*Plus: Release 12.2.0.1.0 Production on Thu Nov 9 13:02:32 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> ERROR:
ORA-39710: The database mode conflicts with the connection type.
SQL> SQL> SQL> 2 SP2-0640: Not connected
SQL> SQL>
SQL> ] end of output produced in exec_DB_script
catconInit: unexpected error in get_instance_status_and_name
End of catcon Errors

You do not use operating system authentication to connect to the database.

When using DBUA,Providing SYSTEM username and password in “Select database” screen  .

To solve this error, When running DBUA:

Leave “User Name” and “Password” fields blank if you have OS authentication to SYS user.

Or

Provide the “SYS” username and “<sys_password>” (in case if you are calling DBUA screen for non-oracle user.

or For manual upgrade ,invoke the command and enter the password when asked for:

dbupgrade -u SYS

Do you want to learn more details about Delete operations and Oracle SQL Tutorial, then read the following post.

DELETE Statement in Oracle SQL | Oracle SQL Tutorials -11