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 184.108.40.206.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.
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.