Steps to Rename Host in Oracle RESTART (ASM) in Linux

 

oracle@localhost ] asmcmd

ASMCMD> lsdg

State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  N         512             512   4096  4194304      5116     5016                0            5016              0             N  DATA/

ASMCMD> exit

oracle@localhost ] ps -ef | grep tns

root         19      2  0 13:04 ?        00:00:00 [netns]

oracle     2992      1  0 13:05 ?        00:00:00 /u01/app/grid/122/bin/tnslsnr LISTENER -no_crs_notify -inherit

oracle    72150   4366  0 15:20 pts/0    00:00:00 grep --color=auto tns

oracle@localhost ]  crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

               ONLINE  ONLINE       localhost                STABLE

ora.LISTENER.lsnr

               ONLINE  ONLINE       localhost                STABLE

ora.asm

               ONLINE  ONLINE       localhost                Started,STABLE

ora.ons

               OFFLINE OFFLINE      localhost                STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       localhost                STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       localhost                STABLE

--------------------------------------------------------------------------------

oracle@localhost ] su

Password:

[root@localhost oracle]# . oraenv

ORACLE_SID = [+ASM] ? +ASM

The Oracle base remains unchanged with value /u01/app/grid

[root@localhost oracle]# cd $ORACLE_HOME/crs/install

[root@localhost install]# ./roothas.sh -deconfig -force

Using configuration parameter file: /u01/app/grid/122/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/grid/crsdata/localhost/crsconfig/hadeconfig.log

2023/12/19 15:21:59 CLSRSC-332: CRS resources for listeners are still configured

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'localhost'

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'localhost'

CRS-2677: Stop of 'ora.DATA.dg' on 'localhost' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'localhost'

CRS-2677: Stop of 'ora.asm' on 'localhost' succeeded

CRS-2673: Attempting to stop 'ora.evmd' on 'localhost'

CRS-2677: Stop of 'ora.evmd' on 'localhost' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'localhost'

CRS-2677: Stop of 'ora.cssd' on 'localhost' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'localhost' has completed

CRS-4133: Oracle High Availability Services has been stopped.

2023/12/19 15:22:17 CLSRSC-337: Successfully deconfigured Oracle Restart stack

[root@localhost install]#  hostnamectl set-hostname PROD1

[root@localhost install]#  cat /etc/hostname

prod1

[root@localhost install]# ./roothas.sh

Using configuration parameter file: /u01/app/grid/122/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/grid/crsdata/prod1/crsconfig/roothas_2023-12-19_03-23-20PM.log

2023/12/19 15:23:21 CLSRSC-363: User ignored prerequisites during installation

LOCAL ADD MODE

Creating OCR keys for user 'oracle', privgrp 'oinstall'..

Operation successful.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4664: Node prod1 successfully pinned.

2023/12/19 15:23:30 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod1'

CRS-2673: Attempting to stop 'ora.evmd' on 'prod1'

CRS-2677: Stop of 'ora.evmd' on 'prod1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

CRS-4123: Oracle High Availability Services has been started.

prod1     2023/12/19 15:24:13     /u01/app/grid/122/cdata/prod1/backup_20231219_152413.olr     0

2023/12/19 15:24:14 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

[root@localhost install]# bash

[root@prod1 install]# . oraenv

ORACLE_SID = [+ASM] ?

The Oracle base remains unchanged with value /u01/app/grid

[root@prod1 install]# cd $ORACLE_HOME

[root@prod1 bin]#  ./crsctl stop has

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod1'

CRS-2673: Attempting to stop 'ora.evmd' on 'prod1'

CRS-2677: Stop of 'ora.evmd' on 'prod1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

[root@prod1 bin]#  ./crsctl start has

CRS-4123: Oracle High Availability Services has been started.

[root@prod1 bin]# . oraenv

ORACLE_SID = [+ASM] ?

The Oracle base remains unchanged with value /u01/app/grid

[root@prod1 bin]# crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.ons

               OFFLINE OFFLINE      prod1                    STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       prod1                    STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  INTERMEDIATE prod1                    STABLE

--------------------------------------------------------------------------------

[root@prod1 bin]# srvctl add listener -l LISTENER -p 1521

[root@prod1 bin]# crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

               OFFLINE OFFLINE      prod1                    STABLE

ora.ons

               OFFLINE OFFLINE      prod1                    STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       prod1                    STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       prod1                    STABLE

--------------------------------------------------------------------------------

[root@prod1 bin]# srvctl add asm -l LISTENER -d DATA -p +data/spfile.ora

[root@prod1 bin]# srvctl config asm

ASM home: <CRS home>

Password file:

Backup of Password file:

ASM listener: LISTENER

Spfile: +data/spfile.ora

ASM diskgroup discovery string: DATA

[root@prod1 bin]# ps -ef | grep pmon

root      76366  75358  0 15:26 pts/0    00:00:00 grep --color=auto pmon

[root@prod1 bin]#  ./crsctl stop has

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prod1'

CRS-2673: Attempting to stop 'ora.evmd' on 'prod1'

CRS-2677: Stop of 'ora.evmd' on 'prod1' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'prod1'

CRS-2677: Stop of 'ora.cssd' on 'prod1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prod1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

[root@prod1 bin]#  ./crsctl start has

CRS-4123: Oracle High Availability Services has been started.

[oracle@prod1 ~]$ ps -ef | grep pmon

oracle    76995  76935  0 15:27 pts/1    00:00:00 grep --color=auto pmon

[oracle@prod1 ~]$ ps -ef | grep d.bin

oracle    76465      1  2 15:26 ?        00:00:01 /u01/app/grid/122/bin/ohasd.bin reboot

oracle    76632      1  0 15:27 ?        00:00:00 /u01/app/grid/122/bin/evmd.bin

oracle    76659      1  1 15:27 ?        00:00:00 /u01/app/grid/122/bin/ocssd.bin

[oracle@prod1 ~]$ . oraenv

ORACLE_SID = [oracle] ? +ASM

The Oracle base has been set to /u01/app/grid

[oracle@prod1 ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

               OFFLINE OFFLINE      prod1                    STABLE

ora.asm

               OFFLINE OFFLINE      prod1                    Instance Shutdown,ST

                                                             ABLE

ora.ons

               OFFLINE OFFLINE      prod1                    STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       prod1                    STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       prod1                    STABLE

--------------------------------------------------------------------------------

[oracle@prod1 ~]$ crsctl start resource ora.LISTENER.lsnr -unsupported

CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'prod1'

CRS-2676: Start of 'ora.LISTENER.lsnr' on 'prod1' succeeded

[oracle@prod1 ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

               ONLINE  ONLINE       prod1                    STABLE

ora.asm

               OFFLINE OFFLINE      prod1                    Instance Shutdown,ST

                                                             ABLE

ora.ons

               OFFLINE OFFLINE      prod1                    STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       prod1                    STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       prod1                    STABLE

--------------------------------------------------------------------------------

[oracle@prod1 ~]$ crsctl start resource ora.asm -unsupported

CRS-2672: Attempting to start 'ora.asm' on 'prod1'

CRS-2676: Start of 'ora.asm' on 'prod1' succeeded

[oracle@prod1 ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

               ONLINE  ONLINE       prod1                    STABLE

ora.asm

               ONLINE  ONLINE       prod1                    Started,STABLE

ora.ons

               OFFLINE OFFLINE      prod1                    STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       prod1                    STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       prod1                    STABLE

--------------------------------------------------------------------------------

[oracle@prod1 ~]$ asmcmd

ASMCMD> lsdg

ASMCMD> exit

[oracle@prod1 ~]$ ps -ef | grep pmon

oracle    77269      1  0 15:28 ?        00:00:00 asm_pmon_+ASM

oracle    77712  76935  0 15:30 pts/1    00:00:00 grep --color=auto pmon

[oracle@prod1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 19 15:30:07 2023

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> alter diskgroup data mount;

Diskgroup altered.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[oracle@prod1 ~]$ asmcmd lsdg

State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  N         512             512   4096  4194304      5116     5016                0            5016              0             N  DATA/

[oracle@prod1 ~]$

Bit about Share Market - Notes

BULLISH FLAG  : https://www.youtube.com/shorts/qtwZ8kfCZNY

BEARISH FLAG 

BULLISH PENNANT

BEARISH PENNANT

https://www.youtube.com/watch?v=oljma-gkOic

ASCENDING TRIANGLE  : https://www.youtube.com/watch?v=TuPd6e2Qn_c

DESCENDING TRIANGLE : https://www.youtube.com/watch?v=7-YGayL5ras

BULLISH RECTANGLE :  https://www.youtube.com/watch?v=fsmgGEVPRrc

BEARISH RECTANGLE : https://www.youtube.com/watch?v=fsmgGEVPRrc

ORA-02085: database link TEST connects to ORCLlocal

 SQL> show parameter global_names

NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ global_names boolean FALSE SQL> select * from dual@test; select * from dual@test * ERROR at line 1: ORA-02085: database link TEST connects to ORCLlocal SQL> alter session set global_names=FALSE; Session altered. SQL> select * from dual@test; D - X

SQL> alter system set global_names=FALSE sid='*' scope=both; System altered. SQL> exit Disconnected from Oracle Database 19c EE High Perf Release 19.0.0.0.0 - Production Version 19.20.0.0.0 [oracle@localhost ]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 26 12:33:26 2024 Version 19.20.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Connected to: Oracle Database 19c EE High Perf Release 19.0.0.0.0 - Production Version 19.20.0.0.0 SQL> conn testusr/testusr@TRGTDB Connected. SQL> select * from dual@test; D - X

Could not connect 'Ethernet0' to virtual network 'VMnet0'. More information can be found in the vmware.log file.

Error 

Could not connect 'Ethernet0' to virtual network 'VMnet0'. More information can be found in the vmware.log file.

 

Failed to connect virtual device 'Ethernet0'.

 

Solution: 

1. Stop all VMS from VMware workstation.

2. Once stop, click on  Edit -> "Virtual Network Editior"

3. It will open below wizard and click on change settings .  

4. Click on restore default and wait to complete. once reset completed start your machine. 

Hostname changed and ORACLE ASM restart is not able start and connect

If hostname changed (click here) and ORACLE ASM restart is not able start and connect, 

[root@oemserver oracle]# crsctl start has
CLSU-00100: operating system function: opendir failed with error data: 2
CLSU-00101: operating system error message: No such file or directory
CLSU-00103: error location: scrsearch1
CLSU-00104: additional error information: cant open scr home dir scls_scr_getval
CRS-4000: Command Start failed, or completed with errors.

Note: Below steps may loose your ASM disk data, so pls do not try below steps on prod directly .

Solution : Please refer below steps from Root user.

/u01/app/oracle/product/12.2.0.1/grid/perl/bin/perl  /u01/app/oracle/product/12.2.0.1/grid/crs/install/roothas.pl -deconfig -force
/u01/app/oracle/product/12.2.0.1/grid/perl/bin/perl  /u01/app/oracle/product/12.2.0.1/grid/crs/install/roothas.pl 
or
/u01/app/oracle/product/12.2.0.1/grid/perl/bin/perl  /u01/app/oracle/product/12.2.0.1/grid/crs/install/root.sh 

====  Other Issue during start ORACLE ASM Restart ======================

[oracle@oemserver ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.ons

               OFFLINE OFFLINE      oemserver                STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        OFFLINE OFFLINE                                      STABLE

ora.diskmon

      1        OFFLINE OFFLINE                                       STABLE

ora.evmd

      1        ONLINE  ONLINE       oemserver                STABLE

--------------------------------------------------------------------------------

 
Error :
[oracle@oemserver ~]$ crsctl start resource ora.cssd
CRS-4995:  The command 'Stop  resource' is invalid in crsctl. Use srvctl for this command.

Solution :
./crsctl start resource ora.cssd -unsupported

[oracle@oemserver ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.ons

               OFFLINE OFFLINE      oemserver                STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       oemserver                STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       oemserver                STABLE

--------------------------------------------------------------------------------

=====================================================================

If asm is not starting, set display and use asmca. it will start ASM and you can mount disk which you wants.

[oracle@oemserver ~]$ asmca

[oracle@oemserver ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.ons

               OFFLINE OFFLINE      oemserver                STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       oemserver                STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       oemserver                STABLE

--------------------------------------------------------------------------------

[oracle@oemserver ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Dec 19 14:09:20 2023

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

=====================================================================

Steps to add Listner/Disk/ASM in SRVCTL

[oracle@oemserver ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.asm

               OFFLINE OFFLINE      oemserver                STABLE

ora.ons

               OFFLINE OFFLINE      oemserver                STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       oemserver                STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       oemserver                STABLE

--------------------------------------------------------------------------------

[oracle@oemserver ~]$ srvctl add listener -listener LISTENER -endpoints 1521

[oracle@oemserver ~]$ srvctl add asm -l LISTENER -d DATA -p +data/spfile.ora

[oracle@oemserver ~]$ srvctl config asm

ASM home: <CRS home>

Password file:

Backup of Password file:

ASM listener: LISTENER

Spfile: +data/spfile.ora

ASM diskgroup discovery string: DATA

[oracle@oemserver ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

               OFFLINE OFFLINE      oemserver                STABLE

ora.asm

               OFFLINE OFFLINE      oemserver                STABLE

ora.ons

               OFFLINE OFFLINE      oemserver                STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        ONLINE  ONLINE       oemserver                STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       oemserver                STABLE

--------------------------------------------------------------------------------

[oracle@oemserver ~]$

Unable to open kernel device '\\.\VMCIDev\VMX': The operation completed successfully.

Hello Friends, 

When I was working on new machine and install VMware 17 Pro, I copied backed up VM machine to new machine and started VM, It was showing below error.    

Error :

====================================================================================================

 Unable to open kernel device '\\.\VMCIDev\VMX': The operation completed successfully. Did you reboot after installing VMware Workstation?

Module 'DevicePowerOn' power on failed.

Failed to start the virtual machine.

====================================================================================================

Solution : 

I have copied/restored VM to "D:\VMware\VM2\EL_7.9" . 

1. Go to your VM directories. 

2. take backup of VMware virtual machine configuration (.vmx), as highlighted.  

3. Open OEL7.9 in notepad and search for vmci0.present. If it has set with TRUE value. Make it FALSE. shown as below.

4. Restart your VM machine, it will run without any error.

Feel free to share if issue not fixed. 

How to fix CheckName: TBLSPACE_FLASHBACK_OFF issue during Oracle Auto Upgrade

 Hello Friends, 

As from oracle 19c, Oracle started to provide database upgrade using autoupgrade features, It also provide report of preupgrade we have in traditional method but here you can get that report in HTML and easy to focus on error.  

Important point is DBA must be keep practicing to check flashback status on tablespace too if you are using tablespace during time of any activity. 

You may check it with the hep of "select name, flashback_on from v$tablespace " 

You face issue related to TBLSPACE_FLASHBACK_OFF is failing during prechecks stage. Error could be same as showing error in red box and description.  Please refer solution which fixes the issue.

• CheckName: TBLSPACE_FLASHBACK_OFF
 
• FixUp Available: NO
 
• Severity: ERROR
 
• Stage: PRECHECKS

As the AutoUpgrade utility creates restore points by default, enable flashback for the tablespace(s) that have flashback off prior to upgrading. For more details, refer to the section on "Using Flashback Database and Restore Points" in Oracle documentation "Backup and Recovery User's Guide".
Note: To find tablespaces with flashback off, run: select name from v$tablespace where flashback_on = 'NO';

Flashback is not possible if at least one tablespace in the database has flashback disabled.

At least one tablespace in this database has flashback off. To find such tablespaces, run: select name, flashback_on from v$tablespace where flashback_on = 'NO';

• Solution: 

SQL> select name, flashback_on from v$tablespace ;
NAME                           FLA
------------------------------ ---
SYSTEM                         YES
SYSAUX                         YES
UNDOTBS1                       YES
TEMP                           YES
USERS                          YES
DATA_SCOTT                      NO
INDX_SCOTT                      NO

 

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

 

SQL> startup mount;
ORACLE instance started.
Total System Global Area 3.2212E+10 bytes
Fixed Size                 12178656 bytes
Variable Size            1.6643E+10 bytes
Database Buffers         1.5502E+10 bytes
Redo Buffers               54927360 bytes
Database mounted.

 

SQL>  alter tablespace DATA_SCOTT flashback on;
Tablespace altered.

SQL>  alter tablespace INDEX_SCOTT flashback on;
Tablespace altered.

SQL> select name, flashback_on from v$tablespace ;
NAME                           FLA
------------------------------ ---
SYSTEM                         YES
SYSAUX                         YES
UNDOTBS1                       YES
TEMP                           YES
USERS                          YES
DATA_SCOTT                      YES
INDX_SCOTT                      YES

SQL> alter database open; 

Once it started to show All tablespace flashback_on is YES, you may resume upgrade job.

 

 Please share your feedback if this didn't works.