Oracle database upgrade from 19c to 21c .

Oracle database upgrade from 19c to 21c =============================================

+ASM:/u01/app/21.3.0/grid:N             # line added by Agent

v14mpc:/u01/app/oracle/product/19.0.0/dbhome1:N   >>>> aim to upgrade to 21 c
cdborcl:/u01/app/oracle/product/21.0.0/dbhome1:N
xxx:/u01/app/oracle/product/19.0.0/dbhome1:N


Note :

Starting with Oracle Database Release 21c, preupgrade tool functionality (preupgrade.jar) has been integrated into the AutoUpgrade tool (autoupgrade.jar -preupgrade option). Refer to Oracle Database Upgrade Guide for details on usage.

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




Oracle 19c !!!! 
Check all the pdbs should be read write mode 


 SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 V14MPCPDB                      READ WRITE NO


======
https://nyoug.org/wp-content/uploads/2019/12/OOW2019_AutoUpgrade19c.pdf

options 
$ java -jar autoupgrade.jar -config config.cfg -mode analyze
$ java -jar autoupgrade.jar -config config.cfg -mode fixups
$ java -jar autoupgrade.jar -config config.cfg -mode upgrade

-mode analyze|fixups|deploy


[oracle@oragrid ~]$ /usr/bin/java -jar /u01/app/oracle/product/21.0.0/dbhome1/rdbms/admin/autoupgrade.jar -config /u01/app/oracle/autoupgrade1/config1.txt -mode analyze
AutoUpgrade 24.8.241119 launched with default internal options
Processing config file ...


upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|         MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 104| v14mpc|PRECHECKS|EXECUTING|RUNNING|  06:22:38|16s ago|Executing Checks|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+----------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|         MESSAGE|
+----+-------+---------+---------+-------+----------+-------+----------------+
| 104| v14mpc|PRECHECKS|EXECUTING|RUNNING|  06:22:38|19s ago|Executing Checks|
+----+-------+---------+---------+-------+----------+-------+----------------+
Total jobs 1

upg> Job 104 completed
------------------- Final Summary --------------------
Number of databases            [ 1 ]

Jobs finished                  [1]
Jobs failed                    [0]

Please check the summary report at:
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status/status.html
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status/status.log


[oracle@oragrid ~]$ cat /u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status/status.log
==========================================
          Autoupgrade Summary Report
==========================================
[Date]           Sat Dec 28 06:26:49 GMT 2024
[Number of Jobs] 1
==========================================
[Job ID] 104
==========================================
[DB Name]                v14mpc
[Version Before Upgrade] 19.3.0.0.0
[Version After Upgrade]  21.3.0.0.0
------------------------------------------
[Stage Name]    PRECHECKS
[Status]        SUCCESS
[Start Time]    2024-12-28 06:22:38
[Duration]      0:04:11
[Log Directory] /u01/app/oracle/autoupgrade1/v14mpc/104/prechecks
[Detail]        /u01/app/oracle/autoupgrade1/v14mpc/104/prechecks/v14mpc_preupgrade.log
                Check passed and no manual intervention needed
------------------------------------------


[oracle@oragrid ~]$ ls -ltr /u01/app/oracle/autoupgrade1/v14mpc/104/prechecks
total 1212
-rw-r----- 1 oracle oinstall 362101 Dec 28 06:25 prechecks_cdb_root.log
-rw-r----- 1 oracle oinstall 294935 Dec 28 06:25 prechecks_v14mpcpdb.log
-rw-r----- 1 oracle oinstall 294684 Dec 28 06:26 prechecks_pdb_seed.log
-rw-r----- 1 oracle oinstall  31427 Dec 28 06:26 v14mpc_checklist.xml
-rw-r----- 1 oracle oinstall  33148 Dec 28 06:26 v14mpc_checklist.json
-rw-r----- 1 oracle oinstall   9930 Dec 28 06:26 v14mpc_checklist.cfg
-rw-r----- 1 oracle oinstall  64911 Dec 28 06:26 v14mpc_preupgrade.html  ----check html file 
-rw-r----- 1 oracle oinstall  93796 Dec 28 06:26 upgrade.xml
-rw-r----- 1 oracle oinstall  39551 Dec 28 06:26 v14mpc_preupgrade.log
[oracle@oragrid ~]$



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

Run below as per update v14mpc_preupgrade.html file 


[oracle@oragrid ~]$ !sql
sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Dec 28 06:53:13 2024
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>
EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
PL/SQL procedure successfully completed.

 SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 V14MPCPDB                      READ WRITE NO
SQL> alter session set container=V14MPCPDB ;

Session altered.

SQL> EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

PL/SQL procedure successfully completed.

SQL>

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

upgade start from here !!!!!!!!!!!!!!!!
Now use … -mode deploy

/usr/bin/java -jar /u01/app/oracle/product/21.0.0/dbhome1/rdbms/admin/autoupgrade.jar -config /u01/app/oracle/autoupgrade1/config1.txt -mode deploy




[root@oragrid trace]# pwd
/u01/app/oracle/diag/rdbms/v14mpc/v14mpc/trace
[root@oragrid trace]# tail -100f alert_v14mpc.log


to update the locate ...
updatedb

locate cfgtoollogs|grep -i 28   <<<< date 
/u01/app/21.3.0/grid/cfgtoollogs/opatch/opatch2024-12-13_15-14-28PM_1.log
/u01/app/21.3.0/grid/cfgtoollogs/opatch/opatch2024-12-13_15-28-42PM_1.log
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_18_15
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_26_32
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_18_15/progress.json
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_18_15/status.html
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_18_15/status.json
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_18_15/status.log
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_18_15/v14mpc_prechecks.success
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_26_32/progress.json
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_26_32/status.html
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_26_32/status.json
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_26_32/status.log
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status_2024_12_28_06_26_32/v14mpc_prechecks.success


-rw-r----- 1 oracle oinstall 4077850 Dec 28 09:00 autoupgrade.log
[root@oragrid auto]# pwd
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto
[root@oragrid auto]#


[root@oragrid auto]# pwd
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto
[root@oragrid auto]# tail -100f autoupgrade.log





upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|31s ago|52%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|99s ago|52%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|63s ago|52%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|60s ago|76%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+--------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME| UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+--------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|117s ago|76%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+----------+--------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|31s ago|85%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43| 4s ago|0%Upgraded V14MPCPDB|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|26s ago|1%Upgraded V14MPCPDB|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+---------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|              MESSAGE|
+----+-------+---------+---------+-------+----------+-------+---------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|35s ago|22%Upgraded V14MPCPDB|
+----+-------+---------+---------+-------+----------+-------+---------------------+
Total jobs 1

upg> lsj -e
+----+-------+-----+---------+------+----------+-------+-------+
|Job#|DB_NAME|STAGE|OPERATION|STATUS|START_TIME|UPDATED|MESSAGE|
+----+-------+-----+---------+------+----------+-------+-------+
+----+-------+-----+---------+------+----------+-------+-------+
Total jobs 0

upg> lsj
+----+-------+---------+---------+-------+----------+-------+---------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|              MESSAGE|
+----+-------+---------+---------+-------+----------+-------+---------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|48s ago|22%Upgraded V14MPCPDB|
+----+-------+---------+---------+-------+----------+-------+---------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|11s ago|52%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|87s ago|52%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|37s ago|52%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+-------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|78s ago|52%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+----------+-------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+--------+--------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME| UPDATED|             MESSAGE|
+----+-------+---------+---------+-------+----------+--------+--------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|120s ago|52%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+----------+--------+--------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+---------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|              MESSAGE|
+----+-------+---------+---------+-------+----------+-------+---------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|46s ago|58%Upgraded V14MPCPDB|
+----+-------+---------+---------+-------+----------+-------+---------------------+
Total jobs 1

upg> lsj -e
+----+-------+-----+---------+------+----------+-------+-------+
|Job#|DB_NAME|STAGE|OPERATION|STATUS|START_TIME|UPDATED|MESSAGE|
+----+-------+-----+---------+------+----------+-------+-------+
+----+-------+-----+---------+------+----------+-------+-------+
Total jobs 0

upg> lsj
+----+-------+---------+---------+-------+----------+-------+---------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|              MESSAGE|
+----+-------+---------+---------+-------+----------+-------+---------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|87s ago|76%Upgraded V14MPCPDB|
+----+-------+---------+---------+-------+----------+-------+---------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+---------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|              MESSAGE|
+----+-------+---------+---------+-------+----------+-------+---------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43| 2s ago|76%Upgraded V14MPCPDB|
+----+-------+---------+---------+-------+----------+-------+---------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+---------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|              MESSAGE|
+----+-------+---------+---------+-------+----------+-------+---------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|62s ago|76%Upgraded V14MPCPDB|
+----+-------+---------+---------+-------+----------+-------+---------------------+
Total jobs 1

upg> lsj
+----+-------+---------+---------+-------+----------+-------+---------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|START_TIME|UPDATED|              MESSAGE|
+----+-------+---------+---------+-------+----------+-------+---------------------+
| 105| v14mpc|DBUPGRADE|EXECUTING|RUNNING|  07:39:43|36s ago|85%Upgraded V14MPCPDB|
+----+-------+---------+---------+-------+----------+-------+---------------------+
Total jobs 1

upg> lsj
+----+-------+----------+---------+-------+----------+-------+----------------------------------------+
|Job#|DB_NAME|     STAGE|OPERATION| STATUS|START_TIME|UPDATED|                                 MESSAGE|
+----+-------+----------+---------+-------+----------+-------+----------------------------------------+
| 105| v14mpc|SYSUPDATES|EXECUTING|RUNNING|  07:39:43|34s ago|RAC configurations have finished success|
+----+-------+----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1

upg> lsj
+----+-------+----------+---------+-------+----------+-------+----------------------------------------+
|Job#|DB_NAME|     STAGE|OPERATION| STATUS|START_TIME|UPDATED|                                 MESSAGE|
+----+-------+----------+---------+-------+----------+-------+----------------------------------------+
| 105| v14mpc|SYSUPDATES|EXECUTING|RUNNING|  07:39:43|39s ago|RAC configurations have finished success|
+----+-------+----------+---------+-------+----------+-------+----------------------------------------+
Total jobs 1

upg> Job 105 completed
------------------- Final Summary --------------------
Number of databases            [ 1 ]

Jobs finished                  [1]
Jobs failed                    [0]
Jobs restored                  [0]
Jobs pending                   [0]

---- Drop GRP at your convenience once you consider it is no longer needed ----
Drop GRP from v14mpc: drop restore point AUTOUPGRADE_9212_V14MPC193000


Please check the summary report at:
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status/status.html
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status/status.log



====

2024-12-28 09:44:12.451 INFO ------------------- Final Summary --------------------
Number of databases            [ 1 ]

Jobs finished                  [1]
Jobs failed                    [0]
Jobs restored                  [0]
Jobs pending                   [0]

---- Drop GRP at your convenience once you consider it is no longer needed ----
Drop GRP from v14mpc: drop restore point AUTOUPGRADE_9212_V14MPC193000


Please check the summary report at:
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status/status.html
/u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto/status/status.log - Exit.summaryInfoSection#279
2024-12-28 09:44:12.459 INFO Starting files protection - SetProtection.setGlobalProtections#268
2024-12-28 09:44:12.459 INFO Protecting global dir - SetProtection.setGlobalProtections#269
2024-12-28 09:44:12.460 INFO The console is closing now as per interruption request - ConsoleReader.run#70
2024-12-28 09:44:12.460 INFO Closing - ConsoleReader.run#108
2024-12-28 09:44:12.461 INFO Starting - SetProtection.protectPath#307
2024-12-28 09:44:12.461 INFO Protecting path /u01/app/oracle/autoupgrade1/cfgtoollogs/upgrade/auto - SetProtection.protectPath#308
2024-12-28 09:44:12.462 INFO Bye Bye thread queue_reader | daemon false - AbstractJobMonitor.stopTheParty#97
2024-12-28 09:44:12.462 INFO Bye Bye thread cmd-0 | daemon false - AbstractJobMonitor.stopTheParty#100
2024-12-28 09:44:12.462 INFO Bye Bye thread console | daemon false - AbstractJobMonitor.stopTheParty#100
2024-12-28 09:44:12.462 INFO Bye Bye thread job_manager-0 | daemon false - AbstractJobMonitor.stopTheParty#97
2024-12-28 09:44:12.462 INFO Bye Bye thread StatUpg | daemon true - AbstractJobMonitor.stopTheParty#97
2024-12-28 09:44:12.462 INFO Bye Bye thread main | daemon false - AbstractJobMonitor.stopTheParty#97
2024-12-28 09:44:12.462 INFO End  - AbstractJobMonitor.stopTheParty#103
2024-12-28 09:44:12.462 INFO Closing - DeployTypeMon.shutdownCheck#217
2024-12-28 09:44:12.463 INFO Protecting elapsed time 0 seconds - SetProtection.protectPath#336
2024-12-28 09:44:12.463 INFO End  - SetProtection.protectPath#337
2024-12-28 09:44:12.463 INFO FilesProtector running for job 105 - Exit.lambda$coreExit$3#208
2024-12-28 09:44:12.463 INFO Starting files protection - SetProtection.setJobProtections#284
2024-12-28 09:44:12.463 INFO Protecting local dir - SetProtection.setJobProtections#285
2024-12-28 09:44:12.464 INFO Starting - SetProtection.protectPath#307
2024-12-28 09:44:12.464 INFO Protecting path /u01/app/oracle/autoupgrade1/v14mpc/105 - SetProtection.protectPath#308
2024-12-28 09:44:12.468 INFO Protecting elapsed time 0 seconds - SetProtection.protectPath#336
2024-12-28 09:44:12.468 INFO End  - SetProtection.protectPath#337
2024-12-28 09:44:12.468 INFO Starting - SetProtection.protectPath#307
2024-12-28 09:44:12.468 INFO Protecting path /u01/app/oracle/autoupgrade1/v14mpc/temp - SetProtection.protectPath#308
2024-12-28 09:44:12.469 INFO Protecting elapsed time 0 seconds - SetProtection.protectPath#336
2024-12-28 09:44:12.469 INFO End  - SetProtection.protectPath#337
2024-12-28 09:44:12.469 INFO End processing cmd [exit] - CommandController.processCmd#116
2024-12-28 09:44:12.469 INFO Executing global actions after running AutoUpgrade - ActionsExecutor.runGlobalAfterAction#249

Linux virtual machine can't ping google while host can do it !!!!!

1. on vm > setting > network > bridged adapter 


2.

on laptop

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

on DOS cmd !!!!!


C:\Users\>ipconfig -all

Windows IP Configuration

   Host Name . . . . . . . . . . . . : DESKTOP-*****
   Primary Dns Suffix  . . . . . . . :
   Node Type . . . . . . . . . . . . : Hybrid
   IP Routing Enabled. . . . . . . . : No
   WINS Proxy Enabled. . . . . . . . : No
   DNS Suffix Search List. . . . . . : ******

Ethernet adapter Ethernet 5:

   Connection-specific DNS Suffix  . :
   Description . . . . . . . . . . . : VirtualBox Host-Only Ethernet Adapter
   Physical Address. . . . . . . . . : 0A-00-27-00-00-17
   DHCP Enabled. . . . . . . . . . . : No
   Autoconfiguration Enabled . . . . : Yes
   Link-local IPv6 Address . . . . . : fe80::d6d3:a222:fb62:c216%23(Preferred)
   IPv4 Address. . . . . . . . . . . : 192.168.56.1(Preferred)
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . :
   DHCPv6 IAID . . . . . . . . . . . : 822738983
   DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-2D-80-59-CC-8C-04-BA-09-51-49
   NetBIOS over Tcpip. . . . . . . . : Enabled

Wireless LAN adapter Local Area Connection* 1:

   Media State . . . . . . . . . . . : Media disconnected
   Connection-specific DNS Suffix  . :
   Description . . . . . . . . . . . : Microsoft Wi-Fi Direct Virtual Adapter
   Physical Address. . . . . . . . . : D0-AB-D5-2C-F5-DE
   DHCP Enabled. . . . . . . . . . . : Yes
   Autoconfiguration Enabled . . . . : Yes

Wireless LAN adapter Local Area Connection* 10:

   Media State . . . . . . . . . . . : Media disconnected
   Connection-specific DNS Suffix  . :
   Description . . . . . . . . . . . : Microsoft Wi-Fi Direct Virtual Adapter #2
   Physical Address. . . . . . . . . : D2-AB-D5-2C-F5-DD
   DHCP Enabled. . . . . . . . . . . : Yes
   Autoconfiguration Enabled . . . . : Yes

Wireless LAN adapter WiFi:

   Connection-specific DNS Suffix  . : lan
   Description . . . . . . . . . . . : Intel(R) Dual Band Wireless-AC 8265
   Physical Address. . . . . . . . . : D0-AB-D5-2C-F5-DD
   DHCP Enabled. . . . . . . . . . . : Yes
   Autoconfiguration Enabled . . . . : Yes
   IPv6 Address. . . . . . . . . . . : 2a00:23c6:9735:5900:ddd6:4f4d:42d7:b65e(Preferred)
   IPv6 Address. . . . . . . . . . . : fd78:4c15:7f9d::fa5(Preferred)
   Lease Obtained. . . . . . . . . . : 25 December 2024 06:20:46
   Lease Expires . . . . . . . . . . : 28 December 2024 07:22:17
   IPv6 Address. . . . . . . . . . . : fd78:4c15:7f9d:0:241d:5b8:815f:9899(Preferred)
   Temporary IPv6 Address. . . . . . : 2a00:23c6:9735:5900:18c3:619d:8145:53f5(Preferred)
   Temporary IPv6 Address. . . . . . : 2a00:23c6:9735:5900:589a:f4b4:6eac:936a(Deprecated)
   Temporary IPv6 Address. . . . . . : 2a00:23c6:9735:5900:6c49:e836:4352:6eb5(Deprecated)
   Temporary IPv6 Address. . . . . . : 2a00:23c6:9735:5900:ecbc:b24d:a806:8b47(Deprecated)
   Temporary IPv6 Address. . . . . . : 2a00:23c6:9735:5900:fd1f:74b6:8106:6ba2(Deprecated)
   Temporary IPv6 Address. . . . . . : fd78:4c15:7f9d:0:18c3:619d:8145:53f5(Preferred)
   Temporary IPv6 Address. . . . . . : fd78:4c15:7f9d:0:589a:f4b4:6eac:936a(Deprecated)
   Temporary IPv6 Address. . . . . . : fd78:4c15:7f9d:0:6c49:e836:4352:6eb5(Deprecated)
   Temporary IPv6 Address. . . . . . : fd78:4c15:7f9d:0:ecbc:b24d:a806:8b47(Deprecated)
   Temporary IPv6 Address. . . . . . : fd78:4c15:7f9d:0:fd1f:74b6:8106:6ba2(Deprecated)
   Link-local IPv6 Address . . . . . : fe80::f22a:c00e:45e2:27b7%2(Preferred)
   IPv4 Address. . . . . . . . . . . : 192.168.1.213(Preferred)
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Lease Obtained. . . . . . . . . . : 25 December 2024 06:20:55
   Lease Expires . . . . . . . . . . : 28 December 2024 07:22:05
   Default Gateway . . . . . . . . . : fe80::ba6a:f1ff:fec4:ae90%2
                                       192.168.1.254
   DHCP Server . . . . . . . . . . . : 192.168.1.254
   DHCPv6 IAID . . . . . . . . . . . : 47229909
   DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-2D-80-59-CC-8C-04-BA-09-51-49
   DNS Servers . . . . . . . . . . . : 192.168.1.254   <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< check dns !!!!!!!!!!
   NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter Bluetooth Network Connection:

   Media State . . . . . . . . . . . : Media disconnected
   Connection-specific DNS Suffix  . :
   Description . . . . . . . . . . . : Bluetooth Device (Personal Area Network)
   Physical Address. . . . . . . . . : D0-AB-D5-2C-F5-E1
   DHCP Enabled. . . . . . . . . . . : Yes
   Autoconfiguration Enabled . . . . : Yes

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



on vm !!!!



[root@srv1 ~]# ifconfig -a
enp0s3: flags=4163  mtu 1500                          >>>> card name enp0s3
        inet 192.168.1.120  netmask 255.255.255.0  broadcast 192.168.1.255
        inet6 fd78:4c15:7f9d::677  prefixlen 128  scopeid 0x0
        inet6 fe80::8f73:744d:ce36:6e12  prefixlen 64  scopeid 0x20
        inet6 2a00:23c6:9735:5900:9af9:fed8:2570:486b  prefixlen 64  scopeid 0x0
        inet6 fd78:4c15:7f9d:0:1155:a65a:49d8:fcc8  prefixlen 64  scopeid 0x0
        inet6 2a00:23c6:9735:5900::677  prefixlen 128  scopeid 0x0
        ether 08:00:27:a5:38:cd  txqueuelen 1000  (Ethernet)
        RX packets 13009  bytes 1299156 (1.2 MiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 2974  bytes 305294 (298.1 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

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


[root@srv1 ~]# route -n
Kernel IP routing table
Destination     Gateway         Genmask         Flags Metric Ref    Use Iface
0.0.0.0         192.168.1.1     0.0.0.0         UG    100    0        0 enp0s3   <<<<<<<<<<<<<<<<<----- wrong gateway should be 192.168.1.254
192.168.1.0     0.0.0.0         255.255.255.0   U     100    0        0 enp0s3
192.168.122.0   0.0.0.0         255.255.255.0   U     0      0        0 virbr0
[root@srv1 ~]#



[root@srv1 ~]# ip a
1: lo:  mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host
       valid_lft forever preferred_lft forever
2: enp0s3:  mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
    link/ether 08:00:27:a5:38:cd brd ff:ff:ff:ff:ff:ff
    inet 192.168.1.120/24 brd 192.168.1.255 scope global noprefixroute enp0s3
       valid_lft forever preferred_lft forever
    inet6 fd78:4c15:7f9d::677/128 scope global noprefixroute dynamic
       valid_lft 86203sec preferred_lft 43003sec
    inet6 2a00:23c6:9735:5900::677/128 scope global noprefixroute dynamic
       valid_lft 86203sec preferred_lft 43003sec
    inet6 fd78:4c15:7f9d:0:1155:a65a:49d8:fcc8/64 scope global noprefixroute
       valid_lft forever preferred_lft forever
    inet6 2a00:23c6:9735:5900:9af9:fed8:2570:486b/64 scope global noprefixroute dynamic
       valid_lft 315274393sec preferred_lft 315274393sec
    inet6 fe80::8f73:744d:ce36:6e12/64 scope link noprefixroute
       valid_lft forever preferred_lft forever
3: virbr0:  mtu 1500 qdisc noqueue state DOWN group default qlen 1000
    link/ether 52:54:00:bd:bd:d5 brd ff:ff:ff:ff:ff:ff
    inet 192.168.122.1/24 brd 192.168.122.255 scope global virbr0
       valid_lft forever preferred_lft forever
4: virbr0-nic:  mtu 1500 qdisc pfifo_fast master virbr0 state DOWN group default qlen 1000
    link/ether 52:54:00:bd:bd:d5 brd ff:ff:ff:ff:ff:ff
[root@srv1 ~]#




cat /etc/sysconfig/network-scripts/ifcfg-enp0s3

TYPE=Ethernet
PROXY_METHOD=none
BROWSER_ONLY=no
BOOTPROTO=static
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6_ADDR_GEN_MODE=stable-privacy
NAME=enp0s3
UUID=85024e4e-c958-4e04-8cda-3ed286b66822
DEVICE=enp0s3
ONBOOT=yes
IPV6_PRIVACY=no
IPADDR=192.168.1.120
PREFIX=24
GATEWAY=192.168.1.254   <<<< add dns router ip  or  add via this command >>>  route add default gw 192.168.1.254 enp0s3
DNS1=192.168.1.254


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

command !!!!  or add on network card 

route add default gw 192.168.1.254 enp0s3

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

chattr -i /etc/resolv.conf

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

edit below file 

[root@srv1 ~]# cat /etc/resolv.conf
# Generated by NetworkManager
search localdomain
nameserver 192.168.1.254
nameserver 8.8.8.8
nameserver 8.8.4.4


chattr +i /etc/resolv.conf

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


[root@srv1 ~]# ip route show
default via 192.168.1.1 dev enp0s3 proto static metric 100
192.168.1.0/24 dev enp0s3 proto kernel scope link src 192.168.1.120 metric 100
192.168.122.0/24 dev virbr0 proto kernel scope link src 192.168.122.1 linkdown
[root@srv1 ~]#



[root@srv1 ~]# route -n

Kernel IP routing table
Destination     Gateway         Genmask         Flags Metric Ref    Use Iface
0.0.0.0         192.168.1.254   0.0.0.0         UG    100    0        0 enp0s3
192.168.1.0     0.0.0.0         255.255.255.0   U     100    0        0 enp0s3
192.168.122.0   0.0.0.0         255.255.255.0   U     0      0        0 virbr0



nmcli connection down "connection_name"
nmcli connection up   "connection_name"
nmcli connection down "enp0s3"  

systemd-resolve --flush-caches


nmcli networking off
nmcli networking on

[root@srv1 ~]# systemctl restart NetworkManager
[root@srv1 ~]# systemctl status NetworkManager



[root@srv1 ~]# ping 8.8.8.8
PING 8.8.8.8 (8.8.8.8) 56(84) bytes of data.
64 bytes from 8.8.8.8: icmp_seq=1 ttl=117 time=6.84 ms
64 bytes from 8.8.8.8: icmp_seq=2 ttl=117 time=8.01 ms
64 bytes from 8.8.8.8: icmp_seq=3 ttl=117 time=7.42 ms
64 bytes from 8.8.8.8: icmp_seq=4 ttl=117 time=7.09 ms
64 bytes from 8.8.8.8: icmp_seq=5 ttl=117 time=7.15 ms



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


dhcp setting 


cat /etc/sysconfig/network-scripts/ifcfg-enp0s3
TYPE="Ethernet"
PROXY_METHOD="none"
BROWSER_ONLY="no"
BOOTPROTO="dhcp"
DEFROUTE="yes"
IPV4_FAILURE_FATAL="no"
IPV6INIT="yes"
IPV6_AUTOCONF="yes"
IPV6_DEFROUTE="yes"
IPV6_FAILURE_FATAL="no"
IPV6_ADDR_GEN_MODE="stable-privacy"
NAME="enp0s3"
UUID="fdc2fc8c-f5b5-4e81-9c9e-b579991f2249"
DEVICE="enp0s3"
ONBOOT="yes"


[root@oragrid ~]# route -n
Kernel IP routing table
Destination     Gateway         Genmask         Flags Metric Ref    Use Iface
0.0.0.0         192.168.1.254   0.0.0.0         UG    100    0        0 enp0s3
192.168.1.0     0.0.0.0         255.255.255.0   U     100    0        0 enp0s3
192.168.122.0   0.0.0.0         255.255.255.0   U     0      0        0 virbr0
[root@oragrid ~]#

Linux version Or unix version

cat /etc/oracle-release
cat /etc/redhat-release
cat /etc/os-release
lsb_release -id




lsb_release -a


[root@oragrid ~]# lsb_release -a
LSB Version:    :core-4.1-amd64:core-4.1-noarch
Distributor ID: CentOS
Description:    CentOS Linux release 8.5.2111
Release:        8.5.2111
Codename:       n/a


[root@oragrid ~]# lsb_release -d
Description:    CentOS Linux release 8.5.2111


[root@oragrid ~]# lsb_release -i -s
CentOS

[root@oragrid ~]# lsb_release -rcs
8.5.2111 n/a

[root@oragrid ~]# lsb_release -s
:core-4.1-amd64:core-4.1-noarch

[root@oragrid ~]# lsb_release -si
CentOS



[root@oragrid ~]# cat /etc/redhat-release
CentOS Linux release 8.5.2111

[root@oragrid ~]# cat /etc/os-release
NAME="CentOS Linux"
VERSION="8"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="8"
PLATFORM_ID="platform:el8"
PRETTY_NAME="CentOS Linux 8"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:8"
HOME_URL="https://centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"
CENTOS_MANTISBT_PROJECT="CentOS-8"
CENTOS_MANTISBT_PROJECT_VERSION="8"

[INS-30502] No ASM Disk Group found

[INS-30502] No ASM Disk Group found

as root 

vi /etc/group

dba:x:54322:grid,oracle
oper:x:54323:oracle
backupdba:x:54324:
dgdba:x:54325:
kmdba:x:54326:
asmdba:x:54327:grid,oracle   <<<<< oracle should be part of asmdba 
asmoper:x:54328:grid
asmadmin:x:54329:grid
racdba:x:54330:
postdrop:x:90:
postfix:x:89:
osdba:x:1020:oracle,grid
osoper:x:1030:oracle
osbackupdba:x:1040:oracle
oskmdba:x:1050:oracle
osdgdba:x:1060:oracle
osracdba:x:1070:oracle
[root@oragrid ~]#

How To Relink The Oracle Grid Infrastructure Standalone (Restart) Installation.

 


Metalink Note :

How To Relink The Oracle Grid Infrastructure Standalone (Restart) Installation 
Or Oracle Grid Infrastructure RAC/Cluster Installation (11.2 to 21c). (Doc ID 1536057.1)



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

as Grid .. 

[grid@oragrid ~]$ id
uid=1100(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54327(asmdba),54328(asmoper),54329(asmadmin)


[grid@oragrid ~]$ . oraenv
ORACLE_SID = [+ASM] ?
The Oracle base remains unchanged with value /u01/app/grid
[grid@oragrid ~]$


stop has via grid user 

[grid@oragrid ~]$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oragrid'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'oragrid'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'oragrid'
CRS-2677: Stop of 'ora.DATA.dg' on 'oragrid' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'oragrid'
CRS-2673: Attempting to stop 'ora.asm' on 'oragrid'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'oragrid' succeeded
CRS-2677: Stop of 'ora.asm' on 'oragrid' succeeded
CRS-2677: Stop of 'ora.evmd' on 'oragrid' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oragrid'
CRS-2677: Stop of 'ora.cssd' on 'oragrid' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oragrid' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[grid@oragrid ~]$


grid@oragrid ~]$ crsctl check has
CRS-4639: Could not contact Oracle High Availability Services





2. 

# as root !!!!!!!!

unlock the Oracle Grid Infrastructure Standalone installation

as root !!!!

[root@oragrid ~]# . oraenv
ORACLE_SID = [root] ? +ASM
The Oracle base has been set to /u01/app/grid
[root@oragrid ~]# id
uid=0(root) gid=0(root) groups=0(root)
[root@oragrid ~]#

below error !!!
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
[root@oragrid ~]# id
uid=0(root) gid=0(root) groups=0(root)
[root@oragrid ~]# $ORACLE_HOME/crs/install/roothas.pl -unlock
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 8: =head1: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 10: roothas.pl: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 12: =head1: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 14: roothas.pl: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 15: parameter-file: No such file or directory
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 16: path: No such file or directory
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 17: path: No such file or directory
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 18: [[-prepatch: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 18: path: No such file or directory
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 19: [-lockacfs]: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 20: path: No such file or directory
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 22: Options:: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 23: -verbose: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 24: -upgrade: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 25: -lock: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 26: -paramfile: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 27: -deconfig: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 28: -force: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 29: is: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 30: -unlock: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 31: -hahome: command not found
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 32: syntax error near unexpected token `('
/u01/app/21.3.0/grid/crs/install/roothas.pl: line 32: `   -prepatch  Perform required steps before the Oracle patching tool (Opatch) is invoked'
[root@oragrid ~]# echo $ORACLE_HOME
/u01/app/21.3.0/grid
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

On 12.1/12.2/21c releases, roothas.sh can be used instead of roothas.pl.   <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< roothas.sh
Command to unlock the GI home is /crs/install/roothas.sh -unlock


[root@oragrid ~]# ls -ltr $ORACLE_HOME/crs/install/roothas.pl
-rwxr-x--- 1 root oinstall 10305 Oct 10 09:07 /u01/app/21.3.0/grid/crs/install/roothas.pl
[root@oragrid ~]# ls -ltr $ORACLE_HOME/crs/install/roothas.sh
-rwxr-x--- 1 grid oinstall 3926 Dec 12 15:08 /u01/app/21.3.0/grid/crs/install/roothas.sh  <<<< use this 
[root@oragrid ~]#



[root@oragrid ~]# ls -ltr $ORACLE_HOME/crs/install/roothas.pl
-rwxr-x--- 1 root oinstall 10305 Oct 10 09:07 /u01/app/21.3.0/grid/crs/install/roothas.pl
[root@oragrid ~]# ls -ltr $ORACLE_HOME/crs/install/roothas.sh
-rwxr-x--- 1 grid oinstall 3926 Dec 12 15:08 /u01/app/21.3.0/grid/crs/install/roothas.sh

[root@oragrid ~]# $ORACLE_HOME/crs/install/roothas.sh -unlock
Using configuration parameter file: /u01/app/21.3.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/oragrid/crsconfig/haunlock__2024-12-16_09-43-56AM.log
2024/12/16 09:44:07 CLSRSC-347: Successfully unlock /u01/app/21.3.0/grid

[root@oragrid ~]#


[root@oragrid ~]# ls -ltr $ORACLE_HOME/rdbms/lib/config.o*
-rw-r--r-- 1 grid oinstall 1352 Dec 12 15:10 /u01/app/21.3.0/grid/rdbms/lib/config.o_BAK
[root@oragrid ~]#



env| egrep 'ORA|PATH' | sort
LD_LIBRARY_PATH=/u01/app/21.3.0/grid/lib
ORACLE_BASE=/u01/app/grid
ORACLE_HOME=/u01/app/21.3.0/grid
ORACLE_SID=+ASM
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/u01/app/21.3.0/grid/bin
[root@oragrid ~]#




as Grid 

[grid@oragrid ~]$ script /tmp/relink_gi.txt
Script started, file is /tmp/relink_gi.txt

[grid@oragrid ~]$ id
uid=1100(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54327(asmdba),54328(asmoper),54329(asmadmin)

[grid@oragrid ~]$ env| egrep 'ORA|PATH' | sort
LD_LIBRARY_PATH=/u01/app/21.3.0/grid/lib
ORACLE_BASE=/u01/app/grid
ORACLE_HOME=/u01/app/21.3.0/grid
ORACLE_SID=+ASM
PATH=/home/grid/.local/bin:/home/grid/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/u01/app/21.3.0/grid/bin
[grid@oragrid ~]$



 lock back the Oracle Grid Infrastructure Standalone installation

AS root #


[root@oragrid ~]# ls -ltr /u01/app/21.3.0/grid/crs/install/roothas.sh
-rwxr-x--- 1 grid oinstall 3926 Dec 12 15:08 /u01/app/21.3.0/grid/crs/install/roothas.sh



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



[root@oragrid ~]# /u01/app/21.3.0/grid/crs/install/roothas.sh -postpatch
Using configuration parameter file: /u01/app/21.3.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/oragrid/crsconfig/hapatch_2024-12-16_10-00-09AM.log
2024/12/16 10:00:14 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2024/12/16 10:01:01 CLSRSC-672: Post-patch steps for patching GI home successfully completed.
[root@oragrid ~]#



[root@oragrid ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       oragrid                  STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       oragrid                  STABLE
ora.asm
               ONLINE  ONLINE       oragrid                  Started,STABLE
ora.ons
               OFFLINE OFFLINE      oragrid                  STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       oragrid                  STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       oragrid                  STABLE
--------------------------------------------------------------------------------
[root@oragrid ~]#



[root@oragrid ~]# crsctl status res | awk -F= '/NAME=/{n=$2}/TYPE=/{t=$2}/TARGET=/{g=$2}/STATE=/{s=$2; printf("%-60s%-30s%-10s%-30s\n", n,t,g,s)}'

ora.DATA.dg                                                 ora.diskgroup.type            ONLINE    ONLINE on oragrid
ora.LISTENER.lsnr                                           ora.listener.type             ONLINE    ONLINE on oragrid
ora.asm                                                     ora.asm.type                  ONLINE    ONLINE on oragrid
ora.cssd                                                    ora.cssd.type                 ONLINE    ONLINE on oragrid
ora.diskmon                                                 ora.diskmon.type              OFFLINE   OFFLINE
ora.evmd                                                    ora.evm.type                  ONLINE    ONLINE on oragrid
ora.ons                                                     ora.ons.type                  OFFLINE   OFFLINE
[root@oragrid ~]#

How to Deinstall Old Clusterware Home Once Upgrade to Newer Version is Complete

How to Deinstall Old Clusterware Home Once Upgrade to Newer Version is Complete (Doc ID 1346305.1)


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

[grid@oragrid ContentsXML]$ pwd
/u01/app/oraInventory/ContentsXML
[grid@oragrid ContentsXML]$ cat inventory.xml





   12.2.0.9.0
   2.1.0.6.0








[grid@oragrid ContentsXML]$


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


export OLD_HOME=/u01/app/19.2.0/grid
export ORACLE_HOME=$OLD_HOME

[grid@oragrid ~]$ echo $ORACLE_HOME
/u01/app/19.2.0/grid

[grid@oragrid ~]$ $OLD_HOME/oui/bin/runInstaller -detachHome -silent ORACLE_HOME=$OLD_HOME
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 6759 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
You can find the log of this install session at:
 /u01/app/oraInventory/logs/DetachHome2024-12-13_12-30-06PM.log
'DetachHome' was successful.



[grid@oragrid ContentsXML]$ cat /u01/app/oraInventory/ContentsXML/inventory.xml





   12.2.0.7.0
   2.1.0.6.0



      <<<< now we are good 







[grid@oragrid ContentsXML]$


$NEW_HOME/OPatch/opatch lsinventory -all  


/u01/app/21.3.0/grid/OPatch/opatch lsinventory -all


/u01/app/21.3.0/grid/OPatch/opatch lsinventory -all
Oracle Interim Patch Installer version 12.2.0.1.26
Copyright (c) 2024, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/19.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/19.2.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.26
OUI version       : 12.2.0.7.0
Log file location : /u01/app/19.2.0/grid/cfgtoollogs/opatch/opatch2024-12-13_12-34-42PM_1.log

List of Homes on this system:

  Home name= OraGI21Home1, Location= "/u01/app/21.3.0/grid"
LsInventorySession failed: RawInventory gets null OracleHomeInfo

OPatch failed with error code 73
[grid@oragrid ContentsXML]$



[root@oragrid ~]# export OLD_HOME=/u01/app/19.2.0/grid
[root@oragrid ~]# rm -rf $OLD_HOME
[root@oragrid ~]# ls -ltr /u01/app/19.2.0/grid

Upgrading Oracle Restart from 19c to 21c on centos 8.5

Upgrading Oracle Restart from 19c to 21c on centos 8.5  ======================================== To check resource crsctl status res | awk -F= '/NAME=/{n=$2}/TYPE=/{t=$2}/TARGET=/{g=$2}/STATE=/{s=$2; printf("%-60s%-30s%-10s%-30s\n", n,t,g,s)}'   ora.DATA.dg                                                 ora.diskgroup.type            ONLINE    ONLINE on oragrid ora.LISTENER.lsnr                                           ora.listener.type             ONLINE    ONLINE on oragrid ora.asm                                                     ora.asm.type                  ONLINE    ONLINE on oragrid ora.cssd                                                    ora.cssd.type                 ONLINE    ONLINE on oragrid ora.diskmon                                                 ora.diskmon.type              OFFLINE   OFFLINE ora.evmd                                                    ora.evm.type                  ONLINE    ONLINE on oragrid ora.ons                                                     ora.ons.type                  OFFLINE   OFFLINE   [grid@oragrid ~]$ crsctl query has releaseversion Oracle High Availability Services release version on the local node is [19.0.0.0.0]   [grid@oragrid ~]$ crsctl query has softwareversion Oracle High Availability Services version on the local node is [19.0.0.0.0] [grid@oragrid ~]$   Download   LINUX.X64_213000_grid_home.zip   mkdir -p /u01/app/21.3.0/grid   [grid@oragrid ~]$ cd /u01/app/21.3.0/grid/ [grid@oragrid grid]$ pwd /u01/app/21.3.0/grid [grid@oragrid grid]$ unzip -oq /home/grid/LINUX.X64_213000_grid_home.zip    ./runcluvfy.sh stage -pre hacfg   This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.   Performing following verification checks ...     Physical Memory ...FAILED (PRVF-7530)   Available Physical Memory ...PASSED   Swap Size ...PASSED   Free Space: oragrid:/usr,oragrid:/var,oragrid:/etc,oragrid:/sbin,oragrid:/tmp ...PASSED   User Existence: grid ...     Users With Same UID: 1100 ...PASSED   User Existence: grid ...PASSED   Group Existence: dba ...PASSED   Group Existence: oinstall ...PASSED   Group Membership: dba ...FAILED (PRVG-10460)   Group Membership: oinstall(Primary) ...PASSED   Run Level ...PASSED   Architecture ...PASSED   OS Kernel Version ...PASSED   OS Kernel Parameter: semmsl ...PASSED   OS Kernel Parameter: semmns ...PASSED   OS Kernel Parameter: semopm ...PASSED   OS Kernel Parameter: semmni ...PASSED   OS Kernel Parameter: shmmax ...PASSED   OS Kernel Parameter: shmmni ...PASSED   OS Kernel Parameter: shmall ...PASSED   OS Kernel Parameter: file-max ...PASSED   OS Kernel Parameter: ip_local_port_range ...PASSED   OS Kernel Parameter: rmem_default ...PASSED   OS Kernel Parameter: rmem_max ...PASSED   OS Kernel Parameter: wmem_default ...PASSED   OS Kernel Parameter: wmem_max ...PASSED   OS Kernel Parameter: aio-max-nr ...PASSED   OS Kernel Parameter: panic_on_oops ...PASSED   Package: kmod-20-21 (x86_64) ...PASSED   Package: kmod-libs-20-21 (x86_64) ...PASSED   Package: binutils-2.30-49.0.2 ...PASSED   Package: libgcc-8.2.1 (x86_64) ...PASSED   Package: libstdc++-8.2.1 (x86_64) ...PASSED   Package: sysstat-10.1.5 ...PASSED   Package: ksh ...PASSED   Package: make-4.2.1 ...PASSED   Package: glibc-2.28 (x86_64) ...PASSED   Package: glibc-devel-2.28 (x86_64) ...PASSED   Package: libaio-0.3.110 (x86_64) ...PASSED   Package: nfs-utils-2.3.3-14 ...PASSED   Package: smartmontools-6.6-3 ...PASSED   Package: net-tools-2.0-0.51 ...PASSED   Package: policycoreutils-2.9-3 ...PASSED   Package: policycoreutils-python-utils-2.9-3 ...PASSED   Users With Same UID: 0 ...PASSED   Current Group ID ...PASSED   Root user consistency ...PASSED   Pre-check for Oracle Restart configuration was unsuccessful.     Failures were encountered during execution of CVU verification request "stage -pre hacfg".   Physical Memory ...FAILED oragrid: PRVF-7530 : Sufficient physical memory is not available on node          "oragrid" [Required physical memory = 8GB (8388608.0KB)]   Group Membership: dba ...FAILED oragrid: PRVG-10460 : User "grid" does not belong to group "dba" selected for          privileges "OSDBA" on node "oragrid".     CVU operation performed:      stage -pre hacfg Date:                         12-Dec-2024 13:06:32 CVU home:                     /u01/app/21.3.0/grid Grid home:                    /u01/app/19.2.0/grid User:                         grid Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64 [grid@oragrid grid]$       *******************************     oragrid: PRVG-10460 : User "grid" does not belong to group "dba" selected for  privileges "OSDBA" on node "oragrid".      cat /etc/group|grep -i grid dba:x:54322:grid  <<<<<--- add grid into dba group asmdba:x:54327:grid asmoper:x:54328:grid asmadmin:x:54329:grid   ********************************       ./runcluvfy.sh stage -pre hacfg This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.   Performing following verification checks ...     Physical Memory ...FAILED (PRVF-7530)   Available Physical Memory ...PASSED   Swap Size ...PASSED   Free Space: oragrid:/usr,oragrid:/var,oragrid:/etc,oragrid:/sbin,oragrid:/tmp ...PASSED   User Existence: grid ...     Users With Same UID: 1100 ...PASSED   User Existence: grid ...PASSED   Group Existence: dba ...PASSED   Group Existence: oinstall ...PASSED   Group Membership: dba ...PASSED   Group Membership: oinstall(Primary) ...PASSED   Run Level ...PASSED   Architecture ...PASSED   OS Kernel Version ...PASSED   OS Kernel Parameter: semmsl ...PASSED   OS Kernel Parameter: semmns ...PASSED   OS Kernel Parameter: semopm ...PASSED   OS Kernel Parameter: semmni ...PASSED   OS Kernel Parameter: shmmax ...PASSED   OS Kernel Parameter: shmmni ...PASSED   OS Kernel Parameter: shmall ...PASSED   OS Kernel Parameter: file-max ...PASSED   OS Kernel Parameter: ip_local_port_range ...PASSED   OS Kernel Parameter: rmem_default ...PASSED   OS Kernel Parameter: rmem_max ...PASSED   OS Kernel Parameter: wmem_default ...PASSED   OS Kernel Parameter: wmem_max ...PASSED   OS Kernel Parameter: aio-max-nr ...PASSED   OS Kernel Parameter: panic_on_oops ...PASSED   Package: kmod-20-21 (x86_64) ...PASSED   Package: kmod-libs-20-21 (x86_64) ...PASSED   Package: binutils-2.30-49.0.2 ...PASSED   Package: libgcc-8.2.1 (x86_64) ...PASSED   Package: libstdc++-8.2.1 (x86_64) ...PASSED   Package: sysstat-10.1.5 ...PASSED   Package: ksh ...PASSED   Package: make-4.2.1 ...PASSED   Package: glibc-2.28 (x86_64) ...PASSED   Package: glibc-devel-2.28 (x86_64) ...PASSED   Package: libaio-0.3.110 (x86_64) ...PASSED   Package: nfs-utils-2.3.3-14 ...PASSED   Package: smartmontools-6.6-3 ...PASSED   Package: net-tools-2.0-0.51 ...PASSED   Package: policycoreutils-2.9-3 ...PASSED   Package: policycoreutils-python-utils-2.9-3 ...PASSED   Users With Same UID: 0 ...PASSED   Current Group ID ...PASSED   Root user consistency ...PASSED   Pre-check for Oracle Restart configuration was unsuccessful.     Failures were encountered during execution of CVU verification request "stage -pre hacfg".   Physical Memory ...FAILED oragrid: PRVF-7530 : Sufficient physical memory is not available on node          "oragrid" [Required physical memory = 8GB (8388608.0KB)]     CVU operation performed:      stage -pre hacfg Date:                         12-Dec-2024 13:24:10 CVU home:                     /u01/app/21.3.0/grid Grid home:                    /u01/app/19.2.0/grid User:                         grid Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64 [grid@oragrid grid]$         unset ORACLE_HOME unset ORACLE_BASE unset ORACLE_SID   [grid@oragrid grid]$ export CV_ASSUME_DISTID=OEL7.8 [grid@oragrid grid]$ ./gridSetup.sh & [1] 11065 [grid@oragrid grid]$ ERROR: Unable to verify the graphical display setup. This application requires X display. Make sure that xdpyinfo exist under PATH variable. Launching Oracle Grid Infrastructure Setup Wizard...   The response file for this session can be found at:  /u01/app/21.3.0/grid/install/response/grid_2024-12-12_03-04-14PM.rsp   You can find the log of this install session at:  /u01/app/oraInventory/logs/GridSetupActions2024-12-12_03-04-14PM/gridSetupActions2024-12-12_03-04-14PM.log         [root@oragrid ~]# /u01/app/21.3.0/grid/rootupgrade.sh Performing root user operation.   The following environment variables are set as:     ORACLE_OWNER= grid     ORACLE_HOME=  /u01/app/21.3.0/grid   Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]: y    Copying oraenv to /usr/local/bin ... The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]: y    Copying coraenv to /usr/local/bin ...   Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. Using configuration parameter file: /u01/app/21.3.0/grid/crs/install/crsconfig_params The log of current session can be found at:   /u01/app/grid/crsdata/oragrid/crsconfig/roothas_2024-12-12_03-17-27PM.log 2024/12/12 15:17:30 CLSRSC-595: Executing upgrade step 1 of 12: 'UpgPrechecks'. 2024/12/12 15:17:36 CLSRSC-595: Executing upgrade step 2 of 12: 'GetOldConfig'. 2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 3 of 12: 'GenSiteGUIDs'. 2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 4 of 12: 'SetupOSD'. Redirecting to /bin/systemctl restart rsyslog.service 2024/12/12 15:17:41 CLSRSC-595: Executing upgrade step 5 of 12: 'PreUpgrade'. 2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 6 of 12: 'UpgradeAFD'. 2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 7 of 12: 'UpgradeOLR'. clscfg: EXISTING configuration version 0 detected. Creating OCR keys for user 'grid', privgrp 'oinstall'.. Operation successful. 2024/12/12 15:18:23 CLSRSC-595: Executing upgrade step 8 of 12: 'UpgradeOCR'. LOCAL ONLY MODE Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'root'.. Operation successful. CRS-4664: Node oragrid successfully pinned. 2024/12/12 15:18:27 CLSRSC-595: Executing upgrade step 9 of 12: 'CreateOHASD'. 2024/12/12 15:18:29 CLSRSC-595: Executing upgrade step 10 of 12: 'ConfigOHASD'. 2024/12/12 15:18:29 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service' 2024/12/12 15:18:48 CLSRSC-595: Executing upgrade step 11 of 12: 'UpgradeSIHA'.   oragrid     2024/12/12 15:19:45     /u01/app/grid/crsdata/oragrid/olr/backup_20241212_151945.olr     0   oragrid     2024/12/10 15:51:48     /u01/app/grid/crsdata/oragrid/olr/backup_20241210_155148.olr     724960844 2024/12/12 15:19:45 CLSRSC-595: Executing upgrade step 12 of 12: 'InstallACFS'. 2024/12/12 15:20:51 CLSRSC-327: Successfully configured Oracle Restart for a standalone server [root@oragrid ~]#       [grid@oragrid grid]$ crsctl query has releaseversion Oracle High Availability Services release version on the local node is [21.0.0.0.0] [grid@oragrid grid]$ crsctl query has softwareversion Oracle High Availability Services version on the local node is [21.0.0.0.0] [grid@oragrid grid]$     [grid@oragrid grid]$ $ORACLE_HOME/OPatch/opatch lspatches There are no Interim patches installed in this Oracle Home "/u01/app/21.3.0/grid".   OPatch succeeded. [grid@oragrid grid]$   ====   [1]+  Done                    ./gridSetup.sh [grid@oragrid grid]$       [grid@oragrid grid]$ cluvfy stage -post hacfg This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.   Performing following verification checks ...     Oracle Restart Integrity ...PASSED   OLR Integrity ...PASSED   Post-check for Oracle Restart configuration was successful.   CVU operation performed:      stage -post hacfg Date:                         12-Dec-2024 15:28:01 CVU home:                     /u01/app/21.3.0/grid Grid home:                    /u01/app/21.3.0/grid User:                         grid Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64 [grid@oragrid grid]$

 

[root@oragrid ~]# /u01/app/21.3.0/grid/rootupgrade.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /u01/app/21.3.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

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

The log of current session can be found at:

  /u01/app/grid/crsdata/oragrid/crsconfig/roothas_2024-12-12_03-17-27PM.log

2024/12/12 15:17:30 CLSRSC-595: Executing upgrade step 1 of 12: 'UpgPrechecks'.

2024/12/12 15:17:36 CLSRSC-595: Executing upgrade step 2 of 12: 'GetOldConfig'.

2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 3 of 12: 'GenSiteGUIDs'.

2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 4 of 12: 'SetupOSD'.

Redirecting to /bin/systemctl restart rsyslog.service

2024/12/12 15:17:41 CLSRSC-595: Executing upgrade step 5 of 12: 'PreUpgrade'.

2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 6 of 12: 'UpgradeAFD'.

2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 7 of 12: 'UpgradeOLR'.

clscfg: EXISTING configuration version 0 detected.

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

Operation successful.

2024/12/12 15:18:23 CLSRSC-595: Executing upgrade step 8 of 12: 'UpgradeOCR'.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

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

Operation successful.

CRS-4664: Node oragrid successfully pinned.

2024/12/12 15:18:27 CLSRSC-595: Executing upgrade step 9 of 12: 'CreateOHASD'.

2024/12/12 15:18:29 CLSRSC-595: Executing upgrade step 10 of 12: 'ConfigOHASD'.

2024/12/12 15:18:29 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'

2024/12/12 15:18:48 CLSRSC-595: Executing upgrade step 11 of 12: 'UpgradeSIHA'.

oragrid     2024/12/12 15:19:45     /u01/app/grid/crsdata/oragrid/olr/backup_20241212_151945.olr     0

oragrid     2024/12/10 15:51:48     /u01/app/grid/crsdata/oragrid/olr/backup_20241210_155148.olr     724960844

2024/12/12 15:19:45 CLSRSC-595: Executing upgrade step 12 of 12: 'InstallACFS'.

2024/12/12 15:20:51 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

[root@oragrid ~]#

[grid@oragrid grid]$ crsctl query has releaseversion

Oracle High Availability Services release version on the local node is [21.0.0.0.0]

[grid@oragrid grid]$ crsctl query has softwareversion

Oracle High Availability Services version on the local node is [21.0.0.0.0]

[grid@oragrid grid]$

[grid@oragrid grid]$ cluvfy stage -post hacfg

This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.

Performing following verification checks ...

  Oracle Restart Integrity ...PASSED

  OLR Integrity ...PASSED

Post-check for Oracle Restart configuration was successful.

CVU operation performed:      stage -post hacfg

Date:                         12-Dec-2024 15:28:01

CVU home:                     /u01/app/21.3.0/grid

Grid home:                    /u01/app/21.3.0/grid

User:                         grid

Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64

[grid@oragrid grid]$