My Oracle Support Banner

Upgrade to 12.2 fails with error: "SP2-0640: Not connected"or "ORA-39710: The database mode conflicts with the connection type" (Doc ID 2328603.1)

Last updated on OCTOBER 02, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Oracle Database – Enterprise Edition – Version 12.2.0.1 and later .

Symptoms

1)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

 

 2)Manual upgrade fails with error:
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 Mon Oct 1 14:11:17 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

SQL> ERROR:
ORA-12560: TNS:protocol adapter error

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

Changes

 Upgrading the database to 12.2.0.1 .

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!


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