Database Upgrade

https://docs.oracle.com/database/121/UPGRD/preup.htm#UPGRD52784

https://blogs.oracle.com/optimizer/upgrade-to-oracle-database-12c-and-avoid-query-regression

Things to Consider for 11.2.0.4 to Avoid Problems with SQL Plan Management (SPM) (Doc ID 2034706.1)

https://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf

Hidden Parameters

select 'Hidden Parameters' "CHECK_NAME",a.inst_id, a.ksppinm "Parameter",

b.ksppstvl "Session Value",

c.ksppstvl "Instance Value"

from x$ksppi a, x$ksppcv b, x$ksppsv c

where a.indx = b.indx and a.indx = c.indx

and a.inst_id=b.inst_id and b.inst_id=c.inst_id

and a.ksppinm in ('_undo_autotune', '_smu_debug_mode',

'_highthreshold_undoretention','_disable_flashback_archiver',

'event', '_first_spare_parameter','_rollback_segment_count')

 order by 2

 /

ORACLE Doc ID

1. SRDC - ORA-1555: Checklist of Evidence to Supply (Doc ID 1682708.1) 2. How To Gather & Backup ASM/ACFS Metadata In A Formatted Manner version 10.1, 10.2, 11.1, 11.2, 12.1, 12.2, 18.x and 19.x (Doc ID 470211.1) 3 How To Identify LOB Segment Use PCTVERSION Or RETENTION From Data Dictionary (Doc ID 422826.1) 4.  ORA-1555 Seen When Executing Datapump Export (EXPDP) Using FLASHBACK_TIME Option With TO_TIMESTAMP(sysdate) (Doc ID 2509092.1) 5. ORA-1555 ORA-8180 During DataPump Export (expdp) With Parameter FLASHBACK_TIME (Doc ID 1268663.1) 6. Using FLASHBACK_TIME Option With DataPump Import (IMPDP) Fails With Error ORA-1555 (Doc ID 467123.1) 7.

.

How To Gather & Backup ASM/ACFS Metadata In A Formatted Manner version 10.1, 10.2, 11.1, 11.2, 12.1, 12.2, 18.x and 19.x (Doc ID 470211.1)

Disconnected: No supported authentication methods available (server sent publickey, gssapi-keyex gssapi-with-mic)

Disconnected: No supported authentication methods available (server sent publickey, gssapi-keyex gssapi-with-mic) 

Fix:

uncomment PasswordAuthentication yes
[root@oracle12102 ~]# cat /etc/ssh/sshd_config |grep -i Pass
# To disable tunneled clear text passwords, change to no here!
PasswordAuthentication yes
:wq
service sshd restart

How to ensure that Right Oracle ASM Modules

How to check right Oracle ASM modules.


cat /etc/*release

[oracle@node1 ~]$ cat /etc/*release
Oracle Linux Server release 7.8
NAME="Oracle Linux Server"
VERSION="7.8"
ID="ol"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.8"
PRETTY_NAME="Oracle Linux Server 7.8"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:7:8:server"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.8
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=7.8
Red Hat Enterprise Linux Server release 7.8 (Maipo)
Oracle Linux Server release 7.8
[oracle@node1 ~]$

uname -a

[oracle@node1 ~]$ uname -a
Linux node1 4.14.35-1902.301.1.el7uek.x86_64 #2 SMP Tue Mar 31 16:50:32 PDT 2020 x86_64 x86_64 x86_64 GNU/Linux

rpm -qa |grep oracleasm

[oracle@node1 ~]$ rpm -qa |grep oracleasm
oracleasm-support-2.1.11-2.el7.x86_64
[oracle@node1 ~]$

Changing Hostname

Changing Host name

#hostname
node01.uk.abc.com
#vi /etc/hostname
node02.uk.abc.com
:wq
restart the node
or 
restart :

hostname
node02.uk.abc.com

AWR Snapshots Not Generated With "Reliable Messages" Waits Bug:26961929

AWR Snapshots Not Generated With "Reliable Messages" Waits - Bug 26961929

exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();
is not getting completed after long time also, so terminated it manually after collecting orabug trace.



1. Upgrade to 18.1 where this is first included.
or
2. Apply Patch 26961929 which will enforce a runtime policy that will prevent any action to run indefinitely
or
3. Use workaround:

Restart MMON process by using "kill -9" against its process ID on all RAC instances - MMON process will be re-spawn