oracle 实例名不一致,RAC, 两实例看到的数据库版本不一致，是什么情况？

--1  新建单节点(只在节点2上)数据库K3CLOUD，再次登录查看，发现版本还是19.3

印证了第1中猜测。

cloudrac2@oracle ~]

$export ORACLE_SID=k3cloud

[cloudrac2@oracle ~]

$sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 14 08:38:39 2019

Version 19.4.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

SYS@k3cloud>exit

--2  看清楚当前的RU补丁情况：19.4.0.0.190716 (29834717)

[cloudrac2@oracle ~]

$opatch lspatches

29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)

29834717;Database Release Update : 19.4.0.0.190716 (29834717)

OPatch succeeded.

[cloudrac2@oracle ~]

--3 　回滚节点2上的RU补丁，

[cloudrac2@oracle ~]

$opatch rollback -id 29834717

Oracle Interim Patch Installer version 12.2.0.1.17

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

Oracle Home       : /home/app/19c/product/db_1

Central Inventory : /home/app/oraInventory

from           : /home/app/19c/product/db_1/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.2.0.7.0

Log file location : /home/app/19c/product/db_1/cfgtoollogs/opatch/opatch2019-10-14_08-51-35AM_1.log

Patches will be rolled back in the following order:

29834717

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

Start OOP by Prereq process.

Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.17

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

Oracle Home       : /home/app/19c/product/db_1

Central Inventory : /home/app/oraInventory

from           : /home/app/19c/product/db_1/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.2.0.7.0

Log file location : /home/app/19c/product/db_1/cfgtoollogs/opatch/opatch2019-10-14_08-51-51AM_1.log

Patches will be rolled back in the following order:

29834717

The following patch(es) will be rolled back: 29834717

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/home/app/19c/product/db_1')

Is the local system ready for patching? [y|n]

Y (auto-answered by -silent)

User Responded with: Y

Rolling back patch 29834717...

RollbackSession rolling back interim patch '29834717' from OH '/home/app/19c/product/db_1'

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Deleting "piht.o" from archive "/home/app/19c/product/db_1/lib/libplp19_pic.a"

Deleting "pifi.o" from archive "/home/app/19c/product/db_1/lib/libpls19_pic.a"

Deleting "pci.o" from archive "/home/app/19c/product/db_1/lib/libpls19_pic.a"

Deleting "psdufa.o" from archive "/home/app/19c/product/db_1/lib/libplc19_pic.a"

--4   回滚成功。

Patching component oracle.precomp.common, 19.0.0.0.0...

RollbackSession removing interim patch '29834717' from inventory

Inactive sub-set patch [29517242] has become active due to the rolling back of a super-set patch [29834717].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /home/app/19c/product/db_1/cfgtoollogs/opatch/opatch2019-10-14_08-51-51AM_1.log

OPatch succeeded.

--5   查看此时的RU补丁情况，19.3.0.0.190416 (29517242)

[cloudrac2@oracle ~]

$opatch lspatches

29850993;OCW RELEASE UPDATE 19.4.0.0.0 (29850993)

29517242;Database Release Update : 19.3.0.0.190416 (29517242)

OPatch succeeded.

--6  此时，$ORACLE_HOME/inventory/oneoffs 下已经没了29834717的目录。

[cloudrac2@oracle ~]

$cd $ORACLE_HOME/inventory/oneoffs

[cloudrac2@oracle /home/app/19c/product/db_1/inventory/oneoffs]

$ls -lrt

total 972

drwxr-x--- 4 oracle oinstall     29 Oct 12 08:55 29585399

drwxr-x--- 4 oracle oinstall     29 Oct 12 08:55 29517242

drwxr-xr-x 4 oracle oinstall     29 Oct 12 18:08 29850993

-rw-r--r-- 1 oracle oinstall 860160 Oct 12 19:31 29834717.tar

-rw-r--r-- 1 oracle oinstall 133120 Oct 12 19:31 29850993.tar

--7 　再次打补丁29834717

[cloudrac2@oracle /backup/soft/19c/p29699097/29699097/29708769]

$cd *7

[cloudrac2@oracle /backup/soft/19c/p29699097/29699097/29708769/29834717]

$ls -lrt

total 80

-rw-r--r--  1 grid oinstall    21 Jul 15 02:54 README.txt

drwxr-x--- 25 grid oinstall   309 Jul 15 02:54 files

-rw-r--r--  1 grid oinstall 73804 Jul 15 02:56 README.html

drwxr-x---  3 grid oinstall    20 Jul 15 02:56 etc

[cloudrac2@oracle /backup/soft/19c/p29699097/29699097/29708769/29834717]

$opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 12.2.0.1.17

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

PREREQ session

Oracle Home       : /home/app/19c/product/db_1

Central Inventory : /home/app/oraInventory

from           : /home/app/19c/product/db_1/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.2.0.7.0

Log file location : /home/app/19c/product/db_1/cfgtoollogs/opatch/opatch2019-10-14_08-58-52AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[cloudrac2@oracle /backup/soft/19c/p29699097/29699097/29708769/29834717]

$opatch apply

Oracle Interim Patch Installer version 12.2.0.1.17

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

Oracle Home       : /home/app/19c/product/db_1

Central Inventory : /home/app/oraInventory

from           : /home/app/19c/product/db_1/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.2.0.7.0

Log file location : /home/app/19c/product/db_1/cfgtoollogs/opatch/opatch2019-10-14_08-59-10AM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   29834717

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/home/app/19c/product/db_1')

Patching component oracle.precomp.common, 19.0.0.0.0...

Patch 29834717 successfully applied.

Sub-set patch [29517242] has become inactive due to the application of a super-set patch [29834717].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /home/app/19c/product/db_1/cfgtoollogs/opatch/opatch2019-10-14_08-59-10AM_1.log

OPatch succeeded.

--8  打完补丁，尝试登录，此时看到的版本是19.4。

[cloudrac2@oracle /backup/soft/19c/p29699097/29699097/29708769/29834717]

$sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 14 09:06:21 2019

Version 19.4.0.0.0

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

Connected to an idle instance.

SYS@k3cloud>exit

Disconnected

[cloudrac2@oracle /backup/soft/19c/p29699097/29699097/29708769/29834717]

$srvctl start database  -d k3cloud

[cloudrac2@oracle /backup/soft/19c/p29699097/29699097/29708769/29834717]

$sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 14 09:07:38 2019

Version 19.4.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.4.0.0.0

SYS@k3cloud>select * from v$version;

BANNER

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

BANNER_FULL

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

BANNER_LEGACY                                                                        CON_ID

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

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.4.0.0.0

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production                    0

Elapsed: 00:00:00.01

SYS@k3cloud>

[cloudrac2@oracle ~]

$sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 14 09:14:49 2019

Version 19.4.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.4.0.0.0

SYS@orcl2>select inst_id, banner_full from gv$version;

INST_ID BANNER_FULL

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

2 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.4.0.0.0

1 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.4.0.0.0

Elapsed: 00:00:00.01

SYS@orcl2>