SP2-0640 Not connected.

I got ” SP2-0640 Not connected. ” error in Oracle database.

SP2-0640 Not connected.

Details of error are as follows.

SP2-0640 Not connected.

Cause: The PASSWORD command was issued when there was no connection to the Oracle instance.

Action: Connect to the Oracle database before re-issuing the PASSWORD command.

Not connected

This SP2-0640 errors are related with the PASSWORD command was issued when there was no connection to the Oracle instance.

Connect to the Oracle database before re-issuing the PASSWORD command.

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

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, perform the following steps.

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

2) For manual upgrade ,invoke the command and enter the passowrd when asked for:

dbupgrade -u SYS

Read the following post, because the following error is related with this.

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

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )